3_adv_disadv Flashcards
“What is the role of DBMS in businesses and organizations?”
“DBMS plays a vital role for businesses, institutions, and organizations of all scales in effectively managing their data, ensuring data accuracy and security, and supporting essential decision-making processes. It serves as the core of contemporary information systems, facilitating efficient data management and serving as a basis for a wide range of applications and services.”
“What are the key needs of DBMS?”
“1. Data Security - DBMS implements security mechanisms that regulate access to sensitive information, safeguarding it from unauthorized access and potential data breaches.
2. Data Redundancy and Inconsistency - DBMS removes data redundancy, minimizing storage needs and ensuring consistency through the maintenance of a unified version of the data.
3. Data Integrity - DBMS guarantees data integrity by enforcing rules and constraints that prohibit the entry of incorrect or inconsistent data into the database.”
“What are the advantages of DBMS?”
“1. Data Scalability - DBMS can handle large datasets and scale to accommodate increasing amounts of data as an organization grows.
2. Data Abstraction - DBMS offers data abstraction, allowing users and applications to interact with the database without needing to understand its underlying complexities.”
“What are the disadvantages of DBMS?”
“1. Cost - Acquiring, deploying, and sustaining DBMS software can incur significant costs. Furthermore, the hardware essential for the proficient operation of a DBMS can also lead to substantial expenses.
2. Scale Projects - When dealing with modest applications and minimal data storage requirements, adopting a comprehensive DBMS could introduce avoidable intricacies and additional burdens. In these instances, more streamlined data storage alternatives could be better suited.
3. Vendor Lock-In - Once you’ve chosen a specific DBMS, it can be challenging to switch to a different one due to differences in data formats, query languages, and other technical aspects. This can lead to vendor lock-in, where you are dependent on a particular vendor’s technology and pricing.”
