Advertisement

Graphical Querying of Model-Driven Spreadsheets

  • Jácome Cunha
  • João Paulo Fernandes
  • Rui Pereira
  • João Saraiva
Part of the Lecture Notes in Computer Science book series (LNCS, volume 8521)

Abstract

This paper presents a graphical interface to query model-driven spreadsheets to simplify query construction for typical end-users with little to no knowledge of SQL. This was based on experience with previous work and empirical studies in querying systems. We briefly show our previous text based model-driven querying system. Afterwards, we detail our graphical model-driven querying interface, explaining each part of the interface and showing an example. To validate our work, we executed an empirical study, comparing our graphical querying approach to an alternative querying tool, which produced positive results.

Keywords

Model-driven engineering graphical querying spreadsheets 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Maier, D.: The Theory of Relational Databases. Computer Science Press (1983)Google Scholar
  2. 2.
    Hainaut, J.L.: The transformational approach to database engineering. [17], 95–144Google Scholar
  3. 3.
    Engels, G., Erwig, M.: ClassSheets: automatic generation of spreadsheet applications from object-oriented specifications. In: Proc. of the 20th IEEE/ACM Int. Conf. on Aut. Sof. Eng., pp. 124–133. ACM (2005)Google Scholar
  4. 4.
    Bals, J.C., Christ, F., Engels, G., Erwig, M.: Classsheets - model-based, object-oriented design of spreadsheet applications. In: TOOLS Europe Conference (TOOLS 2007), Zürich, Swiss, vol. 6, pp. 383–398 (October 2007); Journal of Object TechnologyGoogle Scholar
  5. 5.
    Cunha, J., Erwig, M., Saraiva, J.: Automatically inferring classsheet models from spreadsheets. In: IEEE Symp. on Visual Languages and Human-Centric Computing, pp. 93–100. IEEE CS (2010)Google Scholar
  6. 6.
    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)CrossRefGoogle Scholar
  7. 7.
    Google: Google query function (2013), https://developers.google.com/chart/interactive/docs/querylanguage (accessed on November 2013)
  8. 8.
    Cunha, J., Mendes, J., Fernandes, J.P., Pereira, R., Saraiva, J.: Design and implementation of queries for model-driven spreadsheets. In: Proceedings of the Domain-Specific Language Summer School 2013 (submitted 2014)Google Scholar
  9. 9.
    Schmidt, D.C.: Guest editor’s introduction: Model-driven engineering. Computer 39(2), 25–31 (2006)Google Scholar
  10. 10.
    Bézivin, J.: Model driven engineering: An emerging technical space. [17 ], pp. 36–64Google Scholar
  11. 11.
    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
  12. 12.
    Abraham, R., Erwig, M., Kollmansberger, S., Seifert, E.: Visual specifications of correct spreadsheets. In: Proceedings of the 2005 IEEE Symposium on Visual Languages and Human-Centric Computing, VLHCC 2005, pp. 189–196. IEEE Computer Society, Washington, DC (2005)Google Scholar
  13. 13.
    Cunha, J., Fernandes, J.P., Mendes, J., Saraiva, J.: Mdsheet: A framework for model-driven spreadsheet engineering. In: ICSE, pp. 1395–1398 (2012)Google Scholar
  14. 14.
    Pereira, R.: Querying for model-driven spreadsheets. Master’s thesis, University of Minho (2013)Google Scholar
  15. 15.
    Cunha, J., Fernandes, J.P., Mendes, J., Pereira, R., Saraiva, J.: Querying model-driven spreadsheets. [18], pp. 83–86Google Scholar
  16. 16.
    Belo, O., Cunha, J., Fernandes, J.P., Mendes, J., Pereira, R., Saraiva, J.: Querysheet: A bidirectional query environment for model-driven spreadsheets. [18], pp. 199–200Google Scholar
  17. 17.
    Lämmel, R., Saraiva, J., Visser, J. (eds.): GTTSE 2005. LNCS, vol. 4143. Springer, Heidelberg (2006)Google Scholar
  18. 18.
    Kelleher, C., Burnett, M.M., Sauer, S. (eds.): 2013 IEEE Symposium on Visual Languages and Human Centric Computing, San Jose, CA, USA, September 15-19 (2013); Kelleher, C., Burnett, M.M., Sauer, S. (eds.): VL/HCC. IEEE (2013)Google Scholar

Copyright information

© Springer International Publishing Switzerland 2014

Authors and Affiliations

  • Jácome Cunha
    • 1
    • 2
  • João Paulo Fernandes
    • 1
    • 3
  • Rui Pereira
    • 1
  • João Saraiva
    • 1
  1. 1.HASLab/INESC TEC & Universidade do MinhoPortugal
  2. 2.CIICESI, ESTGF, Instituto Politécnico do PortoPortugal
  3. 3.RELEASE, Universidade da Beira InteriorPortugal

Personalised recommendations