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

dc.contributor.authorFluri, Jasmin
dc.contributor.authorFornari, Fabrizio
dc.contributor.authorPustulka, Elzbieta
dc.date.accessioned2024-04-22T13:37:57Z
dc.date.available2024-04-22T13:37:57Z
dc.date.issued2023
dc.description.abstractModern 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.
dc.event2023 IEEE/ACM International Conference on Software and System Processes (ICSSP)
dc.event.end2023-05-15
dc.event.start2023-05-14
dc.identifier.doi10.1109/ICSSP59042.2023.00015
dc.identifier.isbn979-8-3503-1196-9
dc.identifier.urihttps://irf.fhnw.ch/handle/11654/43461
dc.language.isoen
dc.relation.ispartof2023 IEEE/ACM International Conference on Software and System Processes. ICSSP. Melbourne, Australia, 14-15 May 2023. Proceedings
dc.spatialMelbourne
dc.subject.ddc330 - Wirtschaft
dc.titleMeasuring the benefits of CI/CD practices for database application development
dc.type04B - Beitrag Konferenzschrift
dspace.entity.typePublication
fhnw.InventedHereYes
fhnw.ReviewTypeAnonymous ex ante peer review of a complete publication
fhnw.affiliation.hochschuleHochschule für Wirtschaftde_CH
fhnw.affiliation.institutInstitut für Wirtschaftsinformatikde_CH
fhnw.openAccessCategoryClosed
fhnw.pagination46-57
fhnw.publicationStatePublished
relation.isAuthorOfPublication4721ad98-6fd2-4aed-93b9-748e842cc266
relation.isAuthorOfPublication2c6211f2-904f-4c1c-b3f1-f84c8cb08def
relation.isAuthorOfPublication3e7f2a0a-692e-4652-b305-7a7e19e011de
relation.isAuthorOfPublication.latestForDiscovery4721ad98-6fd2-4aed-93b9-748e842cc266
Dateien
Lizenzbündel
Gerade angezeigt 1 - 1 von 1
Lade...
Vorschaubild
Name:
license.txt
Größe:
1.36 KB
Format:
Item-specific license agreed upon to submission
Beschreibung: