What is DBMS, and what are its primary functions and its relationships in database management?
management system is a computer based system to manage a database,
or a collection databases or files. The essential word here is manage
management implies the controlled use of a resource, that is controlling
its quality coordinating shared use, of a resource, that is, controlling
its quality, coordinating shared use and controlling access to authorized
A DBMS has many uses:
- it enables users to access and manipulate the database.
- it provides a building block in constructing data processing systems for applications requiring database access – MIS or systems for accounting, production and inventory control or customer support.
- it helps the DBA perform certain managerial duties.
The name ‘database management system’ was chosen recognizing that different names are in use and different types of systems exist. Substantial generalization is assumed in any DBMS of interest without using ‘generalized.’ ‘Data is preferred over ‘information’ for the various reasons cited.
Functions of a Database
- Database Definition
- Database creation (storing data in a defined database)
- Retrieval (query and reporting)
- Update(Changing the contents of the database)
- Programming User Facilities for system development)
- Database revision and restructuring
- Database integrity control
- Performance Monitoring
Overview of Relationships
in Database Management:
In a database environment, the main components, or players are database users, a database administrator, applications programs, and the DBMS. People can access the database directly using a DBMS, or they can write a program (or have a programmer write one for them, or use a previously written program) in cases requiring special or more complex processing. The DBA establishes and periodically revises the database to meet the needs of the users. The DBA establishes integrity controls.
The users and the DBA communicate formally and informally about system use and database access, and about the regulations and standards in force. Application programs and the DBMS are processes executed by machine. While accessing and controlling the database, the DBMS has three distinct interfaces – with users, with the DBA and with programs. Database users access the database directly using the facilities of the database management system or through a program written by themselves. The database administrator establishes the database and the controls on people and programs using the database.
The Database Administrator must be a manager, rather than a technician – seeking to meet the needs of people who use data. Since many users may share the same data resources, the DBA must be repared to mediate conflicting needs and objectives, sometimes imposing a compromise solution. Functions of Database Administration are as follows:
- Define, acquire
and retire data according to the user needs.
- Provide tools to access and update the data and produce reports.
- Inform and assist users in planning and using data resources and database management tools.
- Maintain database integrity by protecting its existence, maintaining its quality and controlling access to private data.
- Monitor operations for efficient performance and integrity threats.
The central idea
behind managing data resources is getting a handle on organizational
data resources which support operations and management decisions. Proper
management of data also promotes the use of data. Solving the problem
of data management entails both the administrative and technical factors:
creating an effective organizational structure and appointing a responsible
authority called the Database Administrator and using computer based
facilities along with associated operating personnel and procedures.
|Database Management System - DBMS Architecture | High Level Data Oriented Command Languages | Retrieve Data from a Multifile Data Structure in a DBMS Model | Data Structures in Database Management System - DBMS Enviornment | User Interfaces in the DBMS Environment | Objectives of Database Management in an Organization | Relationship in Database Management System - DBMS | Different User Roles in the Database Management System - DBMS Environment | distributed database management | what is database management | management software database | Database File System | Database Management System - DBMS Applications | Program Communication in Database Management System - DBMS | Difference between good database design and a bad one | Good Database Desing Using Normalization | Direct Manipulation in Database Management System - DBMS | MIS and the Role of Database in an Organization | Maintaining database quality in an organization | Validation criteria in a Database Management System - DBMS model | Relational Database Management System - RDBMS | successful database design | Database Management System - DBMS Relationship | | distributed database management | what is database management | management software database | Database File System | Database Management System - DBMS Applications | Program Communication in Database Management System - DBMS | Difference between good database design and a bad one | Good Database Desing Using Normalization | Direct Manipulation in Database Management System - DBMS | MIS and the Role of Database in an Organization | Maintaining database quality in an organization | Validation criteria in a Database Management System - DBMS model | Relational Database Management System - RDBMS | successful database design | Database Management System - DBMS Relationship | Understanding cloud computing database management system | Best Customer Database Software for Small Business |