From spreadsheets to relational databases and back

• Tipo: Artigo em Livro de Atas de Conferência Internacional
• Data: 2009

Autores

Cunha, J (Autor) Outra; Saraiva, J (Autor) Outra; Visser, J (Autor) Outra

Ata de Conferência Internacional

Título: Proceedings of the 2009 ACM SIGPLAN Symposium on Partial Evaluation and Program Manipulation, PEPM'09

Páginas: 179-188

2009 ACM SIGPLAN Symposium on Partial Evaluation and Program Manipulation, PEPM'09

Savannah, GA, 19 January 2009 through 20 January 2009

Indexação

Scopus - 50 Citações

Outras Informações

ID Authenticus: P-007-QK7

DOI: 10.1145/1480945.1480972

Abstract (EN): 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 constructed HASKELL-based tools to manipulate, optimize and refactor Excel-like spreadsheets. ©2009 ACM.

Idioma: Inglês

Tipo (Avaliação Docente): Científica