DBMS
Database management system (DBMS) is computer software for storing and retrieving users’ data while considering appropriate security measures. It consists of a group of programs which manipulate the database. In other word, DBMS is software that is used to record and process the data in order to produce accurate and reliable information. It is also called as a digital warehouse as it collects, process, stores, distributes and terminates various available data in an organization and provides meaningful information to the management to make managerial decision. It is widely used in banking sectors to conduct financial transactions with the help of Core banking software which is an example of DBMS.
Features of DBMS
The data are combined to form operational units to minimize the duplication of data and increase access to all data in the data base.
Protect the data from physical harm and un-authorized systems.
Allow for growth in the data base system.
Make the latest modifications to the data base available immediately.
Allow for multiple users to be active at one time.
Provide prompt response to user requests for data.
Functions of DBMS
A mechanism for organizing, structuring and storing data.
A mechanism for accessing data that provides a measure of data independence, i.e., to some extent it insulates application programs from changes to the data structure.
Creating program and data independence. Either one can be altered independently of the other.
Reducing data redundancy.
Providing security to the user’s data. Access is limited to authorized users by pass words or similar schemes.
Reducing physical storage requirements by separating the logical and physical aspects of the data base.
Users of DBMS
Database Administrators are needed to administer and monitor usage of the Database. They are responsible to tune the Database for performance issues, to grant access of DB to users and initiate recovery in event of system crash and protect the system in case of security issues.
Database Designers come into picture before a database is built. They gather requirements from all prospective users; level of access required for each user or a group and designs the DB which meets the requirement. They are responsible for identifying the data to be populated and appropriate data strictures for the database. They are generally part of Database Administrators.
Application programmers are necessary to built user interfaces and applications to satisfy needs of end users. They develop applications which make data retrieval, creation of reports more convenient. They are fully aware of all the functionalities of DB and use it to their advantage.
Final users use such system after the development of it to conduct business transactions; they perform several activities such as collecting, recording, processing data to produces reliable information to make managerial decision.
? What are its features, purpose, and functions?Who are the users of DBMS?){kind=link}