SQL
- Relational database management system (RDBMS)
- These databases have fixed or static or predefined schema
- These databases are not suited for hierarchical data storage.
- These databases are best suited for complex queries
- Vertically Scalable
- Example - MySQL, PostgreSQL, Oracle
NoSQL
- Non-relational or distributed database system.
- They have dynamic schema
- These databases are best suited for hierarchical data storage.
- These databases are not so good for complex queries
- Horizontally scalable
- Example - MongoDB, Cassandra, Redis
Top comments (0)