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

1.2.1.1 Online Data Hierarchy

The online data is structured in a tree or hierarchical
structure consisting of four levels; 1) Timespan, 2)
Information Area, 3) File, and 4) Cycle.  Figure 1-3
illustrates the level hierarchy.

                        Database
                            |
  Level 1:             Timespan(s)     (DAYS, WEEKS, etc)
                            |
  Level 2:         Information Area(s)    (TSO, Batch, etc)
                            |
  Level 3:                File(s)    (TSO User Activity File)
                            |
  Level 4:               Cycle(s)      (Last cycle processed,
                                    2nd last, 3rd last, etc.)

Figure 1-3. Online Data Hierarchy

The following sections describe each of the levels depicted
above for storing data online and the discussion concludes
with an example of the Database hierarchical design.