Thursday, June 17, 2010

History of oracle

HISTORY OF ORACLE

More than three decades ago Larry Ellison saw an opportunity other companies missed: a description of a working prototype for a relational database. No company had committed to commercializing the technology, but Ellison and co-founders Bob Miner and Ed Oates realized the tremendous business potential of the relational database model.

l Software Development Laboratories – the company's name before it was called Oracle was founded by the Trio Larry Ellison, Bob Miner, and Ed Oates.

l Throughout its history Oracle has proved it can build technology for the future on the foundation of its innovations and, its intimate knowledge of customer challenges and successes analyzed by the best technical and business minds in the world.

l Thirty years later, Oracle is the gold standard for database technology and applications in enterprises throughout the world, from the largest multinational corporations to the corner coffee shop

1978: Oracle version 1

l Ran on PDP-11 under RSX, in 128 KB memory

l Written in assembly language

l Separated Oracle code (OPI) and user code (UPI)

1979: Oracle version 2

l • Written in PDP-11 assembly language

l • Ran on VAX/VMS in compatibility mode

1980: Oracle version 3

l Written in C: portable source code

l Retained split architecture

l Introduced the concept of atomic SQL execution

and transactions (commit, rollback)

1984: Oracle version 4

l Introduced read consistency

l Ported to many platforms

l Interoperability between PC and server

1986: Oracle version 5

l True client-server (distributed processing)

l VAX-cluster support

l Version 5.1: Distributed queries

1989: Oracle version 6 (major kernel rewrite)

l OLTP performance enhancements, savepoints

l Online backup and recovery

l Row-level locking, PL/SQL in the database

l Parallel Server (VAX clusters, nCube)

1993: Oracle7

l Declarative referential integrity

l Stored procedures and triggers

l Shared SQL, parallel execution

l Advanced replication

1997: Oracle8

l Object-relational extensions in the database

l From client/server to three-tier architecture

l Partitioning option

1999: Oracle8i

l Java in the database (JVM and SQLJ)

l Partitioning enhancements

l Data warehousing enhancements

l XML support

l Summary management

l Oracle Internet Directory (LDAP)

l Ported to Linux

2001: Oracle9i

l Real Application Clusters, with cache fusion

l Scalability on inexpensive clustered hardware

l Automatic segment-space management

l Internet security enhancements

l Integrated business intelligence functionality

l Data Guard (standby databases)

l Oracle managed files

l Globalization support (Unicode, time zones, locales)

2003: Oracle 10g

l Primary goal: Build a self-managing database that requires minimal human intervention.

l Reduction in administration cost without compromising high availability, scalability, and security.

l Minimal performance impact

l Effective for all configurations and workloads