Graphical querying of model-driven spreadsheets

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

doi:10.1007/978-3-319-07731-4_42

Graphical querying of model-driven spreadsheets

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

Computer Science

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

Abstract

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.

Original language	English (US)
Title of host publication	Human Interface and the Management of Information
Subtitle of host publication	Information and Knowledge Design and Evaluation - 16th International Conference, HCI International 2014, Proceedings
Publisher	Springer Verlag
Pages	419-430
Number of pages	12
Edition	PART 1
ISBN (Print)	9783319077307
DOIs	https://doi.org/10.1007/978-3-319-07731-4_42
State	Published - 2014
Event	16th International Conference on Human Interface and the Management of Information: Information and Knowledge Design and Evaluation, HCI International 2014 - Heraklion, Crete, Greece Duration: Jun 22 2014 → Jun 27 2014

Publication series

Name	Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Number	PART 1
Volume	8521 LNCS
ISSN (Print)	0302-9743
ISSN (Electronic)	1611-3349

Conference

Conference	16th International Conference on Human Interface and the Management of Information: Information and Knowledge Design and Evaluation, HCI International 2014
Country/Territory	Greece
City	Heraklion, Crete
Period	6/22/14 → 6/27/14

Keywords

graphical querying
Model-driven engineering
spreadsheets

ASJC Scopus subject areas

Theoretical Computer Science
General Computer Science

Access to Document

10.1007/978-3-319-07731-4_42

Cite this

Cunha, J., Fernandes, J. P., Pereira, R., & Saraiva, J. (2014). Graphical querying of model-driven spreadsheets. In Human Interface and the Management of Information: Information and Knowledge Design and Evaluation - 16th International Conference, HCI International 2014, Proceedings (PART 1 ed., pp. 419-430). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 8521 LNCS, No. PART 1). Springer Verlag. https://doi.org/10.1007/978-3-319-07731-4_42

Graphical querying of model-driven spreadsheets. / Cunha, Jácome; Fernandes, João Paulo; Pereira, Rui et al.
Human Interface and the Management of Information: Information and Knowledge Design and Evaluation - 16th International Conference, HCI International 2014, Proceedings. PART 1. ed. Springer Verlag, 2014. p. 419-430 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 8521 LNCS, No. PART 1).

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

Cunha, J, Fernandes, JP, Pereira, R & Saraiva, J 2014, Graphical querying of model-driven spreadsheets. in Human Interface and the Management of Information: Information and Knowledge Design and Evaluation - 16th International Conference, HCI International 2014, Proceedings. PART 1 edn, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), no. PART 1, vol. 8521 LNCS, Springer Verlag, pp. 419-430, 16th International Conference on Human Interface and the Management of Information: Information and Knowledge Design and Evaluation, HCI International 2014, Heraklion, Crete, Greece, 6/22/14. https://doi.org/10.1007/978-3-319-07731-4_42

Cunha J, Fernandes JP, Pereira R, Saraiva J. Graphical querying of model-driven spreadsheets. In Human Interface and the Management of Information: Information and Knowledge Design and Evaluation - 16th International Conference, HCI International 2014, Proceedings. PART 1 ed. Springer Verlag. 2014. p. 419-430. (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); PART 1). doi: 10.1007/978-3-319-07731-4_42

Cunha, Jácome ; Fernandes, João Paulo ; Pereira, Rui et al. / Graphical querying of model-driven spreadsheets. Human Interface and the Management of Information: Information and Knowledge Design and Evaluation - 16th International Conference, HCI International 2014, Proceedings. PART 1. ed. Springer Verlag, 2014. pp. 419-430 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); PART 1).

@inproceedings{0c70d7ce7e2146a78d851b48f8ee8aca,

title = "Graphical querying of model-driven spreadsheets",

abstract = "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.",

keywords = "graphical querying, Model-driven engineering, spreadsheets",

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

year = "2014",

doi = "10.1007/978-3-319-07731-4_42",

language = "English (US)",

isbn = "9783319077307",

series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",

publisher = "Springer Verlag",

number = "PART 1",

pages = "419--430",

booktitle = "Human Interface and the Management of Information",

edition = "PART 1",

note = "16th International Conference on Human Interface and the Management of Information: Information and Knowledge Design and Evaluation, HCI International 2014 ; Conference date: 22-06-2014 Through 27-06-2014",

}

TY - GEN

T1 - Graphical querying of model-driven spreadsheets

AU - Cunha, Jácome

AU - Fernandes, João Paulo

AU - Pereira, Rui

AU - Saraiva, João

PY - 2014

Y1 - 2014

N2 - 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.

AB - 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.

KW - graphical querying

KW - Model-driven engineering

KW - spreadsheets

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

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

U2 - 10.1007/978-3-319-07731-4_42

DO - 10.1007/978-3-319-07731-4_42

M3 - Conference contribution

AN - SCOPUS:84904137306

SN - 9783319077307

T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

SP - 419

EP - 430

BT - Human Interface and the Management of Information

PB - Springer Verlag

T2 - 16th International Conference on Human Interface and the Management of Information: Information and Knowledge Design and Evaluation, HCI International 2014

Y2 - 22 June 2014 through 27 June 2014

ER -

Graphical querying of model-driven spreadsheets

Abstract

Publication series

Conference

Keywords

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Cite this