Graphical Querying of Model-Driven Spreadsheets

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.

[1]  Jácome Cunha,et al.  QuerySheet: A bidirectional query environment for model-driven spreadsheets , 2013, 2013 IEEE Symposium on Visual Languages and Human Centric Computing.

[2]  Jim Melton,et al.  Database Language SQL , 2006, Handbook on Architectures of Information Systems.

[3]  Jean-Luc Hainaut,et al.  The Transformational Approach to Database Engineering , 2005, GTTSE.

[4]  Gregor Engels,et al.  ClassSheets: automatic generation of spreadsheet applications from object-oriented specifications , 2005, ASE '05.

[5]  Jácome Cunha,et al.  Querying model-driven spreadsheets , 2013, 2013 IEEE Symposium on Visual Languages and Human Centric Computing.

[6]  J. V. Leeuwen.  Revised Papers , 2003 .

[7]  Esther Guerra,et al.  IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC 2010, Leganés-Madrid, Spain, 21-25 September 2010, Proceedings , 2010, VL/HCC.

[8]  Jácome Cunha,et al.  MDSheet: A framework for model-driven spreadsheet engineering , 2012, 2012 34th International Conference on Software Engineering (ICSE).

[9]  2013 IEEE Symposium on Visual Languages and Human Centric Computing, San Jose, CA, USA, September 15-19, 2013 , 2013, VL/HCC.

[10]  Martin Erwig,et al.  Visual specifications of correct spreadsheets , 2005, 2005 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC'05).

[11]  Douglas C. Schmidt,et al.  Guest Editor's Introduction: Model-Driven Engineering , 2006, Computer.

[12]  Jácome Cunha,et al.  Automatically Inferring ClassSheet Models from Spreadsheets , 2010, 2010 IEEE Symposium on Visual Languages and Human-Centric Computing.

[13]  Gregor Engels,et al.  ClassSheets - model-based, object-oriented design of spreadsheet applications , 2007, J. Object Technol..

[14]  Peter Bernus,et al.  Handbook on Architectures of Information Systems , 1999 .

[15]  David Maier,et al.  The Theory of Relational Databases , 1983 .

[16]  Rui Alexandre Afonso Pereira.  Querying for model-driven spreadsheetsd , 2013 .

[17]  Jean Bézivin,et al.  Model Driven Engineering: An Emerging Technical Space , 2005, GTTSE.

[18]  Jácome Cunha,et al.  Design and Implementation of Queries for Model-Driven Spreadsheets , 2013, CEFP.

[19]  João Saraiva,et al.  Generative and Transformational Techniques in Software Engineering II , 2007, Lecture Notes in Computer Science.