/* related posts with thumb nails */

Advantages of DBMS:

§  Improved data sharing: A database is designed as a shared resource. Authorized users are granted permission to use the database, and each user is provided one or more user views.  DBMS provides better access to data and better-managed data.  

§  Improved data security: When number of users increases to access the data, the risk of data security increases. But, DBMS provides a framework for better enforcement of data privacy and security policies. A database can be accessed only by proper authentication usually by verifying login and password.

§  Better data integration: DBMS integrates the many different users' views into a single data repository. This gives clear picture of the organization's operations. It becomes much easier to see how actions in one segment of the company affect other segments.

§  Minimized data inconsistency: Data inconsistency exists when different versions of the same data appear in different places. In a DBMS, by eliminating this data redundancy, we can improve data consistency. For example, if a customer address is stored only once, updating that becomes simple.

§  Improved data access: The DBMS makes it possible to produce quick answers to any queries.  A query is a request or a question put to the DBMS for data manipula­tion or retrieval. Without any programming experience, one can retrieve and display data very easily. The language used to write queries is called Structured Query Language (SQL). For example, records from EMP table can be displayed using the query “SELECT * FROM EMP”

§  Improved decision making: Now a day business success depends on decision making which is based on quality information generated by databases. In DBMS, better-managed data and improved data access make it possible to generate quality information, on which better decisions are based.

§  Program-Data Independence: The separation of data description (metadata) from the application programs that use the data is called data independence.  With the database approach, data descriptions are stored in a central location called the repository.  This allows an organization’s data to change without changing the application programs that process the data.
Related Topics:


Post a Comment