System and method for database management

• US 8,082,520 B2
• Filed: 02/26/2004
• Issued: 12/20/2011
• Est. Priority Date: 02/26/2004
• Status: Expired due to Fees

• Current Assignee: Domo, Inc.
• Original Assignee: International Business Machines Corporation
• Inventors: Davis, Jeffrey Michael, Oyarzabal, Randy Eugenio, Springer, Crystal Faye, Steffenhagen, Nathan Gary
• Primary Examiner(s): Bashore, William
• Assistant Examiner(s): Keaton, Sherrod
• Application Number:
  US10/787,641
• Publication Number:
  US 20050193033A1
• Time in Patent Office: 2,854 Days
• Field of Search: 707/10, 709/223, 715/810, 715/845, 715/841, 715/828
• US Class Current: 715/810
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409

Abstract

A method, system and article of manufacture for database management and, more particularly, for managing multiple information management tools in a data processing system. One embodiment provides a method of managing multiple information management tools in a data processing system. The method comprises displaying, on a display device, a user interface of a toolkit configured for managing the multiple information management tools, the user interface comprising a plurality of selectable operations applicable to information management tools, receiving a user selection of an operation of the plurality of selectable operations, and applying the selected operation to at least one of the information management tools.

Claims

1. A method of managing multiple databases in a data processing system, comprising:

displaying, on a display device, a first user interface screen configured for managing the multiple databases, the first user interface screen comprising a viewable representation of a plurality of selectable databases;

receiving a user selection of a subset of databases from the plurality of selectable databases;

displaying, on the display device, a second user interface screen, the second user interface screen comprising a viewable representation of a plurality of selectable operations applicable to the databases;

receiving a user selection of an operation of the plurality of selectable operations;

executing a master agent configured to determine a preferred sequence to execute one or more local agents and to invoke the execution of one or more local agents in the preferred sequence, wherein the local agents perform the selected operation to each database of the subset of databases.

2. The method of claim 1, wherein the selected operation is one of an operation for querying each database of the subset of databases and an operation for modifying a database design of each database of the subset of databases.

3. The method of claim 1, wherein the subset of databases comprises a multiplicity of documents, the method further comprising:

receiving a query suitable for identifying a subset of documents from the multiplicity of documents; and

identifying the subset of documents; and

wherein applying the selected operation includes applying the selected operation only to each document of the identified subset of documents.

4. The method of claim 1, wherein the master agent resides on a first computer and each of the multiple databases resides on one or more second computers connected to the first computer via a network.

5. The method of claim 1, wherein each of the multiple databases comprises at least one of a calendar function and an email function.

6. A computer readable storage medium containing a program which, when executed, performs a process of managing multiple databases in a data processing system, the process comprising:

displaying, on a display device, a first user interface screen configured for managing the multiple databases, the first user interface screen comprising a viewable representation of a plurality of selectable databases;

receiving a user selection of a subset of databases from the plurality of selectable databases;

displaying, on the display device, a second user interface screen, the second user interface screen comprising a viewable representation of a plurality of selectable operations applicable to the databases;

receiving a user selection of an operation of the plurality of selectable operations; and

executing a master agent configured to determine a preferred sequence to execute one or more local agents and to invoke, in the preferred sequence, the execution of the one or more local agents, wherein the local agents perform the selected operation to each database of the subset of databases.

7. The computer readable storage medium of claim 6, wherein the selected operation is one of an operation for querying each database of the subset of databases and an operation for modifying a database design of each database of the subset of databases.

8. The computer readable storage medium of claim 6, wherein the subset of databases comprises a multiplicity of documents, the process further comprising:

receiving a query suitable for identifying a subset of documents from the multiplicity of documents; and

identifying the subset of documents; and

wherein applying the selected operation includes applying the selected operation only to each document of the identified subset of documents.

9. The computer readable storage medium of claim 6, wherein the master agent resides on a first computer and each of the multiple databases resides on one or more second computers connected to the first computer via a network.

10. The computer readable storage medium of claim 6, wherein each of the multiple databases comprises at least one of a calendar function and an email function.

11. A data processing system, comprising:

a processor; and

a memory containing a program, which when executed on the processor performs an operation for managing multiple databases, the program being configured for;

displaying a first user interface screen comprising a viewable representation of a plurality of selectable databases;

displaying a second user interface screen comprising a viewable representation of a plurality of selectable operations applicable to the databases; and

receiving, via the first user interface screen, a user selection of a subset of databases from the plurality of selectable databases;

receiving, via the second user interface screen, a user selection of an operation of the plurality of selectable operations; and

executing a master agent configured to determine a sequence of execution for one or more local agents and to invoke each of the one or more local agents, wherein the local agents apply the selected operations to each database of the subset of databases, in the determined sequence.