Discuss the capabilities that should be provided by a dbms
Answers
Answered by
16
Most of the software apps that we use day-to-day on our various devices work with some kind of database software, often referred to as a DBMS (Database Management System.) Widely used relational DBMS software products include Oracle, SQL Server, MySQL, PostgreSQL, DB2 UDB -- to name just a few. And there are many non-relational DBMS software products available as well.
Features and functions of these different DBMS products vary, but here is a short list of the most common:
Data Storage, Retrieval & Update. The DBMS software allows the app to read data from the database, add new data into the database, modify the data or delete the data from the database.
Master Catalog – “Metadata”. The DBMS software stores all the info it needs about itself within itself.
Central Control, Monitoring. The DBMS software includes features that allow database administrators (DBAs) to watch the database software as it runs to make sure it is running smoothly and efficiently, and that the database remains available and reliable.
Transaction Support. When an application or user needs to process a transaction that updates the database, the DBMS software must keep track of ALL aspects of that transaction, and ensure that the entire transaction is completed successfully. If any part of the transaction fails, then the DBMS software must be able to “roll back” any partial updates, leaving the database in a consistent state.
Data Independence (“Views”) In cases where the different kinds or types of data stored in a database may not be modified or viewed by all users, the DBMS software allows DBAs to create “views” of subsets of data that are appropriate for the permissions granted to each user.
Concurrent Shared Updates & Locking. In cases where there are multiple users accessing the database at the same time, the DBMS software must control access so that one user’s updates don’t interfere with another user’s access. The DBMS implements this control via “locks”. If one user is updating a record, that record is locked so that no one else can read it or update it until the first user’s update is finished. If one user is reading a record, it is locked so that no one can update it until the read activity is finished.
Integrity Constraints. Data is stored in relational databases in TABLES. Often, the data in one table is related to the data in another table. For example, the database may store customer data in one table, and a history of each purchase transaction for that customer in another table. The DBMS software can ensure that every purchase transaction ties back to a valid customer and, for example, prevent the insertion of a purchase transaction for a customer that is not on file. This is an example of the DBMS software enforcing a data integrity constraint.
Query Language. Most DBMS software products come with a query language that allows users of the DBMS software to write programs that access the data in the database. “SQL” (Structured Query Language) is a very common programming tool used by relational databases to enable users to work with their databases.
Features and functions of these different DBMS products vary, but here is a short list of the most common:
Data Storage, Retrieval & Update. The DBMS software allows the app to read data from the database, add new data into the database, modify the data or delete the data from the database.
Master Catalog – “Metadata”. The DBMS software stores all the info it needs about itself within itself.
Central Control, Monitoring. The DBMS software includes features that allow database administrators (DBAs) to watch the database software as it runs to make sure it is running smoothly and efficiently, and that the database remains available and reliable.
Transaction Support. When an application or user needs to process a transaction that updates the database, the DBMS software must keep track of ALL aspects of that transaction, and ensure that the entire transaction is completed successfully. If any part of the transaction fails, then the DBMS software must be able to “roll back” any partial updates, leaving the database in a consistent state.
Data Independence (“Views”) In cases where the different kinds or types of data stored in a database may not be modified or viewed by all users, the DBMS software allows DBAs to create “views” of subsets of data that are appropriate for the permissions granted to each user.
Concurrent Shared Updates & Locking. In cases where there are multiple users accessing the database at the same time, the DBMS software must control access so that one user’s updates don’t interfere with another user’s access. The DBMS implements this control via “locks”. If one user is updating a record, that record is locked so that no one else can read it or update it until the first user’s update is finished. If one user is reading a record, it is locked so that no one can update it until the read activity is finished.
Integrity Constraints. Data is stored in relational databases in TABLES. Often, the data in one table is related to the data in another table. For example, the database may store customer data in one table, and a history of each purchase transaction for that customer in another table. The DBMS software can ensure that every purchase transaction ties back to a valid customer and, for example, prevent the insertion of a purchase transaction for a customer that is not on file. This is an example of the DBMS software enforcing a data integrity constraint.
Query Language. Most DBMS software products come with a query language that allows users of the DBMS software to write programs that access the data in the database. “SQL” (Structured Query Language) is a very common programming tool used by relational databases to enable users to work with their databases.
Similar questions