Sunday 9 June 2013

DBMS and RDBMS

Data is one of the most important assets of a company. It is very important to make sure data is stored and maintained accurately and quickly.

Database Management System (DBMS)
Database Management System is a collection of interrelated data and set of programs to access those data. The DBMS is a general purpose software system that facilitates the process of defining constructing and manipulating databases for various applications.

Most of the currently popular DBMS have more complex architecture. Moreover not only human users but other programs also can interact with the DBMS. In this arrangement the database is commonly known as back-end while the user program is called front-end.

Relational Database Management System (RDBMS)
A DBMS that is based on relational model is called as Relational Database Management System. Relation model is most successful mode of all three models. Designed by E.F. Codd, relational model is based on the theory of sets and relations of mathematics.

Relational model represents data in the form a table. A table is a two dimensional array containing rows and columns. Each row contains data related to an entity such as a student. Each column contains the data related to a single attribute of the entity such as student name.

RDBMS = DBMS + REFERENTIAL INTEGRITY


EmoticonEmoticon