Type of Database Management System

Here is all about DBMS data model.

1. 1
Deep and pointwise information about database users
BY Param Radadiya

2. Param
Source : Internet
2
Q1. Type of Database.
Ans.
There are many type of Database in real world depending
upon the usage, But mostly we uses few of them which are describe
as below.
Databases
Object-oriented
Database
Relational
Database
Network
Database
Hierarchical
Database
Entity-
Relationship
Database
Now, let’s talk about all these Databases and get some
related details and know the usage.

3. Param
Source : Internet
3
oHierarchical Database:
•This data model is recognized as the first database model which
was created by IBMin 1960.
•In this type of Data model, data are organized into Tree-like
structure.This structure is simple but inflexible because the
relationship is confined to a one-to-many relationship.
•A record is a collection data, and these type of records stored in
this data model which are connected through Links.
•In this data model, each parent record can have one or more child
records, but each child record has only one parent record.
•Currently hierarchical databases are still widely used especially in
applications that require very high performance and availability such
as banking and telecommunications.
•Example of Hierarchical Data model show as below chart.

4. Param
Source : Internet
4
oEntity-Relationship Database:
•Entity-Relationship was developed and design by Peter Chen in
1976.
•Basically, ER model is composed of entity types and specifies
relationship that can exist between entities. And it’s describes
interrelated things of interest in a specific domain of knowledge.
•ER database model is commonly use to represent things of
business needs to remember in order to perform business
processes.
•Entities and relationships can both have attributes. Examples: an
employee entity might have a Social Security Number attribute,
while a proved relationship may have a date attribute.
•Every entity must have a minimal set of uniquely identifying
attributes, which is called the entity's primary key.
•Example of ER model.

5. Param
Source : Internet
5
oRelational Database:
•Relational data model first described by Edgar Coddin 1969.
•It’s also called as RDBMS.
•This model is use to managing data using structure and language
consistent with first-order predicate logic.
•The purpose of the relational data model is to managing system
software take care of describing data structures for storing the
data and retrieval procedures for answering queries.
•Example of Relational data model is show as below diagram.

6. Param
Source : Internet
6
oObject-oriented Database:
•This data model was considered in the 1980.
•It’s also called as ODBMS.
•In this data model information is represented in the form of
objects as used in object-oriented programming.
•ODBMS is used in those companies that are geared towards
multimedia presentation or organizations that utilize computer-
aided design (CAD).
•Example :

7. Param
Source : Internet
7
oNetwork Database:
•Sometimes this data model is known as CODASYL model because
this model was adopted by the CODASYL Data Base Task Group in
1969.
•This model is conceived as a flexible way of representing object
and their relationships.
•The network model allows each record to have multiple parent and
child records, forming a generalized graphstructure.
•Network and Hierarchal databases were persuasive for many large-
scale applications, but as hardware became faster, the extra
productivity and flexibility of the relational model led to the gradual
obsolescence of the network model in corporate enterprise usage.
•Example :