Please use this identifier to cite or link to this item: https://hdl.handle.net/1822/67888

TitleEvaluating refactorings for spreadsheet models
Author(s)Cunha, Jácome
Fernandes, João Paulo
Martins, Pedro
Mendes, Jorge
Pereira, Rui
Saraiva, João
KeywordsSoftware refactoring
Model-driven engineering
Spreadsheets
Empirical study
Issue date2016
PublisherElsevier Science Inc
JournalJournal of Systems and Software
Abstract(s)Software refactoring is a well-known technique that provides transformations on software artifacts with the aim of improving their overall quality.We have previously proposed a catalog of refactorings for spreadsheet models expressed in the ClassSheets modeling language, which allows us to specify the business logic of a spreadsheet in an object-oriented fashion.Reasoning about spreadsheets at the model level enhances a model-driven spreadsheet environment where a ClassSheet model and its conforming instance (spreadsheet data) automatically co-evolves after applying a refactoring at the model level. Research motivation was to improve the model and its conforming instance: the spreadsheet data.In this paper we define such refactorings using previously proposed evolution steps for models and instances.We also present an empirical study we designed and conducted in order to confirm our original intuition that these refactorings have a positive impact on end-user productivity, both in terms of effectiveness and efficiency.The results are not only presented in terms of productivity changes between refactored and nonrefactored scenarios, but also the overall user satisfaction, relevance, and experience.In almost all cases the refactorings improved end-users productivity. Moreover, in most cases users were more engaged with the refactored version of the spreadsheets they worked with.
TypeArticle
URIhttps://hdl.handle.net/1822/67888
DOI10.1016/j.jss.2016.04.043
ISSN0164-1212
Publisher versionhttps://www.sciencedirect.com/science/article/abs/pii/S0164121216300280
Peer-Reviewedyes
AccessRestricted access (UMinho)
Appears in Collections:HASLab - Artigos em revistas internacionais

Files in This Item:
File Description SizeFormat 
JSS16.pdf
  Restricted access
4,41 MBAdobe PDFView/Open

Partilhe no FacebookPartilhe no TwitterPartilhe no DeliciousPartilhe no LinkedInPartilhe no DiggAdicionar ao Google BookmarksPartilhe no MySpacePartilhe no Orkut
Exporte no formato BibTex mendeley Exporte no formato Endnote Adicione ao seu ORCID