DBMS: Objectives
Data independence
Physical independence:
Independence between data structures and storage structures.
A DBMS makes it possible to describe data in a logical way, without worrying about how this is going to be done physically in the files. (1)[1]
Logical independence:
The same data set canbe viewed differently by different users.
All these personal visions (views) of the data must be integrated into a global vision.
Manipulation by non-computer specialists: You need to be able to access data without knowing how to program, which means using query languages[2].
Efficient data access:
These languages must be able to provide answers to queries in a "reasonable" time.
They must therefore beoptimized and minimize disk accesses.
Data consistency:
Data is subject to a certain number of constraints that define a coherent state of the database.
It must be possible to express these constraints simply, and to check them automatically each time data is inserted, modified or deleted: A person's age greater than zero, salary >0, ....As soon as you try to enter a value that does not respect this constraint, the DBMS rejects the value.
Centralized data administration:
Differing views of data (among other things) are more easily resolved if data is administered centrally.
Data sharing:
Enabling multiple users to access the same data at the same time. While this problem is easy to solve when only queries are involved, and in a single-user context, it is no longer the case when modifications are required in a multi-user context. In this case, you need to be able to: Allow two (or more) users to modify the same data "at the same time ensure consistent query results for a user consulting a table while another is modifying it.
Non-redundancy of data: To avoid problems during updates, each piece of data must only be present once in the database.
Data security:
Data must be protected against unauthorized access.
Resistance to failure:
A DBMS must integrate fail over mechanisms (e.g. power failure).