System and method for information management in a distributed network

• US 20050203873A1
• Filed: 03/14/2005
• Published: 09/15/2005
• Est. Priority Date: 03/15/2004
• Status: Active Grant

• Current Assignee: Emc IP Holding Company LLC (Dell Technologies Inc.)
• Original Assignee: WysDM Software, Inc. (Dell Technologies Inc.)
• Inventors: McDonald, James Gregor
• Granted Patent: US 7,606,804 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/245 Query processing
• 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/99938 Concurrency, e.g. lock management in shared database

Abstract

A system and method of information management for a distributed network of data sources comprises, in one example, obtaining information from at least one data source and storing the information in at least one data structure in accordance with previously stored configuration parameters. The system and method further includes receiving a query for selected information of the stored information and processing the stored information based on the query to generate an output representing the selected information.

Claims

1. A method of data management for a distributed network of data sources comprising:

obtaining data from a plurality of remote data sources;

storing the data from the plurality of data sources in at least one data structure in accordance with a predetermined data structure configuration;

receiving at least one parameter associated with selected data from the data structure, and

processing the selected data to generate an output, wherein the output is based at least in part on the selected data.

2. The method of claim 1, wherein the data may be obtained from at least one of a remote system, network, application or storage domain.

3. The method of claim 1, wherein the predetermined data structure configuration is based on an organizational hierarchy.

4. The method of claim 1, wherein the at least one data structure comprises a relational database.

5. The method of claim 1, wherein the at least one data structure is configured for SQL applications.

6. The method of claim 1, wherein the at least one parameter includes at least one user-defined attribute.

7. The method of claim 1, wherein the at least one parameter is received in XML format.

8. The method of claim 1, wherein the at least one parameter is associated with a predetermined data selection for a particular user.

9. The method of claim 1, wherein the at least one parameter is associated with at least one predictive analysis operation.

10. The method of claim 1, wherein the selected data spans a plurality of data structures.

11. The method of claim 1, wherein processing the selected data includes coding the data in XML format.

12. The method of claim 11, wherein the selected data is coded in a compressed XML format when the amount of selected data exceeds a predetermined threshold.

13. The method of claim 1, wherein processing the selected data includes correlating the selected data with the at least one parameter.

14. The method of claim 1, wherein processing the selected data includes performing at least one mathematical or logical operation.

15. The method of claim 1, wherein processing the selected data includes correlating the selected data with at least one time period parameter.

16. The method of claim 1, wherein the output is generated for presentation via a user interface.

17. The method of claim 1, wherein the output includes at least one of an email or SNMP alert.

18. The method of claim 1, wherein the output is generated for additional processing.

20. The system of claim 1, wherein the collector includes a plurality of modules for obtaining data from each of the plurality of remote data sources.

21. The system of claim 1, wherein the collector may obtain data from at least one of a remote system, network, application or storage domain.

22. The system of claim 1, wherein the configuration of the data mine is based on an organizational hierarchy.

23. The system of claim 1, wherein the data mine comprises at least one relational database.

24. The system of claim 1, wherein the data mine is configured for SQL applications.

25. The system of claim 1, wherein the at least one parameter includes at least one user-defined attribute.

26. The system of claim 1, wherein the at least one parameter is received in XML format.

27. The system of claim 1, wherein the at least one parameter is associated with a predetermined data selection for a particular user.

28. The system of claim 1, wherein the at least one parameter is associated with at least one predictive analysis operation.

29. The system of claim 1, wherein the selected data spans a plurality of data structures within the data mine.

30. The system of claim 1, wherein the reporter processes the selected data by coding the selected data in XML format.

31. The system of claim 30, wherein the reporter codes the selected data in a compressed XML format when the amount of selected data exceeds a predetermined threshold.

32. The system of claim 1, wherein the reporter correlates the selected data with the at least one parameter.

33. The system of claim 1, wherein the reporter processes the selected data by performing at least one mathematical or logical operation.

34. The system of claim 1, wherein the reporter processes the selected data by correlating the selected data with at least one time parameter.

35. The system of claim 1, further comprising a publisher for generating a report based at least in part on the output for presentation to a user.

36. The system of claim 1, wherein the output includes at least one of an email or SNMP alert.

37. The system of claim 1, wherein the reporter generates the output for additional processing.

38. The system of claim 1, further comprising a predictive analysis component for correlating the output based at least in part on the selected data with previously selected data.

39. The system of claim 38, wherein the predictive analysis component generates an alert associated with the correlation of the output with the previously selected data

40. The system of claim 39, wherein the alert is one of an email or SNMP alert.

19. A system of data management for a distributed network of data sources comprising:

a collector for obtaining data from a plurality of remote data sources;

a data mine for storing the data from the plurality of data sources;

a listener for processing the data from the plurality of data sources in accordance with a predetermined data structure configuration, the listener for further inserting the processed data into the data mine;

a controller for receiving at least one parameter associated with selected data from the data mine,

wherein the controller includes a data structure for storing control and configuration information associated with accessing the data mine; and

a reporter for processing the selected data to generate an output, wherein the output is based at least in part on the selected data.

41. An information management system comprising:

at least one gathering process for obtaining information from at least one data source;

at least one storage process for storing said information obtained from said at least one data source in a data structure in accordance with previously stored configuration parameters; and

at least one extraction process for extracting selected information from said stored information processing said selected information to generate an output.