METHOD AND APPARATUS FOR MANAGING DATA FOR USE BY DATA APPLICATIONS

• US 20020188584A1
• Filed: 08/31/1999
• Published: 12/12/2002
• Est. Priority Date: 08/31/1998
• Status: Active Grant

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: Aprisma Management Technologies Incorporated (Broadcom, Inc.)
• Inventors: LEWIS, LUNDY M., DATTA, UTPAL, GHANNAM, JEFF, LOOMIS, TODD A.
• Granted Patent: US 6,651,062 B2
• Time in Patent Office: Days
• US Class Current: 707/1
• 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: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A system and method is provided for managing information. Information is aggregated from multiple data sources into a data warehouse wherein the information can be provided to software applications. Disparate information from multiple sources is processed and stored in the data warehouse. Processing may include filtering, collation, compression, and mapping information into database fields of the warehouse. In one aspect, information stored in the warehouse may be network management data.

Claims

1. A system for managing information, the system comprising:

a data manager that accepts data from a plurality of management systems and processes and stores the data in a data warehouse, the data manager comprising;

an agent configured to accept information from the plurality of management systems and which maps the accepted information into database fields of the data warehouse; and

a database accessor that stores the accepted information in the data warehouse.

2. The system according to claim 1, wherein the agent deletes duplicate data received from more than one source.

3. The system according to claim 1, wherein at least one of the plurality of management systems is a network management system.

4. The system according to claim 1, wherein the database accessor utilizes a standard database interface to one or more proprietary data warehouses.

5. The system according to claim 1, wherein the agent is a push agent configured to push data to the database accessor at a specified interval.

6. The system according to claim 1, wherein the agent is a polling agent configured to poll one or more systems for obtaining management data and provides the management data to the database accessor.

7. The system according to claim 6, wherein the one or more systems are network management systems.

8. The system according to claim 7, wherein the network management systems store different types of management information.

9. A method of managing information, the method comprising steps of:

accepting data from a plurality of management systems;

accepting information from the plurality of management systems and mapping the accepted information into database fields of the data warehouse; and

storing the accepted information in the data warehouse.

10. The method according to claim 9, further comprising a step of deleting duplicate data received from more than one management system.

11. The method according to claim 9, wherein at least one of the plurality of management systems is a network management system.

12. The method according to claim 9, wherein the database includes one or more proprietary data warehouses and the method further comprises a step of using a standard database interface to access the one or more proprietary data warehouses.

13. The method according to claim 9, further comprising a step of pushing data for storage in the data warehouse at a specified interval.

14. The method according to claim 9, further comprising a step of polling at least one of the plurality of management systems to obtain management information and providing the management information for storage in the data warehouse.

15. The method according to claim 14, wherein the one or more systems are network management systems.

16. The method according to claim 15, wherein the network management systems store different types of management information.

17. A computer program product comprising a computer-readable medium having computer logic recorded thereon for enabling a processor in a computer system to manage information, the computer program being adapted to cause the computer system to perform the steps of:

accepting information from a plurality of management systems;

accepting information from the plurality of management systems and mapping the accepted information into database fields of the data warehouse; and

storing the accepted information in the data warehouse.