Types Of Database Management System

DBMS Tutorial



[fblike]

Types Of DBMS (Database Management Systems)

  • With respect to the need and requirement of users in industry, different types of Database Management Systems were introduced to let the compatibility of user’s requirement match with the types of DBMS(Database Management Systems) available.
  • These types of databases are generated and introduced on the basis of certain requirement parameters and technology change. Some of them are listed below.

 

Types Of DBMS

Types Of DBMS

 

1. Types Of DBMS : File Processing System

  • File Processing System is a traditional approach of storing and managing data. Data Storage was being done by storing the information in files present in the computer. If in case there is a need of data, the files were checked individually to retrieve desired results.
  • For small scaled data, file processing system was a good option to store, manipulate and retrieve data. But when the size of data increases, file processing system was so slow to generate desired results and it lagged behind. It was a tough job file processing system to input such a large data in the form of files and completely impossible to retrieve data just by simply searching it in every file.
  • Other problems of file processing system includes data duplicity(redundancy), low security of data, inability to handle multiple user request at same time and many more. That is why file processing system was left out and other databases are being used now.

 

2. Types Of DBMS : Relational Database Management System(RDBMS)

  • In Relational Database Management Systems, unlike file processing system the data is stored in the tables(having rows and columns) where any table can be related or linked to any other table using certain concepts. Also, data storage using tables makes it very easy to maintain, manage and manipulate records.
  • The data stored in tables is presented as relation and this data can be extracted and retrieved at any point of time. This can be done by using query languages such as SQL(Structured Query Language) which helps in data manipulation and data extraction.

 

Types Of DBMS : RDBMS

Types Of DBMS : RDBMS

 

3. Types Of DBMS : Network Database Management System(NDBMS)

  • Network Database Management System is another type which was very popular in the late 1970’s. These databases were known to be very adaptable and flexible in terms of data storage because of their data storage architecture. But, the problem aroused at the time of data retrieval as their flexibility became the major issue.
  • Every dataset being related to every other data set forming a network made it very complex and difficult to search and get back the required data. Hence, they were also avoided and are not being used now.

 

Types Of DBMS : NDBMS

Types Of DBMS : NDBMS

 

4. Types Of DBMS : Hierarchical Database Management System(HDBMS)

  • The Hierarchical Database Management System works on the concept similar to that of “Concept Hierarchy” . The whole database is structured and architecture in the form similar to the structure of tree, making it one of the simplest and fastest database present out there.

 

Types Of DBMS : HDBMS

Types Of DBMS : HDBMS

 

5. Types Of DBMS : Object-Oriented Database Management System(OODBMS)

  • They are different from other databases as Object-Oriented Database Management Systems revolves around “Object”(An object here referred to any real world entity) and is based upon the concept of various object oriented languages such as “C++, Java” etc.
  • OODBMS also pertains the concepts of:
    1. Encapsulation.
    2. Inheritance.
    3. Overloading.
    4. Overriding.
  • OnNotes, Poet, EyeDB are some of the examples of OODBMS.