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