Types of DBMS (based on the type of data) §
- Relational
- Data is organised into tables
- SQL is used for performing operations on data
- Ex: Oracle MySQL, PostgreSQL, MSSM, etc.
- No-SQL
- Databases designed to handle semi-structured (
JSON, YAML) and unstructured data (sensor data, multimedia data)
- Types,
- Document based - MongoDB, Couchbase
- Key-Value - Redis, DynamoDB
- Graph - Neo4j, Amazon Neptune
- Columnar - Cloud Bigtable, Cassandra
- Object-Oriented (OODBMS)
- Stores data in the form of Objects
- Ex: ObjectStore, Versant
- Hierarchical DBMS
- Network DBMS
- In-memory