Refactoring meets model-driven spreadsheet evolution

Jácome Cunha; João Paulo Fernandes; Pedro Martins; Rui Pereira; João Saraiva

doi:10.1109/QUATIC.2014.34

Refactoring meets model-driven spreadsheet evolution

Jácome Cunha, João Paulo Fernandes, Pedro Martins, Rui Pereira, João Saraiva

Computer Science

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

Abstract

Software refactoring is a well-known technique that provides transformations on software artifacts with the aim of improving their overall quality. In this paper we present a set of refactoring for Class Sheets, a modelling language that allows to specify the business logic of a spreadsheet in an object-oriented fashion. The set of refactoring that we propose allows us to improve the quality of these spreadsheet models. Moreover, it is implemented in a setting that guarantees that all model refactoring are automatically carried to all the corresponding (spreadsheet) instances, thus providing an automatic evolution of the data so it is always synchronized with the model.

Original language	English (US)
Title of host publication	Proceedings - 2014 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014
Editors	Alberto Rodrigues da Silva, Antonio Rito da Silva, Miguel A. Brito, Ricardo J. Machado
Publisher	Institute of Electrical and Electronics Engineers Inc.
Pages	196-201
Number of pages	6
ISBN (Electronic)	9781479961337
DOIs	https://doi.org/10.1109/QUATIC.2014.34
State	Published - Dec 12 2014
Event	9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014 - Guimaraes, Portugal Duration: Sep 23 2014 → Sep 26 2014

Publication series

Name	Proceedings - 2014 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014

Conference

Conference	9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014
Country/Territory	Portugal
City	Guimaraes
Period	9/23/14 → 9/26/14

Keywords

classsheets
model-driven spreadsheets
refactoring

ASJC Scopus subject areas

Computer Networks and Communications
Information Systems

Access to Document

10.1109/QUATIC.2014.34

Cite this

Cunha, J., Fernandes, J. P., Martins, P., Pereira, R., & Saraiva, J. (2014). Refactoring meets model-driven spreadsheet evolution. In A. R. da Silva, A. R. da Silva, M. A. Brito, & R. J. Machado (Eds.), Proceedings - 2014 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014 (pp. 196-201). Article 6984117 (Proceedings - 2014 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014). Institute of Electrical and Electronics Engineers Inc.. https://doi.org/10.1109/QUATIC.2014.34

Refactoring meets model-driven spreadsheet evolution. / Cunha, Jácome; Fernandes, João Paulo; Martins, Pedro et al.
Proceedings - 2014 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014. ed. / Alberto Rodrigues da Silva; Antonio Rito da Silva; Miguel A. Brito; Ricardo J. Machado. Institute of Electrical and Electronics Engineers Inc., 2014. p. 196-201 6984117 (Proceedings - 2014 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

Cunha, J, Fernandes, JP, Martins, P, Pereira, R & Saraiva, J 2014, Refactoring meets model-driven spreadsheet evolution. in AR da Silva, AR da Silva, MA Brito & RJ Machado (eds), Proceedings - 2014 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014., 6984117, Proceedings - 2014 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014, Institute of Electrical and Electronics Engineers Inc., pp. 196-201, 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014, Guimaraes, Portugal, 9/23/14. https://doi.org/10.1109/QUATIC.2014.34

Cunha J, Fernandes JP, Martins P, Pereira R, Saraiva J. Refactoring meets model-driven spreadsheet evolution. In da Silva AR, da Silva AR, Brito MA, Machado RJ, editors, Proceedings - 2014 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014. Institute of Electrical and Electronics Engineers Inc. 2014. p. 196-201. 6984117. (Proceedings - 2014 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014). doi: 10.1109/QUATIC.2014.34

Cunha, Jácome ; Fernandes, João Paulo ; Martins, Pedro et al. / Refactoring meets model-driven spreadsheet evolution. Proceedings - 2014 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014. editor / Alberto Rodrigues da Silva ; Antonio Rito da Silva ; Miguel A. Brito ; Ricardo J. Machado. Institute of Electrical and Electronics Engineers Inc., 2014. pp. 196-201 (Proceedings - 2014 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014).

@inproceedings{55b08e67dd2940acaa789d2e5f450502,

title = "Refactoring meets model-driven spreadsheet evolution",

abstract = "Software refactoring is a well-known technique that provides transformations on software artifacts with the aim of improving their overall quality. In this paper we present a set of refactoring for Class Sheets, a modelling language that allows to specify the business logic of a spreadsheet in an object-oriented fashion. The set of refactoring that we propose allows us to improve the quality of these spreadsheet models. Moreover, it is implemented in a setting that guarantees that all model refactoring are automatically carried to all the corresponding (spreadsheet) instances, thus providing an automatic evolution of the data so it is always synchronized with the model.",

keywords = "classsheets, model-driven spreadsheets, refactoring",

author = "J{\'a}come Cunha and Fernandes, {Jo{\~a}o Paulo} and Pedro Martins and Rui Pereira and Jo{\~a}o Saraiva",

note = "Publisher Copyright: {\textcopyright} 2014 IEEE.; 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014 ; Conference date: 23-09-2014 Through 26-09-2014",

year = "2014",

month = dec,

day = "12",

doi = "10.1109/QUATIC.2014.34",

language = "English (US)",

series = "Proceedings - 2014 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014",

publisher = "Institute of Electrical and Electronics Engineers Inc.",

pages = "196--201",

editor = "{da Silva}, {Alberto Rodrigues} and {da Silva}, {Antonio Rito} and Brito, {Miguel A.} and Machado, {Ricardo J.}",

booktitle = "Proceedings - 2014 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014",

}

TY - GEN

T1 - Refactoring meets model-driven spreadsheet evolution

AU - Cunha, Jácome

AU - Fernandes, João Paulo

AU - Martins, Pedro

AU - Pereira, Rui

AU - Saraiva, João

PY - 2014/12/12

Y1 - 2014/12/12

N2 - Software refactoring is a well-known technique that provides transformations on software artifacts with the aim of improving their overall quality. In this paper we present a set of refactoring for Class Sheets, a modelling language that allows to specify the business logic of a spreadsheet in an object-oriented fashion. The set of refactoring that we propose allows us to improve the quality of these spreadsheet models. Moreover, it is implemented in a setting that guarantees that all model refactoring are automatically carried to all the corresponding (spreadsheet) instances, thus providing an automatic evolution of the data so it is always synchronized with the model.

AB - Software refactoring is a well-known technique that provides transformations on software artifacts with the aim of improving their overall quality. In this paper we present a set of refactoring for Class Sheets, a modelling language that allows to specify the business logic of a spreadsheet in an object-oriented fashion. The set of refactoring that we propose allows us to improve the quality of these spreadsheet models. Moreover, it is implemented in a setting that guarantees that all model refactoring are automatically carried to all the corresponding (spreadsheet) instances, thus providing an automatic evolution of the data so it is always synchronized with the model.

KW - classsheets

KW - model-driven spreadsheets

KW - refactoring

UR - http://www.scopus.com/inward/record.url?scp=84921061977&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84921061977&partnerID=8YFLogxK

U2 - 10.1109/QUATIC.2014.34

DO - 10.1109/QUATIC.2014.34

M3 - Conference contribution

AN - SCOPUS:84921061977

T3 - Proceedings - 2014 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014

SP - 196

EP - 201

BT - Proceedings - 2014 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014

A2 - da Silva, Alberto Rodrigues

A2 - da Silva, Antonio Rito

A2 - Brito, Miguel A.

A2 - Machado, Ricardo J.

PB - Institute of Electrical and Electronics Engineers Inc.

T2 - 9th International Conference on the Quality of Information and Communications Technology, QUATIC 2014

Y2 - 23 September 2014 through 26 September 2014

ER -

Refactoring meets model-driven spreadsheet evolution

Abstract

Publication series

Conference

Keywords

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Cite this