Question

What are the types of database? Explain each of them.​

Answer 1

Answer:

A system that contains databases is called a database management system, or DBM. We discussed four main types of databases: text databases, desktop database programs, relational database management systems (RDMS), and NoSQL and object-oriented databases.

Answer 2

Answer:

$\huge\underbrace\mathcal\pink{database}$

database is a collection of data or records.

$\huge\underbrace\mathcal\pink{types}$

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

$\huge\underbrace\mathcal\blue{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.

Advantages of hierarchial database-

A hierarchical database can be accessed and updated rapidly

Disadvantages of hierarchial database-

This type of database structure is that each child in the tree may have only one parent. Relationships or linkages between children are not permitted, even if they make sense from a logical standpoint. Hierarchical databases are like this in their design. Adding a new field or record requires that the entire database be redefined.

$\huge\underbrace\mathcal\blue{network database}$

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.

Popular network database-

Some of the popular network databases are Integrated Data Store (IDS), IDMS (Integrated Database Management System), Raima Database Manager, TurboIMAGE, and Univac DMS-1100.

$\huge\underbrace\mathcal\blue{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.

Advantages of relational database-

Relational databases can be used with little or no training.

Database entries can be modified without specifying the entire body.

$\huge\underbrace\mathcal\blue{Object-Oriented Model</p><p> }$

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. It adds the database functionality to object programming languages.

Disadvantages of Object-oriented databases-

Object-oriented databases are more expensive to develop.

Most organizations are unwilling to abandon and convert from those databases.

Benefits of Object-oriented databases-

The benefits of object-oriented databases are compelling. The ability to mix and match reusable objects provides incredible multimedia capability.

$\huge\underbrace\mathcal\pink{graphdatabases}$

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.

$\huge\underbrace\mathcal\pink{ER model database}$

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

$\huge\underbrace\mathcal\pink{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.

$\huge\underbrace\mathcal\pink{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.

Here is a list of 5 popular NoSQL databases:

1. Cosmos DB
2. ArangoDB
3. SAP HANA
4. Informix
5. Amazon DocumentDB

Hope it helps you❤️

stay safe and blessed ❤️

goodluck4Ur bright future ❤️