This blog explains the evolution of Oracle from its inception as a relational database and then out numbering its competitors for the past 3 decades as the world’s most robust and flexible relational database.
Oracle version 2 (1979) was the very first commercial release and they named it as version 2 as they believed that any potential customer will be more hesitant to buy the very first version of any software. This version had the complete implementation of SQL but lacked reliability.
Oracle version 3 (1983) was completely rewritten in C language to support portability beyond the range of operating systems. This version of Oracle solved the reliability issue with the earlier release. Any SQL statement executed here would either be committed or rolled back.
Oracle version 4 (1984) improved the stability and read consistency. For example, the transaction performed between the accounts is not mis-computed when a query is being executed.
Oracle version 5.1 (1985) and 5.2 (1986) worked as a distributed database by introducing the first every service/ client relational database so that a client running on a machine in one location could access a server over a network. This version also supported distributed querying as one query could access data stored from more than one location.
Oracle version 6 (1988) introduced a new architecture on the availability of the database during a transaction. This version primarily changed the locking method from table level to row level, resulting in better system throughput when many users are accessing the database. This version also allowed hot backups, the process of taking a backup of the database while it is still in use.
Oracle version 7 (1992) solved the procedural limitation of the SQL by allowing the database users to create Programmable Logical Structured Query Language in short PL/SQL codes and thus making it an efficient programming language of all the fourth generation languages. This version allowed us to create Procedures, Functions and Triggers along with distributed transactions and security methods allowing programmers to create complex business rules.
Oracle version 8 (1997) was designed to work with Oracle’s Network Computer and this version supported OLTP system, HTML and Java interface. Oracle version 8.1 (1998) supported parallel processing with Linux, which eliminated the highly costing downtime.
Oracle version 9i (2001) introduced the concept of Real Application Clustering and provided high availability in the Oracle database. This version allowed the database to integrate relational and multidimensional processing and introduced the concept of table compression, which reduced the disk size from 3 to 10 times and increased the performance when accessing the data.
Oracle version 10g (2003) introduced us to the grid technology for sharing the hardware resources against the data centers, thus lowering the infrastructure cost. By introducing Oracle 10g Express Edition, Oracle gave the entry level business corporations to make the most of the Oracle technology with no cost at all.
Oracle version 11g (2007) introduced some salient features like flashback data archive, virtual column, parallel back up of the same files, case sensitive passwords and wide range of performance and optimization enhancements making it a more stable release of all the time.
Oracle version 12c (2013) is out of Oracle’s major innovation which supported multi-tenancy – an option which allows us to share common infrastructure like memory and background processes between multiple databases. These are called as “pluggable” databases which are plugged into a “container” or “master” database. The main advantage of this technology is to possibly allow n- number of databases to run on a single hardware with complete security and isolation between them.
Thank you,
Boobal Ganesan
Oracle version 2 (1979) was the very first commercial release and they named it as version 2 as they believed that any potential customer will be more hesitant to buy the very first version of any software. This version had the complete implementation of SQL but lacked reliability.
Oracle version 3 (1983) was completely rewritten in C language to support portability beyond the range of operating systems. This version of Oracle solved the reliability issue with the earlier release. Any SQL statement executed here would either be committed or rolled back.
Oracle version 4 (1984) improved the stability and read consistency. For example, the transaction performed between the accounts is not mis-computed when a query is being executed.
Oracle version 5.1 (1985) and 5.2 (1986) worked as a distributed database by introducing the first every service/ client relational database so that a client running on a machine in one location could access a server over a network. This version also supported distributed querying as one query could access data stored from more than one location.
Oracle version 6 (1988) introduced a new architecture on the availability of the database during a transaction. This version primarily changed the locking method from table level to row level, resulting in better system throughput when many users are accessing the database. This version also allowed hot backups, the process of taking a backup of the database while it is still in use.
Oracle version 7 (1992) solved the procedural limitation of the SQL by allowing the database users to create Programmable Logical Structured Query Language in short PL/SQL codes and thus making it an efficient programming language of all the fourth generation languages. This version allowed us to create Procedures, Functions and Triggers along with distributed transactions and security methods allowing programmers to create complex business rules.
Oracle version 8 (1997) was designed to work with Oracle’s Network Computer and this version supported OLTP system, HTML and Java interface. Oracle version 8.1 (1998) supported parallel processing with Linux, which eliminated the highly costing downtime.
Oracle version 9i (2001) introduced the concept of Real Application Clustering and provided high availability in the Oracle database. This version allowed the database to integrate relational and multidimensional processing and introduced the concept of table compression, which reduced the disk size from 3 to 10 times and increased the performance when accessing the data.
Oracle version 10g (2003) introduced us to the grid technology for sharing the hardware resources against the data centers, thus lowering the infrastructure cost. By introducing Oracle 10g Express Edition, Oracle gave the entry level business corporations to make the most of the Oracle technology with no cost at all.
Oracle version 11g (2007) introduced some salient features like flashback data archive, virtual column, parallel back up of the same files, case sensitive passwords and wide range of performance and optimization enhancements making it a more stable release of all the time.
Oracle version 12c (2013) is out of Oracle’s major innovation which supported multi-tenancy – an option which allows us to share common infrastructure like memory and background processes between multiple databases. These are called as “pluggable” databases which are plugged into a “container” or “master” database. The main advantage of this technology is to possibly allow n- number of databases to run on a single hardware with complete security and isolation between them.
Thank you,
Boobal Ganesan
No comments:
Post a Comment