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

TitleFrom spreadsheets to relational databases and back
Author(s)Cunha, Jácome Miguel Costa
Saraiva, João Alexandre
Visser, Joost
KeywordsBi-directional transformations
Functional programming
Spreadsheets
Type-safe data migration
Issue date2009
Abstract(s)This paper presents techniques and tools to transform spreadsheets into relational databases and back. A set of data refinement rules is introduced to map a tabular datatype into a relational database schema. Having expressed the transformation of the two data models as data refinements, we obtain for free the functions that migrate the data. We use well-known relational database techniques to optimize and query the data. Because data refinements define bidirectional transformations we can map such database back to an optimized spreadsheet. We have implemented the data refinement rules and we have constructed tools to manipulate, optimize and refactor Excel-like spreadsheets.
TypeConference paper
URIhttps://hdl.handle.net/1822/36479
ISBN978-1-60558-327-3
DOI10.1145/1480945.1480972
Peer-Reviewedyes
AccessOpen access
Appears in Collections:HASLab - Artigos em atas de conferências internacionais (texto completo)

Files in This Item:
File SizeFormat 
145.pdf327,92 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