DocumentCode
1788269
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
fYear
2014
fDate
July 28 2014-Aug. 1 2014
Firstpage
151
Lastpage
154
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;
fLanguage
English
Publisher
ieee
Conference_Titel
Visual Languages and Human-Centric Computing (VL/HCC), 2014 IEEE Symposium on
Conference_Location
Melbourne, VIC
Type
conf
DOI
10.1109/VLHCC.2014.6883039
Filename
6883039
Link To Document