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.
Oracle 8i
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.
Oracle 9i
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.
Thank you Jenny for such an interesting post on various versions oracle. I have been reading blogs on various niche like database, oracle. I have also got help from remote dba experts regarding oracle and many other tools which are used for database designing.
Good post! Thank you very much for informative article. I have been doing discussion with my team members who are remote dba experts. I will keep this topic in front of them as it gives detail description of oracle. Keep sharing such articles in future. Thumps up for the article.
nyc post … easy to understand………
So much needed comparison between Oracle versions. Every version has some added features. Most database administrator doesn’t know the difference between the versions of the oracle database. This is most useful article for such database administrator. The description about each version can be taken through remote dba services. Thank you Jenny for sharing this article with us. Hope to see more articles in future. Well done.
Very nice.loved it.
Thanks you for Jenny Richards for sharing such a article. Article has many useful points which I like to share with my friends and discuss it with them. Good to read!! I like to read and gather more information as you post has some interesting information. If you are interested to know more about database, then you can go for remote dba services. Looking more article on same