what are tje different type of database ?explain each of them briefly
Answers
Answer:
1. Centralised Database
The information(data) is stored at a centralized location and the users from different locations can access this data. This type of database contains application procedures that help the users to access the data even from a remote location.
2. Distributed Database
Just opposite of the centralized database concept, the distributed database has contributions from the common database as well as the information captured by local computers also.
3. Personal Database
Data is collected and stored on personal computers which is small and easily manageable. The data is generally used by the same department of an organization and is accessed by a small group of people.
4. End User Database
This is a shared database which is specifically designed for the end user, just like different levels’ managers. Summary of whole information is collected in this database.
5. Commercial Database
These are the paid versions of the huge databases designed uniquely for the users who want to access the information for help. These databases are subject specific, and one cannot afford to maintain such a huge information. Access to such databases is provided through commercial links.
6. NoSQL Database
These are used for large sets of distributed data. There are some big data performance issues which are effectively handled by relational databases, such kind of issues are easily managed by NoSQL databases. There are very efficient in analyzing large size unstructured data that may be stored at multiple virtual servers of the cloud.
7. Operational Database
Information related to operations of an enterprise is stored inside this database.
8. Relational Databases
These databases are categorized by a set of tables where data gets fit into a pre-defined category. The Structured Query Language (SQL) is the standard user and application program interface for a relational database.
9. Cloud Databases
A cloud database is a database that has been optimized or built for such a virtualized environment.
10. Object-Oriented Databases
An object-oriented database is a collection of object-oriented programming and relational database. An object-oriented database is organized around objects rather than actions, and data rather than logic.
11. Graph Databases
The graph is a collection of nodes and edges where each node is used to represent an entity and each edge describes the relationship between entities.
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.