Title :
Embedding model-driven spreadsheet queries in spreadsheet systems
Author :
Cunha, Jacome ; Fernandes, Joao Paulo ; Mendes, J. ; Pereira, Rui ; Saraiva, Juliana
Author_Institution :
HASLab/INESC TEC, Univ. do Minho, Braga, Portugal
fDate :
July 28 2014-Aug. 1 2014
Abstract :
Spreadsheets are widely used not only to define mathematical expressions, but also to store large and complex data. To query such data is usually a difficult task to perform, usually for end user. In this work we embed the textual query language in the model-driven spreadsheet environment as a spreadsheet itself. The result is an expressive and powerful query environment that has knowledge of the business logic defined by the spreadsheet data (the spreadsheet model) to guide end users constructing correct queries.
Keywords :
query languages; query processing; spreadsheet programs; business logic; complex data storage; data query; model-driven spreadsheet queries; spreadsheet data; spreadsheet systems; textual query language; Computational modeling; Data models; Database languages; Databases; Object oriented modeling; Synchronization; Visualization;
Conference_Titel :
Visual Languages and Human-Centric Computing (VL/HCC), 2014 IEEE Symposium on
Conference_Location :
Melbourne, VIC
DOI :
10.1109/VLHCC.2014.6883039