architecture of database management system pdf

End users and software programs are free from having to understand where the data is physically located or on what type of storage medium it resides because the DBMS handles all requests.

A DBMS can limit what data end users see and how they view the data, providing many views of a single database schema. The DBMS provides a centralized view of data that can be accessed by multiple users from multiple locations in a controlled manner. Most database management systems are also responsible for automated rollbacks and restarts as well as logging and auditing of activity in databases and the applications that access them. The DBMS supports many typical database administration tasks, including change management, performance monitoring and tuning, security, and backup and recovery. These three foundational elements help provide concurrency, security, data integrity and uniform data administration procedures. The DBMS manages the data the database engine allows data to be accessed, locked and modified and the database schema defines the database's logical structure.

The most prevalent type of data management platform, the DBMS essentially serves as an interface between databases and users or application programs, ensuring that data is consistently organized and remains easily accessible. A DBMS makes it possible for end users to create, protect, read, update and delete data in a database. A database management system (DBMS) is system software for creating and managing databases.

Architecture of database management system pdf