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 manipulation 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.
Disadvantages of a DBMS
Danger of a Overkill: For small and simple applications for single users a database system is often not advisable.
Complexity: A database system creates additional complexity and requirements. The supply and operation of a database management system with several users and databases is quite costly and demanding.
Qualified Personnel: The professional operation of a database system requires appropriately trained staff. Without a qualified database administrator nothing will work for long.
Costs: Through the use of a database system new costs are generated for the system itselfs but also for additional hardware and the more complex handling of the system.
Lower Efficiency: A database system is a multi-use software which is often less efficient than specialised software which is produced and optimised exactly for one problem.
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 manipulation 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.
Disadvantages of a DBMS
Danger of a Overkill: For small and simple applications for single users a database system is often not advisable.
Complexity: A database system creates additional complexity and requirements. The supply and operation of a database management system with several users and databases is quite costly and demanding.
Qualified Personnel: The professional operation of a database system requires appropriately trained staff. Without a qualified database administrator nothing will work for long.
Costs: Through the use of a database system new costs are generated for the system itselfs but also for additional hardware and the more complex handling of the system.
Lower Efficiency: A database system is a multi-use software which is often less efficient than specialised software which is produced and optimised exactly for one problem.
No comments:
Post a Comment