Federated database systems for managing distributed, heterogeneous, and autonomous databases
ACM Computing Surveys (CSUR) - Special issue on heterogeneous databases
Semantic integration of semistructured and structured data sources
ACM SIGMOD Record
Determining Semantic Similarity among Entity Classes from Different Ontologies
IEEE Transactions on Knowledge and Data Engineering
Generic Schema Matching with Cupid
Proceedings of the 27th International Conference on Very Large Data Bases
A survey of approaches to automatic schema matching
The VLDB Journal — The International Journal on Very Large Data Bases
Similarity Flooding: A Versatile Graph Matching Algorithm and Its Application to Schema Matching
ICDE '02 Proceedings of the 18th International Conference on Data Engineering
iMAP: discovering complex semantic matches between database schemas
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Measuring semantic similarity in the taxonomy of WordNet
ACSC '05 Proceedings of the Twenty-eighth Australasian conference on Computer Science - Volume 38
Integrating heterogeneous multidimensional databases
SSDBM'2005 Proceedings of the 17th international conference on Scientific and statistical database management
The Security Issue of Federated Data Warehouses in the Area of Evidence-Based Medicine
ARES '06 Proceedings of the First International Conference on Availability, Reliability and Security
Analysing multi-dimensional data across autonomous data warehouses
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Integrating different grain levels in a medical data warehouse federation
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Element similarity measures in XML schema matching
Information Sciences: an International Journal
Inferring aggregation hierarchies for integration of data marts
DEXA'10 Proceedings of the 21st international conference on Database and expert systems applications: Part II
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
Semantic similarity measurement using historical google search patterns
Information Systems Frontiers
Hi-index | 0.00 |
A federated data warehouse is a logical integration of data warehouses applicable when physical integration is impossible due to privacy policy or legal restrictions. In order to enable the translation of queries in a federated approach, schemas of the federated and the local warehouses must be matched. In this paper we present a procedure that enables the matching process for schema structures specific to the multidimensional model of data warehouses: facts, measures, dimensions, aggregation levels and dimensional attributes. Similarities between warehouse-specific structures are computed by using linguistic and structural comparison, where calculated values are used to create necessary mappings. We present restriction rules and recommendations for aggregation level matching, which builds the most complex part of the process. A software implementation of the entire process is provided in order to perform its verification, as well as to determine the proper selection metric for mapping different multidimensional structures.