Visualizing impacts of database schema changes - A controlled experiment

被引:3
|
作者
Karahasanovic, A [1 ]
Sjoberg, DIK [1 ]
机构
[1] Univ Oslo, Dept Informat, Ind Syst Dev Grp, N-0316 Oslo, Norway
关键词
D O I
10.1109/HCC.2001.995292
中图分类号
TP31 [计算机软件];
学科分类号
081202 ; 0835 ;
摘要
Research in schema evolution has been driven by the need for more effective software development and maintenance. Finding impacts of schema changes on the applications and presenting them in an appropriate way are particularly challenging. We have developed a tool that finds impacts of schema changes on applications in object-oriented systems. This tool displays components (packages, classes, interfaces, methods and fields) of a database application system as a graph. Components potentially affected by a change are indicated by changing the shape of the boxes representing those components. Two versions of the tool are available. One version identifies affected parts of applications at the granularity of packages, classes, and interfaces, whereas the other version identifies affected parts at the finer granularity of fields and methods. This paper presents the design and results of a controlled student experiment testing these two granularity levels with respect to productivity and user satisfaction. There are indications that identifying impacts at the finer granularity can reduce the time needed to conduct schema changes and reduce the number of errors. Our results also show that the subjects of the experiment appreciated the idea of visualizing the impacts of schema changes.
引用
收藏
页码:358 / 365
页数:8
相关论文
共 50 条
  • [1] Improved Teaching of Database Schema Modeling by Visualizing Changes in Levels of Abstraction
    Katz, Adi
    [J]. Journal of Information Systems Education, 2020, 31 (04) : 294 - 311
  • [2] Impact Analysis of Database Schema Changes
    Maule, Andy
    Emmerich, Wolfgang
    Rosenblum, David S.
    [J]. ICSE'08 PROCEEDINGS OF THE THIRTIETH INTERNATIONAL CONFERENCE ON SOFTWARE ENGINEERING, 2008, : 451 - 460
  • [3] Adapting Queries to Database Schema Changes in Hybrid Polystores
    Fink, Jerome
    Gobert, Maxime
    Cleve, Anthony
    [J]. 2020 20TH IEEE INTERNATIONAL WORKING CONFERENCE ON SOURCE CODE ANALYSIS AND MANIPULATION (SCAM 2020), 2020, : 127 - 131
  • [4] LESSQL: Dealing with Database Schema Changes in Continuous Deployment
    Afonso, Ariel
    da Silva, Altigran
    Conte, Tayana
    Martins, Paulo
    Cavalcanti, Joao
    Garcia, Alessandro
    [J]. PROCEEDINGS OF THE 2020 IEEE 27TH INTERNATIONAL CONFERENCE ON SOFTWARE ANALYSIS, EVOLUTION, AND REENGINEERING (SANER '20), 2020, : 138 - 148
  • [5] Schema repository for database schema evolution
    Bounif, Hassina
    Pottinger, Rachel
    [J]. SEVENTEENTH INTERNATIONAL CONFERENCE ON DATABASE AND EXPERT SYSTEMS APPLICATIONS, PROCEEDINGS, 2006, : 647 - +
  • [6] Visualizing Code Smells: Tables or Code Cities? A Controlled Experiment
    Galperin, Falko
    Koschke, Rainer
    Steinbeck, Marcel
    [J]. 2022 WORKING CONFERENCE ON SOFTWARE VISUALIZATION (IEEE VISSOFT), 2022, : 51 - 62
  • [7] Database schema evolution through the specification and maintenance of changes on entities and relationships
    Liu, CT
    Chrysanthis, PK
    Chang, SK
    [J]. ENTITY-RELATIONSHIP APPROACH - ER '94, 1994, 881 : 132 - 151
  • [8] A Two-folded Impact Analysis of Schema Changes on Database Applications
    Spyridon K. Gardikiotis
    Nicos Malevris
    [J]. Machine Intelligence Research, 2009, (02) : 109 - 123
  • [9] A Two-folded Impact Analysis of Schema Changes on Database Applications
    Gardikiotis, Spyridon K.
    Malevris, Nicos
    [J]. INTERNATIONAL JOURNAL OF AUTOMATION AND COMPUTING, 2009, 6 (02) : 109 - 123
  • [10] Developing a database schema generator based on XML schema
    Lim, Jong-Seon
    Choi, Mun-Young
    Joo, Kyung-Soo
    [J]. DYNAMICS OF CONTINUOUS DISCRETE AND IMPULSIVE SYSTEMS-SERIES B-APPLICATIONS & ALGORITHMS, 2007, 14 : 1690 - 1694