Job scheduling for automatic movement of multidimensional data between live datacubes
First Claim
1. A method for exporting data from a software system comprising:
- defining a link from a source model of a first software application to a target model of a second software application, wherein the link specifies a source area of a multidimensional database comprising one or more multidimensional data cubes defined by the source model, the source area being associated with the first software application, and a target area of a multidimensional database comprising one or more multidimensional data cubes defined by the target model, the target area being associated with the second software application, and wherein the link defines a mapping between source items in the one or more multidimensional data cubes of the source model and target items in the one or more multidimensional data cubes of the target model;
automatically formulating, by one or more computing devices, a plurality of work elements that, when executed, move multidimensional data from the source area to the target area in accordance with the link, wherein automatically formulating the plurality of work elements comprises;
identifying groups of the target items that the mapping maps to groups of the source items;
determining overlaps of items between the groups of the source items specified by the mapping, wherein the overlaps correspond to source items that are common to two or more of the groups of the source items; and
formulating the plurality of work elements such that each of the work elements specifics one of the groups of the target items and a corresponding one of the groups of the source items based on the mapping, and such that each of the items in at least one of the overlaps of items is present in only one of the work elements; and
executing the work elements.
4 Assignments
0 Petitions
Accused Products
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.
-
Citations
29 Claims
-
1. A method for exporting data from a software system comprising:
-
defining a link from a source model of a first software application to a target model of a second software application, wherein the link specifies a source area of a multidimensional database comprising one or more multidimensional data cubes defined by the source model, the source area being associated with the first software application, and a target area of a multidimensional database comprising one or more multidimensional data cubes defined by the target model, the target area being associated with the second software application, and wherein the link defines a mapping between source items in the one or more multidimensional data cubes of the source model and target items in the one or more multidimensional data cubes of the target model; automatically formulating, by one or more computing devices, a plurality of work elements that, when executed, move multidimensional data from the source area to the target area in accordance with the link, wherein automatically formulating the plurality of work elements comprises; identifying groups of the target items that the mapping maps to groups of the source items; determining overlaps of items between the groups of the source items specified by the mapping, wherein the overlaps correspond to source items that are common to two or more of the groups of the source items; and formulating the plurality of work elements such that each of the work elements specifics one of the groups of the target items and a corresponding one of the groups of the source items based on the mapping, and such that each of the items in at least one of the overlaps of items is present in only one of the work elements; and executing the work elements. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A system comprising:
-
a first database storing multidimensional data for a first software application; a second database storing multidimensional data for a second software application; an interface that receives input that defines a link specifying a source area of the first database and a target area of the second database, wherein the link defines a mapping between source items in one or more multidimensional data cubes of a source model for the first database and target items in one or more multidimensional data cubes of a target model for the second database; a link control module that automatically formulates a plurality of work elements that, when executed, move multidimensional data from the source area to the target area in accordance with the link, wherein to formulate the plurality of work elements, the link control module identifies groups of the target items that the mapping maps to groups of the source items, determines overlaps of items between the groups of the source items specified by the mapping, wherein the overlaps correspond to source items that are common to two or more of the groups of the source items, and formulates the plurality of work elements such that each of the work elements specifies one of the groups of the target items and a corresponding one of the groups of the source items based on the mapping, and such that each of the items in at least one of the overlaps of items is present in only one of the work elements; and a set of one or more processors that execute the plurality of work elements. - View Dependent Claims (15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27)
-
-
28. A computer-readable storage medium comprising instructions that, when executed, cause a processor to:
-
present a user interface to receive input that specifies a mapping from one or more source items in one or more multidimensional data cubes of a source model to one or more target items in one or more multidimensional data cubes of a target model; automatically formulate a plurality of work elements that, when executed, move multidimensional data in the source model that are associated with the source items of the source data cube to the target items of the target model wherein the instructions that cause the processor to automatically formulate the plurality of work elements comprise instructions that cause the processor to; identify groups of the target items that the mapping maps to groups of the source items; determine overlaps of items between the groups of the source items specified by the mapping, wherein the overlaps correspond to source items that are common to two or more of the groups of the source items; and formulate the plurality of work elements such that each of the work elements specifies one of the groups of the target items and a corresponding one of the groups of the source items based on the mapping, and such that each of the items in at least one of the overlaps of items is present in only one of the work elements; and cause one or more other processors to execute the plurality of work elements. - View Dependent Claims (29)
-
Specification