Hier finden Sie wissenschaftliche Publikationen aus den Fraunhofer-Instituten.

A Generic Approach to Schema Evolution in Live Relational Databases

: Bhróithe, A.O.'F. de; Heiden, F.; Schemmert, A.; Phan, D.; Hung, L.; Freiheit, J.; Fuchs-Kittowski, F.


Borzemski, L.:
Information Systems Architecture and Technology. 40th Anniversary International Conference on Information Systems Architecture and Technology, ISAT 2019. Proceedings. Pt.I
Cham: Springer, 2020 (Advances in Intelligent Systems and Computing 1050)
ISBN: 978-3-030-30440-9
ISBN: 978-3-030-30439-3
International Conference on Information Systems Architecture and Technology (ISAT) <40, 2019, Wroclaw>
Fraunhofer FOKUS ()

Schema evolution is an important theme for many database users across a broad range of fields. This paper introduces a generic data management layer, GeneRelDB, which allows the schema of a relational database to evolve during run time without the need to rewrite database queries in the application code. It is designed to run as an abstraction layer, handling all communication (queries and data exchange) between the user interface and the database backend. The only restriction to the changes that can be made relate to data type conversion for existing columns in the database. Foreign key constraints are supported and referential integrity is maintained during evolution.