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

TitleBidirectional transformation of model-driven spreadsheets
Author(s)Cunha, Jácome Miguel Costa
Fernandes, João Paulo Sousa Ferreira
Mendes, Jorge
Pacheco, Hugo
Saraiva, João Alexandre
KeywordsSoftware evolution
Data evolution
Bidirectional transformation
Model synchronization
Spreadsheets
Issue date2012
PublisherSpringer
JournalLecture Notes in Computer Science (including Subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Abstract(s)Spreadsheets play an important role in software organizations. Indeed, in large software organizations, spreadsheets are not only used to define sheets containing data and formulas, but also to collect information from diferent systems, to adapt data coming from one system to the format required by another, to perform operations to enrich or simplify data, etc. In fact, over time many spreadsheets turn out to be used for storing and processing increasing amounts of data and supporting increasing numbers of users. Unfortunately, spreadsheet systems provide poor support for modularity, abstraction, and transformation, thus, making the maintenance, update and evolution of spreadsheets a very complex and error-prone task. We present techniques for model-driven spreadsheet engineering where we employ bidirectional transformations to maintain spreadsheet models and instances synchronized. In our setting, the business logic of spreadsheets is defined by ClassSheet models to which the spreadsheet data conforms, and spreadsheet users may evolve both the model and the data instances. Our techniques are implemented as part of the MDSheet framework: an extension for a traditional spreadsheet system.
TypeConference paper
DescriptionLecture Notes in Computer Science Volume 7307, 2012
URIhttps://hdl.handle.net/1822/36156
ISBN978-3-642-30475-0
DOI10.1007/978-3-642-30476-7_7
ISSN0302-9743
Publisher versionhttp://link.springer.com/chapter/10.1007%2F978-3-642-30476-7_7
Peer-Reviewedyes
AccessOpen access
Appears in Collections:HASLab - Artigos em atas de conferências internacionais (texto completo)

Files in This Item:
File SizeFormat 
126.pdf768,7 kBAdobe 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