Utilize este identificador para referenciar este registo:
https://hdl.handle.net/1822/36469
Registo completo
Campo DC | Valor | Idioma |
---|---|---|
dc.contributor.author | Cunha, Jácome | por |
dc.contributor.author | Erwig, Martin | por |
dc.contributor.author | Saraiva, João Alexandre | por |
dc.date.accessioned | 2015-07-28T11:06:33Z | - |
dc.date.available | 2015-07-28T11:06:33Z | - |
dc.date.issued | 2010 | - |
dc.identifier.isbn | 9780769542065 | por |
dc.identifier.issn | 1943-6092 | - |
dc.identifier.uri | https://hdl.handle.net/1822/36469 | - |
dc.description.abstract | Many errors in spreadsheet formulas can be avoided if spreadsheets are built automatically from higher-level models that can encode and enforce consistency constraints. However, designing such models is time consuming and requires expertise beyond the knowledge to work with spreadsheets. Legacy spreadsheets pose a particular challenge to the approach of controlling spreadsheet evolution through higher-level models, because the need for a model might be overshadowed by two problems: (A) The benefit of creating a spreadsheet is lacking since the legacy spreadsheet already exists, and (B) existing data must be transferred into the new model-generated spreadsheet.To address these problems and to support the modeldriven spreadsheet engineering approach, we have developed a tool that can automatically infer ClassSheet models from spreadsheets. To this end, we have adapted a method to infer entity/relationship models from relational database to the spreadsheets/ClassSheets realm. We have implemented our techniques in the HAEXCEL framework and integrated it with the ViTSL/Gencel spreadsheet generator, which allows the automatic generation of refactored spreadsheets from the inferred ClassSheet model. The resulting spreadsheet guides further changes and provably safeguards the spreadsheet against a large class of formula errors. The developed tool is a significant contribution to spreadsheet (reverse) engineering, because it fills an important gap and allows a promising design method (ClassSheets) to be applied to a huge collection of legacy spreadsheets with minimal effort. | por |
dc.description.sponsorship | (undefined) | por |
dc.language.iso | eng | por |
dc.publisher | IEEE | por |
dc.relation | Supported by the Portuguese Research Foundation (FCT) PhD grant SFRH/BD/30231/2006 | por |
dc.relation | Supported by the SSaaPP project (SpreadSheets as a Programming Paradigm) under FCT contract PTDC/EIA-CCO/108613/2008. | por |
dc.rights | openAccess | por |
dc.title | Automatically inferring ClassSheet models from spreadsheets | por |
dc.type | conferencePaper | por |
dc.peerreviewed | yes | por |
dc.relation.publisherversion | http://ieeexplore.ieee.org/xpls/abs_all.jsp?arnumber=5635202 | por |
dc.comments | 143 | por |
sdum.publicationstatus | published | por |
oaire.citationStartPage | 93 | por |
oaire.citationEndPage | 100 | por |
oaire.citationConferencePlace | Leganes | por |
oaire.citationTitle | Proceedings of the Symposium on Visual Languages and Human-Centric Computing - VL/HCC | por |
dc.publisher.uri | IEEE Computer Society | por |
dc.identifier.doi | 10.1109/VLHCC.2010.22 | por |
sdum.conferencePublication | Proceedings of the Symposium on Visual Languages and Human-Centric Computing - VL/HCC | por |
Aparece nas coleções: |