An Introduction to The Oracle Database System

Google+ Pinterest LinkedIn Tumblr +

Oracle is a database management system that was developed by Larry Ellison, together with his colleagues Bob Miner and Ed Oates. In 1979, Relational Software Incorporated (RSI) introduced the Oracle V2 as a relational database. And in 1983, RSI became the Oracle Corporation as a way of making the organization more representative of its flagship product.

When version three of Oracle was published it had been completely rewritten in C programming language, and the version supported the Unix platform for the very first time. In early 1985, Oracle began integrating the client-server model, and this coincided with the advent of networks around that time.

By 2001, Oracle 9i introduced four hundred new features and had the capacity to read and write XML documents. Integration of the OLAP engine in Oracle became a reality starting with the 9i version.

The classification system of versions has evolved over time, but is typically based on the XYZa convention, in which case XY refers to the major version of the product: 8.1 to 8i, 9.2 to 9i Release 2, etc. Within the same primary version (8i, 9i or 10g), the general features of the RDBMS are meant to be similar.

The digit Z relates to the level of generic patch employed; in essence Oracle delivers between three and four updates, otherwise known as a patchset in some of the major releases. In principle, the digit defines a level of patch-specific operating system or platform.  

Oracle RDBMS products are sold in two types of licenses, and these include the appointed users license which entails the specification of the number of unique individuals connecting to databases. And it is most appropriate for distinctive business applications in client/server.

The second license relates to the processors, this option entails the number of processors on the server hosting. The alternative is directly dedicated to the three-tier architectures, with which the exact number of clients are barely known, or one that allows database access (websites) to thousands of people.

In version 10g, Oracle enhances the price of a license in three editions which are namely the enterprise edition (includes all the features of the product). The standard edition (comes with functionality limitations and the number of processors – four) and the standard edition one (limitations to the functionality and the number of processors – two).

The complete bouquet of Oracle products, is as follows – the database (RDBMS), the application server (IAS), the collaboration Suite (OCS), the development environment (ODS) and the eBusiness Suite.



About Author

Leave A Reply