Database Management System
Database
A collection of inter-related data used for retrieval, insertion and deletion of data.
Organizes data in the form of a table, schema, views, and reports.
Example: College Database containing information about the admin, staff, students and faculty.
Database Management System
Software used to manage the database.
Examples: MySQL, Oracle
Provides an interface to perform operations like database creation, data storage, updating data and creating tables.
Offers protection and security to the database.
Maintains data consistency for multiple users.
Characteristics of DBMS
Uses a digital repository to store and manage information.
Provides a clear and logical view of data manipulation.
Contains automatic backup and recovery procedures.
Follows ACID properties to maintain data integrity.
Reduces complex relationships between data.
Supports manipulation and processing of data.
Provides data security.
Allows viewing the database from different viewpoints.
Advantages of DBMS
Controls database redundancy.
Enables data sharing.
Facilitates easy maintenance.
Reduces time.
Provides backup.
Offers multiple user interface.
Disadvantages of DBMS
High cost of hardware and software.
Large size.
Complexity.
High impact of failure.

свернуть