Junior — Middle
Can you list the main types of database management systems you know?
sobes.tech AI
Answer from AI
Main types of database management systems (DBMS):
- Relational DBMS (RDBMS) — store data in tables with clearly defined relationships. Examples: MySQL, PostgreSQL, Oracle.
- Document-oriented DBMS — store data in document formats (e.g., JSON). Example: MongoDB.
- Key-Value (Key-Value) DBMS — simple key-value pair storage structure. Example: Redis.
- Column-oriented DBMS — optimized for storing and processing large volumes of data by columns. Example: Apache Cassandra.
- Graph DBMS — store data as graphs (nodes and edges). Example: Neo4j.
Each type is suitable for different tasks depending on data structure and performance requirements.