Relational Database Management System
In this lecture, you will know an understanding of the relational database management system that is also known with the name RDBMS and the object relational database management system that is ORDBMS. You will also be introduced to the following terms: A database management system (DBMS) is a collection of set of programs that enables users to create and maintain a database. The DBMS is thus a general- purpose software system which facilitates the processes of defining, manipulating, and constructing databases for several applications.
Database Management System
In this section of this chapter we shall discuss about database and associative concepts. A database is the system and a static storage area which works on it is known as the DBMS Database Management System. The user interacts with DBMS and not with the database. The major purpose of a DBMS is to give an effective way of retrieving and storing the data faster for both type of user either is single- user or multi-user systems.
Database Management largely includes:
• Storage of Data
• Manipulation of the data
• For unauthorized users Access restriction.
Functions of a DBMS
Some of the functions of DBMS are as given below:
» Database Definition – how data is to be stored and organized
» Database Creation – Storing data in a defined database
» Data Retrieval –Reporting and Querying
» Updating – changing the contents of the database
» For system development Programming user facilities
» Database revision and restructuring
» Database Integrity control
» Performance monitoring
Characteristics of DBMS
» Control of data redundancy
» Sharing data
» Maintenance of integrity
» Support for transaction control and recovery
» Data independence
» Availability of productivity tools
» Security
» Processing speeds
» Hardware independence
Relational Database Management Systems (RDBMS)
It is the most popular model and solves most of the problems which existed in the previous models. A basic definition of RDBMS is:
“Database management system is the system where data are organized as tables of data values and all the operations on the data work on the these tables”