Header and Unit Inference for Spreadsheets Through Spatial Analyses
VLHCC '04 Proceedings of the 2004 IEEE Symposium on Visual Languages - Human Centric Computing
Visualization of mappings between schemas
Proceedings of the SIGCHI Conference on Human Factors in Computing Systems
Estimating the Numbers of End Users and End User Programmers
VLHCC '05 Proceedings of the 2005 IEEE Symposium on Visual Languages and Human-Centric Computing
XML Mapping technology: making connections in an XML-centric world
IBM Systems Journal
Nested mappings: schema mapping reloaded
VLDB '06 Proceedings of the 32nd international conference on Very large data bases
ManyEyes: a Site for Visualization at Internet Scale
IEEE Transactions on Visualization and Computer Graphics
STBenchmark: towards a benchmark for mapping systems
Proceedings of the VLDB Endowment
A Spreadsheet Algebra for a Direct Data Manipulation Query Interface
ICDE '09 Proceedings of the 2009 IEEE International Conference on Data Engineering
Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
The life and times of files and information: a study of desktop provenance
Proceedings of the SIGCHI Conference on Human Factors in Computing Systems
Spreadsheet as a relational database engine
Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
Automatic web spreadsheet data extraction
Proceedings of the 3rd International Workshop on Semantic Search Over the Web
Senbazuru: a prototype spreadsheet database management system
Proceedings of the VLDB Endowment
| Hi-index | 0.00 |
Spreadsheets are used by millions of users as a routine all-purpose data management tool. It is now increasingly necessary for external applications and services to consume spreadsheet data. In this paper, we investigate the problem of transforming spreadsheet data to structured formats required by these applications and services. Unlike prior methods, we propose a novel approach in which transformation logic is embedded into a familiar and expressive spreadsheet-like formula mapping language. Popular transformation patterns provided by transformation languages and mapping tools, that are relevant to spreadsheet-based data transformation, are supported in the language via formulas. Consequently, the language avoids cluttering the source spreadsheets with transformations and turns out to be helpful when multiple schemas are targeted. We implemented a prototype and evaluated the benefits of our approach via experiments in a real application. The experimental results confirmed the benefits of our approach.