DBMS: Objectives

  1. 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.

  2. Manipulation by non-computer specialists: You need to be able to access data without knowing how to program, which means using query languages[2].

  3. 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.

  4. 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.

  5. Centralized data administration:

    Differing views of data (among other things) are more easily resolved if data is administered centrally.

  6. 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.

  7. Non-redundancy of data: To avoid problems during updates, each piece of data must only be present once in the database.

  8. Data security:

    Data must be protected against unauthorized access.

  9. Resistance to failure:

    A DBMS must integrate fail over mechanisms (e.g. power failure).