A comparative analysis of methodologies for database schema integration
ACM Computing Surveys (CSUR)
The derivation problem of summary data
SIGMOD '88 Proceedings of the 1988 ACM SIGMOD international conference on Management of data
Managing semantic heterogeneity in databases: a theoretical prospective
PODS '97 Proceedings of the sixteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
Management of heterogeneous and autonomous database systems
Management of heterogeneous and autonomous database systems
Efficient optimization of a class of relational expressions
ACM Transactions on Database Systems (TODS)
Testing implications of data dependencies
ACM Transactions on Database Systems (TODS)
Testing satisfaction of functional dependencies
Journal of the ACM (JACM)
Extending OLAP querying to external object databases
Proceedings of the ninth international conference on Information and knowledge management
The Clio project: managing heterogeneity
ACM SIGMOD Record
Data integration: a theoretical perspective
Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Database Systems Concepts
Foundations of Databases: The Logical Level
Foundations of Databases: The Logical Level
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
Handling summary information in a database: derivability
SIGMOD '81 Proceedings of the 1981 ACM SIGMOD international conference on Management of data
On relationships offering new drill-across possibilities
Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
Specifying OLAP Cubes on XML Data
Journal of Intelligent Information Systems
A Logical Approach to Multidimensional Databases
EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
The Classification Problem with Semantically Heterogeneous Data
Proceedings of the 4th International Working Conference SSDBM on Statistical and Scientific Database Management
From a Procedural to a Visual Query Language for OLAP
SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management
SSDBM '02 Proceedings of the 14th International Conference on Scientific and Statistical Database Management
A survey of approaches to automatic schema matching
The VLDB Journal — The International Journal on Very Large Data Bases
On the Integration of Autonomous Data Marts
SSDBM '04 Proceedings of the 16th International Conference on Scientific and Statistical Database Management
Evaluating XML-extended OLAP queries based on a physical algebra
Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
A framework for modeling and evaluating automatic semantic reconciliation
The VLDB Journal — The International Journal on Very Large Data Bases
Integrating heterogeneous multidimensional databases
SSDBM'2005 Proceedings of the 17th international conference on Scientific and statistical database management
DaWaII: a Tool for the Integration of Autonomous Data Marts
ICDE '06 Proceedings of the 22nd International Conference on Data Engineering
Design and development of a tool for integrating heterogeneous data warehouses
DaWaK'05 Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery
Hetero-homogeneous hierarchies in data warehouses
APCCM '10 Proceedings of the Seventh Asia-Pacific Conference on Conceptual Modelling - Volume 110
Towards OLAP query reformulation in peer-to-peer data warehousing
DOLAP '10 Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
New Frontiers in business intelligence: distribution and personalization
ADBIS'10 Proceedings of the 14th east European conference on Advances in databases and information systems
Inferring aggregation hierarchies for integration of data marts
DEXA'10 Proceedings of the 21st international conference on Database and expert systems applications: Part II
Journal of Computer and System Sciences
DEXA'11 Proceedings of the 22nd international conference on Database and expert systems applications - Volume Part II
Enforcing strictness in integration of dimensions: beyond instance matching
Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP
Incremental integration of data warehouses: the hetero-homogeneous approach
Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP
OLAP query reformulation in peer-to-peer data warehousing
Information Systems
ORE: an iterative approach to the design and evolution of multi-dimensional schemas
Proceedings of the fifteenth international workshop on Data warehousing and OLAP
FedDW global schema architect: UML-based design tool for the integration of data mart schemas
Proceedings of the fifteenth international workshop on Data warehousing and OLAP
Partial multi-dimensional schema merging in heterogeneous data warehouses
ER'12 Proceedings of the 31st international conference on Conceptual Modeling
| Hi-index | 0.00 |
In this paper we address the problem of integrating independent and possibly heterogeneous data warehouses, a problem that has received little attention so far, but that arises very often in practice.We start by tackling the basic issue of matching heterogeneous dimensions and provide a number of general properties that a dimension matching should fulfill. We then propose two different approaches to the problem of integration that try to enforce matchings satisfying these properties. The first approach refers to a scenario of loosely coupled integration, in which we just need to identify the common information between data sources and perform join operations over the original sources. The goal of the second approach is the derivation of a materialized view built by merging the sources, and refers to a scenario of tightly coupled integration in which queries are performed against the view.We also illustrate architecture and functionality of a practical system that we have developed to demonstrate the effectiveness of our integration strategies.