Abstracted dynamic report definition generation for use within information technology infrastructure

• US 9,251,222 B2
• Filed: 06/29/2006
• Issued: 02/02/2016
• Est. Priority Date: 06/29/2006
• Status: Active Grant

• Current Assignee: Daedalus Blue LLC
• Original Assignee: International Business Machines Corporation
• Inventors: Chang, Kyusun, Wilhm, Ryan Kelly
• Primary Examiner(s): ALAM, SHAHID AL
• Application Number:
  US11/427,378
• Publication Number:
  US 20080016086A1
• Time in Patent Office: 3,505 Days
• Field of Search: 707/603, 707/609, 707/100, 707/204, 707/802, 707/640, 705/5
• US Class Current: 1/1
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data
• CPC Class Codes: G06F 16/2308 Concurrency control transaction processing G06F9/466
• CPC Class Codes: G06F 16/248 Presentation of query results

Abstract

A computer implemented method, data processing system, and computer program product for abstracted dynamic report definition generation within an information technology infrastructure. When a request to generate a report is received, report definition associated with the requested report is identified, wherein the report definition comprises a generalized description of desired data in the report without any database-specific properties. The resources which are able to provide the desired data using report instance parameters in the report definition are then identified. Responsive to determining the resources that are able to provide the desired data, the generalized description in the report definition is translated into report content generation engine-specific implementation details and actions. The translated report content generation engine-specific implementation details and actions are executed to obtain the desired data from the resources. A report may then be generated based on the resulting output.

Claims

1. A computer implemented method executed by a processor for processing abstracted report definitions within an information technology infrastructure, the computer implemented method comprising:

responsive to receiving a request to generate a report, identifying a report definition associated with the requested report, wherein the report definition comprises a generalized description of desired data in the report without any database-specific properties;

identifying resources which are able to provide the desired data using report instance parameters in the report definition;

responsive to determining the resources that are able to provide the desired data, translating the generalized description in the report definition into report content generation engine-specific implementation details and actions by mapping relationships between the generalized description of desired data in the report definition and the identified resources;

executing the translated report content generation engine-specific implementation details and actions to obtain the desired data from the resources; and

generating the report using the obtained data.

2. The computer implemented method of claim 1, wherein the request to generate a report is initiated from one of a user or a report scheduling function.

3. The computer implemented method of claim 1, wherein the identified resources include physical data sources and a report content generation engine.

4. The computer implemented method of claim 3, wherein the report definition comprises input data set requirements and report content generation engine requirements.

5. The computer implemented method of claim 4, wherein the identifying step further comprises:

verifying that the physical data sources satisfy the data set requirements in the report definition.

6. The computer implemented method of claim 4, wherein the identifying step further comprises:

verifying that the report content generation engine satisfies the report content generation engine requirements in the report definition.

7. The computer implemented method of claim 6, wherein the verification step further comprises:

selecting a best possible report content generation engine instance if multiple candidates satisfy minimum report content generation engine requirements in the report definition.

8. The computer implemented method of claim 1, wherein the generalized description of desired data includes descriptive information about aggregation operations and other elements that describe a business concept.

9. A data processing system for processing abstracted report definitions within an information technology infrastructure, the data processing system comprising:

a bus;

a storage device connected to the bus, wherein the storage device contains computer usable code;

at least one managed device connected to the bus;

a communications unit connected to the bus; and

a processing unit connected to the bus, wherein the processing unit executes the computer usable code to identify a report definition associated with the requested report in response to receiving a request to generate a report, wherein the report definition comprises a generalized description of desired data in the report without any database-specific properties, identify resources which are able to provide the desired data using report instance parameters in the report definition, translate the generalized description in the report definition into report content generation engine-specific implementation details and actions by mapping relationships between the generalized description of desired data in the report definition and the identified resources in response to determining the resources that are able to provide the desired data, execute the translated report content generation engine-specific implementation details and actions to obtain the desired data from the resources, and generate the report using the obtained data.

10. The data processing system of claim 9, wherein the identified resources include physical data sources and a report content generation engine.

11. The data processing system of claim 10, wherein the report definition comprises input data set requirements and report content generation engine requirements.

12. The data processing system of claim 11, wherein the identifying step further comprises:

verifying that the physical data sources satisfy the data set requirements in the report definition.

13. The data processing system of claim 11, wherein the identifying step further comprises:

verifying that the report content generation engine satisfies the report content generation engine requirements in the report definition.

14. A computer program product for processing abstracted report definitions within an information technology infrastructure, the computer program product comprising:

a non-transitory computer readable storage medium having computer usable program code stored thereon, the computer usable program code comprising;

computer usable program code for identifying a report definition associated with the requested report in response to receiving a request to generate a report, wherein the report definition comprises a generalized description of desired data in the report without any database-specific properties;

computer usable program code for identifying resources which are able to provide the desired data using report instance parameters in the report definition;

computer usable program code for translating the generalized description in the report definition into report content generation engine-specific implementation details and actions by mapping relationships between the generalized description of desired data in the report definition and the identified resources in response to determining the resources that are able to provide the desired data;

computer usable program code for executing the translated report content generation engine-specific implementation details and actions to obtain the desired data from the resources; and

computer usable program code for generating the report using the obtained data.

15. The computer program product of claim 14, wherein the identified resources include physical data sources and a report content generation engine.

16. The computer program product of claim 15, wherein the report definition comprises input data set requirements and report content generation engine requirements.

17. The computer program product of claim 16, wherein the computer usable program code for identifying resources further comprises:

computer usable program code for verifying that the physical data sources satisfy the data set requirements in the report definition.

18. The computer program product of claim 16, wherein the computer usable program code for identifying resources further comprises:

computer usable program code for verifying that the report content generation engine satisfies the report content generation engine requirements in the report definition.

19. The computer program product of claim 18, wherein the computer usable program code for verifying that the report content generation engine satisfies the report content generation engine requirements further comprises:

computer usable program code for selecting a best possible report content generation engine instance if multiple candidates satisfy minimum report content generation engine requirements in the report definition.

20. The computer program product of claim 14, wherein the generalized description of desired data includes descriptive information about aggregation operations and other elements that describe a business concept.