DATABASE MANAGEMENT SYSTEM OBJECTIVES, ADVANTAGES,FEATURES
DATABASE MANAGEMENT SYSTEM | OBJECTIVES, ADVANTAGES, FEATURES
Normally the DBMS is used for large or medium-sized organizations, having heterogeneous types of files used for different purposes. In this mechanism, the data elements are so integrated, cross-referenced, and shared among them that the duplication of data is almost possible.
DEFINITION OF DATABASE MANAGEMENT SYSTEM:
What is database management systems or database system? The Database Management System a collection of programs that are used for storing and manipulating an online database is called database management system (DBMS). DMBS is an improvement over the traditional file management system. It uses DBMS software which controls the overall structure of a database and access to the data itself.
OBJECTIVE OF DATABASE MANAGEMENT SYSTEM
There are many objectives of the Database Management System some are mentioned below:
Shareability: Different people and different processes must be able to use the same actual data virtually the same line.
Availability: Both the data and DBMS which deliver the data must be easily accessible to the user.
Resolvability: The ability of the DBMS to change in response to growing user needs and advancing technology.
DATABASE Integrity: Since data/information is shared among multiple users, adequate integrity control measures must be maintained.
ADVANTAGES OF DATABASE MANAGEMENT TOOLS:
Advantages of DBMS are given below:
Application(App) programs are not aware of the physical implementation of the data sets. The DBMS sits in between the application programs and the actual data sets that make up the database
SUPPORT COMPLEX DATA RELATIONSHIP:
Really complex data structures can be designed which allow various ways to logically view or access the data. This complexity of data greatly enhances the ability of a designer to put data where it belongs and provide a path to that data whenever needed.
DATA SECURITY FEATURES:
DBMS provide enhance security mechanism for access to data. Database security mechanisms typically go much further to add more extensive security features. If granted Read access to a file or table, the user may see each record in the file, and every data field it contains. Access intent of each application program can be specified explicitly. An application program’s view of data/information records may be controlled to the field level.
DATABASE BACKUP AND RECOVERY:
DBMS provides a sophisticated backup recovery mechanism. Backup and Recovery capabilities often distinguish between true DBMS and a software package that only claims this facility. A DBMS has a logging or recording mechanism that captures information on changes to data within a database. In the case of database recovery, a utility within the DBMS rebuilds it by using a backup copy of the data and log of changes as input.
DBMS normally have advance access capability for online and ad-hoc reporting capabilities. However, the ability to provide data independence to create complex data structures, to provide security to data access, and to provide backup and recovery capability are the primary requirements of a Database Management.
FEATURES OF DATABASE MANAGEMENT SYSTEM
Some database has a data dictionary, procedures a document, or disk file that stores the data definitions or a description of the structure of data used in the database. The data/information dictionary may monitor the data being entered to make sure it conforms to the data definition rules i.e. a file names, field names, field sizes, data types, etc. It may be used for data access authorization for the database system.
Normally SQL is used for creating table structures, entering data into them, and retrieving/updating the selected records, based on the particular criteria and format indicated, within the databases. Typically, the query is in the form of a sentence or English like commands such as SELECT, DELETE, INSERT, and UPDATE commands.
UTILITIES IN DBMS:
The DATABASE MANAGEMENT SYSTEM utilities are the software programs that are used to maintain the database by manipulating the data, records, and files. Some programs are also used for backup and recovery procedures of the database.
Thank you for reading this article titled “Database Management System”, hope It will beneficial for you for more you articles recommended below: