Introduction – DBMS and RDBMS

What is DBMS ?

A DBMS is a set of software programs that controls the system organization, storage, management, and retrieval of data in a database. The DBMS determines how data are stored and retrieved.

Data is the back bone of any organization. So it is very essential to manage it in a efficient way. DBMS accepts request from application and processes in the operating system and vice verse.

Examples :- Oracle, Microsoft SQL Server, DB2, MySQL etc.

Features of DBMS

1. Data Security –

DBMS is capable of protecting the data stored inside the database. Examples are database passwords, schema management etc.

2. Data Integrity –

DBMS ensures the data integrity by maintaining the transcriptional and user level access. It eliminates the unwanted duplicity.

3. Data Access –

DBMS provides an efficient way to access and manage the data called SQL (Structured Query Language). All modern databases support SQL.

4. Data Audit –

DBMS should allow to audit and manage the data stored inside the database.

What is RDBMS ?

Any DBMS which has the ability to represent the data in set of tuples (related set of data) which share the same type is called RDBMS. In another way it organizes data into related rows and columns. All RDBMS terms can be defined in mathematical terms. In RDBMS all tables will have a relationship among.

Relational Model

The fundamental assumption of the relational model is that all data is represented as mathematical n-tuples relations. The relational model of data permits the database designer to create a consistent, logical representation of information.

Comparing Relational and Mathematical models

Relational Model Mathematical Model
Column Attribute
Row Tuple
Table Relation
Data Set Element

 

Advertisements

Author: sqlandplsql

To learn more about the Oracle, SQL, PL SQL, Performance Tuning, Database Modeling, Ubuntu, MySQL etc .Suggestions, comments, feedbacks and referrals are highly appreciated.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s