Computerized system and process for managing a distributed database system

• US 5,459,860 A
• Filed: 10/05/1992
• Issued: 10/17/1995
• Est. Priority Date: 10/05/1992
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Haas, Garry L., Burnett, Colin J.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Lintz, Paul R.
• Application Number:
  US07/956,947
• Time in Patent Office: 1,107 Days
• Field of Search: 395/600, 395/200, 395/650
• US Class Current: 1/1
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/275 Synchronous replication
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

In a distributed data processing system comprising a plurality of different computer systems, each system having a central processing unit (CPU), memory, a database stored in the memory, and a DBMS, a computerized method is provided for generating a plurality of objects in a standardized format. A unique object identifier is associated with each of the plurality of objects. Each unique object identifier is stored in memory in association with at least one object location type or instance, an object generation specification for each object location type or instance, and a generation specification type. For a requested object type at a specified location, identifying from the computer memory an object generation specification, and a specification type. The requested object is generated in a standardized format from the specified location using the identified process type and the identified object generation specification.

Claims

1. In a data processing system comprising a central processing unit (CPU), memory, and a plurality of database management systems (DBMSs) each associated with at least one database stored in the memory, wherein at least one DBMS is different from at least one other DBMS, a computerized method for the generation of objects in a standardized format comprising the steps of:

(a) associating a unique object identifier with each of the plurality of objects;

(b) storing in a table in a computer memory each unique object identifier in association with at least one object location type or instance corresponding to a particular database instance, an object generation specification for each object location type or instance, and a generation specification type, wherein said object generation specification for each object location type or instance specifies how an object is to be generated from said particular database instance;

(c) for a requested object and a specified database, identifying from the table in the computer memory, an object generation specification, and a generation specification type; and

(d) generating in a standardized format the requested object from the specified database using the identified generation specification type and the identified object generation specification.

2. The method of claim 1 wherein the object generation specification contains at least one qualifier identifier and requester supplied qualifier values are substituted for each qualifier identifier.

3. The method of claim 1 wherein the requested object is the object generation specification having a requester supplied qualifier value substituted for each qualifier identifier in the object generation specification.

4. The method of claim 1 wherein the object is a result of the object generation specification, having a requester supplied qualifier value substituted for each qualifier identifier in the object generation specification, executed as an SQL statement by a DBMS.

5. The method of claim 1 wherein the object is a result of the object generation specification executed as a program by a CPU with a requester supplied qualifier value substituted for each qualifier identifier program parameter.

6. The method of claim 1 wherein the standardized format comprises a pointer to the requested object with an indicator of the size of the requested object.

7. The method of claim 1 wherein each unique object identifier is stored in a set of at least one table in association with at least one object location, an object generation specification for each object location, and a generation specification type.

8. The method of claim 7 further comprising the step of adding a new object identifier and associated information to the set of at least one table.

9. In a distributed data processing system having a plurality of different computer systems, each system having a central processing unit (CPU), memory, a database stored in the memory, and a DBMS, a system for the generation of objects in a standardized format from each of the computer systems, comprising:

means for associating a unique object identifier with each of the plurality of objects;

means for storing in a table in a computer memory each unique object identifier in association with at least one object location type or instance, an object generation specification for each object location type or instance, and a specification type wherein said object generation specification for an object location type or instance specifies how object is to be generated from a particular computer system;

means for identifying from the table in the computer memory, an object generation specification, and a generation specification type; and

means for generating in a standardized format information about the requested object using the identified generation specification type and the identified object generation specification.

10. The system of claim 9 wherein the object generation specification contains at least one qualifier identifier and requester supplied qualifier values are substituted for each qualifier identifier.

11. The system of claim 9 wherein the requested object is the object generation specification having a requester supplied qualifier value substituted for each qualifier identifier in the object generation specification.

12. The system of claim 9 wherein the object is the result of the object generation specification, having a requester supplied qualifier value substituted for each qualifier identifier in the object generation specification, executed as an SQL statement by a DBMS.

13. The system of claim 9 wherein the object is the result of the object generation specification executed as a program by a CPU with a requester supplied qualifier value substituted for each qualifier identifier program parameter.

14. In a data processing system comprising at least one database and a plurality of database management systems, a method for the generation of an object in a standardized format, comprising the steps of:

assigning an object identifier to the object;

creating a generation specification for the object, indicating how the object is to be generated for a particular system;

storing in a table in a memory said object identifier and said generation specification; and

generating information about the object for said particular system in a standardized format using said stored generation specification.

15. The method of claim 14, further comprising the step of storing a generation specification type indicating a type of said generation specification used to generate the object.

16. The method of claim 14, further comprising the steps of:

receiving from a routine a request to generate the object, wherein said request identifies the object by said object identifier and identifies a particular system; and

retrieving from said table said generation specification associated with the requested object for said identified system.

17. The method of claim 16, wherein said step of receiving comprises the step of receiving qualifter values from said routine and said step of generating comprises the step of substituting said qualifter values into said generation specification to produce an SQL statement.

18. The method of claim 16, wherein said step of receiving comprises the step of receiving qualifter values from said routine and said step of generating comprises the step of substituting said qualifter values into said generation specification to produce the object.