talk at dsl13
DESCRIPTION
Talk at the Domain Specific Languages Summer School'13 Cluj-Napoca, RomaniaTRANSCRIPT
![Page 1: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/1.jpg)
Supervised by:
Prof. Dr. João Alexandre Saraiva
Prof. Dr. Orlando Manuel Belo
Rui Alexandre Afonso Pereira
Querying SpreadSheets
![Page 2: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/2.jpg)
Problem: Querying Spreadsheets
• Spreadsheets are generally used to store information• Much like database systems• Have no way to query what data they contain
• Attempts have been made to replicate traditional querying systems for spreadsheets• MS-Query• Google QUERY Function
![Page 3: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/3.jpg)
Problem: Querying Spreadsheets
• Highly restrict user’s spreadsheet data• Requires data to be in a tabular format• Requires headers to be present (in first
row)• Column letters ≠ Column labels• Counter intuitive queries• Data evolution not supported
![Page 4: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/4.jpg)
Proposed Solution: Example
![Page 5: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/5.jpg)
Proposed Solution: Example
• Model-Driven spreadsheet representing orders, clients, and products
![Page 6: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/6.jpg)
Proposed Solution: Example
• Spreadsheet data
![Page 7: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/7.jpg)
Proposed Solution: Example
• Query: How much have we profited from each client?
![Page 8: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/8.jpg)
Proposed Solution: Example
Google QUERY Function :
Denormalization
![Page 9: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/9.jpg)
Proposed Solution: Example
• Google Query:
Google QUERY Function :
![Page 10: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/10.jpg)
Proposed Solution: Example
• Proposed Query:
Proposed Solution:
![Page 11: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/11.jpg)
Proposed Solution: Example
Proposed Solution:
![Page 12: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/12.jpg)
Proposed Solution: Example
Results:
• Query: How much have we profited from each client?
![Page 13: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/13.jpg)
Recap
![Page 14: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/14.jpg)
Recap
• Take advantage of the powerful Google query engine while adding extra functionality
• Allow more humanized queries
• Have ClassSheets supported
• Automatically structure the data into the needed format
• Automatically deal with problems caused by denormalized data querying
Not to reinvent the wheel
![Page 15: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/15.jpg)
Architecture
![Page 16: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/16.jpg)
Architecture
![Page 17: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/17.jpg)
Demonstration
![Page 18: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/18.jpg)
Demonstration
![Page 19: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/19.jpg)
Future Work
![Page 20: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/20.jpg)
Future Work
• Incremental Denormalization
• Integration of ClassSheet Inference
• Spreadsheet Synchronization
• Empirical Evaluations
![Page 21: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/21.jpg)
Publications
![Page 22: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/22.jpg)
Publications
• QuerySheet: A Bidirectional Query Environment for Model-Driven Spreadsheets. Orlando Belo, Jácome Cunha, João Paulo Fernandes, Jorge Mendes, Rui Pereira and João Saraiva. In proceedings of the IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC’13), San Jose, CA, USA, September 15–19, 2013. IEEE Computer Society, Showpieces paper. (to appear)
• Querying Model-Driven Spreadsheets, Jácome Cunha, João Paulo Fernandes, Jorge Mendes, Rui Pereira, João Saraiva. In proceedings of the IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC’13), San Jose, CA, USA , September 15–19, 2013. IEEE Computer Society. (to appear)
![Page 23: Talk at DSL13](https://reader036.vdocuments.us/reader036/viewer/2022081516/55835eead8b42a575f8b4fe8/html5/thumbnails/23.jpg)
Mulțumesc