Data Base:
Collection of data will be stored in the data base.
A database is an organized collection of data that is stored and managed in a structured manner. It is designed to efficiently store and retrieve large amounts of information.
DBMS (Database Management System)
A database management system (DBMS) is middleware that allows programmers, database administrators , software applications and end users to store, organize, access, query and manipulate data in a database.
DBMSs are important because they provide efficient and reliable mechanisms for organizing, managing and using vast amounts of data while also ensuring data integrity and providing other data management benefits.
In another words
- DBMS stand for Database Management System.
- DBMS is software.
- DBMS is responsible for all the type of operation such a inserting the data, deleting the data and modifying the data etc.
- DBMS is a intermediate between user and the database.
Types of DBMS
Here are some common types of DBMS:
- RDBMS
- HDBMS
- NDBMS
- Relational Database Management System (RDBMS): This is the most prevalent type of DBMS. It organizes data into tables with rows and columns, and establishes relationships between tables using keys. RDBMS ensures data integrity, enforces constraints, and supports SQL for querying and managing data. Examples include MySQL, Oracle Database, Microsoft SQL Server, and PostgreSQL.
- Hierarchical Database Management System: In this type of DBMS, data is organized in a tree-like structure, where each record has a parent-child relationship. The parent can have multiple children, but each child can have only one parent. Hierarchical DBMS is mainly used in mainframe systems and is less commonly used today.
- Network DBMS: Similar to hierarchical DBMS, network DBMS organizes data in a more flexible network structure, allowing each record to have multiple parent and child relationships. It allows for more complex data relationships than hierarchical DBMS. CODASYL DBMS (Conference on Data Systems Languages) is an example of a network DBMS.