Home » 2013 » March

Monthly Archives: March 2013

Object Oriented DBMS (OODBMS)


Please visit SQLVERSITY.COM for more details.

A database management system is said to be object oriented, if the data is stored in the form of objects.

The name itself says that Object Oriented(OO) + Database Management System(DBMS). That means, If we integrate the features of object oriented programming language like C++, Java, C# etc.. and database, the result will be object oriented database management system(OODBMS). It is also called as an object database management system (ODMS). It allows the developers to store the data or modify the data in the form of objects.

Ex: EyeDB, Versant etc..



Flat File Based DBMS (FDBMS)

Flat File Database

Please visit SQLVERSITY.COM for more details.

A flat file database is a database which stores the data in plain text file. It is a database consisting of a single table with no structure and relationship.

This kind of database holds one record in a row and fields are separated by delimiters like commas or tabs spaces or pipe symbols or may have fixed length.


Relational DBMS (RDBMS)

What is RDBMS

Please visit SQLVERSITY.COM for more details.

A Database Management System is said to be Relational if it works based on Relational model. This was introduced by E.F.Codd in 1969.

A relational database is a collection of data organized and described in terms of related tables from which data can be accessed easily. A relational database is created using the relational model.

Network DBMS (NDBMS)

Please visit SQLVERSITY.COM for more details.

A DBMS is said to be Network DBMS, when it organizes the data in a network structure. As you all are aware that, a network may have as many connections as it can.

In our DBMS language, we can say that a parent can have many children and a child can have more than one parent. So a Network DBMS will have many-to-many relationship.

There are some differences between hierarchical DBMS and Network DBMS.