You get a bonus - 1 coin for daily activity. Now you have 1 coin

3.2. Hierarchical systems

Lecture



A typical representative (the most famous and common) is the IBM Information Management System (IMS). The first version appeared in 1968. Until now, many databases are supported, which creates significant problems with the transition to both new database technology and new technology.

3.2.1. Hierarchical data structures

A hierarchical database consists of an ordered set of trees; more precisely, from an ordered set of several instances of the same tree type.

A tree type consists of one “root” record type and an ordered set of zero or more subtree types (each of which is a certain tree type). A tree type as a whole is a hierarchically organized set of record types.

Example of tree type (hierarchical database schema):

  3.2.  Hierarchical systems

Here   A department is an ancestor for the Chief and Employees, and the Chief and Employees are the descendants of the Division. Relationships are maintained between record types.

A database with such a scheme could look like this (we show one instance of the tree):

  3.2.  Hierarchical systems

All instances of this type of descendant with a common instance of the type of ancestor are called twins. For the database, the complete traversal order is defined - from top to bottom, from left to right.

IMS used the original and non-standard terminology: “segment” instead of “record”, and “record DB” was understood as the whole segment tree.

3.2.2. Data manipulation

Examples of typical manipulation operators for hierarchically organized data include:

  • Find the specified database tree (for example, department 310);
  • Jump from one tree to another;
  • Move from one record to another within the tree (for example, from a department to the first employee);
  • Move from one record to another in the order of traversing the hierarchy;
  • Insert a new entry in the specified position;
  • Delete current record.
3.2.3. Integrity constraints

The integrity of links between ancestors and descendants is automatically maintained. The basic rule: no descendant can exist without its parent. Note that similar integrity maintenance by links between records that are not in the same hierarchy is not supported (an example of such an "external" link could be the contents of the Kaf_Number field in the Curator type instance).

In hierarchical systems, some form of database representation was supported based on hierarchy constraints. An example of the presentation of the above DB may be a hierarchy

  3.2.  Hierarchical systems

Comments


To leave a comment
If you have any suggestion, idea, thanks or comment, feel free to write. We really value feedback and are glad to hear your opinion.
To reply

IBM System R — реляционная СУБД

Terms: IBM System R — реляционная СУБД