Chapter Contents


SAS/ACCESS Interface to CA-IDMS Software: Reference

Data Dictionaries and the DDS

CA-IDMS enables you to build one or more databases using a data dictionary. A data dictionary is itself a CA-IDMS database that contains all the data and system definitions for one or more databases.

A data dictionary is divided logically into areas. The information is organized into entity types, which correspond to the main data processing components, such as elements, records, files, programs, and users. Data dictionaries monitor most aspects of the database environment, from tracking the status of terminals, systems, and users to being a central resource of information about the system and providing security. Some large information systems use multiple dictionaries; for example, a system may have one dictionary for each division of a company.

A database administrator (DBA) manages and maintains the data dictionaries and the entire CA-IDMS system. DBA duties often include programming systems, managing resources, monitoring the system's performance, and overseeing its security. The DBA has a key role in the SAS/ACCESS interface to CA-IDMS, which is explained in more detail in this chapter.

Within a CA-IDMS data dictionary are the definitions for a database's schema and subschema. A schema describes the contents and structure of a single database, including all of the records and sets that are necessary to define its data elements and data relationships.

A subschema is a subset of a schema that is used by programs at runtime. It consists of all the data elements, records, sets, and areas that are defined in the schema or a subset thereof. It includes database records and can include logical records as well as logical-record paths (defined below). The DBA defines logical records and their paths in the subschema before application programs are coded and executed.

Data Dictionary, Schemas, and Subschemas illustrates the relationships among the data dictionary, schemas, and subschemas.

Data Dictionary, Schemas, and Subschemas


CA-IDMS provides two operating environments, or modes, for accessing data dictionaries and databases. In the central version, multiple concurrently executing programs access the database(s) through one shared copy of the database management system (DBMS). The central version controls concurrent updating of the database by multiple users in order to maintain database integrity.

In local mode, one program at a time accesses the database through a dedicated copy of the DBMS. You cannot run local mode against a database at the same time that the central version is accessing it.

A Distributed Database System (DDS) distributes data storage and processing functions among several systems. These systems can execute on one or more machines and at one or more sites. Each system is a node in the DDS configuration. A central version specifies which node within the DDS system to access.

Chapter Contents



Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.