Adapting Queries to Database Schema Changes in Hybrid Polystores

Research output: Contribution in Book/Catalog/Report/Conference proceedingConference contribution

5 Downloads (Pure)

Abstract

Database schema change has long been recognized as a complex, time-consuming and risky process. It requires not only the modification of database structures and contents, but also the joint evolution of related application programs. This coevolution process mainly consists in converting database queries expressed on the source database schema, into equivalent queries expressed on the target database schema. Several approaches, techniques and tools have been proposed to address this problem, by considering software systems relying on a single database. In this paper, we propose an automated approach to query adaptation for schema changes in hybrid polystores, i.e., data-intensive systems relying on several, possibly heterogeneous, databases. The proposed approach takes advantage of a conceptual modeling language for representing the polystore schema, and considers a generic query language for expressing queries on top of
this schema. Given a source polystore schema, a set of input queries and a list of schema change operators, our approach (1) identifies those input queries that cannot be transformed into equivalent queries expressed on the target schema, (2) automatically transforms those input queries that can be adapted to the target schema, and (3) generates warnings for those output queries requiring further manual inspection. Index Terms—database schema evolution, query adaptation, hybrid polystores
Original languageEnglish
Title of host publicationProceedings of the 20th IEEE International Working Conference on Source Code Analysis and Manipulation (SCAM 2020)
PublisherIEEE Computer Society Press
Number of pages5
Publication statusPublished - 2020

Fingerprint Dive into the research topics of 'Adapting Queries to Database Schema Changes in Hybrid Polystores'. Together they form a unique fingerprint.

  • Cite this

    Fink, J., Gobert, M., & Cleve, A. (2020). Adapting Queries to Database Schema Changes in Hybrid Polystores. In Proceedings of the 20th IEEE International Working Conference on Source Code Analysis and Manipulation (SCAM 2020) IEEE Computer Society Press.