Data model extension impact analysis

Name: Data model extension impact analysis
Author: Ersoy, E., Sözer, Hasan

İsim	Data model extension impact analysis
Yazar	Ersoy, E., Sözer, Hasan
Basım Tarihi:	2021
Basım Yeri	- IEEE
Konu	Change impact analysis, Data model extension, Database models, Software maintenance, Software reliability
Tür	Belge
Dil	İngilizce
Dijital	Evet
Yazma	Hayır
Kütüphane:	Özyeğin Üniversitesi
Demirbaş Numarası	978-166541070-0
Kayıt Numarası	df0a3f10-c41f-4211-973a-ade7887ddae8
Lokasyon	Computer Science
Tarih	2021
Örnek Metin	Relational database schemas are subject to change. For instance, columns of a table can be modified, deleted or extended. These changes have an impact on the source code that utilizes the corresponding table. They also have an impact on other database elements such as tables, views and stored procedures related to that table. Studies on change impact analysis so far mainly focus on the impact of changes on source code. There are a few tools that can analyze the impact of changes on database elements. However, these tools consider modifications and deletions, while ignoring extensions as a type of change. In this study, we propose an approach and a tool that can analyze the impact of data model extensions. Our approach involves the computation of a similarity score between each pair of tables in the database based on the unique column names defined in these tables. Tables that are similar to the extended tables beyond a threshold level are considered to be under impact. We perform an industrial case study to evaluate the accuracy of our approach and the effects of the threshold level on the accuracy of results.
DOI	10.1109/UYMS54260.2021.9659747
Cilt	21

Kaynağa git Özyeğin Üniversitesi

Aramaya Dön

Özyeğin Üniversitesi

Kaynağa git

Data model extension impact analysis

Yazar Ersoy, E., Sözer, Hasan

Basım Tarihi 2021

Basım Yeri - IEEE

Konu Change impact analysis, Data model extension, Database models, Software maintenance, Software reliability

Tür Belge

Dil İngilizce

Dijital Evet

Yazma Hayır

Kütüphane Özyeğin Üniversitesi

Demirbaş Numarası 978-166541070-0

Kayıt Numarası df0a3f10-c41f-4211-973a-ade7887ddae8

Lokasyon Computer Science

Tarih 2021

Örnek Metin Relational database schemas are subject to change. For instance, columns of a table can be modified, deleted or extended. These changes have an impact on the source code that utilizes the corresponding table. They also have an impact on other database elements such as tables, views and stored procedures related to that table. Studies on change impact analysis so far mainly focus on the impact of changes on source code. There are a few tools that can analyze the impact of changes on database elements. However, these tools consider modifications and deletions, while ignoring extensions as a type of change. In this study, we propose an approach and a tool that can analyze the impact of data model extensions. Our approach involves the computation of a similarity score between each pair of tables in the database based on the unique column names defined in these tables. Tables that are similar to the extended tables beyond a threshold level are considered to be under impact. We perform an industrial case study to evaluate the accuracy of our approach and the effects of the threshold level on the accuracy of results.

DOI 10.1109/UYMS54260.2021.9659747

Cilt 21