Synchronization of Queries and Views Upon Schema Evolutions
Synchronization of Queries and Views Upon Schema Evolutions
复制标题
架构演变时的查询和视图的同步
DOI：
10.1145/2903726
复制
发表时间：
2016
期刊：
影响因子：
--
通讯作者：
G. Tortora
中科院分区：
文献类型：
--
作者：
Loredana Caruccio;G. Polese;G. Tortora
数据库模式演变产生的问题之一是，在以前的模式版本上定义的某些查询和视图可能不再正常工作。因此，发展数据库模式需要重新定义查询和视图，以使它们适应新的模式。虽然这个问题主要是在传统信息系统的背景下提出的，但在其他与数据库相关的领域也提出了解决方案，如数据集成、Web数据集成和数据仓库。这是一个严重的问题，因为工业组织经常需要调整他们的数据库和数据仓库，以适应现实世界中频繁的变化。在本文中，我们对现有的方法和工具进行了综述，以适应数据库模式演化中的查询和视图的问题；我们还提出了一个分类框架，以实现在许多不同的方法和工具之间的统一比较方法。
One of the problems arising upon the evolution of a database schema is that some queries and views defined on the previous schema version might no longer work properly. Thus, evolving a database schema entails the redefinition of queries and views to adapt them to the new schema. Although this problem has been mainly raised in the context of traditional information systems, solutions to it are also advocated in other database-related areas, such as Data Integration, Web Data Integration, and Data Warehouses. The problem is a critical one, since industrial organizations often need to adapt their databases and data warehouses to frequent changes in the real world. In this article, we provide a survey of existing approaches and tools to the problem of adapting queries and views upon a database schema evolution; we also propose a classification framework to enable a uniform comparison method among many heterogeneous approaches and tools.