Thursday, March 6, 2008

Introuduction to Oracle

Overview of RDBMS:
RDBMS is the abbreviation for 'Relational Database Management System'. Proper management of data is very essential to run any concern succesfully. Before the emergence of RDBMS , people used DBMS to manage data. But most of the concerns felt that DBMS was not efficient to meet their expectations. As a result,application developers began to move their attention to other environment like COBOL and C.

Only in late 1970's a mathematician E.F.T.Codd injected new blood into DBMS. He applied principles of relationship of data management. Thus the era of RDBMS began in the early 1980's.

DataBase Management System:
A database Management System is a collection of interelated data together with a set of programs to access the data.
The collection of interrelated data is called the Database.

Any database system consists of two parts. They are
a) Database Management System
b) Database Application
The Database management system is required to organise and maintain the data.
The Database Application is a program to retrive,insert and update the data in the system.