What are the different types of database management systems?
Database management systems allow users to store pieces of information, organize and load some or all as needed. Each of the main types of database management systems requires a software program that creates records for data organization and creates messages from this data. Database software programs create one of four common types: hierarchical databases, network databases, relational databases or object -oriented databases.
The hierarchical database is one of the oldest types of database management systems. It is most commonly used on the computers of maintenance computers. The creator of the database predefins relations between each record and his data. The structure requires a root record or a parent from which the database designer creates a parent-child relationship for each piece of data that moves into the database.
The network database also organizes data using defined relationships between the parent and the child. Like the real family, the structure of the network database allows pieces of data classified asa child to have more than one parent. This is an improvement compared to the hierarchical types of database management systems. It allows users to connect information in one database to another set of data via a superior record and a child recording.
The management system of relational databases has increased in popularity due to its flexibility and easy use. It allows the database designer to use individual information to create relationships between separate databases without limiting parents or owners' relationships. Information in one database that connects it with data in another is a unique identifier, such as the employee's identification number.
relational types of database management systems allow database designers to create one database to store wage and salaries for employees. The designer creates a separate database personal data such as home addresses and telephone numbers. Different users can enter and updateRecords in each database. Messages pull data from the records of any database in which the corresponding employee identification number is found.
object -oriented types of database management systems provide a way to organize data other than numbers and text. Designers use them to customize multimedia items such as photos, music and videos. This database management system uses two identifiers for each item. The first is the descriptive name of the object and the second is a miniature program with instructions or methods that the computer runs during storage and search. Both parts become an object that database users can organize as they can with text or numbers.