Querying model-driven spreadsheets

Jácome Cunha; João Paulo Fernandes; Jorge Mendes; Rui Pereira; João Saraiva

doi:10.1109/VLHCC.2013.6645247

Querying model-driven spreadsheets

Jácome Cunha, João Paulo Fernandes, Jorge Mendes, Rui Pereira, João Saraiva

Computer Science

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

Abstract

Spreadsheets are being used with many different purposes that range from toy applications to complete information systems. In any of these cases, they are often used as data repositories that can grow significantly. As the amount of data grows, it also becomes more difficult to extract concrete information out of them. This paper focuses on the problem of spreadsheet querying. In particular, we propose an expressive and composable technique where intuitive queries can be defined. Our approach builds on a model-driven spreadsheet development environment, and queries are expressed referencing entities in the model of a spreadsheet instead of in its actual data. Finally, the system that we have implemented relies on Google's query function for spreadsheets.

Original language	English (US)
Title of host publication	Proceedings - 2013 IEEE Symposium on Visual Languages and Human Centric Computing, VL/HCC 2013
Pages	83-86
Number of pages	4
DOIs	https://doi.org/10.1109/VLHCC.2013.6645247
State	Published - 2013
Event	2013 IEEE Symposium on Visual Languages and Human Centric Computing, VL/HCC 2013 - San Jose, CA, United States Duration: Sep 15 2013 → Sep 19 2013

Publication series

Name	Proceedings of IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC
ISSN (Print)	1943-6092
ISSN (Electronic)	1943-6106

Conference

Conference	2013 IEEE Symposium on Visual Languages and Human Centric Computing, VL/HCC 2013
Country/Territory	United States
City	San Jose, CA
Period	9/15/13 → 9/19/13

ASJC Scopus subject areas

Computational Theory and Mathematics
Human-Computer Interaction
Software

Access to Document

10.1109/VLHCC.2013.6645247

Cite this

Cunha, J., Fernandes, J. P., Mendes, J., Pereira, R., & Saraiva, J. (2013). Querying model-driven spreadsheets. In Proceedings - 2013 IEEE Symposium on Visual Languages and Human Centric Computing, VL/HCC 2013 (pp. 83-86). Article 6645247 (Proceedings of IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC). https://doi.org/10.1109/VLHCC.2013.6645247

Querying model-driven spreadsheets. / Cunha, Jácome; Fernandes, João Paulo; Mendes, Jorge et al.
Proceedings - 2013 IEEE Symposium on Visual Languages and Human Centric Computing, VL/HCC 2013. 2013. p. 83-86 6645247 (Proceedings of IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

Cunha, J, Fernandes, JP, Mendes, J, Pereira, R & Saraiva, J 2013, Querying model-driven spreadsheets. in Proceedings - 2013 IEEE Symposium on Visual Languages and Human Centric Computing, VL/HCC 2013., 6645247, Proceedings of IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC, pp. 83-86, 2013 IEEE Symposium on Visual Languages and Human Centric Computing, VL/HCC 2013, San Jose, CA, United States, 9/15/13. https://doi.org/10.1109/VLHCC.2013.6645247

@inproceedings{ef8ef5b8522a4c90b38fbfa376714646,

title = "Querying model-driven spreadsheets",

abstract = "Spreadsheets are being used with many different purposes that range from toy applications to complete information systems. In any of these cases, they are often used as data repositories that can grow significantly. As the amount of data grows, it also becomes more difficult to extract concrete information out of them. This paper focuses on the problem of spreadsheet querying. In particular, we propose an expressive and composable technique where intuitive queries can be defined. Our approach builds on a model-driven spreadsheet development environment, and queries are expressed referencing entities in the model of a spreadsheet instead of in its actual data. Finally, the system that we have implemented relies on Google's query function for spreadsheets.",

author = "J{\'a}come Cunha and Fernandes, {Jo{\~a}o Paulo} and Jorge Mendes and Rui Pereira and Jo{\~a}o Saraiva",

year = "2013",

doi = "10.1109/VLHCC.2013.6645247",

language = "English (US)",

isbn = "9781479903689",

series = "Proceedings of IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC",

pages = "83--86",

booktitle = "Proceedings - 2013 IEEE Symposium on Visual Languages and Human Centric Computing, VL/HCC 2013",

note = "2013 IEEE Symposium on Visual Languages and Human Centric Computing, VL/HCC 2013 ; Conference date: 15-09-2013 Through 19-09-2013",

}

TY - GEN

T1 - Querying model-driven spreadsheets

AU - Cunha, Jácome

AU - Fernandes, João Paulo

AU - Mendes, Jorge

AU - Pereira, Rui

AU - Saraiva, João

PY - 2013

Y1 - 2013

N2 - Spreadsheets are being used with many different purposes that range from toy applications to complete information systems. In any of these cases, they are often used as data repositories that can grow significantly. As the amount of data grows, it also becomes more difficult to extract concrete information out of them. This paper focuses on the problem of spreadsheet querying. In particular, we propose an expressive and composable technique where intuitive queries can be defined. Our approach builds on a model-driven spreadsheet development environment, and queries are expressed referencing entities in the model of a spreadsheet instead of in its actual data. Finally, the system that we have implemented relies on Google's query function for spreadsheets.

AB - Spreadsheets are being used with many different purposes that range from toy applications to complete information systems. In any of these cases, they are often used as data repositories that can grow significantly. As the amount of data grows, it also becomes more difficult to extract concrete information out of them. This paper focuses on the problem of spreadsheet querying. In particular, we propose an expressive and composable technique where intuitive queries can be defined. Our approach builds on a model-driven spreadsheet development environment, and queries are expressed referencing entities in the model of a spreadsheet instead of in its actual data. Finally, the system that we have implemented relies on Google's query function for spreadsheets.

UR - http://www.scopus.com/inward/record.url?scp=84891115523&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84891115523&partnerID=8YFLogxK

U2 - 10.1109/VLHCC.2013.6645247

DO - 10.1109/VLHCC.2013.6645247

M3 - Conference contribution

AN - SCOPUS:84891115523

SN - 9781479903689

T3 - Proceedings of IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC

SP - 83

EP - 86

BT - Proceedings - 2013 IEEE Symposium on Visual Languages and Human Centric Computing, VL/HCC 2013

T2 - 2013 IEEE Symposium on Visual Languages and Human Centric Computing, VL/HCC 2013

Y2 - 15 September 2013 through 19 September 2013

ER -

Querying model-driven spreadsheets

Abstract

Publication series

Conference

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Cite this