1.Oracle Version & its Features
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 Oracle Version 3.1980: Written in C, Portable Source Code Retained Split Architecture Introduced the concept of Atomic SQL Execution and transactions (Commit & Rollback) Oracle Version 4, 1984: Introduced Read Consistency. Portable to many platforms Interoperability between PC and Server Oracle Version 5, 1986: True Client Server ???Distributed Processing VAX ???Cluster Support Version 5.1- Distributed Queries Oracle Version 6, 1989: 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) Oracle Version 7, 1993: Stored Procedures and Triggers Shared SQL, Parallel Execution Declarative Referential Integrity Advanced Replication Oracle Version 8, 1997: 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 |