DATABASE MANAGEMENT SYSTEM

Read this Oracle Tutorial Point article to know about Oracle Database Management System and what are different models present in oracle and how to communicate with DBMS. Database Management System is a program. This takes care of,

1. Storing of Information
2. Retrieving of Information
3. Modification of Information
4. Deletion of Information

Different types of Databases:

1. Hierarchical
2. Network
3. Relational
4. Object Oriented
5. Object Relational

Relational Models: The Model was first outlined by E.F.Codd in 1970. The components of Relational Model are,

1. Collection of relations or objects that stores the data.
2. A set of operations that can act on the relations to produce the other relations.
3. Data integrity for consistency and accuracy.

A Relational database uses relations or two dimensional tables to store information.

Data Model:
The Data model's helps in exploring ideas and improve the understanding of the database design.

Purpose of Data Model:

1. Categorize
2. Communicate
3. Describe
4. Specify
5. Investigate
6. Evolve
7. Analyse
8. Imitate

Objective of Models:
To produce a model that fits a multitude of uses. It should be understood by an end user. It should contain enough details for a developer to make the database system.

Relational Database Properties:
It can be accessed and modified by executing SQL(Structured Query Language) statements. It contains a collection of tables with no physical pointers. It uses a group of operators. We need not specify the route to the tables. There is no need to identify how the data is organised physically.

Communicating with RDBMS:
The Structured Query Language is used to communicate with RDBMS.

Structured Query Language:
SQL permits the user to communicate with server. It is efficient and it is easy to learn and use. It's functionally complete, by permitting the user to define, retrieve and manipulate the data.