Types of Databases



Types of Databases

There are many different types of databases. The best database for a specific organization depends on how the organization intends to use the data.


Which types of Database exists?

Relational databases: Relational databases became dominant in the 1980s. Items in a relational database are organized as a set of tables with columns and rows. Relational database technology provides the most efficient and flexible way to access structured information.

Object-oriented databases: Information in an object-oriented database is represented in the form of objects, as in object-oriented programming.

Distributed databases: A distributed database consists of two or more files located in different sites. The database may be stored on multiple computers, located in the same physical location, or scattered over different networks.

Data warehouses: A central repository for data, a data warehouse is a type of database specifically designed for fast query and analysis.

NoSQL databases: A NoSQL, or nonrelational database, allows unstructured and semistructured data to be stored and manipulated (in contrast to a relational database, which defines how all data inserted into the database must be composed). NoSQL databases grew popular as web applications became more common and more complex.

Document/JSON database: Designed for storing, retrieving, and managing document-oriented information, document databases are a modern way to store data in JSON format rather than rows and columns.

Database Image

Source: Oracle Database

Source: Wikipedia-Embedded_System

DataBase

A database(DB) is an organized collection of data that is stored and managed so it can be easily accessed, modified, and retrieved.

SQL

SQL is a programming language used by nearly all relational databases to query, manipulate, and define data, and to provide access control.