Computerized system and process for interactively managing a distributed database system

• US 5,539,870 A
• Filed: 10/05/1992
• Issued: 07/23/1996
• Est. Priority Date: 10/05/1992
• Status: Expired due to Fees

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: International Business Machines Corporation
• Inventors: Haas, Garry L., Conrad, Thomas E.
• Primary Examiner(s): Zimmerman, Mark K.
• Assistant Examiner(s): Feild, Joseph H.
• Application Number:
  US07/956,942
• Time in Patent Office: 1,387 Days
• Field of Search: 395/153, 395/155, 395/156, 395/157, 395/159, 395/160, 395/161, 395/600
• US Class Current: 715/810
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• 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 3/04895 Guidance during keyboard input operation, e.g. prompting
• CPC Class Codes: Y10S 715/968 interface for database querying and retrieval

Abstract

An interactive graphical display of object relationships and instances is implemented by means of a table driven process. The user can select one or more object occurrences and then select an action to be performed on the selected object occurrences using a dynamic menu of actions. Changes are made to the tables without modifying the processes. The process can be used in managing a distributed database system to provide a user with increasingly detailed levels of information about object types and occurrences in the database systems.

Claims

1. In a distributed data processing system including a plurality of computer systems each having a central processing unit (CPU), memory, a database stored in the memory, a database management system (DBMS), and communication means, a method of managing and navigating the distributed data processing system from a computer system having a display device and user interaction device, comprising the steps of:

(a) displaying on the display device an object listing of related data processing system object types and displaying object occurrences corresponding to each of the displayed object types;

(b) interactively modifying said object listing using input from the user interaction device and control information accessible from a set of at least one user alterable Related Object Table stored in the distributed system;

(c) interactively selecting an action to be performed on a user selected list of at least one object occurrence from said modified object listing using input from the user interaction device and control information from a set of at least one user alterable Object Action Table stored in the distributed system; and

(d) performing said selected action on said user selected object occurrence list, by means of the CPU executing a list of at least one program stored in the distributed system, wherein the program list is identified using the set of at least one user alterable Object Action Table stored in the distributed system.

2. The method of claim 1 further comprising the step of displaying a dynamic action listing on a portion of the display device, said action listing comprising at least one action performable on the user selected object occurrence list, wherein said action listing is produced by accessing a set of at least one table stored in the distributed system.

3. The method of claim 1 wherein interactively selecting an action comprises the steps of:

(a) selecting from the object listing by means of the user interaction device, a list of at least one object occurrence;

(b) displaying on a portion of the display device a list of at least one action, wherein each action in the action list is identified using the selected object occurrence as a key to identify at least one action entry in an action table; and

(c) selecting, by means of the user interaction device, an action from the displayed action list.

4. The method of claim 1 wherein interactively modifying the object listing comprises the steps of:

(a) receiving input from the user interaction device selecting an object occurrence from the displayed object listing;

(b) displaying, on a portion of the display device, a list of object types related to the selected object occurrence, wherein the related object types are identified using the selected object occurrence as a key to identify at least one object type entry in a user alterable Related Object Table;

(c) receiving input from the user interaction device selecting a related object type from the displayed list of related object types;

(d) retrieving occurrences of the selected related object type using an object occurrence program executed by the CPU, wherein the object occurrence program is identified using the selected related object type as a key to identify a program entry in a user alterable Object Action Table;

(e) displaying the occurrences of the selected related object on the display device as part of the object listing; and

(f) repeating steps (a) through (e) a plurality of times until input is received from the user interaction device to perform an action other than display.

5. The method of claim 4 further comprising the steps of:

(a) displaying a list of qualifiers for the selected related object type in response to input received from the user interaction device, wherein the list of qualifiers for a related object type is identified using a related object qualifier table;

(b) receiving input from the user interaction device selecting a qualifier from the qualifier list;

(c) receiving input from the user interaction device identifying a qualifier value; and

(d) retrieving related object type occurrences having the qualifier value by using the qualifier value as a parameter for the selected program.

6. The method of claim 1 wherein the object listing is in the form of a hierarchical tree with related object occurrences displayed indented beneath the corresponding object type.

7. The method of claim 1 wherein the object listing is displayed in the form of a network of object occurrence nodes connected to object type nodes.

8. The method of claim 1 wherein the object listing is context sensitive and dynamically obtained and the performable action lists are context sensitive and dynamically obtained.

9. In a distributed data processing system including a plurality of computer systems each having a central processing unit (CPU), memory, a database stored in the memory, a database management system (DBMS), and communication means, a method of managing and navigating the distributed data processing system from a computer system having a display device and user interaction device, comprising the steps of:

(a) displaying, on the display device, a list of at least one occurrence of a computer system object type;

(b) receiving input from the user interaction device selecting a displayed object occurrence;

(c) identifying a list of at least one qualifiable object type related to the selected occurrence type using a set of at least one user alterable Related Object Table stored in the distributed system;

(d) displaying the related object type list on a portion of the display device;

(e) receiving input from the user interaction device selecting a related object type;

(f) retrieving a list of at least one occurrence of the selected object type using a program stored in the distributed system, wherein the program is identified using a set of at least one user alterable Object Action Table stored in the distributed system;

(g) displaying the retrieved object occurrence list;

(h) repeating steps (b) through (g) a plurality of times until input is received from the user interaction device to perform a non-display action on a user selected list of at least one object occurrence;

(j) identifying a list of at least one performable action for the selected object occurrence list using the set of at least one user alterable Object Action Table stored in the distributed system;

(k) displaying on a portion of the display device the performable action list;

(1) receiving input from the user interaction device selecting an action from the displayed performable action list;

(m) performing the selected action on the selected occurrence list, using a list of at least one program, wherein the action program list is identified using a user alterable Object Action Table stored in the distributed system; and

(n) repeating steps (b) through (m) a plurality of times until input is received from the user interaction device to stop.

10. The method of claim 9 further comprising the step of:

(a) adding a new object occurrence to the system by adding at least one entry to the set of at least one user alterable Related Object Table;

(b) adding a new object relationship to the system by adding at least one entry to the set of at least one user alterable Related Object Table; and

(c) adding a new performable action for an object type to the system by adding at least one entry to the set of at least one table and storing in the distributed system a program executable by the CPU to perform the new action on the object type.

11. The method of claim 9 wherein at least one program is used to perform an action for more than one type of object type, having at least one parameter passed to the program for the object type.

12. The method of claim 11 wherein a computer system object type for a selected object occurrence is used as a partial key for the table set and as a parameter for the program.

13. In a data processing system having a central processing unit (CPU), memory, a display device and a user interaction device, a method of interactively displaying and navigating a list of related objects in hierarchical form comprising the steps of:

(a) displaying, on the display device, a list of occurrences of an object type computer system;

(b) receiving input from the user interaction device selecting a displayed object occurrence;

(c) identifying a list of at least one object type related to the selected object occurrence using a user alterable Related Object Table stored in the data processing system;

(d) displaying the related object type list on a portion of the display device;

(e) receiving input from the user interaction device selecting a displayed related object type;

(f) identifying a list of at least one occurrence of the selected object type using a program stored in the data processing system, wherein the program is identified using a set of at least one user alterable Object Action Table stored in the data processing system; and

(g) displaying on the display device, the identified object occurrence list.

14. The method of claim 13 further comprising the step of repeating steps (b) through (g) until input is received from the user interaction device to stop.

15. The method of claim 13 wherein the object occurrence list is displayed on the display device in conjunction with the related object occurrence.

16. The method of claim 15 wherein the object occurrence list is displayed indented beneath the related object occurrence.

17. The method of claim 13 further comprising the steps of:

(a) displaying a list of qualifiers for the selected related object type in response to input received from the user interaction device, wherein the list of qualifiers for a related object type is identified using a related object qualifier table;

(b) receiving input from the user interaction device selecting a qualifier from the qualifier list;

(c) receiving input from the user interaction device identifying a qualifier value; and

(d) identifying related object type occurrences having the qualifier value by using the qualifier value as a parameter for the selected program.

18. The method of claim 13 further comprising the steps of:

(a) adding a new object occurrence to the system by adding at least one entry to the set of at least one user alterable Related Object Table; and

(b) adding a new object relationship to the system by adding at least one entry to the set of at least one user alterable Related Object Table.

19. A system to interactively display and navigate a list of related objects on distributed databases, comprising:

a processor; and

a controller to control said processor, comprising;

means for displaying a list of occurrences of an object type computer system;

means for receiving input from a user interaction device selecting a displayed object occurrence;

means for identifying a list of at least one object type related to the selected object occurrence using a user alterable Related Object Table stored in the computer system; and

means for identifying a list of at least one occurrence of the selected object type using a program stored in the computer system, wherein the program is identified using a set of at least one user alterable Object Action Table stored in the computer system.

20. A controller for enabling a processor to interactively display and navigate a list of related objects on distributed databases, comprising:

means for displaying a list of occurrences of an object type computer system;

means for receiving input from a user interaction device selecting a displayed object occurrence;

means for identifying a list of at least one object type related to the selected object occurrence using a user alterable Related Object Table stored in the computer system; and

means for identifying a list of at least one occurrence of the selected object type using a program stored in the computer system, wherein the program is identified using a set of at least one user alterable Object Action Table stored in the computer system.