• Home
  • Search
  • Detecting and Preventing Program Inconsistencies under Database Schema Evolution
  • Cite Icon31
  • https://doi.org/10.1109/qrs.2016.38Copy DOI Icon

Detecting and Preventing Program Inconsistencies under Database Schema Evolution

  • Aug 1, 2016
  • Loup Meurice +2 more
Show More
  • Abstract
  • Literature Map
  • References
  • Citations
  • Similar Papers
Abstract

Nowadays, data-intensive applications tend to access their underlying database in an increasingly dynamic way. The queries that they send to the database server are usually built at runtime, through String concatenation, or Object-Relational-Mapping (ORM) frameworks. This level of dynamicity significantly complicates the task of adapting application programs to database schema changes. Failing to correctly adapt programs to an evolving database schema results in program inconsistencies, which in turn may cause program failures. In this paper, we present a tool-supported approach, that allows developers to (1) analyze how the source code and database schema co-evolved in the past and (2) simulate a database schema change and automatically determine the set of source code locations that would be impacted by this change. Developers are then provided with recommendations about what they should modify at those source code locations in order to avoid inconsistencies. The approach has been designed to deal with Java systems that use dynamic data access frameworks such as JDBC, Hibernate and JPA. We motivate and evaluate the proposed approach, based on three real-life systems of different size and nature.

Similar Papers
  • Research Article
  • Citations1

Data perspectives of workflow schema evolution

  • Jan 30, 2015
  • Business Process Management Journal
  • Aravindhan Arunagiri +1
  • Conference Article
  • Citations65

Clustering Support for Static Concept Location in Source Code

  • Jun 01, 2011
  • Giuseppe Scanniello +1
  • Conference Article
  • Citations13

Compare and contrast: Visual exploration of source code examples

  • Sep 01, 2009
  • Rylan Cottrell +4
  • Conference Article
  • Citations14

Zero-Downtime SQL Database Schema Evolution for Continuous Deployment

  • May 01, 2017
  • Michael De Jong +2
  • Research Article

Security issues in heterogeneous data federations

  • Jan 01, 2011
  • University of Alberta Library
  • Denilson Barbosa +1
  • Research Article

Strategic Paradigms for Achieving Zero Service Interruption During Application Deployment

  • Jan 02, 2026
  • International Journal of Science and Research (IJSR)
  • Sanghamitra Nayak
  • Book Chapter
  • Citations3

Towards a Dynamic Inconsistency-Tolerant Schema Maintenance

  • Jan 01, 2008
  • Hendrik Decker
  • Conference Article
  • Citations36

Java bytecode clone detection via relaxation on code fingerprint and Semantic Web reasoning

  • Jun 01, 2012
  • Iman Keivanloo +2
  • Conference Article
  • Citations26

A Static Code Smell Detector for SQL Queries Embedded in Java Code

  • Sep 01, 2017
  • Csaba Nagy +1
  • Book Chapter
  • Citations10

Semantic-Based Mappings

  • Jan 01, 2013
  • Giansalvatore Mecca +3
  • Conference Article
  • Citations175

Automatic query reformulations for text retrieval in software engineering

  • May 18, 2013
  • Sonia Haiduc +5
  • Research Article
  • Citations11

DAIS: dynamic access and integration services framework for cloud-oriented storage systems

  • Mar 17, 2020
  • Cluster Computing
  • Ajay Kumar +1
  • Book Chapter
  • Citations6

Domain Modeling Based on Requirements Specification and Ontology

  • Aug 27, 2016
  • Iwona Dubielewicz +3
  • Book Chapter
  • Citations11

Biological Network Inference and Analysis Using SEBINI and CABIN

  • Jan 01, 2009
  • Ronald Taylor +1
  • Research Article
  • Citations107

Design and Prototype of a Performance Tool Interface for OpenMP

  • Aug 01, 2002
  • The Journal of Supercomputing
  • Bernd Mohr +3
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.