Home / Summaries / Fundamentals of Database System by Navathe / implementation-independence-operations

Database and Database users - Characteristics of the DB approach - Insulation between prgs and data, and data Abstraction

4 important questions on Database and Database users - Characteristics of the DB approach - Insulation between prgs and data, and data Abstraction

What is program operation independence?

User application programs can operate on the data by invoking the operations through their names and arguments, regardless of how the operations are implemented. This may be termed program-operation independence.

What is the special feature of implementation?

Implementation (or method) of the operation is specified separately and can be changed without affecting the interface

How this characteristic make DB a better approach than file processing?

In traditional file processing, the structure of data files is embedded in the access programs, so any changes to the structure of a file may require changing all programs that access this file. By contrast, DBMS access programs do not require such changes in most cases. The structure of data files is stored in the DBMS catalog separately from the access programs. We call this property as PROGRAM DATA INDEPENDENCE.

What does a data model use and what does it hide?

The data model uses logical concepts, such as objects, their properties, and their interrelationships, that may be easier for most users to understand than computer storage concepts. Hence, the data model hides storage and implementation details that are not of interest to most database users.

The question on the page originate from the summary of the following study material:

Fundamentals of Database System by Navathe | Navathe, et al

View summary