Schema Evolution and Foreign Keys: Birth, Eviction, Change and Absence

2017 ◽  
pp. 106-119 ◽  
Author(s):  
Panos Vassiliadis ◽  
Michail-Romanos Kolozoff ◽  
Maria Zerva ◽  
Apostolos V. Zarras
Keyword(s):  
Schema Evolution

BullFrog: Online Schema Evolution via Lazy Evaluation

2021 ◽  
Author(s):  
Souvik Bhattacherjee ◽  
Gang Liao ◽  
Michael Hicks ◽  
Daniel J. Abadi
Keyword(s):  
Schema Evolution ◽  
Lazy Evaluation

Database schema evolution using EVER diagrams

1994 ◽  
Author(s):  
Chien-Tsai Liu ◽  
Shi-Kuo Chang ◽  
Panos K. Chrysanthis
Keyword(s):  
Database Schema ◽  
Schema Evolution

Schema Evolution in Multiversion Data Warehouses

2021 ◽  
Vol 17 (4) ◽  
pp. 1-28
Author(s):  
Waqas Ahmed ◽  
Esteban Zimányi ◽  
Alejandro A. Vaisman ◽  
Robert Wrembel
Keyword(s):  
Efficient Solution ◽  
Business Processes ◽  
Online Analytical Processing ◽  
User Requirements ◽  
Schema Evolution ◽  
Data Warehouses ◽  
Relational Schema ◽  
External Sources ◽  
Analytical Processing

Data warehouses (DWs) evolve in both their content and schema due to changes of user requirements, business processes, or external sources to name a few. Although multiple approaches using temporal and/or multiversion DWs have been proposed to handle these changes, an efficient solution for this problem is still lacking. The authors' approach is to separate concerns and use temporal DWs to deal with content changes, and multiversion DWs to deal with schema changes. To address the former, previously, they have proposed a temporal multidimensional (MD) model. In this paper, they propose a multiversion MD model for schema evolution to tackle the latter problem. The two models complement each other and allow managing both content and schema evolution. In this paper, the semantics of schema modification operators (SMOs) to derive various schema versions are given. It is also shown how online analytical processing (OLAP) operations like roll-up work on the model. Finally, the mapping from the multiversion MD model to a relational schema is given along with OLAP operations in standard SQL.

Schema Evolution

2018 ◽  
pp. 3287-3289
Author(s):  
John F. Roddick
Keyword(s):  
Schema Evolution
Sign in / Sign up

Export Citation Format

Share Document