The University of Southampton
University of Southampton Institutional Repository

Towards scalable data integration under constraints

Towards scalable data integration under constraints
Towards scalable data integration under constraints
In this paper we consider the problem of answering queries using views, with or without ontological constraints, which is important for data integration, query optimization, and data warehouses. Our context is data integration, so we search for maximally-contained rewritings. We have produced a very scalable and efficient solution for its simplest form, conjunctive queries and views, and we are working towards the full relational case. When considering constraints, the problem is usually divided in two phases: (1) query expansion, which rewrites queries w. r. t. the intentional knowledge and (2) expanded query reformulation using the views. Relevant algorithms have given little attention to the second phase and have studied a limited form of view definition languages overall (namely, only GAV). By looking at the problem from a graph perspective we are able to gain a better insight and develop designs which compactly represent common patterns in the source descriptions, and (optionally) push some computation offline. This allows us to contribute significantly in both aforemention phases individually, tailor one to each other, and moreover address them in a unified way. We intend to provide a solution that supports a variety of ontology languages, and all prevalent view definition languages (G/LAV). Towards such a general and scalable system our preliminary results for the relational case, show an experimental performance about two orders of magnitude faster than current state-of-the-art algorithms, rewriting queries using over 10000 views within seconds.
251-256
Konstantinidis, George
f174fb99-8434-4485-a7e4-bee0fef39b42
Ambite, Jose Luis
0a7ecac4-d15d-47c9-ac49-c06d8525f9d7
Konstantinidis, George
f174fb99-8434-4485-a7e4-bee0fef39b42
Ambite, Jose Luis
0a7ecac4-d15d-47c9-ac49-c06d8525f9d7

Konstantinidis, George and Ambite, Jose Luis (2012) Towards scalable data integration under constraints. Proceedings of the 2012 Joint EDBT/ICDT Workshops, , Berlin, Germany. 26 - 30 Mar 2012. pp. 251-256 .

Record type: Conference or Workshop Item (Paper)

Abstract

In this paper we consider the problem of answering queries using views, with or without ontological constraints, which is important for data integration, query optimization, and data warehouses. Our context is data integration, so we search for maximally-contained rewritings. We have produced a very scalable and efficient solution for its simplest form, conjunctive queries and views, and we are working towards the full relational case. When considering constraints, the problem is usually divided in two phases: (1) query expansion, which rewrites queries w. r. t. the intentional knowledge and (2) expanded query reformulation using the views. Relevant algorithms have given little attention to the second phase and have studied a limited form of view definition languages overall (namely, only GAV). By looking at the problem from a graph perspective we are able to gain a better insight and develop designs which compactly represent common patterns in the source descriptions, and (optionally) push some computation offline. This allows us to contribute significantly in both aforemention phases individually, tailor one to each other, and moreover address them in a unified way. We intend to provide a solution that supports a variety of ontology languages, and all prevalent view definition languages (G/LAV). Towards such a general and scalable system our preliminary results for the relational case, show an experimental performance about two orders of magnitude faster than current state-of-the-art algorithms, rewriting queries using over 10000 views within seconds.

This record has no associated files available for download.

More information

Published date: 30 March 2012
Venue - Dates: Proceedings of the 2012 Joint EDBT/ICDT Workshops, , Berlin, Germany, 2012-03-26 - 2012-03-30

Identifiers

Local EPrints ID: 504281
URI: http://eprints.soton.ac.uk/id/eprint/504281
PURE UUID: 007998e2-1638-4a1b-aaca-db167b556d6a

Catalogue record

Date deposited: 02 Sep 2025 17:08
Last modified: 02 Sep 2025 17:08

Export record

Contributors

Author: George Konstantinidis
Author: Jose Luis Ambite

Download statistics

Downloads from ePrints over the past year. Other digital versions may also be available to download e.g. from the publisher's website.

View more statistics

Atom RSS 1.0 RSS 2.0

Contact ePrints Soton: eprints@soton.ac.uk

ePrints Soton supports OAI 2.0 with a base URL of http://eprints.soton.ac.uk/cgi/oai2

This repository has been built using EPrints software, developed at the University of Southampton, but available to everyone to use.

We use cookies to ensure that we give you the best experience on our website. If you continue without changing your settings, we will assume that you are happy to receive cookies on the University of Southampton website.

×