Junior — Middle
Can you name different types of database management systems?
sobes.tech AI
Answer from AI
Database management systems (DBMS) can be classified by various criteria. The main types:
- Relational DBMS (RDBMS): data is stored in tables with clearly defined relationships. Examples: MySQL, PostgreSQL, Oracle.
- Document-oriented DBMS: store data in the form of documents (usually JSON or BSON). Example: MongoDB.
- Key-Value DBMS: simple structure where data is stored as key-value pairs. Example: Redis.
- Columnar DBMS: optimized for storing and processing large volumes of data by columns. Example: Apache Cassandra.
- Graph DBMS: store data as nodes and edges of a graph, suitable for complex relationships. Example: Neo4j.
Each type is suitable for different tasks and use cases.