System and method for federated member-based data integration and reporting
First Claim
1. A method for integrating data between source data and a target application processing target data, the method comprising the steps of:
- defining a data integration specification, the data integration specification including a lineage information linking a source dimensional member of the source data and a target dimensional member of the target data;
generating a data movement specification using the data integration specification, the data movement specification including the lineage information, a source reference to a source data model, a target reference to a target data model and a query specification for extracting source data for the target application; and
providing the source data to the target application using the data movement specification.
4 Assignments
0 Petitions
Accused Products
Abstract
Method and system for integrating data between source data and a target application processing target data. A declarative data integration specification including a lineage information linking a source dimensional member of the source data and a target dimensional member of the target data is defined. A data movement specification using the data integration specification including the lineage information, a source reference to a source data model, a target reference to a target data model and a query specification for extracting source data for the target application is generated and the source data to the target application using the data movement specification is provided. A federated member-based metadata model including a source metadata model, a target metadata model, the lineage information mapping the source dimensional member and the target dimensional member; and a link connecting the source package layer and the target package layer, is also provided.
83 Citations
46 Claims
-
1. A method for integrating data between source data and a target application processing target data, the method comprising the steps of:
-
defining a data integration specification, the data integration specification including a lineage information linking a source dimensional member of the source data and a target dimensional member of the target data; generating a data movement specification using the data integration specification, the data movement specification including the lineage information, a source reference to a source data model, a target reference to a target data model and a query specification for extracting source data for the target application; and providing the source data to the target application using the data movement specification. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25)
-
-
26. A system for integrating data between a source data to a target data, the system comprising:
-
a data integration module defining a data integration specification, the data integration specification including a lineage information linking a source dimensional member of the source data and a target dimensional member of the target data; a data movement specification generator generating a data movement specification using the data integration specification, the data movement specification including the lineage information, a source reference to a source data model, a target reference to a target data model and a query specification for extracting source data for the target application; and a data movement service providing the source data to the target application using the data movement specification. - View Dependent Claims (27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44)
-
-
45. A storage medium readable by a computer encoding a computer program for execution by the computer to carry out a method for integrating data between a source data and a target application processing target data, the computer program comprising:
-
code means for defining a data integration specification, the data integration specification including a lineage information linking a source dimensional member of the source data and a target dimensional member of the target data; code means for generating a data movement specification using the data integration specification, the data movement specification including the lineage information, a source reference to a source data model, a target reference to a target data model and a query specification for extracting source data for the target application; and code means for providing the source data to the target application using the data movement specification. - View Dependent Claims (46)
-
Specification