Comment on this topic

Documentation Comments

Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.

Reality V15.2 Online Documentation (MoTW) Revision 3

Database Structure (m604803+databasestructure.htm)

To

Reality

Version

Topic

Submitted by

Company

Location

Email address

Comment

 

 

Database Structure

A Reality database, regardless of its type, is structured in four levels:

The diagram below illustrates the four level structure of a database.

Database structure

Database Hierarchy

The three dictionary levels contain information which defines the structure of the database. Each database has one system dictionary called SYSTEM which defines all master dictionaries (MDs) below it. Each MD corresponds to an account, and defines all file dictionaries belonging to that account. Each file dictionary points to one or more data sections associated with it, one of which is generally the default data section.

Multiple index sections can exist for each data section. Each index section is closely coupled to its associated data section, being defined within the data level descriptor.

Dictionaries also contain information that defines the facilities available on the database and the format of the user data in data sections. For details, refer to the topic Dictionaries, Data Sections and Indexes.

RealityV15.2Revision 3Comment on this topic