There are many different database types available, each with advantages and disadvantages. Each database type creates a specific environment for storing the relationships between data and information.
Relational databases store data in a table-like row and column structure with a focus on data consistency. This database type focuses on the relationships between data and is the most widely used database type. Object-oriented databases combine object-oriented programming (OOP) principles with relational database standards. Distributed databases are distributed across multiple sites and scaled horizontally. A data warehouse consistently integrates data from different ** into a single decision support system. Repositories can hold large amounts of data and often reside on big data servers. NoSQL databases are databases with a variety of structures with a strong focus on high availability. The NoSQL system is best suited for large amounts of unstructured data. A graph database is a type of NoSQL database that focuses on the relationships between data points. Graph databases have a topological network structure and are the best system for exploring and discovering relationships. With a focus on short-term, day-to-day transactions, the OLTP database supports a large user base with high data integrity and validity in concurrent queries. The open-source database can be modified and used for free. Customizable user preferences and low cost have led to widespread adoption of this database type. Cloud databases have all the features of a traditional database with the flexibility of cloud computing. A multi-model database provides an engine for handling multiple database model types. A document JSON database is a NoSQL storage system that stores data in JSON documents. Autonomous Cloud Database (Autonomous Database) uses machine learning Xi to automate a variety of tasks in a DBMS. 