Welcome To Series Articles of DBMS(volume-6)
Advantages of Data Base Management System:
There are 7 major advantages they are:
1. Controlling the Redundancy.
2. Restricting unauthorized access.
3. Providing the Persistence storage of program data.
4. Providing the storage structure and search technique for efficient query processing.
5. Backup and Recovering.
6. Providing the multiplex interface.
7. Entering the integrity.
1. Controlling the Redundancy.
Redundancy is storing the same data multiple times leads to several problems.it is otherwise known as data duplicate for a particular database the value must be unique the job of database user is that to control the redundancy by using normalization technique.
2. Restricting unauthorized access.
When multiple users share a large database it is likely that most users will not be authorized to access all the information in the database, for example, The finance data is often considered as a confidential and only otherized person are allowed to access such data. The DBMS should provide security and authorized subsystem which the DBA user to create an account and to specify the account restriction. The DBMS should enforce these restrictions automatically.
3. Providing the Persistence storage of program data.
The database can be used to provide persistent storage of program object and data structure this is one of the main reason for the object-oriented database programming language typically have a complex data structure such as record types in c,c++ and java. the programmer having full authority to access the particular code from the programming database.
4. Providing the storage structure and search technique for efficient query processing.
The database system must provide the capability for efficiently executing queries and objects because the database is typically stored on disk. DBMS must provide specialize data structure and speed up the search for the desired record. the query process and optimized module of DBMS is responsible for choosing an efficient query execution plan for each query based on the existing storage structure.
5. Backup and Recovering.
A DBMS must provide the facilities for recovering from hardware and software failures the backup and recovery system of DBMS is responsible for recovery. for example, if the computer system fails in the middle of a transaction the recovery is responsible for make sure that the database is stored to the state it was in before the transaction started executing.
6. Providing the multiplex interface.
Many types of users with varying levels of tech knowledge use DBMS. It could provide a variety of user interface. these include the query language for the casual user, programming language interface for the application user, forms and command code for parametric user and memory return and natural interface for the standalone user.
7. Entering the integrity constraints.
Most of the database application has certain integrity constant that must hold for the data. DBMS should provide the capability for defining and enforcing these constraints.there are two constraints one is the primary key constraint or unique key and the other is referential integrity or integrity constraints or foreign key.
I hope this article is useful to you, plz follow the next volume for more information.
please post your doubts in the comment box.
You can write to me at codingallrounders@gmail.com
Subscribe by Email
Follow Updates Articles from This Blog via Email
No Comments