1. Database Structure › 1.2 Database Structure and Organization › 1.2.1 Online Data Structure

1.2.1 Online Data Structure

The data maintained online is structured in a unique design
of numerous small, sequential SAS Files organized for
individual, concatenated, group, or relational processing.
This multiple file approach provides a Database capable of
efficiently handling large update requirements (e.g., SMF,
DB2, CICS, etc. data) and still providing quick online
access.

In most other database approaches, the user requests a
segment or information group for processing based on some
sort of common key (e.g., system identification and jobname).
Using the specified keys, the database manager searches a
series of indexes to determine which records in the database
are to be processed.  Once they have been located, then the
desired records are retrieved and the process is complete.
In this example, both the location and processing of the
database information is based on physical data organization.

Access to the CA MICS Database is also a two-part operation
of location and retrieval.  The location part, however, does
not require any physical operation and only requires the user
to name the SAS files that they wish to process.  Since these
files are generally quite small in size (e.g., hourly TSO
system activity data for a given day is stored in a mini-file
containing 24 records) the resultant processing time is
relatively low.

To facilitate the logical location of a file, the Database is
structured to allow the user to readily identify the required
file to be processed as explained in the following six
sections:

    1 - Online Data Hierarchy
    2 - Timespan (Database Level 1)
    3 - Information Area (Database Level 2)
    4 - File (Database Level 3)
    5 - Cycle (Database Level 4)
    6 - Example of Data Structure and Reference

                                                         DATABASE
                                                             |
                                                             |
                 +---------------------+---------------------+---------------------+---------------------+
         INFORMATION AREAS     INFORMATION AREAS     INFORMATION AREAS     INFORMATION AREAS     INFORMATION AREAS
        IN DETAIL TIMESPAN     IN DAYS TIMESPAN     IN WEEKS TIMESPAN     IN MONTHS TIMESPAN     IN YEARS TIMESPAN
                                                             |
                                                             |
                +----------------------------+---------------+----------------+----------------------------+
            ACCOUNTING              HARDWARE UTILIZATION     |             MVS SCP                 SYSTEM RELIABILITY
                |                            |               |                |                            |
    ACCOUNTING JOURNAL FILE(S)   CPU PROCESSOR ACTIVITY FILE |      MVS PAGING ACTIVITY FILE    SYSTEM SOFTWARE DIAGNOSTIC FILE
    ACCOUNTING LEDGER FILE(S)    PHYSICAL CHANNEL ACTIVITY   |      MVS PERFORMANCE GROUP       USER SOFTWARE DIAGNOSTIC FILE
    INVOICE SEQUENCE FILE          FILE                      |          ACTIVITY FILE           SYSTEM SOFTWARE MALFUNCTION
    STANDARD CREDIT FILE         TOTAL CHANNEL ACTIVITY FILE |      MVS PERFORMANCE PERIOD         SUMMARY FILE
    RECURRING CREDIT FILE        CONTROL UNIT ACTIVITY FILE  |          ACTIVITY FILE           USER SOFTWARE MALFUNCTION
    STANDARD DEBIT FILE          DEVICE ACTIVITY FILE        |      MVS DOMAIN ACTIVITY FILE       SUMMARY FILE
    RECURRING DEBIT FILE         DEVICE TYPE ACTIVITY FILE   |      MVS LOGICAL CHAN/CU         RELIABILITY INCIDENT FILE
    BUDGET FILE                  HARDWARE RESERVE ACTIVITY   |          ACTIVITY FILE           PROCESSOR RELIABILITY FILE
    COST CENTER ATTRIBUTES FILE    FILE                      |      MVS PAGE/SWAP DATA SET      STORAGE RELIABILITY FILE
    FINANCIAL RECAP FILE                                     |          ACTIVITY FILE           CHANNEL RELIABILITY FILE
    YEAR-TO-DATE FINANCIAL                                   |      MVS RESOURCE ENQUEUE        DASD DEVICE RELIABILITY FILE
      RECAP FILE                                             |          ACTIVITY FILE           MAGNETIC TAPE DEVICE
                                                             |      MVS TRACE ACTIVITY FILE        RELIABILITY FILE
                                                             |      MVS REPORT GROUP ACTIVITY   UNIT RECORD DEVICE RELIABILITY
                                                             |          FILE                       FILE
                                                             |      MVS DOMAIN CONTROL FILE     TP DEVICE RELIABILITY FILE
                                                             |      MVS ADDRESS SPACE ACTIVITY  DASD MEDIA RELIABILITY FILE
                                                             |          FILE                    MAGNETIC TAPE MEDIA RELIABILITY
                                                             |      MVS REAL STORAGE/CPU/SRM       FILE
                                                             |          ACTIVITY FILE
                                                             |      MVS I/O QUEUING
                                                             |          CONFIGURATION FILE
                                                             |      MVS I/O PROCESSOR QUEUING
                                                             |          FILE
                                                             |      MVS LOGICAL CONTROL UNIT
                                                             |          ACTIVITY FILE
                                                             |      MVS SWAP ACTIVITY FILE
                                                             |      MVS VIRTUAL STORAGE SYSTEM
                                                             |          USAGE FILE
                                                             |      MVS VIRTUAL STORAGE PRIVATE
                                                             |          USAGE FILE
                                                             |
                +----------------------------+---------------+----------------+
       CA MICS ADMINISTRATIVE   FIELD DEVELOPED APPLICATIONS |               VCA
                |                            |               |                |
    INPUT HISTORY LOG FILE                 OPEN              |      DATA SET ALLOCATION FILE
    EXCEPTION ACTIVITY FILE                                  |      VSAM DATA SET ALLOCATION FILE
                                                             |      VOLUME ALLOCATION FILE
 
 

Figure 1-2. Database File Overview