Measuring the benefits of CI/CD practices for database application development

No Thumbnail Available
Author (Corporation)
Publication date
2023
Typ of student thesis
Course of study
Type
04B - Conference paper
Editors
Editor (Corporation)
Supervisor
Parent work
2023 IEEE/ACM International Conference on Software and System Processes. ICSSP. Melbourne, Australia, 14-15 May 2023. Proceedings
Special issue
DOI of the original publication
Link
Series
Series number
Volume
Issue / Number
Pages / Duration
46-57
Patent number
Publisher / Publishing institution
Place of publication / Event location
Melbourne
Edition
Version
Programming language
Assignee
Practice partner / Client
Abstract
Modern software development practices automate software integration and reduce repetitive software engineering work. Automation reduces the time it takes from defining software requirements to deploying the software in production. However, when it comes to database applications, the database integration and deployment are often executed manually, making it costly and error-prone. To mitigate this, we extended current software development methodologies by designing a CI/CD pipeline that takes into consideration the database setting. We report on two industrial case studies in which we implemented a newly designed pipeline and we measure the benefits of integration and deployment automation in database development projects. From a quantitative perspective, we found that introducing CI/CD pipelines reduces failed deployments, improves stability and increases the number of executed deployments. From a qualitative perspective, we interviewed the developers before and after the implementation of the CI/CD pipeline and the results show the CI/CD pipeline brings clear benefits to the development team (i.e., reduced cognitive load). This finding puts current database release practices driven by business expectations such as fixed release windows in question.
Keywords
Subject (DDC)
330 - Wirtschaft
Project
Event
2023 IEEE/ACM International Conference on Software and System Processes (ICSSP)
Exhibition start date
Exhibition end date
Conference start date
14.05.2023
Conference end date
15.05.2023
Date of the last check
ISBN
979-8-3503-1196-9
ISSN
Language
English
Created during FHNW affiliation
Yes
Strategic action fields FHNW
Publication status
Published
Review
Peer review of the complete publication
Open access category
Closed
License
Citation
FLURI, Jasmin, Fabrizio FORNARI und Elzbieta PUSTULKA, 2023. Measuring the benefits of CI/CD practices for database application development. In: 2023 IEEE/ACM International Conference on Software and System Processes. ICSSP. Melbourne, Australia, 14-15 May 2023. Proceedings. Melbourne. 2023. S. 46–57. ISBN 979-8-3503-1196-9. Verfügbar unter: https://irf.fhnw.ch/handle/11654/43461