University of Twente Student Theses

Login

Zero-downtime PostgreSQL database schema migrations in a continuous deployment environment at ING

Richter, N.G. (2021) Zero-downtime PostgreSQL database schema migrations in a continuous deployment environment at ING.

[img] PDF
1MB
Abstract:Migrating a database schema to the next version without interrupting clients performing queries, aka downtime, is important for many reasons. A tool to perform such transformations is proposed which uses the database management system PostgreSQL, but findings are also applicable to other relational databases. The tool can be used as a step within a continuous deployment environment to provide automatic zero-downtime updates of applications when database schema changes are required. The highest scoring tool for schema migration without downtime was selected based on criteria found in the literature. This tool is QuantumDB and during this research, it was improved further and any bugs that were found were fixed. Through validation, it is shown that QuantumDB can perform schema migration without downtime. There are still key challenges that organizations need to take into account before full implementation. To help with adopting the solution a management chapter was made that describes a business case and some use cases in which QuantumDB can be used. At last, the discussion chapter lists future work which future researchers can still perform to improve QuantumDB and give more concrete benefits for organizations to start adopting a zero-downtime schema migration solution.
Item Type:Essay (Master)
Clients:
ING Bank, Amsterdam, Nederland
Faculty:EEMCS: Electrical Engineering, Mathematics and Computer Science
Subject:54 computer science
Programme:Business Information Technology MSc (60025)
Link to this item:https://purl.utwente.nl/essays/88687
Export this item as:BibTeX
EndNote
HTML Citation
Reference Manager

 

Repository Staff Only: item control page