LESSQL: an approach to deal with Database Schema Changes in Continuous Deployment
The 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 c...
| Autor principal: | Afonso, Ariel Antony |
|---|---|
| Outros Autores: | http://lattes.cnpq.br/9917281215896280 |
| Grau: | Dissertação |
| Idioma: | eng |
| Publicado em: |
Universidade Federal do Amazonas
2020
|
| Assuntos: | |
| Acesso em linha: |
https://tede.ufam.edu.br/handle/tede/7795 |
| id |
oai:https:--tede.ufam.edu.br-handle-:tede-7795 |
|---|---|
| recordtype |
dspace |
| spelling |
oai:https:--tede.ufam.edu.br-handle-:tede-77952020-05-23T05:03:46Z LESSQL: an approach to deal with Database Schema Changes in Continuous Deployment LESSQL: uma abordagem para lidar com alterações de esquema de banco de dados na implantação contínua Afonso, Ariel Antony Silva, Altigran Soares da http://lattes.cnpq.br/9917281215896280 http://lattes.cnpq.br/3405503472010994 Conte, Tayana Uchôa http://lattes.cnpq.br/6682919653508224 Garcia, Alessandro Fabricio http://lattes.cnpq.br/0807511237795775 Cavalcanti, João Marcos Bastos http://lattes.cnpq.br/3537707069694606 Schema changes Continuous deployment Database decay Query language Banco de dados - Gerência CIÊNCIAS EXATAS E DA TERRA: CIÊNCIA DA COMPUTAÇÃO Schema changes Continuous deployment Database decay Query language The 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. The 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. 2020-05-22T19:21:31Z 2020-04-24 Dissertação AFONSO, 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. https://tede.ufam.edu.br/handle/tede/7795 eng Acesso Aberto http://creativecommons.org/licenses/by/4.0/ application/pdf Universidade Federal do Amazonas Instituto de Computação Brasil UFAM Programa de Pós-graduação em Informática |
| institution |
TEDE - Universidade Federal do Amazonas |
| collection |
TEDE-UFAM |
| language |
eng |
| topic |
Schema changes Continuous deployment Database decay Query language Banco de dados - Gerência CIÊNCIAS EXATAS E DA TERRA: CIÊNCIA DA COMPUTAÇÃO Schema changes Continuous deployment Database decay Query language |
| spellingShingle |
Schema changes Continuous deployment Database decay Query language Banco de dados - Gerência CIÊNCIAS EXATAS E DA TERRA: CIÊNCIA DA COMPUTAÇÃO Schema changes Continuous deployment Database decay Query language Afonso, Ariel Antony LESSQL: an approach to deal with Database Schema Changes in Continuous Deployment |
| topic_facet |
Schema changes Continuous deployment Database decay Query language Banco de dados - Gerência CIÊNCIAS EXATAS E DA TERRA: CIÊNCIA DA COMPUTAÇÃO Schema changes Continuous deployment Database decay Query language |
| description |
The 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. |
| author_additional |
Silva, Altigran Soares da |
| author_additionalStr |
Silva, Altigran Soares da |
| format |
Dissertação |
| author |
Afonso, Ariel Antony |
| author2 |
http://lattes.cnpq.br/9917281215896280 |
| author2Str |
http://lattes.cnpq.br/9917281215896280 |
| title |
LESSQL: an approach to deal with Database Schema Changes in Continuous Deployment |
| title_short |
LESSQL: an approach to deal with Database Schema Changes in Continuous Deployment |
| title_full |
LESSQL: an approach to deal with Database Schema Changes in Continuous Deployment |
| title_fullStr |
LESSQL: an approach to deal with Database Schema Changes in Continuous Deployment |
| title_full_unstemmed |
LESSQL: an approach to deal with Database Schema Changes in Continuous Deployment |
| title_sort |
lessql: an approach to deal with database schema changes in continuous deployment |
| publisher |
Universidade Federal do Amazonas |
| publishDate |
2020 |
| url |
https://tede.ufam.edu.br/handle/tede/7795 |
| _version_ |
1831969873100537856 |
| score |
11.753896 |