arrow
返回

Integrating domain heterogeneous data sources using decomposition aggregation queries

delete2014-01-01
delete6
PRE
AI
J
Jian Xu *
R
Rachel Pottinger
DOI:10.1016/j.is.2013.06.003delete
delete原文链接
delete原文求助
delete分享
delete收藏
摘要

摘要

En 中文
The decomposition aggregation query (DAQ) we introduce in this paper extends semantic integration queries by allowing query translation to create aggregate queries based on the DAQ's novel three role structure. We describe the application of DAQs in integrating domain heterogeneous data sources, the new semantics of DAQ answers and the query translation algorithm called aggregation rewriting. A central problem of optimizing DAQ processing requires determining the data sources towards which the DAQ is translated. Our source selection algorithm has cover-finding and partitioning steps which are optimized to 1. lower the processing overhead while speeding up query answering and 2. eliminate duplicates with minimal overhead. We establish connections between source selection optimizations and classic NP-hard optimizations and resolve the optimization problems with efficient solvers. We empirically study both the DAQ query translation and the source selection algorithms using real-world and synthetic data sets; the results show satisfying scalability both in size of aggregations and data sources for the query translation algorithms and the source selection algorithms save a good amount of computational resources. (C) 2013 Elsevier Ltd. All rights reserved.
Keyword:
Semantic integration
Aggregation
Query optimization

期刊

Enterprise Information Systems 封面图
Enterprise Information Systems
IF:
3.9
论文数:
2.8K
被引数:
1.8K

机构

U
University of British Columbia
学者数:
7.0W
论文数: 6.1W
被引数: 8.6W