There are four main types
of database management system:
of database management system:
·
Relational database: Data is
organized as logically independent tables. Relationships among tables are shown
through shared data. The data in one table may reference similar data in other
tables, which maintains the integrity of the links among them. This feature is
referred to as referential integrity – an important concept in a relational
database system. Operations such as “select” and “join” can
be performed on these tables. This is the most widely used system of database
organization.
Relational database: Data is
organized as logically independent tables. Relationships among tables are shown
through shared data. The data in one table may reference similar data in other
tables, which maintains the integrity of the links among them. This feature is
referred to as referential integrity – an important concept in a relational
database system. Operations such as “select” and “join” can
be performed on these tables. This is the most widely used system of database
organization.
·
Network database: A network database is a type of database model wherein multiple member
records or files can be linked to multiple owner files and vice versa. The
model can be viewed as an upside-down tree where each member information is the
branch linked to the owner, which is the bottom of the tree. Essentially,
relationships are in a net-like form where a single element can point to
multiple data elements and can itself be pointed to by multiple data elements.
Network database: A network database is a type of database model wherein multiple member
records or files can be linked to multiple owner files and vice versa. The
model can be viewed as an upside-down tree where each member information is the
branch linked to the owner, which is the bottom of the tree. Essentially,
relationships are in a net-like form where a single element can point to
multiple data elements and can itself be pointed to by multiple data elements.
·
Object oriented database: Data is organized with similarity to object oriented
programming concepts. An object consists of data and methods, while classes
group objects having similar data and methods.
Object oriented database: Data is organized with similarity to object oriented
programming concepts. An object consists of data and methods, while classes
group objects having similar data and methods.
·
Hierarchical database: Data is organized with hierarchical relationships. It
becomes a complex network if the one-to-many relationship is violated.
Hierarchical database: Data is organized with hierarchical relationships. It
becomes a complex network if the one-to-many relationship is violated.
