Types of DBMS

Database managment are Categoriesed as the structure of the Database or how to organized the data into the Database.

• Relational DBMS (RDBMS): Stores data consist of rows and columns in the database where relationships between tables are established through Key. like- MySQL, Oracle Database, Microsoft SQL Server, PostgreSQL, MariaDB.

• NoSQL DBMS:Designed for handling large volumes of unstructured or semi-structured data, often used in big data and real-time web applications. NoSQL databases offer flexibility in schema design and scalability. They can be further categorized by their data model. Like-MongoDB (document), Cassandra (column-family), Redis (key-value), Neo4j (graph).

• Hierarchical DBMS:Organizes data in a tree-like structure with a parent-child relationship, where each child record has only one parent. This model is efficient for specific applications with clear hierarchical data. Like -IBM, Information Management System (IMS).

• Network DBMS:Extends the hierarchical model by allowing a child record to have multiple parent records, creating a more complex graph-like structure. This enables representation of many-to-many relationships. Like- Integrated Data Store (IDS).

• Object-Oriented DBMS (OODBMS): Stores data as objects, similar to object-oriented programming concepts. It supports complex data types and relationships, including inheritance and polymorphism. Like- DB4O, ObjectDB.