Reporting module definition language system and method

• US 7,516,127 B2
• Filed: 05/18/2005
• Issued: 04/07/2009
• Est. Priority Date: 05/21/2004
• Status: Active Grant

• Current Assignee: Computer Associates Think Inc. (Broadcom, Inc.)
• Original Assignee: Computer Associates Think Inc. (Broadcom, Inc.)
• Inventors: Starch, Jesper
• Primary Examiner(s): Vital; Pierre M.
• Assistant Examiner(s): Nguyen; Loan T
• Application Number:
  US11/131,699
• Publication Number:
  US 20050262074A1
• Time in Patent Office: 1,420 Days
• Field of Search: 707 2- 7, 707/10, 707/102, 707/200, 707/204
• US Class Current: 1/1
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99937 Sorting

Abstract

In one embodiment, a method for data management includes receiving a request for information associated with an incompatible foreign data source and the compatible native data source. In response to at least the request, technical and logical information for locating and processing the foreign data source are automatically identified. Foreign data from the foreign data source is retrieved in accordance with the technical information. Native data from the native data source is retrieved. At least a portion of the foreign data and at least a portion of the native data is merged in accordance with at least the logical information.

Claims

1. A computer readable medium including computer-executable instructions thereon for retrieving and presenting information from foreign data sources to a user via a software application, wherein the computer-executable instructions operable when executed on a computing device cause the computing device to:

receive, by a software application, a request for information associated with a foreign data source incompatible with the software application and a native data source compatible with the software application, wherein the request is initiated by a user selection of the information associated with the foreign data source and the native data source at the software application;

in response to at least the request, automatically identify, by the software application, at least one module associated with the software application having technical and logical information for locating and processing the information associated with the foreign data source;

retrieve, by the software application, the information associated with the foreign data source from the foreign data source in accordance with the technical information;

retrieve, by the software application, the information associated with the native data source from the native data source;

dynamically link the information associated with the foreign data source with the information associated with the native data source in accordance with the technical information to enable merging of the information associated with the foreign data source and the information associated with the native data source; and

merge, by the software application, at least a portion of the information retrieved from the foreign data source and at least a portion of the information retrieved from the native data source, wherein the software application uses the logical information to merge the foreign data source information and the native data source information and to integrate the foreign data source and the native data source in a logical domain of the software application.

2. The computer readable medium of claim 1, wherein the computer-executable instructions that cause the computing device to merge the information associated with the foreign data source and the information associated with the native data source using the logical information further cause the computing device to map the foreign data to identifiers compatible with native data in accordance with the logical information without input from a user.

3. The computer readable medium of claim 1, wherein the technical and logical information are stored in a reporting module, the reporting module integrated into the logical domain of the software application.

4. Computer readable medium of claim 1, wherein the technical information comprises at least one of a database identifier, a database table identifier, a column identifier, an Internet Protocol (IP) address, a logical location, a login name, a password, a data source identifier, a database command, or a key.

5. The computer readable medium of claim 1, wherein the information associated with the foreign data source and the information associated with the native data source are linked through a foreign key table.

6. A system for retrieving and presenting information from foreign data sources to a user via a software application, comprising:

memory storing a compatible native data source;

one or more processors configured to;

receive, by a software application, a request for information associated with a foreign data source incompatible with the software application and the compatible native data source, wherein the request is initiated by a user selecting the information associated with the foreign data source and the native data source at the software application;

in response to at least the request, automatically identify, by the software application, at least one module associated with the software application having technical and logical information for locating and processing the information associated with the foreign data source;

retrieve, by the software application, the information associated with the foreign data source from the foreign data source in accordance with the technical information;

retrieve, by the software application, the information associated with the native data source from the native data source;

dynamically link the information associated with the foreign data source with the information associated with the native data source in accordance with the technical information to enable merging of the information associated with the foreign data source and the information associated with the native data source; and

merge, by the software application, at least a portion of the information retrieved from the foreign data source and at least a portion of the information retrieved from the native data source, wherein the software application uses the logical information to merge the foreign data source information and the native data source information and to integrate the foreign data source and the native data source in a logical domain of the software application.

7. The system of claim 6, wherein the one or more processors configured to merge the information associated with the foreign data source and the information associated with the native data source using the logical information are further configured to map the information associated with the foreign data source to identifiers compatible with information associated with native data source in accordance with the logical information without input from a user.

8. The system of claim 6, wherein the technical and logical information are stored in a reporting module, the reporting module integrated into the logical domain software application.

9. The system of claim 6, wherein the technical information comprises at least one of a database identifier, a database table identifier, a column identifier, an IP address, a logical location, a login name, a password, a data source identifier, a database command, or a key.

10. The system of claim 6, wherein the information associated with the foreign data source and the information associated with the native data source are linked through a foreign key table.

11. A method for data management retrieving and presenting information from foreign data sources to a user via a software application, comprising:

receiving, by a software application, a request for information associated with a foreign data source incompatible with the software application and a native data source compatible with the software application, wherein the request is initiated by a user selection of the information associated with the foreign data source and the native data source at the software application;

in response to at least the request, automatically identifying, by the software application, at least one module associated with the software application having technical and logical information for locating and processing the information associated with the foreign data source;

retrieving, by the software application, the information associated with the foreign data source from the foreign data source in accordance with the technical information.

retrieving, by the software application, the information associated with the native data source from the native data source;

dynamically link the information associated with the foreign data source with the information associated with the native data source in accordance with the technical information to enable merging of the information associated with the foreign data source and the information associated with the native data source; and

merge, by the software application, at least a portion of the information retrieved from the foreign data source and at least a portion of the information retrieved from the native data source, wherein the software application uses the logical information to merge the foreign data source information and the native data source information and to integrate the foreign data source and the native data source in a logical domain of the software application.

12. The method of claim 11, wherein merging the information associated with the foreign data source and the information associated with the native data source using the logical information comprises mapping the information associated with the foreign data source to identifiers compatible with information associated with the native data source in accordance with the logical information without input from a user.

13. The method of claim 11, wherein the technical and logical information are stored in a reporting module;

the reporting module integrated into the logical domain of the software application.

14. The method of claim 11, wherein the technical information comprises at least one of a database identifier, a database table identifier, a column identifier, an IP address, a logical location, a login name, a password, a data source identifier, a database command, or a key.

15. The method of claim 11, wherein the information associated with the foreign data source and the information associated with the native data source are linked through a foreign key table.