Chapter 7 Data Management

Table of Contents

Data Management Subsystems

KSAM/V

FCOPY (KSAM Options)

KSAM procedures

ALLBASE/SQL

HP SQL

Security

Logical Transaction

Concurrency

Recovery

Database Creation

Database Restructuring

TurboIMAGE/XL Data Base

Master Set

TurboIMAGE/XL and QUERY/V

Creating a Schema

DBUTIL

TurboIMAGE/XL Procedures

QUERY/V

TurboIMAGE DBchange/V

Key DBchange/V Features

DICTDBA

DICTDBU

DICTDBL

• Collecting data: the data entry process, including validating.

• Organizing data: analysis of data and its relationships; development of an appropriate data structure after analyzing the requirements of the application; for example, producing a logical record layout or schema.

• Storing data: the process of installing data in a meaningful form. This is the task of taking raw data and reformatting it for application programs to use.

• Accessing data: the retrieval of data for further processing. This includes additional reorganization or reduction of data for reports or other uses of the data.