Examples of DBMS - SS3 ICT Lesson Note

There are various types of DBMSs designed for different purposes. Here are some examples:

Relational DBMS (RDBMS): These systems store data in tables with predefined schemas. Examples include:

• Oracle Database
• MySQL
• Microsoft SQL Server
• PostgreSQL

 

NoSQL DBMS: These databases are used for unstructured or semi-structured data and include types like:

• MongoDB (document-oriented)
• Cassandra (wide-column)
• Redis (key-value)
• Neo4j (graph)

 

Object-Oriented DBMS (OODBMS): These systems store data as objects, suitable for object-oriented programming. Example include:

• db4o

 

NewSQL DBMS: These combine the benefits of traditional RDBMS and NoSQL databases, aiming for high scalability and performance. Example:

• Google Spanner

 

In-Memory DBMS: These databases store data in memory for lightning-fast access. Example:

• SAP HANA

 

Time-Series DBMS: Designed for handling time-series data efficiently. Example:

• InfluxDB

 

Graph DBMS: Specialized for managing and querying graph data structures. Example:

• Amazon Neptune

 

Each DBMS type serves specific use cases and offers different features, allowing organizations to choose the one that best fits their data management needs.