System and method for managing information for a plurality of computer systems in a distributed network

• US 20060089946A1
• Filed: 11/07/2005
• Published: 04/27/2006
• Est. Priority Date: 01/16/2001
• Status: Active Grant

• Current Assignee: Lakeside Software LLC
• Original Assignee: Lakeside Software, Inc.
• Inventors: Schumacher, Michael K.
• Granted Patent: US 7,865,499 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2246 Trees, e.g. B+trees

Abstract

A system for managing computers in a distributed computer network includes a collection agent for each computer being monitored, a local database coupled to each collection agent, one or more condensing agents coupled to the databases, and at least one console module. The condensing agent generates an index table from a source database and sends it upstream to the next level up in the hierarchy of databases. Other condensing agents may in turn act on this index table and send it up to a still further level, until a top-level master node has an index table reflecting the entire network. The console can use the index table to identify what databases contain needed data, and then make only selective connections to databases to answer queries, avoiding connections to all the local databases. The condensing agent also produces summarized data and sends it upstream as well, to be used by the console. Efficiency is improved over conventional systems. Use of the index method and the summary method can be transparent to (hid from) the user of the console, or may be made visible, with selection options.

Claims

1. A method of managing information for a plurality of computers in a distributed network comprising the steps of:

(A) collecting original data for each computer relating to at least one of a system, an application program and a user associated with said respective computer and storing the original data in a respective database;

(B) generating an index table including index data for each computer wherein the index data is configured (i) to identify at least a portion of the contents of the original data stored in the database, and (ii) to facilitate access to the databases over the distributed network;

(C) selecting at least one of the plurality of databases by scanning index tables and determining, using the index data, which of the databases contain original data responsive to a user query;

(D) accessing the selected databases to retrieve original data and generate an output therefrom.

2. The method of claim 1 wherein said step of generating an index table is performed at least at a first location of a first one of said computers, said steps of selecting and accessing being performed at a second location different from said first location to thereby provide distributed processing.

3. An apparatus for managing information for computers in a distributed network comprising:

a collection agent associated with each of a plurality of computers configured to acquire and store original data related to a respective computer in a respective storage databases, said computers arranged in a logical tree style hierarchy;

at least one condensing agent for condensing said original data into index data, said index data configured (i) to identify at least a portion of the contents of said original data, and (ii) to facilitate access to said storage databases over the distributed network, said index data including fields corresponding to a position in said hierarchy;

a base database including said index data;

a console module configured to select storage databases for access thereto responsive to a user query for said contents, said console being further operative to use said index data to access said selected storage databases, retrieve original data, and generate an output.

4. The apparatus of claim 3 wherein said console module is configured to execute on a head end of said hierarchy, a remainder of said computers populating a subtree of said hierarchy at a plurality of levels.

5. The apparatus of claim 4 wherein said original data in said storage databases comprises information relating to at least one of systems, disks, networks, application programs, and users associated with a respective one of said plurality of computers.

6. An apparatus for managing information for computers in a distributed network comprising:

a first database configured to store original data related to a first computer, said original data corresponding to at least one of operational and configuration characteristics of hardware, software and user of said computers;

a condensing agent coupled to said first database and configured to generate summarized data based on said original data;

a base database having a first portion configured to store said summarized data and a second portion configured to store index data comprising at least connection information of said first database; and

a console module coupled to said base database and configured for operation in (i) a first mode to generate a first output based on said summarized data and (ii) a second mode wherein said console module uses said connection information in said index data to facilitate access to said first database to generate a second output.

7. The apparatus of claim 6 further comprising a data collection agent for acquiring and storing said original data in said first database.

8. The apparatus of claim 7 wherein said first database is local to said first computer.

9. The apparatus of claim 7 wherein said first database is remote from said first computer, said first database comprising a portion of a client-server database.

10. The apparatus of claim 6 wherein said data collection agent is configured to acquire said original data relating to at least one of a system, a disk, a network interface, an application program and a user associated with said first computer.

11. The apparatus of claim 6 wherein said first portion of said base database comprises an application table having information relating to usage of application programs.

12. The apparatus of claim 11 wherein said summarized data comprises statistical information relating to said usage of application programs.

13. The apparatus of claim 11 wherein said application table, for each user executing an application program on said first computer, includes a respective record containing-summarized data indicative of such application program usage.

14. The apparatus of claim 11 wherein a plurality of application programs are executed on said first computer by a user, said application table comprising a corresponding plurality of records, one for each application program and system combination, each record having summarized data comprising statistical information regarding such use of said application programs.

15. The apparatus of claim 11 further including a plurality of computers arranged in a tree style hierarchy, wherein application tables included in databases associated with each computer in said hierarchy are condensed and transmitted, level-by-level, to databases upstream in said hierarchy.

16. A method of managing information for a plurality of computers configured for connection to a network, comprising the steps of:

(A) collecting original data for each computer associated with said respective computer, while at least one of said computers is disconnected from said network, and storing the original data in a respective database;

(B) generating for each computer an index table including index data configured (i) to identify at least a portion of the contents of the original data stored in the database, and (ii) to facilitate access to the databases over the distributed network and wherein said index data reflects the at least one disconnected computer when reconnected to said network;

(C) selecting at least one of the plurality of databases by scanning index tables and determining, using the index data, which of the databases contain original data responsive to a user query;

(D) accessing the selected databases to retrieve original data and generate an output therefrom.

17. The method of claim 16 further including the step of:

before the generating step, reconnecting said at least one disconnected computer to the network.

18. A method of managing information for a plurality of computers configured for connection to a network, comprising the steps of:

(A) collecting original data for each computer associated with said respective computer, and storing the original data in a respective collection database wherein at least one of the computers is remote from its respective collection database (B) disconnecting the at least one computer from the network while its respective database remains connected to the network;

(C) generating, while the at least one computer is disconnected, a base database from said collection databases containing condensed data wherein the condensed data reflects one of an index table including index data or summarized data, the index data being configured (i) to identify at least a portion of the contents of the original data stored in the database, and (ii) to facilitate access to the databases over the distributed network;

(D) generating an output responsive to a user query using the base database.

19. The method of claim 18 further including the step of:

selecting at least one of the plurality of collection databases by scanning index tables and determining, using the index data, which of the collection databases contain original data responsive to the user query; and

accessing the selected collection databases to retrieve original data.

20. The method of claim 18 wherein the collecting step is performed by the substeps of:

establishing a client-server connection the at least one computer and its respective, remote collection database; and

transferring original data from the at least one computer to its respective remote collection database.

21. A method of managing information for a plurality of computer systems in a distributed network comprising the steps of:

(A) collecting original data associated with each computer system and storing the original data in a respective collection database associated therewith (B) selecting certain ones of the plurality of computer systems for search;

(C) issuing a first query to the selected computer systems each of which process the first query locally with respect to original data contained in its respective collection database;

(D) consolidating responses to the first query in a working database at a base location remote from the plurality of collection databases;

(E) applying a second query to the working database at the base location to produce a result set;

(F) generating an output using the result set.

22. The method of claim 21 wherein said selecting step is performed by the substep of:

receiving an identification of the selected computer systems for search from an external source.

23. The method of claim 21 wherein the step of issuing a first query is performed in a substantially parallel fashion to the selected computer systems.

24. The method of claim 21 wherein said selecting step is performed by the substep of:

identifying all of the plurality of computer systems as selected computer systems for search.

25. The method of claim 21 wherein said selecting step is performed by the substeps of:

generating an index table including index data for each computer system wherein the index data is configured (i) to identify at least a portion of the contents of the original data stored in the collection database, and (ii) to facilitate access to the collection databases over the distributed network;

conducting a search space constraining query by scanning the index tables and identifying, using the index data, as the selected databases for search those collection databases that contain original data responsive to the search space constraining query.

26. The method of claim 21 wherein said selecting step is performed by the substeps of:

producing a summarized data table for the computer systems using the original data;

conducting a search space constraining query by scanning the summarized data table and identifying as the selected databases for search those collection databases that contain original data responsive to the search space constraining query.

27. The method of claim 21 wherein the step of applying a second query to the working database includes the substep of:

utilizing supplemental data external to the working database.

28. The method of claim 21 wherein the step of generating an output includes the substeps of:

formatting and displaying the output.