Tuesday, May 7, 2013

RDBMS

A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. Most popular commercial and open source databases currently in use are based on the relational database model.
A short definition of an RDBMS may be a DBMS in which data is stored in the form of tables and the relationship among the data is also stored in the form of tables.


Oracle database
A relational database management system (DBMS) from Oracle, which runs on more than 80 platforms. Introduced in the late 1970s, Oracle was the first database product to run on a variety of platforms from micro to mainframe. The Oracle database is Oracle's flagship product, and version 11g was introduced in 2007.

Oracle 11g features include built-in testing for changes, the capability of viewing tables back in time, superior compression of all types of data and enhanced disaster recovery functions.

The "i" ,"g"and "c" Versions
Starting in 1999 with Version 8i, Oracle added the "i" to the version name to reflect support for the Internet with its built-in Java Virtual Machine (JVM). Oracle 9i added more support for XML in 2001. In 2003, Oracle 10g was introduced with emphasis on the "g" for grid computing, which enables clusters of low-cost, industry standard servers to be treated as a single unit.Further development lead to 11g in 2007 which slowly got developed to 12c.12c features Multi-Tenancy, CDB vs. PDB (CDB is an acronym for “Container Database” and PDB is an acronym for “Pluggable Database”),Split Data Dictionary,Faster Provisioning, Database Administration & Granularity Control Patching & Upgrades are some of its features.

Java Built In
With a JVM (Java interpreter) built into the DBMS, triggers and stored procedures can be written and executed in Java rather than Oracle's PL/SQL programming language. It enables Internet developers to write applications and database procedures in the same language. In addition, the JVM can also execute Enterprise JavaBeans (EJBs), turning the DBMS into an application server.

No comments:

Post a Comment