1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

What is Oracle?

Discussion in 'General' started by tyro, Nov 8, 2008.

  1. tyro

    tyro Forum Genius

    Messages:
    408
    Likes Received:
    20
    Trophy Points:
    260
    Location:
    India
    What is Oracle? - An Introduction for beginners

    When you discuss Oracle, you have to consider this from two aspects. There is Oracle the company and Oracle Technology.

    We will first look at Oracle the company. Oracle the company have come a long way since their appearance as Oracle the database company, and appearing with the Oracle name in 1982, as Oracle Systems. The company was originally founded by Larry Ellison but under the name of Software Development Laboratories, in 1977. Based upon its flagship relational database, the company changed its name to Relational Software Inc, in 1979. They developed a database which was relational in nature, and named this Oracle. The company then took the name of the product as the company name, and hence it has been called Oracle ever since. Larry Ellison is still the CEO of the Oracle Corporation. In 2007, Oracle was ranked third in the world in the list of largest software companies.

    In the beginning Oracle specialised in their relational database product. This product allows you to view data from a central perspective. The origins of the idea were based on a paper written by Edgar F. Codd in 1970 on relational database systems named "A Relational Model of Data for Large Shared Data Banks". Now Oracle provides not only database systems, but a whole suite of applications. They are no longer database only specialists. They provide services to companies all over the world.

    Now we come to Oracle the technology. Well, as mentioned Oracle are mostly known for their database products, which allow data to be controlled and viewed from several perspectives while removing redundant data and duplication in a database.

    The database product provided by Oracle is the world leader. It is provided as a back-end information centre to a great number of websites owned by large corporations. It has its own language, PL/SQL. It provides XML support and has supporting tools for developers, such as Forms, Reports, and recently has become the global leader in CRM technologies, having taken over Siebel Systems in 2006.

    Oracle technology includes Application Server, which serves all the various applications available in the Oracle suite of products. This has high availability built into its server functionality so that the applications are reliable in their operation.

    Oracle have continued to improve their technology and release new versions of their database product on average every two years or so. The latest releases include automatic back-end optimisation and database cleansing in the background. This means that it basically tidies up after itself when data is removed and added to the database, without DBA intervention. The latest versions also include additional features for internet based technologies.

    The advantage of Oracle based technologies are that they are secure, reliable and conform to government requirements, and is hence the reason Oracle is used in a great number of government departments. Oracle databases can handle millions of records.

    In summary, Oracle is, as their marketing campaign goes - the information company virtually attempting to take over all the information requirements of modern enterprises with database technology at it's heart of operations.
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,989
    Likes Received:
    252
    Trophy Points:
    1,455
    It's a good Intro Tyro
     
  3. salmankhalid

    salmankhalid Forum Advisor

    Messages:
    130
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Lahore, Pakistan
    its really very informative for all the poeple either they are beginners or experts and have informtion that i even don't know....

    really nice effort...!
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,533
    Likes Received:
    362
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    If you're going to 'cut and paste' from other sources you need to give attribution to the source and you should also ensure that the text is current; Oracle 9i is desupported and there have been 5 major releases of Oracle since 9i's release, with the most current of those being 12.1.0.2. Adding a response simply to 'add a response' doesn't help anyone in the long run.
     
    raovk13 likes this.
  5. Ansari456

    Ansari456 Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    India
    Thank you for great information about Oracle, such a very useful information.
     
  6. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,533
    Likes Received:
    362
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Us3eful to who? The document is at least 5 major releases behind current and it is really nothing more than a marketing campaign for Oracle. It explains nothing of what Oracle actually is other than through the eyes of the sales team. As a history it's lacking detail; WHO did Larry Ellison work for to get the idea for Oracle? That was IBM and originally they were proposing a relational database product that was put on the 'back burner' because no immediate need was seen. Larry took the original work on the SQL language engine and modified it, developed a relational management system around that and fulfilled a contract he accepted with the CIA for a relational database product. It was named Oracle, after the Oracle of Delphi, because it was intended to give the CIA the possibility of collecting, storing and analyzing intelligence data in a new and faster way. All of this was predicated on the work of Chris Date and Edgar Codd (who worked for IBM). Oracle was a success with the CIA and soon afterwards Oracle Version 2.0 was released for public consumption (there is no Version 1.0 because it was thought to be more marketable if it didn't look like a brand new product, and it wasn't as the CIA had been using it for a while before the commercial version was released). Many improvements have been made since then, one of the most important being the move from writing entire transactions to the redo stream to using change vectors to reduce the volume of redo and increase the speed of recovery operations. This change, in Version 6.0, made it possible for 'hot' backups, where the database is still running and taking transactions, to be taken. Other major changes through the years have improved Oracle in both management and user features and NONE of that information is presented in the original post.

    Such offerings should be titled accurately, such as 'A Very Brief History of Oracle, the Database and the Company', to prevent others from assuming, incorrectly, that the information is complete and exhaustive. A good place to start reading is here:

    https://www.google.com/url?sa=t&rct..._J34uN20huepxYX_U_DJdQ&bvm=bv.142059868,d.cGc

    if you really want a good look at the history of the company and its flagship product.
     
  7. Larasun

    Larasun Starter

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Armenia
    Thanks for the information, it was very useful for me.
     
  8. sarika

    sarika Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Hyderabad
    I am beginner in Oracle. Finally, i got my answer after many hours of surfing the web by reading your article. hope to see more posts on this technology.
     
  9. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,533
    Likes Received:
    362
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Thank you for that minimalist and short-sighted 'explanation'; Oracle is much more than the 'bit bucket' your response claims. Such 'descriptions' come from those who won't take the time to fully understand the product and rely on 'seat-of-their-pants' "knowledge" gained by assumption. I posted a link to a fairly good discussion on what Oracle is, possibly you should read it before posting anything further.