ES-SQL: Visually querying spreadsheets

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

doi:10.1109/vlhcc.2014.6883056

Cited by 2 publications

(3 citation statements)

References 6 publications

(6 reference statements)

Supporting

Mentioning

Contrasting

Order By: Relevance

“…GRAPHICALQUERYBUILDER's backend is implemented in Django 2 and connects to a relational PostgreSQL database. 3 The SQL statement is generated from the user interface web page and passed to the REST APIs defined in the Django application. Django will then send the appropriate response back to web page, built with Angular, in JSON format.…”

Section: B Back-endmentioning

confidence: 99%

“…Effectively constructing queries on advanced database systems that contain domain-specific data which does not follow basic numerical or textual patterns is challenging and errorprone [1], [2]. To support decision making in such scenarios, visual and interactive query systems have been proposed, often focusing on specific domains, such as spreadsheets [3], sports [4], Linked Open Data [5], geographical data [6], or spatio-temporal data [7], [8].…”

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

Querying Spatial-Temporal-Spectral Data Using a Graphical Query Builder

Gorczynska¹,

Fulé²

2022

Preprint

View full text Add to dashboard Cite

Constructing complex queries on data which combines spatial, temporal, and spectral aspects is a challenging and error-prone process. Query interfaces of general-purpose database management systems fall short in providing intuitive support for users to effectively and efficiently construct queries. To address this situation, we developed GRAPHICALQUERY-BUILDER, a tool which provides interactive and immediate feedback during query construction and visually represents search space and queries. A user study with ten professionals showed that users were able to complete queries on average 40% faster and 40 percentage points more accurately compared to a Microsoft Access baseline.

show abstract

Section: B Back-endmentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

Querying Spatial-Temporal-Spectral Data Using a Graphical Query Builder

Gorczynska¹,

Fulé²

2022

Preprint

View full text Add to dashboard Cite

show abstract

“…With this approach we were able to show that users were now more capable of writing queries [19]. Moreover, we have also implemented the embedded querying system under MDSheet [21].…”

Section: Related Workmentioning

confidence: 99%

Embedding model-driven spreadsheet queries in spreadsheet systems

Pereira

Fernandes

Mendes

et al. 2014

2014 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)

Self Cite

View full text Add to dashboard Cite

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.

show abstract

ES-SQL: Visually querying spreadsheets

Abstract: This paper presents ES-SQL, an embedded tool for visually constructing queries over spreadsheets. This tool provides an expressive query environment which has knowledge on the business logic of spreadsheets, and by this knowledge it assists the user in defining the intended queries.

Cited by 2 publications

References 6 publications

Querying Spatial-Temporal-Spectral Data Using a Graphical Query Builder

Querying Spatial-Temporal-Spectral Data Using a Graphical Query Builder

Embedding model-driven spreadsheet queries in spreadsheet systems

Contact Info

Product

Resources

About