Different type of databases

What are different type of databases?

1. Relational databases
-SQL language
-They are compliant with ACID

Examples – SQL Server, Oracle Database, MySQL, PostgreSQL

2. Cloud databases
-Database that’s designed to run in the cloud.
-cloud databases offer flexibility and scalability, along with high availability
Examples: Azure SQL Database, Amazon Relational Database

3. NoSQL databases
-Non-relational database
-To store unstructured or semi-structured data
-One advantage of NoSQL databases is that developers can make changes to the database on the fly, without affecting applications that are using the database
Examples: MongoDB,Apache Cassandra,CouchDB, and CouchBase

4. Key-value databases
-NoSQL databases
-Key-value databases are highly scalable and can handle high volumes of traffic
-Caching values

Examples: Amazon DynamoDB, Redis

5. Columnar databases
-store data in columns rather than rows
– it essentially ignores all of the data that doesn’t apply to the query, because you can retrieve the information from only the columns you want
-Ever increasing data

Examples: Google BigQuery, Cassandra, HBase, MariaDB

6. Document databases
-document stores, use JSON-like documents to model data instead of rows and columns
-Document databases are simple and scalable, making them useful for mobile apps that need fast iterations.

Examples: MongoDB, Amazon DocumentDB, Apache CouchDB

7.Time series databases (Application pushing matrix)
-database optimized for time-stamped, or time series, data

Examples: InfluxDB, Druid,Open TS DB

8. Data ware house/Offline reporting
When you have lot of information for analysis
Example : Hadoop (Amazon/Uber data)

9. Search relevant text
Elastic search (search engine)
Solr

10. Distributed database
Distribute images to different server across globe
Example : CDN

11.Blob storage
Storing video’s/images (amazon/Netflix)
Example Amazon S3