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.
This work is part funded by the ERDF - European Regional Development Fund through the COMPETE Programme (operational programme for competitiveness) and by National Funds through the FCT - Fundação para a Ciência e a Tecnologia (Portuguese Foundation for Science and Technology) within project FCOMP-01-0124-FEDER-022701. The first author was funded by FCT: SFRH/BPD/73358/2010.
Chapter PDF
Similar content being viewed by others
References
Maier, D.: The Theory of Relational Databases. Computer Science Press (1983)
Hainaut, J.L.: The transformational approach to database engineering. [17], 95–144
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)
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 Technology
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)
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)
Google: Google query function (2013), https://developers.google.com/chart/interactive/docs/querylanguage (accessed on November 2013)
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)
Schmidt, D.C.: Guest editor’s introduction: Model-driven engineering. Computer 39(2), 25–31 (2006)
Bézivin, J.: Model driven engineering: An emerging technical space. [17 ], pp. 36–64
Ireson-Paine, J.: Model master: an object-oriented spreadsheet front-end. In: Computer-Aided Learning using Technology in Economies and Business Education (1997)
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)
Cunha, J., Fernandes, J.P., Mendes, J., Saraiva, J.: Mdsheet: A framework for model-driven spreadsheet engineering. In: ICSE, pp. 1395–1398 (2012)
Pereira, R.: Querying for model-driven spreadsheets. Master’s thesis, University of Minho (2013)
Cunha, J., Fernandes, J.P., Mendes, J., Pereira, R., Saraiva, J.: Querying model-driven spreadsheets. [18], pp. 83–86
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–200
Lämmel, R., Saraiva, J., Visser, J. (eds.): GTTSE 2005. LNCS, vol. 4143. Springer, Heidelberg (2006)
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)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
Cunha, J., Fernandes, J.P., Pereira, R., Saraiva, J. (2014). Graphical Querying of Model-Driven Spreadsheets. In: Yamamoto, S. (eds) Human Interface and the Management of Information. Information and Knowledge Design and Evaluation. HIMI 2014. Lecture Notes in Computer Science, vol 8521. Springer, Cham. https://doi.org/10.1007/978-3-319-07731-4_42
Download citation
DOI: https://doi.org/10.1007/978-3-319-07731-4_42
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-07730-7
Online ISBN: 978-3-319-07731-4
eBook Packages: Computer ScienceComputer Science (R0)