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

Vorschaubild nicht verfügbar
Autor:in (Körperschaft)
Publikationsdatum
2023
Typ der Arbeit
Studiengang
Typ
04B - Beitrag Konferenzschrift
Herausgeber:innen
Herausgeber:in (Körperschaft)
Betreuer:in
Übergeordnetes Werk
2023 IEEE/ACM International Conference on Software and System Processes. ICSSP. Melbourne, Australia, 14-15 May 2023. Proceedings
Themenheft
Link
Reihe / Serie
Reihennummer
Jahrgang / Band
Ausgabe / Nummer
Seiten / Dauer
46-57
Patentnummer
Verlag / Herausgebende Institution
Verlagsort / Veranstaltungsort
Melbourne
Auflage
Version
Programmiersprache
Abtretungsempfänger:in
Praxispartner:in/Auftraggeber:in
Zusammenfassung
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.
Schlagwörter
Fachgebiet (DDC)
330 - Wirtschaft
Projekt
Veranstaltung
2023 IEEE/ACM International Conference on Software and System Processes (ICSSP)
Startdatum der Ausstellung
Enddatum der Ausstellung
Startdatum der Konferenz
14.05.2023
Enddatum der Konferenz
15.05.2023
Datum der letzten Prüfung
ISBN
979-8-3503-1196-9
ISSN
Sprache
Englisch
Während FHNW Zugehörigkeit erstellt
Ja
Zukunftsfelder FHNW
Publikationsstatus
Veröffentlicht
Begutachtung
Peer-Review der ganzen Publikation
Open Access-Status
Closed
Lizenz
Zitation
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