Browse Prior Art Database

Method for Accessing Hierarchical Views of a Binary Relational Data-Base

IP.com Disclosure Number: IPCOM000047280D
Original Publication Date: 1983-Oct-01
Included in the Prior Art Database: 2005-Feb-07
Document File: 2 page(s) / 52K

Publishing Venue

IBM

Related People

Pullin, DJ: AUTHOR [+3]

Abstract

This article describes a method for accessing hierarchical views of data derived from a binary relational database. Access may take place via program operations which are analogous to those supported by a hierarchical database system such as IMS, or via an interpreter which presents hierarchical information on a screen display. In the first case, this would allow application programs written against a hierarchical database to be migrated to run on a binary relational database. In the second case, it would allow end users to obtain a range of presentations which are useful and not easily obtainable from n-ary relational databases. A method for accessing virtual files which are materialized from a binary relational database has been described in [*].

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 52% of the total text.

Page 1 of 2

Method for Accessing Hierarchical Views of a Binary Relational Data-Base

This article describes a method for accessing hierarchical views of data derived from a binary relational database. Access may take place via program operations which are analogous to those supported by a hierarchical database system such as IMS, or via an interpreter which presents hierarchical information on a screen display. In the first case, this would allow application programs written against a hierarchical database to be migrated to run on a binary relational database. In the second case, it would allow end users to obtain a range of presentations which are useful and not easily obtainable from n-ary relational databases. A method for accessing virtual files which are materialized from a binary relational database has been described in [*]. This permits an arbitrary number of virtual flat files to be defined and accessed by means of conventional record operations (i.e., GET, PUT, INSERT, DELETE). In each case, the format of the virtual file is defined in a data dictionary. In this method, an extension to this data dictionary is used to define a "parent-child" relationship between records from two virtual files. Where the key field of one record also appears as a non-key field of the other record, then the second of these may be defined as a "child" of the first. Once this definition has been stored in the data dictionary, it may be used to perform hierarchical retrievals as follows: 1. Retrieve a record from t...