It can be said without altering that Oracle database management systems are the most widely used DBMSs in the world. Oracle is an object-relational DBMS, and it has the capability to operate essentially on every computer type: PCs as well as Macs, minicomputers and huge mainframes alike.
Oracle underwent redesign to fulfill the need brought by network computing as well as to give the market a secure and reliable application data management system. It can comfortably support small applications on departmental levels, and scale upwards to serve high-volume online transaction systems and data warehouse applications with query-intensity.
From its creation in the early 1980s, Oracle had undergone continuous improvement and redefinition until the Oracle 8i, first released in 1997 to its most recent release, the Oracle 12c released in June 2013. Below is a basic overview of the five generations of Oracle Databases from 8i to 12c.
An in-depth discussion of all features would obviously require a different forum, a book most precisely. Therefore, what we offer today will be a brief outline of the most significant features that set each generation apart from its predecessors.
The database development and management environment from Oracle provides for client/server DBMS, including a number of utilities useful in the development of database systems:
- Oracle Navigator –useful in the creation of new tables within a visual environment
- Oracle Browser – useful in the creation of SQL queries as well as QBE (query by example queries).
- Oracle Forms – these create/develop menus and/or graphical forms applicable to user applications.
- Oracle Reports – generation of reports in printing and display of data
- SQL Plus – creation testing and debugging command-prompt SQL queries
- Oracle Graphics – generation of graphical representations and visual aids based on information stored in the database.
- Enterprise Manager – management and tuning of the database
- Oracle Webserver – used to create a WWW site to enable users develop dynamic web pages using Oracle databases.
The improvement in Oracle 9i aims at improved optimization of conventional business applications, stimulations of the emergent hosted applications market and facilitation of vital advancement capabilities required for internet-based business.