What are the types of database? Explain each of them briefly
Answers
PLEASE MARK ME AS BRAINLIEST
Explanation:
There are several types of database management systems. Here is a list of seven common database management systems:
1 Hierarchical databases
2 Network databases
3 Relational databases
4 Object-oriented databases
5 Graph databases
6 ER model databases
7 Document databases
8 NoSQL databases
Hierarchical Databases
In a hierarchical database management system (hierarchical DBMSs) model, data is stored in a parent-children relationship node. In a hierarchical database, besides actual data, records also contain information about their groups of parent/child relationships.
In a hierarchical database model, data is organized into a tree-like structure. The data is stored in the form of a collection of fields where each field contains only one value. The records are linked to each other via links into a parent-children relationship. In a hierarchical database model, each child record has only one parent. A parent can have multiple children.
Network Databases
Network database management systems (Network DBMSs) use a network structure to create a relationship between entities. Network databases are mainly used on large digital computers. Network databases are hierarchical databases, but unlike hierarchical databases where one node can have a single parent only, a network node can have a relationship with multiple entities. A network database looks more like a cobweb or interconnected network of records.
Relational Databases
In a relational database management systems (RDBMS), the relationship between data is relational and data is stored in tabular form of columns and rows. Each column if a table represents an attribute and each row in a table represents a record. Each field in a table represents a data value.
Object-Oriented Model
In this Model, we have to discuss the functionality of object oriented Programming. It takes more than the storage of programming language objects. Object DBMS's increase the semantics of C++ and Java. It provides full-featured database programming capabilities while containing native language compatibility.
Graph Databases
Graph Databases are NoSQL databases and use a graph structure for semantic queries. The data is stored in the form of nodes, edges, and properties. In a graph database, a Node represents an entity or instance such as a customer, person, or car. A node is equivalent to a record in a relational database system. An Edge in a graph database represents a relationship that connects nodes. Properties are additional information added to the nodes.
ER Model Databases
An ER model is typically implemented as a database. In a simple relational database implementation, each row of a table represents one instance of an entity type, and each field in a table represents an attribute type. In a relational database, a relationship between entities is implemented by storing the primary key of one entity as a pointer or "foreign key" in the table of another entity.
The entity-relationship model was developed by Peter Chen 1976
Document Databases
Document databases (Document DB) are also NoSQL database that store data in the form of documents. Each document represents the data, its relationship between other data elements, and attributes of data. Document database store data in a key value form.
NoSQL Databases
NoSQL databases are the databases that do not use SQL as their primary data access language. Graph database, network database, object database, and document databases are common NoSQL databases. This article answers the question, what is a NoSQL database.
.
Explanation:
We discussed four main types of databases: text databases, desktop database programs, relational database management systems (RDMS), and NoSQL and object-oriented databases. We also talked about two ways to categorize databases based on their logical design: operational databases and database warehouses.