<?xml version="1.0" encoding="UTF-8"?><xml><records><record><source-app name="Biblio" version="6.x">Drupal-Biblio</source-app><ref-type>47</ref-type><contributors><authors><author><style face="normal" font="default" size="100%">Jácome Cunha</style></author><author><style face="normal" font="default" size="100%">João Alexandre Saraiva</style></author><author><style face="normal" font="default" size="100%">Joost Visser</style></author></authors></contributors><titles><title><style face="normal" font="default" size="100%">From spreadsheets to relational databases and back</style></title><secondary-title><style face="normal" font="default" size="100%">Proceedings of the workshop on Partial evaluation and program manipulation - PEPM</style></secondary-title><tertiary-title><style face="normal" font="default" size="100%">PEPM '09</style></tertiary-title></titles><keywords><keyword><style  face="normal" font="default" size="100%">bi-directional transformations</style></keyword><keyword><style  face="normal" font="default" size="100%">functional programming</style></keyword><keyword><style  face="normal" font="default" size="100%">Spreadsheets</style></keyword><keyword><style  face="normal" font="default" size="100%">type-safe data migration</style></keyword></keywords><dates><year><style  face="normal" font="default" size="100%">2009</style></year><pub-dates><date><style  face="normal" font="default" size="100%">January</style></date></pub-dates></dates><urls><web-urls><url><style face="normal" font="default" size="100%">http://doi.acm.org/10.1145/1480945.1480972</style></url></web-urls><related-urls><url><style face="normal" font="default" size="100%">https://haslab.uminho.pt/sites/default/files/jacome/files/pepm09.pdf</style></url></related-urls></urls><publisher><style face="normal" font="default" size="100%">ACM</style></publisher><pub-location><style face="normal" font="default" size="100%">Savannah, GA, USA</style></pub-location><pages><style face="normal" font="default" size="100%">179–188</style></pages><isbn><style face="normal" font="default" size="100%">978-1-60558-327-3</style></isbn><language><style face="normal" font="default" size="100%">eng</style></language><abstract><style face="normal" font="default" size="100%">&lt;p&gt;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.&lt;/p&gt;
</style></abstract></record></records></xml>