Publication:
Effort estimation for architectural refactoring of data tier software

dc.contributor.authorErsoy, E.
dc.contributor.authorSözer, Hasan
dc.contributor.departmentComputer Science
dc.contributor.ozuauthorSÖZER, Hasan
dc.date.accessioned2023-08-15T10:31:45Z
dc.date.available2023-08-15T10:31:45Z
dc.date.issued2022
dc.description.abstractArchitectural refactoring requires substantial effort. We introduce an approach and a tool to predict this effort prior to refactoring. We focus on PL/SQL programs that are developed as data access tiers of business software. There are two types of common refactoring needs for these programs. First, some of the modules might need to be migrated to a separate database. Second, some of the modules in the data tier might need to be migrated to the application tier. In both cases, the refactoring effort is proportional to the amount of coupling between the migrated modules and the rest of the modules in the database. Our tool can parse PL/SQL programs to reveal this coupling based on an analysis of SQL queries. Unlike prior studies, our tool can analyze queries that are created dynamically and that use multiple tables as well as PL/SQL-specific features. We evaluate our approach with an industrial PL/SQL program from the telecommunications domain. Our results are approved to be accurate by domain experts.en_US
dc.description.sponsorshipTÜBİTAK
dc.identifier.doi10.1109/ICSA53651.2022.00016en_US
dc.identifier.endpage89en_US
dc.identifier.isbn978-166541728-0
dc.identifier.scopus2-s2.0-85132015210
dc.identifier.startpage80en_US
dc.identifier.urihttp://hdl.handle.net/10679/8679
dc.identifier.urihttps://doi.org/10.1109/ICSA53651.2022.00016
dc.identifier.wos000838691200008
dc.language.isoengen_US
dc.publicationstatusPublisheden_US
dc.publisherIEEEen_US
dc.relationinfo:turkey/grantAgreement/TUBITAK/120E488
dc.relation.ispartof2022 IEEE 19th International Conference on Software Architecture (ICSA)
dc.relation.publicationcategoryInternational
dc.rightsinfo:eu-repo/semantics/restrictedAccess
dc.subject.keywordsEffort estimationen_US
dc.subject.keywordsIndustrial case studyen_US
dc.subject.keywordsModule isolationen_US
dc.subject.keywordsModule migrationen_US
dc.subject.keywordsRefactoringen_US
dc.subject.keywordsSoftware architectureen_US
dc.titleEffort estimation for architectural refactoring of data tier softwareen_US
dc.typeConference paperen_US
dspace.entity.typePublication
relation.isOrgUnitOfPublication85662e71-2a61-492a-b407-df4d38ab90d7
relation.isOrgUnitOfPublication.latestForDiscovery85662e71-2a61-492a-b407-df4d38ab90d7

Files

License bundle

Now showing 1 - 1 of 1
Placeholder
Name:
license.txt
Size:
1.45 KB
Format:
Item-specific license agreed upon to submission
Description:

Collections