A logic framework to support database refactoring

  • Authors:
  • Shi-Kuo Chang;Vincenzo Deufemia;Giuseppe Polese;Mario Vacca

  • Affiliations:
  • University of Pittsburgh, Department of Computer Science, Pittsburgh, PA;Università di Salerno, Dipartimento di Matematica e Informatica, Fisciano, Italy;Università di Salerno, Dipartimento di Matematica e Informatica, Fisciano, Italy;Università di Salerno, Dipartimento di Matematica e Informatica, Fisciano, Italy

  • Venue:
  • DEXA'07 Proceedings of the 18th international conference on Database and Expert Systems Applications
  • Year:
  • 2007

Quantified Score

Hi-index 0.00

Visualization

Abstract

We propose a formal framework for database refactoring, analyzing both the changes to the database schema, and their impact on queries. The framework defines a logic model of changes, and views the database refactoring process as an agent based one. The agent tries to discover and resolve inconsistencies, and it is modeled as a problem solver capable to perform changes triggered upon the detection of database schema anomalies. The framework can be considered a first step towards the automation of the database refactoring process.