Automatically moving multidimensional data between live datacubes of enterprise software systems

• US 8,468,125 B2
• Filed: 04/12/2005
• Issued: 06/18/2013
• Est. Priority Date: 04/12/2005
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Bowen, David S., Oppenheimer, Leonard Roy, Pitstick, John Martin, Tarnoff, Finuala
• Primary Examiner(s): Alam, Hosain
• Assistant Examiner(s): Tang, Jieying
• Application Number:
  US11/103,902
• Publication Number:
  US 20060230067A1
• Time in Patent Office: 2,989 Days
• Field of Search: 707/999.104, 707/602, 707/610, 707/637, 709/217, 709/248
• US Class Current: 707/610
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses

Abstract

Techniques are described for sharing multidimensional data between software systems, such as enterprise software systems. Specifically, the techniques provide mechanisms for defining inter-application “links” for automatically moving data among different databases associated with the enterprise software systems. For example, a system may include a first database storing multidimensional data for a first software application, and a second database storing multidimensional data for a second software application. The system further includes an interface by which an administrator defines a link that specifies a source area of the first database and a target area of the second database. A link control module automatically moves multidimensional data from the source area to the target area in accordance with the link. The link control module may automatically move the multidimensional data directly between live portions of the respective databases.

Claims

1. A method for exporting data from a software system comprising:

defining a link from a first software application to a second software application by;

identifying a source data cube associated with the first software application and a target data cube associated with the second software application,

identifying a source dimension of the source data cube and a target dimension of the target data cube, and

defining a mapping between one or more items of the source dimension and one or more items of the target dimension,

wherein the link specifies a live source area storing current multidimensional data in the source data cube of a multidimensional database associated with the first software application and a live target area of a multidimensional database storing current multidimensional data in the target data cube associated with the second software application, wherein the multidimensional database of the second software application includes a staging area to process import data to be imported into the second software application, wherein the staging area of the second software application is separate from the live target area of the second software application; and

automatically moving, by a computer, multidimensional data from the live source area directly to the live target area in accordance with the link by bypassing the staging area of the second software application.

2. The method of claim 1, wherein automatically moving multidimensional data includes moving the multidimensional data in accordance with the mapping.

3. The method of claim 1, further comprising:

defining at least one data transformation; and

applying the transformation to the multidimensional data when moving the multidimensional data from the source area to the target area.

4. The method of claim 1, wherein defining the link comprises defining a data aggregation that maps a plurality of items along the source dimension to one item along the target dimension.

5. The method of claim 1, wherein defining the link comprises mapping an item along a source dimension to a plurality of items along a target dimension.

6. The method of claim 1, further comprising:

defining a schedule for invoking the link; and

automatically moving the multidimensional data in accordance with the schedule.

7. The method of claim 1,

wherein defining the link comprises defining an administrative link, and

wherein automatically moving multidimensional data comprises executing one or more administrative jobs to move the multidimensional data.

8. The method of claim 1, further comprising:

downloading multidimensional planning data to a client device of a user;

automatically moving the multidimensional data from the source area into the planning data upon manual invocation of the link by the user; and

saving the planning data to the target area from the client device.

9. The method of claim 1, wherein automatically moving multidimensional data comprises exporting a consistent set of data from the source area.

10. The method of claim 1, wherein automatically moving multidimensional data comprises automatically moving the multidimensional data from the source area to an import queue of the second software application, wherein the import queue executes within the live target area of the multidimensional database of the second software application.