Oracle Database

Oracle is a database management application or software. At present It is the leading RDBMS vendor worldwide. Currently nearly half of RDBMS worldwide market is owned by Oracle.This article is introduction  to oracle database and describes the basic overview of Oracle. Summary of the article:

  • What is Oracle?
  • History of Oracle
  • Oracle Database Version History
  • Oracle Certification Program
  • Editions of the Oracle Database

database,rdms

Developer: Oracle Corporation
Initial Release: Version 2.0, 1979
Stable Release: Oracle Database 12c
Written in: Assembly language, C, C++
OS: Cross-platform
Available in: Multilingual
License: Proprietary
Website: Oracle

What is Oracle?
Oracle Database or Oracle RDMS or simply Oracle is a Relational Database Management System (RDBMS). It is the most famous and widely used RDMS. Its features and security is best.

History of Oracle
In 1977, Larry Ellison and two friends Bob Miner and Ed Oates started a consultancy firm called Software Development Laboratories (SDL). The original version of the Oracle software was developed by the SDL. The name Oracle comes from the code name of a project of CIA named “Project Oracle”. In 1978, SDL was renamed as Relational Software Inc (RSI). In 1983, RSI became Oracle Systems Corporation and later Oracle Corporation.
In 1979, RSI introduced Oracle V2 (Version 2) as the first commercial SQL based RDBMS. This is a landmark in the history of relational databases.
In 1983, first portable version was released. It was the first RDMS to run on PCs, minicomputers, and mainframes.

Oracle Database Version History
The major Oracle versions are given bellow:

  • Oracle 7
  • Oracle 8
  • Oracle 8i
  • Oracle 9i (Release 1)
  • Oracle 9i (Release 2)
  • Oracle 10g (Release 1)
  • Oracle 10g (Release 2)
  • Oracle 11g (Release 1)
  • Oracle 11g (Release 2)
  • Oracle 12c (Release 1)

Oracle Certification Program
Oracle provides a professional certification program that includes the administration of Oracle Databases. It contains three levels and is given bellow:

  1. Oracle Certified Associate (OCA)
  2. Oracle Certified Professional (OCP)
  3. Oracle Certified Master (OCM)

Editions of the Oracle Database
The available Oracle database server editions are given bellow:

  • Oracle Enterprise Edition
    This is the top level version of the Oracle database that is for the big enterprise customers.
  • Oracle Standard Edition
    This is the four processor version of Oracle Database that provides full clustering support
  • Oracle Standard Edition One
    This is the two processor version of Standard Edition.
  • Oracle Personal Edition
    This is the full featured version for individuals. It is compatible with the entire Oracle Database family (except Real Application Clusters).
  • Oracle Express Edition
    This is the free version of Oracle that is limited to 1 processor, 1 GB RAM and 11 GB of data.

That’s all about Oracle database.

No Responses

Leave a Reply

Your email address will not be published. Required fields are marked *