User-friendly spreadsheet querying: an empirical study

Spreadsheets are nowadays used in a variety of contexts, including in in manipulatin large and complex data. This data is stored in a large unstructured matrix, which is hard to understand and to manipulate. Recent research has been done to manipulate and query such unstructured data, namely by proposing different query approaches to spreadsheets. In this paper we present an empirical study evaluating three recent query approaches to spreadsheets assessing their usage to query spreadsheets. The results of our study show that the end-users' productivity increases when using visual, model-driven queries are used.

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

[2]  Hongjun Lu,et al.  A survey on usage of SQL , 1993, SGMD.

[3]  Jácome Cunha,et al.  Embedding, Evolution, and Validation of Model-Driven Spreadsheets , 2015, IEEE Transactions on Software Engineering.

[4]  Jácome Cunha,et al.  Graphical Querying of Model-Driven Spreadsheets , 2014, HCI.

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

[6]  Jorma Sajaniemi,et al.  An empirical study of spreadsheet authors' mental models in explaining and debugging tasks , 2013, 2013 IEEE Symposium on Visual Languages and Human Centric Computing.

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

[8]  Guoliang Li,et al.  Interactive SQL query suggestion: Making databases user-friendly , 2011, 2011 IEEE 27th International Conference on Data Engineering.