Skip to content
doubtly

1 answer

Best answer

Answer: The main characteristics of the database approach are: self-describing nature, insulation between programs and data (data abstraction), support for multiple views, sharing of data with multiuser transaction processing, controlled redundancy, integrity constraints, security, and backup and recovery.

  1. Self-describing nature: a database stores not only the data but also its description (table structures, data types, constraints) in the system catalog / data dictionary. This data about data is called metadata, and the DBMS uses it to work with any database.
  2. Insulation between programs and data (program-data independence): the structure of the data is kept in the catalog, not inside application programs, so the storage structure can be changed without rewriting programs. The DBMS gives data abstraction through three levels (internal, conceptual, external), giving physical and logical data independence.
  3. Support of multiple views of data: different users can see different views (subsets or derived data) of the same database; for example, the accounts section sees fee details while the library sees only issue records.
  4. Sharing of data and multiuser transaction processing: many users can use the database at the same time. Concurrency control makes sure simultaneous transactions do not corrupt data, and transactions follow the ACID properties (Atomicity, Consistency, Isolation, Durability).
  5. Controlled redundancy: each fact is stored once as far as possible, which saves space and avoids inconsistency; any duplication kept for performance is controlled by the DBMS.
  6. Integrity constraints: rules such as primary key, foreign key (referential integrity), NOT NULL, UNIQUE and CHECK keep the data valid and consistent.
  7. Security and authorisation: only authorised users can access or change data; privileges can be granted per user, table or view.
  8. Backup and recovery: the DBMS can restore the database to a consistent state after a system crash or transaction failure, using logs and backups.
  9. Query language and efficient access: data is retrieved with a high-level language such as SQL, and the DBMS uses indexes and query optimisation to answer queries quickly.
  10. Data stored as related tables (in an RDBMS): real-world entities and the relationships between them are represented in a structured, logical form.
Doubtly · 3 May 2023 Report
Was this answer helpful?

Your answer

Log in or create a free account to answer this question.