Introduction to Oracle Database
It is very large and multi user Database Management System. Oracle Database is a collection of data treated as a unit. The purpose of a database is to store data and retrieve related information.
Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. It is the excellent database server choice for client/computing. Oracle supports in all major operating system.
The database has logical structures and physical structures. Because the physical and logical structures are separate, the physical storage of data can be managed without affecting the access to logical storage structures.
i – internet
g – grid
c – cloud
1977 : Software Development Laboratories, the precursor to Oracle is founded by Larry Ellison, Bob Miner and Ed Oates.
1978 : Oracle Version 1, written in assembly language runs on PDP-11 under RSX in 128K of memory. Implementation separates Oracle code and user code. Oracle V1 is never officially released.
1979 : Oracle Version 2, the first commercial SQL relational database management system was released. The company changed its name to Relational Software Inc. (RSI).
1981 : RSI Started developing tools for Oracle.
1982 : RSI Renamed as Oracle Corporation.
1983 : Oracle Released version 3.0 (rewritten in C language and multiple Platforms).
1984/1985 : Oracle Released version 4.0 ( Concurrency control , consistency etc)
1986 : Oracle Released client/server relational database.
1989 : Oracle Released version 6.0.
1997 : Oracle Released version 8.0 (object relational).
1999 : Oracle Released version 8i (internet) (Java Virtual Machine).
2000 : Oracle Released Application Server.
2001 : Oracle Released 9i (internet) Database server.
2003/2004 : Oracle Released 10g (Grid) Database server.
2009 : Oracle Released Oracle version 11g (Grid) Database server.
2014 : Oracle Released Oracle 12c (Cloud) Database server.
Feature of Oracle Database Server
- Self Managing Database
- Read Consistency
- Locking Mechanisms
- SQL *Plus
- Data Warehousing
- Data mining
- Analytic SQL
- Resource Manager
- Materialized Views
- Table Compression
- Parallel Execution
Part 1 :