Dynamic exception reporting service for heterogeneous structured enterprise data

• US 20060248092A1
• Filed: 04/29/2005
• Published: 11/02/2006
• Est. Priority Date: 04/29/2005
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Keller, Neal M., Rose, Kristoffer H., Sava, Michael, Vridhachalam, Murali
• Application Number:
  US11/118,137
• Publication Number:
  US 20060248092A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/80 of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML content-based retrieval of web data G06F16/95

Abstract

A computer-implemented technique that allows a per element mixture of “concrete” XML elements and “virtual” XML elements that are generated dynamically from external data sources. The technique extends the XML Schema language with declarations of how additional substructure is injected into existing instances. The instances created according to an XML schema with such extra declarations—called pseudo-elements and pseudo-attributes—thus mix original XML structure with the injected structure, but without creating a complete XML instance. The consumer of the structure cannot distinguish between the original and injected parts except by reading the XML Schema containing the declarations.

Claims

1. A computer-implemented method for enriching data sources, comprising:

creating a tree based organizing structure for heterogeneous structured enterprise data sources having associated structured data;

including unmaterialized, computed data fragments on demand in individual data elements in the organizing structure; and

navigating to nodes in the organizing structure so as to provide localized, context sensitive enrichment of the data sources.

2. The computer-implemented method of claim 1, wherein the data sources comprise relational data sources.

3. The computer-implemented method of claim 1, wherein the data sources comprise hierarchical data sources.

4. The computer-implemented method of claim 1, wherein the localized, context sensitive enrichment is based on notation for the data sources which allows navigating to the individual data elements, which are described through paths, and expressing possible navigation steps relative to the paths and the data associated with the data elements visited along the paths.

5. The computer-implemented method of claim 1, wherein the creating, including and navigating are performed using programmatic interface calls.

6. The computer-implemented method of claim 5, wherein the programmatic interface calls are initiated by a web service.

7. The computer-implemented method of claim 1, further comprising:

receiving, from a sponsor entity, specification of performance criteria associated with providing an exception reporting service at a requested performance level for end-users.

8. The computer-implemented method of claim 7, further comprising:

receiving, from a service provider entity, specification of service provision parameters for providing the exception reporting service according to the requested performance level.

9. The computer-implemented method of claim 1, further comprising:

enabling end-users to perform services including navigation, selection and query building functions, and viewing results from executed report queries; and

enabling the end-users to provide feedback on the services.

10. The computer-implemented method of claim 9, further comprising:

monitoring, logging and storing the built queries, report results and feedback provided by the end-users.

11. The computer-implemented method of claim 9, wherein the feedback includes at least one of ratings and comments pertaining to the requested performance level.

12. The computer-implemented method of claim 9, wherein the feedback pertains to pseudo-elements used to enhance the virtual schemas.

13. A computer-implemented method for enriching data sources, comprising:

creating a tree based organizing structure comprising a virtual schema for heterogeneous structured enterprise data sources having associated structured data;

including unmaterialized, computed data fragments on demand in individual data elements in the organizing structure; and

navigating to nodes in the organizing structure so as to provide localized, context sensitive enrichment of the data sources.

14. The computer-implemented method of claim 13, further comprising:

enabling a domain expert to perform selection, building and enhancing functions for the virtual schema.

15. The computer-implemented method of claim 13, wherein the virtual schema includes a per-element mixture of concrete elements and computed pseudo-elements that are generated dynamically from the data sources.

16. The computer-implemented method of claim 13, further comprising:

enabling a domain expert to select the structured data for the virtual schema.

17. The computer-implemented method of claim 13, further comprising:

enabling a domain expert to build the virtual schema.

18. The computer-implemented method of claim 13, wherein the use of the virtual schema instead of complete virtual instances reduces the computer resources required to provide an exception reporting service according to a requested performance level.

19. The computer-implemented method of claim 18, wherein the reduced required computer resources result from context sensitive computations when navigating the organizing structure.

20. The computer-implemented method of claim 13, further comprising:

enabling end-users to navigate the virtual schema, select the structured data and specify constraints to build exception report queries.

21. The computer-implemented method of claim 20, wherein the data elements include open-ended parameters so as to enable the end-users to include hypothetical scenarios in the exception report queries.

22. The computer-implemented method of claim 20, further comprising:

executing the exception report queries.

23. The computer-implemented method of claim 20, further comprising:

enabling the end-users to use library functions to include at least one of totals, averages and other statistics based on selected data in the exception report queries.

24. The computer-implemented method of claim 20, wherein

the inclusion of virtual data materialized on-demand from the data sources in the structured heterogeneous data is transparent to the end-users.

25. The computer-implemented method of claim 13, further comprising:

enabling a domain expert to computationally enhance the structured data and the virtual schema with pseudo-elements.

26. The computer-implemented method of claim 25, further comprising:

enabling end-users to perform navigation, selection and query building functions, view results from executed report queries, and provide feedback on a requested performance level; and

enabling the domain expert to analyze the queries, results and feedback to modify the virtual schema and the pseudo-elements to optimize performance criteria agreed upon by a sponsor and a service provider.

27. The computer-implemented method of claim 25, further comprising:

suggesting the pseudo-elements to the domain expert based on the end-user feedback and optional real time or batch correlation processes for identifying potentially relevant relationships between elements of the data.

28. The computer-implemented method of claim 25, further comprising:

enabling a domain expert to use library functions to include at least one of totals, averages and other statistics in formulas used to create the pseudo-elements.

29. The computer-implemented method of claim 25, wherein the pseudo-elements enable the end-users to explore at least one of boundary conditions and exception conditions in the data.

30. A program storage device tangibly embodying software instructions which are adapted to be executed by a processor to perform a method for enriching data sources, the method comprising:

creating a tree based organizing structure for heterogeneous structured enterprise data sources having associated structured data;

including unmaterialized, computed data fragments on demand in individual data elements in the organizing structure; and

navigating to nodes in the organizing structure so as to provide localized, context sensitive enrichment of the data sources.