Patent
System and method for federated member-based data integration and reporting
Guillaume Senneville,Liam Peyton +1 more
- 29 Oct 2007
41
TL;DR: In this article, a declarative data integration specification including a lineage information linking a source dimensional member of the source data and a target dimension of the target data is defined, and a data movement specification using the lineage information, a source reference to a source data model, a target reference to target data model and a query specification for extracting source data for the target application is generated.
read more
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.
read more
Chat with Paper
AI Agents for this Paper
Find similar papers on Google Scholar, PubMed and Arxiv
Write a critical review of this paper
Analyze citations of this paper to find unaddressed research gaps
Citations
Patent
Mapping entities in data models
Craig W. Stanfill
- 24 Jul 2013
TL;DR: In this article, the mapping information is processed to generate a procedural specification (120) for computing values corresponding to attributes of destination entities, and collections of nodes (600) are generated, each including a first node representing a first relational expression associated with a specified attribute.
51
Patent
Resource Optimization for Parallel Data Integration
Simon Harris,Xiaoyan Pu +1 more
- 04 Sep 2009
TL;DR: In this paper, a job request is received, which specifies a parallel data integration job to deploy in a grid, and a job optimizer module automatically selects a grid resource configuration responsive to the predicted grid resource utilizations and an optimization criterion.
51
Patent
Method for assembly of personalized enterprise information integrators over conjunctive queries
Ullas Nambiar,Biplav Srivastava +1 more
- 28 Nov 2007
TL;DR: In this paper, a plurality of schemas are constructed, based on the plurality of sources, and a desired output is obtained as a conjunctive query, where a list of potential connections between at least selected ones of the sources is provided.
50
Patent
External system integration into automated attribute discovery
Rajendra Bhagwatisingh Panwar,Abe Achkinazi +1 more
- 14 Jan 2008
TL;DR: In this paper, the transformation rules are written which are designed to make all conversions necessary in semantics, units of measure, etc. to transform the source system attribute data into attribute data for the target system which has the proper data format.
44
Patent
Visualizing relationships between data elements and graphical representations of data element attributes
Erik Bator,Joel Gould,Dusan Radivojevic +2 more
- 02 Dec 2009
TL;DR: In this paper, a visual representation is generated of a diagram including nodes representing respective metadata objects and relationships among the nodes, which includes superimposing a representation of a characteristic identified by the summary data characterizing a given metadata object in proximity to the node representing the given metadata objects.
36
References
An overview of data warehousing and OLAP technology
Surajit Chaudhuri,Umeshwar Dayal +1 more
- 01 Mar 1997
TL;DR: An overview of data warehousing and OLAP technologies, with an emphasis on their new requirements, is provided, based on a tutorial presented at the VLDB Conference, 1996.
Patent
Query engine and method for Querying data using metadata model
Henk Cazemier,Glenn D. Rasmussen +1 more
- 01 Sep 2000
TL;DR: In this paper, a query engine uses a metadata model containing model objects that represent the data sources, which allows use of different type of client applications to obtain reports from one or more data sources.
392
Patent
Computer systems and methods for the query and visualization of multidimensional databases
Chris Stolte,Diane L. Tang,Pat Hanrahan +2 more
- 02 Jun 2004
TL;DR: In this article, a visual table, comprising a plurality of panes, is constructed by providing a specification that is in a language based on the hierarchical structure of the database, in some cases, this language can include fields that are in the database schema.
293
Patent
Method and apparatus for automatically populating a data warehouse system
Kenneth R. Rosensteel,Jerry T. Guhr,Joseph K. Picone +2 more
- 27 Apr 1998
TL;DR: In this paper, a data replication component automatically creates the different subcomponents of the request by accessing various links stored by the repository tool and displays a visual representation of the sub-components and their relationships to each other to the administrator.
246
•Book
Data warehousing fundamentals : a comprehensive guide for IT professionals
Paulraj Ponniah
- 01 Jan 2001
TL;DR: This book discusses the design and management of data Warehousing, and the role of metadata in this process.
239