Purpose of DBMS-Function of DBMS

Digital marketing

 

Purpose of DBMS (Functions of DBMS)

 

 

 

1.To reduce redundancy.

 

 

of data which Repeating leads to of several the same problems information such as in wastage database of is space,called duplication effort for entering data and inconsistency.

 

2.To avoid inconsistency:

 

The database is said to be inconsistent if various copies of the same data may no longer agree. For example, a changed customer address may be reflected in saving account but not elsewhere in the system. By using DBMS we can avoid inconsistency.

 

 

3.To share data:

 

The data in the database can be shared among many users and applications. The data requirements of new applications may be satisfied without having to create any new stored files.

 

 

4.To provide support for transactions:

 

 

A transaction is a sequence of database operations that represents a logical unit of work. It accesses a database and transforms it from one state to another. A transaction can update a record, delete one, modify a set of records etc. when the DBMS does a ‘commit’; the changes made by the transaction are made permanent. We can roll back the transaction to undo the effects of transaction.

 

 

 

5.To maintain integrity:

 

Most database applications have certain integrity constraints that must hold for the data. A DBMS provides capabilities for defining and enforcing these constraints. For example, the value of roll number field of each student in student database should be unique for each student. It is a type of rule. Such a rule is enforced using constraint at the time of creation of database.

 

 

6.To enforce security:

 

Not every user of the database system should be able to access all data. Different checks can be established for each type of access (retrieve, modify, delete, etc) to each piece of information in the database.

 

 

 

7.To provide efficient backup and recovery:

 

Provide facilities for recovering from software and hardware failures to restore database to previous consistent state.

 

 

8 .To Concurrent Access Database:

 

Concurrent access means access to the same data simultaneously by more than one user. The same data may be used by many users for the purpose reading at the same time. But when a user tries to modify a data, there should be a concurrency control mechanism to avoid the inconsistency of data. A DBMS provides facilities for these operations.

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *