Oracle Version 1, 1978
Written in Assembly Language
Ran under PDP-11 under RSX in 128K of Memory
Implementation separates oracle code and user code.
Oracle Version 2, 1979
The first SQL Relational Database Management system that was commercially released.
Written in PDP-11 Assembly Language
Ran on VAX/VMS in Compatibility mode
Written in C, Portable Source Code
Retained Split Architecture
Introduced the concept of Atomic SQL Execution and transactions (Commit & Rollback)
Introduced Read Consistency.
Portable to many platforms
Interoperability between PC and Server
True Client Server –Distributed Processing
VAX –Cluster Support
Version 5.1- Distributed Queries
Major Kernel Rewritten
OLTP Performance enhancements (save points)
Online Backup and Recovery
Row level Locking
PL\SQL in the database
Parallel Servers (VAX Clusters, nCube)
Stored Procedures and Triggers
Shared SQL, Parallel Execution
Declarative Referential Integrity
Advanced Replication
Object Relation Extensions in the Database
From Client Server to Three tier Architecture
Partitioning Option
Oracle Version 8i, 1999
Java in the database (JVM and SQLJ)
Partitioning Enhancements
Data Warehousing Enhancements
XML Support
Summary Management
Oracle Internet Directory (LDAP)
Ported to Linux
Oracle Version 9i, 2001
Real Application Clusters, with cache fusion– Scalability on inexpensive clustered hardware
Automatic segment-space management
Internet security enhancements
Integrated business intelligence functionality
Data Guard (standby databases)
Oracle managed files
Globalization support (Unicode, time zones, locales)
Oracle Version 10g, 2003
Primary goal: Build a self-managing database that requires minimal human intervention.
Reduction in administration cost without
Compromising high availability, scalability, and security.
Minimal performance impact
Effective for all configurations and workloads
Oracle Version 11g, 2007
Flashback data Archive
Advanced Compression
Real Application Testing
Automatic Storage Management
