Data relationships processor with unlimited expansion capability

• US 5,604,899 A
• Filed: 06/28/1993
• Issued: 02/18/1997
• Est. Priority Date: 05/21/1990
• Status: Expired due to Term

• Current Assignee: Financial Systems Technology Intellectual Property Pty. Ltd. (Financial Systems Technology Pty. Ltd.)
• Original Assignee: Financial Systems Technology Pty. Ltd.
• Inventors: Doktor, Karol
• Primary Examiner(s): Kriess, Kevin A.
• Assistant Examiner(s): Toplu, Lucien
• Application Number:
  US08/083,861
• Time in Patent Office: 1,331 Days
• Field of Search: 395/600, 364/283.4, 364/225.4, 364/963, 364/252.4
• US Class Current: 1/1
• CPC Class Codes: C09K 2323/02 Alignment layer characterised by chemical composition
• CPC Class Codes: G06F 16/288 Entity relationship models
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

Machine automated techniques are described for a method of data processing called Relationships Processing. A computing system is disclosed which provides for the high speed recording and extraction of data objects (entities) and for the development data representing a queried relationship between the entities. The system is expandable to handle the relatively voluminous data bases of large, commercial data repositories.

A user defines set of entities and allowed relationships between the entities. The user can expand this set of allowed entities and relationships at any time during the life of the system without reprogramming or compiling of computer program code or disrupting concurrent operational use of the system. Large systems can now be built that are no longer limited to a scope of design requirements known during initial systems development. For a given set of defined relationships the system allows the user to perform complex inquiries (again without programming at the code level) that would normally require multiple nested inquiries to be coded programmatically and would not achieve the performance levels of the Relationships Processor.

Claims

1. In a computer system, a relational database processing system for retrieving a desired entity instance record, said relational database processing system comprising:

memory means containing (i) entity definition table means comprised of at least one entity type record containing an entity type and specifying an entity instance table associated with said entity type, (ii) entity instance table means comprised of at least one entity instance table, wherein each entity type record of said entity definition table is associated with an entity instance table, and wherein each entity instance table is comprised of a plurality of entity instance records wherein each entity instance record is of an entity type of said entity definition table means, (iii) relation definition table means comprised of at least one relation type record defining a provided relation type associating said desired entity type with a provided entity type, and iv) relation instance table means comprised of at least one relation instance record which defines a relation of said provided relation type between said desired entity instance record and a provided entity instance record, wherein said entity definition table means, said entity instance table means, said relation definition table means and said relation instance definition means are part of a relational database;

means, operatively coupled to said relation definition table means, using said provided relation type, for retrieving from said relation definition table means said relation type record defining said provided relation type;

means, operatively coupled to said relation definition table retrieving means and to said relation instance table means, using said relation type record, for retrieving from said relation instance table means a specific relation instance record containing said provided relation type and said provided entity instance record, wherein said desired entity instance record is specified in said specific relation instance record by a desired entity type and a desired entity record identifier;

means, operatively coupled to said relation instance retrieving means and said entity definition table means, using said desired entity type, for retrieving from said entity definition table means a desired entity type record defining said desired entity type; and

means, operatively coupled to said entity type record retrieving means and said entity instance table means, using said desired entity type and said desired record identifier, for retrieving from said entity instance table means said desired entity instance record;

wherein a desired entity instance table is specified by said desired entity type record; and

further wherein said desired entity instance record is a record identified by said desired entity record identifier in said entity instance table means.

2. The relational database processing system of claim 1 wherein said relation type record defining said provided relation type further comprises a table identifier, wherein said table identifier identifies a specific relation instance table containing said specific relation instance in said relation instance table means;

and

further wherein said means for retrieving a relation instance record further comprises means for retrieving from said specific relation instance table a relation instance record having data identifying said provided entity instance record and said desired entity instance record.

3. The relational database processing system of claim 1 wherein said memory means further contains inquiry table means comprised of at least one inquiry record, wherein said inquiry record specifies said provided relation type and said provided entity instance record, said relational database processing system further comprising:

means, operatively coupled to said inquiry table means and said relation definition table retrieving means, for retrieving from said inquiry table means said inquiry record; and

means, operatively coupled to said inquiry record retrieving means and said relation instance retrieving means, for retrieving from said inquiry record said provided relation type and said provided entity instance record from said inquiry record; and

means, operatively coupled to said provided relation type and said provided entity instance retrieving means and said relation instance retrieving means, for providing said provided entity instance and said provided relation type to said relation instance retrieving means.

8. The relational database processing system of claim 1, wherein said entity definition table means further comprises:

a second entity type record containing a second entity type and specifying a second entity instance table associated with said second entity type; and

a third entity type record containing a third entity type and specifying said second entity instance table, thereby also associating said second entity instance table with said third entity type.

4. A computer method for retrieving a desired entity of a desired entity type from a relational database wherein said desired entity is related to a provided entity by a provided relation type associating said provided entity type with said desired entity type, said method comprising:

retrieving from relation definition table means, which comprises at least one relation type record defining a relation type, of said relational database a specific relation type record wherein said specific relation type record defines said provided relation type;

retrieving from relation instance table means corresponding to said specific relation type record of said relational database, based on said specific relation type record and said provided entity, a specific relation instance record defining a relation of said provided relation type between, said provided entity and said desired entity wherein said relation instance record specifies said desired entity by a desired entity type and a desired record identifier;

retrieving from entity definition table means of said relational database, based on said desired entity type and said desired record identifier, a desired entity type record wherein said desired entity type record contains said desired entity type and specifies a desired entity instance table of said relational database, associated with said desired entity type; and

retrieving from said desired entity instance table specified by said desired entity type record said desired entity, wherein said desired entity comprises a record identified by said desired record identifier in said desired entity instance table.

5. The method of claim 4 wherein the step of retrieving a specific relation instance record comprises:

retrieving from said specific relation type record a table identifier wherein said table identifier identifies a specific relation instance table in said relation instance table means; and

retrieving from said specific relation instance table said specific relation instance record based on said specific relation type record and said provided entity.

6. The method of claim 4 further comprising the step of retrieving from inquiry table means data specifying said provided relation type prior to the step of retrieving a specific relation type record, wherein said data is used in said step of retrieving from relation instance means to determine said specific relation instance record.

7. The method of claim 4 further comprising the step of retrieving from inquiry table means data specifying said provided entity prior to the step of retrieving a relation specific instance record, wherein said data is used in said step of retrieving from relation instance means to determine said specific relation instance record.