Dynamic report mapping apparatus to physical data source when creating report definitions for information technology service management reporting for peruse of report definition transparency and reuse

• US 8,712,965 B2
• Filed: 06/29/2006
• Issued: 04/29/2014
• Est. Priority Date: 06/29/2006
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Chang, Kyusun, Manohar, Navin D., Wilhm, Ryan Kelly
• Primary Examiner(s): ALAM, SHAHID AL
• Application Number:
  US11/427,385
• Publication Number:
  US 20080005197A1
• Time in Patent Office: 2,861 Days
• Field of Search: 707/204, 707/100, 707/640, 707/770, 707/804, 705/10
• US Class Current: 707/640
• CPC Class Codes: G06F 16/84 Mapping; Conversion

Abstract

A computer implemented method, data processing system, and computer program product for dynamically creating report mapping relationships at runtime within an information technology infrastructure. When report definition comprising a generalized description of desired data without any database-specific properties is generated, a relationship mapping definition based on the generalized description in the report definition is created, wherein the relationship mapping definition comprises data connection information for accessing the data sources containing the desired data. The relationship mapping definition is then used to initiate a connection to the data sources. Once the desired data has been acquired from the data sources, a report may then be created using the acquired data.

Claims

1. A computer implemented method for dynamically creating report mapping relationships at runtime, the computer implemented method comprising:

responsive to generating a report definition comprising a generalized description of desired data without any database-specific properties, creating a relationship mapping definition based on the generalized description in the report definition, wherein the relationship mapping definition comprises data connection information for accessing one or more data sources containing the desired data;

initiating a connection to the one or more data sources using the relationship mapping definition; and

responsive to acquiring the desired data from the one or more data sources, generating a report using the acquired data.

2. The computer implemented method of claim 1, wherein the relationship mapping definition dynamically provides the data connection information for the one or more data sources and the report definition at runtime.

3. The computer implemented method of claim 1, wherein the creating step further comprises:

creating a database SQL statement using the mapping relationship definition; and

issuing a request to generate the report to the report content generation engine.

4. The computer implemented method of claim 1, wherein the creating step further comprises:

determining whether a report output is acceptable;

if the report output is unacceptable, editing the data connection details in the relationship mapping definition; and

if the report is acceptable, saving the report definition.

5. The computer implemented method of claim 1, wherein the relationship mapping definition includes at least one of attribute-to-entity, column-to-attribute, or table-to-entity relationships.

6. The computer implemented method of claim 1, wherein the creating step is performed by a report content generation engine.

7. The computer implemented method of claim 1, wherein the report content generation engine comprises a mapping module and a knowledge module.

8. A data processing system for dynamically creating report mapping relationships at runtime, 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 create a relationship mapping definition based on the generalized description in the report definition in response to generating a report definition comprising a generalized description of desired data without any database-specific properties, wherein the relationship mapping definition comprises data connection information for accessing one or more data sources containing the desired data, initiate a connection to the one or more data sources using the relationship mapping definition, and generate a report using the acquired data in response to acquiring the desired data from the one or more data sources.

9. The data processing system of claim 8, wherein the relationship mapping definition dynamically provides the data connection information for the one or more data sources and the report definition at runtime.

10. The data processing system of claim 8, wherein the computer usable code to create a relationship mapping definition further comprises computer usable code to create a database SQL statement using the mapping relationship definition, and computer usable code to issue a request to generate the report to the report content generation engine.

11. The data processing system of claim 8, wherein the computer usable code to create a relationship mapping definition further comprises computer usable code to determine whether a report output is acceptable, computer usable code to create a relationship mapping definition editing the data connection details in the relationship mapping definition if the report output is unacceptable, and computer usable code to save the report definition if the report is acceptable.

12. The data processing system of claim 8, wherein the relationship mapping definition includes at least one of attribute-to-entity, column-to-attribute, or table-to-entity relationships.

13. The data processing system of claim 8, wherein the creating step is performed by a report content generation engine.