System and method for business intelligence metadata exchange

• US 8,229,882 B2
• Filed: 05/28/2004
• Issued: 07/24/2012
• Est. Priority Date: 05/28/2004
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Da Silva, Ricardo, Perlman, Julia
• Primary Examiner(s): COLAN, GIOVANNA B
• Application Number:
  US10/856,036
• Publication Number:
  US 20050278304A1
• Time in Patent Office: 2,979 Days
• Field of Search: 707/104.1, 707/513, 707/6, 707/523, 709/223, 715/530
• US Class Current: 707/601
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

The invention makes use of a single data structure to define all of the information and parameters necessary for the efficient sharing and exchange of entire or partial BI applications. The invention enables a user to capture preferences that are applicable to both ends of the exchange, namely the source and the target systems. It provides for users to be presented with a comprehensive list of preferences and smart defaults from which they can select, and in some cases override, at both the source and target end points of the exchange. The actual metadata exchange is persisted as an exchange structure in a computer system file system called an exchange archive.

Claims

1. A method for sharing an exchange definition file between a source system and a target system for a business intelligence application having application objects, the method comprising the steps of:

a) selecting a report definition in the source system, the report definition being used for constructing business intelligence report, the source system being defined by a source environment;

b) defining environment parameters for the source environment;

the environment parameters including default values and restrictions;

c) creating the exchange definition file in the source system using the environment parameters, the exchange definition file including the report definition, a database connection, and a model package;

d) saving the exchange definition file in an archive, the archive accessible by the source system and the target system;

e) reading the exchange definition file from the archive into the target system;

f) recreating the report definitions in the target system from the exchange definition file; and

g) creating new environment parameters in the target system according to the exchange definition file.

2. The method according to claim 1, wherein the source and the target system use the same business intelligence application.

3. The method according to claim 2, wherein the source and the target system have different data sources and users.

4. The method according to claim 2, wherein the step of saving the exchange definition file and the step of reading the exchange definition file from the archive are non-concurrent.

5. The method according to claim 1, wherein the exchange definition file comprises application objects selected from a group consisting of report definitions, reporting schedules, report execution histories, groups and roles, contacts and distribution lists, data sources, database connections, model package and a combination thereof.

6. The method according to claim 1, wherein the exchange definition file is encrypted.

7. A system for sharing an exchange definition file between a source system and a target system for a business intelligence application having application objects, the system comprising:

means for selecting a report definition in the source system, the report definition being used for constructing business intelligence report, the source system being defined by a source environment;

means for defining environment parameters for the source environment;

the environment parameters including default values and restrictions;

means for creating the exchange definition file in the source system using the environment parameters, the exchange definition file including the report definition, a database connection, and a model package;

means for saving the exchange definition file in an archive, the archive accessible by the source system and the target system;

means for reading the exchange definition file from the archive into the target system;

means for recreating the report definitions in the target system from the exchange definition file; and

means for creating new environment parameters in the target system according to the exchange definition file.

8. The system according to claim 7, wherein the source and the target system use the same business intelligence application.

9. The system according to claim 8, wherein the source and the target system have different data sources and users.

10. A storage medium readable by a computer encoding a computer program for execution by the computer to carry out a method for sharing an exchange definition file between a source system and a target system for a business intelligence application having application objects, the computer program comprising:

code means for selecting a report definition in the source system, the report definition being used for constructing business intelligence report, the source system being defined by a source environment;

code means for defining environment parameters for the source environment;

the environment parameters including default values and restrictions;

code means for creating the exchange definition file in the source system using the environment parameters, the exchange definition file including a report definition, a database connection, and a model package;

code means for saving the exchange definition file in an archive, the archive accessible by the source system and the target system;

code means for reading the exchange definition file from the archive into the target system;

code means for recreating the report definitions in the target system from the exchange definition file; and

code means for creating new environment parameters in the target system according to the exchange definition file.

11. The storage medium according to claim 10, wherein the source and the target system use the same business intelligence application.

12. The storage medium according to claim 11, wherein the source and the target system have different data sources and users.

13. The storage medium according to claim 11, wherein the code means for saving the exchange definition file and the code means for reading the exchange definition file from the archive run non-concurrently.

14. The storage medium according to claim 10, wherein the exchange definition file comprises application objects selected from a group consisting of report definitions, reporting schedules, report execution histories, groups and roles, contacts and distribution lists, data sources, database connections, model package and a combination thereof.

15. The storage medium according to claim 10, wherein the exchange definition file is encrypted.