Interactive construction of means for database maintenance

• US 4,791,561 A
• Filed: 03/21/1988
• Issued: 12/13/1988
• Est. Priority Date: 04/17/1987
• Status: Expired due to Term

• Current Assignee: Intel Corporation
• Original Assignee: Wang Laboratories Incorporated
• Inventors: Huber, Val J.
• Primary Examiner(s): Shaw, Gareth D.
• Assistant Examiner(s): Kriess, Kevin A.
• Application Number:
  US07/171,232
• Time in Patent Office: 267 Days
• Field of Search: 364/200 MS File, 364/900 MS, 364/300
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

In a data processing system, application programs for the maintenance of a relational database may be constructed interactively and nonprocedurally. A data dictionary and screen-files are defined interactively and nonprocedurally. Data structures represent a meta-dictionary modeled as a relational database, a definition screen-file, a builder screen-file, and a set of archetype screen formats for modification.

Claims

1. Method for retrieving from a destination relation in a stored relational database, signals representing record occurrences related to a record occurrence of a starting relation, said method comprising

providing, for a relationship between particular relations in said database, stored signals representing relationship attributes including a specification of a relationship field common to said particular relations,

accessing, responsive to selection of a starting paticular relation and a relationship in which said starting relation participates, said stored relationship attribute signals,

generating, responsive to said relationship attributes, generic cursor signals representing a generic cursor defined against the other particular relation as a destination relation,

storing said generic cursor signals in working storage,

copying, responsive to a signal representing selection by an operator of a particular record occurrence in the starting relation and to an operation selection signal from the operator, values of said specified relationship field from said particular record occurrence to locations in said generic cursor to form a completed cursor,

accessing in said stored database, responsive to said completed cursor, destination relation record occurrence signals defined by said completed cursor, and

storing said accessed destination relation record occurrence signals in working storage.

2. The method of claim 1, further comprising the step of displaying representations of said stored destination relation record occurrence signals together with representations of a plurality of selectable operations performable with respect to destination relation record occurrences.

3. Record retrieval means for retrieving from a destination relation in a stored relational database, signals representing record occurrences related to a record occurrence of a starting relation, said means comprising

storage means for providing, for a relationship between particular relations in said database, stored attribute signals representing relationship attributes including a specification of a relationship field common to said particular relations,

means for accessing, responsive to selection of a starting particular relation and a relationship in which said starting relation participates, said stored relationship attribute signals,

means for generating, responsive to said relationship attributes, generic cursor signals representing a generic cursor defined against the other particular relation as a destination relation,

means for storing said generic cursor signals in working storage,

means for copying, responsive to a signal representing selection by an operator of a particular record occurrence in the starting relation and to an operation selection signal from the operator, values of said specified relationship field from said particular record occurrence to locations in said generic cursor to form a completed cursor,

means for accessing in said stored database, responsive to said completed cursor, destination relation record occurrence signals defined by said completed cursor, and

means for storing said accessed destination relation record occurrence signals in working storage.

4. The record retrieval means of claim 3, further comprising means for displaying representations of said stored destination relation record occurrence signals together with representations of a plurality of selectable operations performable with respect to destination relation record occurrences.

5. The record retrieval means of claim 3,

said storage means further providing, for a relation in said database, stored descriptor signals comprising

a relation name, and

a relationship identifier signal for each relationship in which said relation participates, said relationship identifier signal being an index to said stored atrribute signals for the corresponding said relationship,

said stored attribute signals further comprising name signals representing names of the particular relations related by the relationship,

said record retrieval means further comprising

means for controlling an initial display of names of relations in said database,

means for accessing, responsive to operator selection of a starting relation name during said initial display, a corresponding said relationship identifier signal in said descriptor signals,

said means for accessing said stored relationship attribute signals being responsive to said accessed relationship identifier signal fo accessing appropriate said stored relationship attribute signals,

means for controlling a next display, responsive to said accessed attribute signals, of a representation of the name of a particular relation related to said starting relation,

means for deriving, responsive to operator selection of a represented said particular relation name as a destination relation during said next display, the said attribute identifier for the relationship between said starting and destination relations,

means for accessing said relationship attribute signals, responsive to said derived attribute identifer, said means for generating being responsive to said accessed attribute signals.

6. The record retrieval means of claim 5,

said storage means further providing

stored format signals representing a modifiable run-time display format for display of representations of

selectable starting relation record occurrences, and

selectable operation names, and

associated stored control signals for each said selectable operation,

said stored attribute signals further comprising a name of said relationship,

said record retrieval means further comprising

means for modifying, responsive to said operator selection of a said starting relation during said next display, said stored format signals to represent an additional selectable operation identified by said relationship name,

means for generating, responsive to said operator selection of a said destination relation, control signals associated with said additional selectable operation and comprising a cursor index to said stored generic cursor signals, and

means for storing said generated control signals,

said means for copying being responsive during display according to said run-time format signals to operator selection of a starting relation record occurrence and of said relationship name, to access said cursor index.

7. The record retrieval means of claim 6,

said stored attribute signals further comprising

status specification signals specifying parent or child relationship status of each said particular relation related by the relationship, and

representations of an ascend relationship name and a descend relationship name,

said record retrieval means further comprising name selection means responsive to said status specification signals for accessing said relationship ascend name for display with record occurrences of a starting relation having relationship child status, and for accessing said relationship descend name for display with record occurrences of a starting relation having relationship parent status,

said means for modifying said stored format signals being responsive to said name selection means.

8. In a data dictionary definition means, relationship naming means comprising

name signal generating means for forming, responsive to input relationship definition signals, signals representing default ascend and descend names of a relationship,

means for storing said default name signals in attribute storage corresponding to said relationship,

means for controlling the display of representations of said default relationship names,

means for accepting operator input signals for modifying such display, and

means for forming modified name signals representing modified relationship ascend and descend names, responsive to said operator input signals, and

means for storing said modified name signals in said attribute storage.