???item.export.label??? ???item.export.type.endnote??? ???item.export.type.bibtex???

Please use this identifier to cite or link to this item: https://tede.ufam.edu.br/handle/tede/7795
Full metadata record
DC FieldValueLanguage
dc.creatorAfonso, Ariel Antony-
dc.creator.Latteshttp://lattes.cnpq.br/9917281215896280por
dc.contributor.advisor1Silva, Altigran Soares da-
dc.contributor.advisor1Latteshttp://lattes.cnpq.br/3405503472010994por
dc.contributor.referee1Conte, Tayana Uchôa-
dc.contributor.referee1Latteshttp://lattes.cnpq.br/6682919653508224por
dc.contributor.referee2Garcia, Alessandro Fabricio-
dc.contributor.referee2Latteshttp://lattes.cnpq.br/0807511237795775por
dc.contributor.referee3Cavalcanti, João Marcos Bastos-
dc.contributor.referee3Latteshttp://lattes.cnpq.br/3537707069694606por
dc.date.issued2020-04-24-
dc.identifier.citationAFONSO, Ariel Antony. LESSQL: an approach to deal with Database Schema Changes in Continuous Deployment. 2020. 72 f. Dissertação (Mestrado em Informática) - Universidade Federal do Amazonas, Manaus, 2020.por
dc.identifier.urihttps://tede.ufam.edu.br/handle/tede/7795-
dc.description.resumoThe adoption of Continuous Deployment (CD) aims at allowing software systems to quickly evolve to accommodate new features. However, structural changes to the database schema are frequent and may incur in systems' services downtime. This encompasses the proper maintenance of both schema and source code, including rewrites of all outdated queries that use the same database. Previous solutions try to mitigate the burdening task of manually rewriting outdated queries. Unfortunately, a software team must still interact with some tools to properly fix the affected queries. Moreover the team still has to locate and modify all the impacted code, which are often error-prone tasks. Thus, a project may not experience CD benefits when changes impact various code regions. In this thesis, we present an alternative approach, called LESSQL, whose goal is to improve queries' stability in the presence of structural schema changes over time. LESSQL supports queries that are less dependent on the database schema since they do not include the FROM clause. An underlying framework intercepts each LESSQL query and generates a corresponding SQL query for the current schema. It also locates the query attributes in the current schema and generate proper expressions to join required tables. LESSQL supports unsupervised, supervised and hybrid configurations to process mappings of attributes to a newer schema version. We conducted experiments in two open-source applications: Wikipedia, an online and popular information system, and WebERP, a web-based accounting and business management system. Experiments outcomes indicate that our approach is effective in significantly reducing the modifications required for applying schema changes, allowing to better reap the benefits of CD. While supervised and hybrid configurations achieved a success rate higher than 95% with a minor query generation overhead, the unsupervised configuration was also successful for certain types of structural schema changes. These results show that LESSQL effectively favors CD and keeps queries running after database schema changes without services interruption.por
dc.description.abstractThe adoption of Continuous Deployment (CD) aims at allowing software systems to quickly evolve to accommodate new features. However, structural changes to the database schema are frequent and may incur in systems' services downtime. This encompasses the proper maintenance of both schema and source code, including rewrites of all outdated queries that use the same database. Previous solutions try to mitigate the burdening task of manually rewriting outdated queries. Unfortunately, a software team must still interact with some tools to properly fix the affected queries. Moreover the team still has to locate and modify all the impacted code, which are often error-prone tasks. Thus, a project may not experience CD benefits when changes impact various code regions. In this thesis, we present an alternative approach, called LESSQL, whose goal is to improve queries' stability in the presence of structural schema changes over time. LESSQL supports queries that are less dependent on the database schema since they do not include the FROM clause. An underlying framework intercepts each LESSQL query and generates a corresponding SQL query for the current schema. It also locates the query attributes in the current schema and generate proper expressions to join required tables. LESSQL supports unsupervised, supervised and hybrid configurations to process mappings of attributes to a newer schema version. We conducted experiments in two open-source applications: Wikipedia, an online and popular information system, and WebERP, a web-based accounting and business management system. Experiments outcomes indicate that our approach is effective in significantly reducing the modifications required for applying schema changes, allowing to better reap the benefits of CD. While supervised and hybrid configurations achieved a success rate higher than 95% with a minor query generation overhead, the unsupervised configuration was also successful for certain types of structural schema changes. These results show that LESSQL effectively favors CD and keeps queries running after database schema changes without services interruption.eng
dc.formatapplication/pdf*
dc.thumbnail.urlhttps://tede.ufam.edu.br//retrieve/38803/Disserta%c3%a7%c3%a3o_ArielAntony_PPGI.pdf.jpg*
dc.languageengpor
dc.publisherUniversidade Federal do Amazonaspor
dc.publisher.departmentInstituto de Computaçãopor
dc.publisher.countryBrasilpor
dc.publisher.initialsUFAMpor
dc.publisher.programPrograma de Pós-graduação em Informáticapor
dc.rightsAcesso Abertopor
dc.rights.urihttp://creativecommons.org/licenses/by/4.0/-
dc.subjectSchema changeseng
dc.subjectContinuous deploymenteng
dc.subjectDatabase decayeng
dc.subjectQuery languageeng
dc.subjectBanco de dados - Gerênciapor
dc.subject.cnpqCIÊNCIAS EXATAS E DA TERRA: CIÊNCIA DA COMPUTAÇÃOpor
dc.titleLESSQL: an approach to deal with Database Schema Changes in Continuous Deploymentpor
dc.title.alternativeLESSQL: uma abordagem para lidar com alterações de esquema de banco de dados na implantação contínuapor
dc.typeDissertaçãopor
dc.subject.userSchema changeseng
dc.subject.userContinuous deploymenteng
dc.subject.userDatabase decayeng
dc.subject.userQuery languageeng
Appears in Collections:Mestrado em Informática

Files in This Item:
File Description SizeFormat 
Dissertação_ArielAntony_PPGI.pdfDissertação_ArielAntony_PPGI2,51 MBAdobe PDFThumbnail

Download/Open Preview


This item is licensed under a Creative Commons License Creative Commons