Design and Implementation of Queries for Model-Driven Spreadsheets

1. Chambers, C., Scaffidi, C.: Struggling to excel: A field study of challenges faced by spreadsheet users. In: Hundhausen, C.D., Pietriga, E., Díaz, P., Rosson, M.B. (eds.) VL/HCC, pp. 187–194. IEEE (2010)

   Google Scholar 

2. Wadler, P.: Xquery: a typed functional language for querying xml. In: Jeuring, J., Jones, S.L.P. (eds.) AFP 2002. LNCS, vol. 2638, pp. 188–212. Springer, Heidelberg (2003)

   Chapter  Google Scholar 

3. Cunha, J., Mendes, J., Fernandes, J.P., Pereira, R., Saraiva, J.: Querying model-driven spreadsheets. In: IEEE Symposium on Visual Languages and Human-Centric Computing. IEEE CS, San Jose (2013)

   Google Scholar 

4. Belo, O., Cunha, J., Fernandes, J.P., Mendes, J., Pereira, R., Saraiva, J.: Querysheet: A bidirectional query environment for model-driven spreadsheets. In: IEEE Symposium on Visual Languages and Human-Centric Computing, VLHCC 2013. IEEE CS, San Jose (2013)

   Google Scholar 

5. Maier, D.: The Theory of Relational Databases. Computer Science Press, Rockville (1983)

   MATH  Google Scholar 

6. Schmidt, D.C.: Guest editor’s introduction: Model-driven engineering. Computer 39(2), 25–31 (2006)

   Article  Google Scholar 

7. Bézivin, J.: Model driven engineering: an emerging technical space. In: Lämmel, R., Saraiva, J., Visser, J. (eds.) GTTSE 2005. LNCS, vol. 4143, pp. 36–64. Springer, Heidelberg (2006)

   Chapter  Google Scholar 

8. Ireson-Paine, J.: Model master: an object-oriented spreadsheet front-end. In: Computer-Aided Learning using Technology in Economies and Business Education (1997)

   Google Scholar 

9. Abraham, R., Erwig, M., Kollmansberger, S., Seifert, E.: Visual Specifications of Correct Spreadsheets. In: VL/HCC 2005: IEEE Symposium on Visual Languages and Human-Centric Computing, pp. 189–196. IEEE Computer Society (2005)

   Google Scholar 

10. Cunha, J., Fernandes, J.P., Mendes, J., Saraiva, J.: MDSheet: A framework for model-driven spreadsheet engineering. In: Proceedings of the 34th International Conference on Software Engineering, pp. 1412–1415. ACM (2012)

    Google Scholar 

11. Mendes, J.: Evolution of model-driven spreadsheets. Master’s thesis, University of Minho (2012)

    Google Scholar 

12. Engels, G., Erwig, M.: ClassSheets: automatic generation of spreadsheet applications from object-oriented specifications. In: Proceedings of the 20th IEEE/ACM International Conference on Automated Software Engineering, pp. 124–133. ACM (2005)

    Google Scholar 

13. Bals, J.C., Christ, F., Engels, G., Erwig, M.: Classsheets - model-based, object-oriented design of spreadsheet applications. In: Proceedings of the TOOLS Europe Conference (TOOLS 2007), Zürich (Swiss), vol. 6, pp. 383–398, October 2007. Journal of Object Technology

    Google Scholar 

14. Mens, T., Demeyer, S. (eds.): Software Evolution. Springer, New York (2008)

    MATH  Google Scholar 

15. Pereira, R.: Querying for model-driven spreadsheets. Master’s thesis, University of Minho (2013)

    Google Scholar 

16. Kankuzi, B., Sajaniemi, J.: An empirical study of spreadsheet authors’ mental models in explaining and debugging tasks. In: 2013 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC), pp. 15–18 (2013)

    Google Scholar 

17. Melton, J.: Database language sql. In: Bernus, P., Mertins, K., Schmidt, G. (eds.) Handbook on Architectures of Information Systems. International Handbooks on Information Systems, pp. 103–128. Springer, Heidelberg (1998)

    Chapter  Google Scholar 

18. Shin, S.K., Sanders, G.L.: Denormalization strategies for data retrieval from data warehouses. Decis. Support Syst. 42(1), 267–282 (2006)

    Article  Google Scholar 

19. Google: Google query function (2013). https://developers.google.com/chart/interactive/docs/querylanguage. (Accessed on November 2013)

20. Google: Google spreadsheet api (2013). https://developers.google.com/google-apps/spreadsheets. (Accessed on November 2013)

21. Cunha, J., Erwig, M., Saraiva, J.: Automatically inferring classsheet models from spreadsheets. In: IEEE Symposium on Visual Languages and Human-Centric Computing, pp. 93–100. IEEE CS (2010)

    Google Scholar 

22. Cunha, J., Fernandes, J.P., Martins, P., Mendes, J., Saraiva, J.: Smellsheet detective: A tool for detecting bad smells in spreadsheets. In: Erwig, M., Stapleton, G., Costagliola, G. (eds.) VL/HCC, pp. 243–244. IEEE (2012)

    Google Scholar 

23. Cunha, J., Fernandes, J.P., Ribeiro, H., Saraiva, J.: Towards a catalog of spreadsheet smells. In: Murgante, B., Gervasi, O., Misra, S., Nedjah, N., Rocha, A.M.A.C., Taniar, D., Apduhan, B.O. (eds.) ICCSA 2012, Part IV. LNCS, vol. 7336, pp. 202–216. Springer, Heidelberg (2012)

    Chapter  Google Scholar 

24. Hermans, F., Pinzger, M., van Deursen, A.: Detecting and visualizing inter-worksheet smells in spreadsheets. In: Proceedings of the 2012 International Conference on Software Engineering, ICSE 2012. IEEE Press, Piscataway (2012)

    Google Scholar 

25. Fowler, M.: Refactoring: Improving the Design of Existing Code. Addison-Wesley Longman Publishing Co., Inc., Boston (1999)

    Google Scholar 

26. Bohannon, A., Vaughan, J.A., Pierce, B.C.: Relational lenses: A language for updateable views. In: Principles of Database Systems (PODS) (2006). Extended version available as University of Pennsylvania technical report MS-CIS-05-27

    Google Scholar 

Download references