{"id":"https://openalex.org/W2164750100","doi":"https://doi.org/10.1109/vlhcc.2014.6883056","title":"ES-SQL: Visually querying spreadsheets","display_name":"ES-SQL: Visually querying spreadsheets","publication_year":2014,"publication_date":"2014-07-01","ids":{"openalex":"https://openalex.org/W2164750100","doi":"https://doi.org/10.1109/vlhcc.2014.6883056","mag":"2164750100"},"language":"en","primary_location":{"id":"doi:10.1109/vlhcc.2014.6883056","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vlhcc.2014.6883056","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2014 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://figshare.com/articles/dataset/ES_SQL_Visually_Querying_Spreadsheets/1140430","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5042720932","display_name":"J\u00e1come Cunha","orcid":"https://orcid.org/0000-0002-4713-3834"},"institutions":[{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]},{"id":"https://openalex.org/I4210125590","display_name":"Institute for Systems Engineering and Computers","ror":"https://ror.org/033wn8m60","country_code":"PT","type":"nonprofit","lineage":["https://openalex.org/I4210125590"]}],"countries":["PT"],"is_corresponding":true,"raw_author_name":"J\u00e1come Cunha","raw_affiliation_strings":["HASLab/INESC TEC & Universidade do Minho, Portugal","INESC, Universidade do Minho, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"HASLab/INESC TEC & Universidade do Minho, Portugal","institution_ids":["https://openalex.org/I99682543"]},{"raw_affiliation_string":"INESC, Universidade do Minho, Portugal","institution_ids":["https://openalex.org/I99682543","https://openalex.org/I4210125590"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037619063","display_name":"Jo\u00e3o Paulo Fernandes","orcid":"https://orcid.org/0000-0002-1952-9460"},"institutions":[{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]},{"id":"https://openalex.org/I4210125590","display_name":"Institute for Systems Engineering and Computers","ror":"https://ror.org/033wn8m60","country_code":"PT","type":"nonprofit","lineage":["https://openalex.org/I4210125590"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Jo\u00e3o Paulo Fernandes","raw_affiliation_strings":["HASLab/INESC TEC & Universidade do Minho, Portugal","INESC, Universidade do Minho, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"HASLab/INESC TEC & Universidade do Minho, Portugal","institution_ids":["https://openalex.org/I99682543"]},{"raw_affiliation_string":"INESC, Universidade do Minho, Portugal","institution_ids":["https://openalex.org/I99682543","https://openalex.org/I4210125590"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075244092","display_name":"Jorge Mendes","orcid":"https://orcid.org/0000-0002-7977-9453"},"institutions":[{"id":"https://openalex.org/I4210125590","display_name":"Institute for Systems Engineering and Computers","ror":"https://ror.org/033wn8m60","country_code":"PT","type":"nonprofit","lineage":["https://openalex.org/I4210125590"]},{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Jorge Mendes","raw_affiliation_strings":["HASLab/INESC TEC & Universidade do Minho, Portugal","INESC, Universidade do Minho, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"HASLab/INESC TEC & Universidade do Minho, Portugal","institution_ids":["https://openalex.org/I99682543"]},{"raw_affiliation_string":"INESC, Universidade do Minho, Portugal","institution_ids":["https://openalex.org/I99682543","https://openalex.org/I4210125590"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5088321345","display_name":"Rui Pereira","orcid":"https://orcid.org/0000-0002-5801-7345"},"institutions":[{"id":"https://openalex.org/I4210125590","display_name":"Institute for Systems Engineering and Computers","ror":"https://ror.org/033wn8m60","country_code":"PT","type":"nonprofit","lineage":["https://openalex.org/I4210125590"]},{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Rui Pereira","raw_affiliation_strings":["HASLab/INESC TEC & Universidade do Minho, Portugal","INESC, Universidade do Minho, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"HASLab/INESC TEC & Universidade do Minho, Portugal","institution_ids":["https://openalex.org/I99682543"]},{"raw_affiliation_string":"INESC, Universidade do Minho, Portugal","institution_ids":["https://openalex.org/I99682543","https://openalex.org/I4210125590"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5087190575","display_name":"Jo\u00e3o Saraiva","orcid":"https://orcid.org/0000-0002-5686-7151"},"institutions":[{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]},{"id":"https://openalex.org/I4210125590","display_name":"Institute for Systems Engineering and Computers","ror":"https://ror.org/033wn8m60","country_code":"PT","type":"nonprofit","lineage":["https://openalex.org/I4210125590"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Jo\u00e3o Saraiva","raw_affiliation_strings":["HASLab/INESC TEC & Universidade do Minho, Portugal","INESC, Universidade do Minho, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"HASLab/INESC TEC & Universidade do Minho, Portugal","institution_ids":["https://openalex.org/I99682543"]},{"raw_affiliation_string":"INESC, Universidade do Minho, Portugal","institution_ids":["https://openalex.org/I99682543","https://openalex.org/I4210125590"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5042720932"],"corresponding_institution_ids":["https://openalex.org/I4210125590","https://openalex.org/I99682543"],"apc_list":null,"apc_paid":null,"fwci":0.4508,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.71282652,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"203","last_page":"204"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10731","display_name":"Educational Games and Gamification","score":0.9419999718666077,"subfield":{"id":"https://openalex.org/subfields/3204","display_name":"Developmental and Educational Psychology"},"field":{"id":"https://openalex.org/fields/32","display_name":"Psychology"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T13682","display_name":"Engineering Education and Pedagogy","score":0.9409999847412109,"subfield":{"id":"https://openalex.org/subfields/2216","display_name":"Architecture"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.882168173789978},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.8173849582672119},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.56577068567276},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4519514739513397},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4300052523612976},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.42996877431869507},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4244897961616516},{"id":"https://openalex.org/keywords/business-logic","display_name":"Business logic","score":0.41927915811538696},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.3321792483329773},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.13718146085739136},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.08295789361000061}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.882168173789978},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8173849582672119},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.56577068567276},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4519514739513397},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4300052523612976},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.42996877431869507},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4244897961616516},{"id":"https://openalex.org/C146222976","wikidata":"https://www.wikidata.org/wiki/Q1204997","display_name":"Business logic","level":2,"score":0.41927915811538696},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3321792483329773},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.13718146085739136},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.08295789361000061}],"mesh":[],"locations_count":6,"locations":[{"id":"doi:10.1109/vlhcc.2014.6883056","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vlhcc.2014.6883056","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2014 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)","raw_type":"proceedings-article"},{"id":"pmh:oai:figshare.com:article/1140430","is_oa":true,"landing_page_url":"https://figshare.com/articles/dataset/ES_SQL_Visually_Querying_Spreadsheets/1140430","pdf_url":null,"source":{"id":"https://openalex.org/S4377196282","display_name":"Figshare","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210132348","host_organization_name":"Figshare (United Kingdom)","host_organization_lineage":["https://openalex.org/I4210132348"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Dataset"},{"id":"pmh:oai:repositorio.inesctec.pt:123456789/5425","is_oa":true,"landing_page_url":"http://repositorio.inesctec.pt/handle/123456789/5425","pdf_url":null,"source":{"id":"https://openalex.org/S4306402433","display_name":"Portuguese National Funding Agency for Science, Research and Technology (RCAAP Project by FCT)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"conference object"},{"id":"pmh:oai:repositorium.sdum.uminho.pt:1822/37721","is_oa":true,"landing_page_url":"http://hdl.handle.net/1822/37721","pdf_url":null,"source":{"id":"https://openalex.org/S4306400354","display_name":"Reposit\u00f3riUM (Universidade do Minho)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I99682543","host_organization_name":"University of Minho","host_organization_lineage":["https://openalex.org/I99682543"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"conference paper"},{"id":"pmh:oai:repositorium.uminho.pt:1822/37721","is_oa":true,"landing_page_url":"https://hdl.handle.net/1822/37721","pdf_url":null,"source":{"id":"https://openalex.org/S4306402433","display_name":"Portuguese National Funding Agency for Science, Research and Technology (RCAAP Project by FCT)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"conference paper"},{"id":"doi:10.6084/m9.figshare.1140430.v1","is_oa":true,"landing_page_url":"https://doi.org/10.6084/m9.figshare.1140430.v1","pdf_url":null,"source":{"id":"https://openalex.org/S4377196282","display_name":"Figshare","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210132348","host_organization_name":"Figshare (United Kingdom)","host_organization_lineage":["https://openalex.org/I4210132348"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"dataset"}],"best_oa_location":{"id":"pmh:oai:figshare.com:article/1140430","is_oa":true,"landing_page_url":"https://figshare.com/articles/dataset/ES_SQL_Visually_Querying_Spreadsheets/1140430","pdf_url":null,"source":{"id":"https://openalex.org/S4377196282","display_name":"Figshare","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210132348","host_organization_name":"Figshare (United Kingdom)","host_organization_lineage":["https://openalex.org/I4210132348"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Dataset"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W1969600276","https://openalex.org/W2025005530","https://openalex.org/W2066044245","https://openalex.org/W2077287293","https://openalex.org/W2094438898","https://openalex.org/W2253754074","https://openalex.org/W3148828430"],"related_works":["https://openalex.org/W151494989","https://openalex.org/W1548279772","https://openalex.org/W2897196530","https://openalex.org/W319014924","https://openalex.org/W1488984669","https://openalex.org/W3210031882","https://openalex.org/W4388053677","https://openalex.org/W3114457612","https://openalex.org/W2031915568","https://openalex.org/W4285818047"],"abstract_inverted_index":{"This":[0,13],"paper":[1],"presents":[2],"ES-SQL,":[3],"an":[4,16],"embedded":[5],"tool":[6,14],"for":[7],"visually":[8],"constructing":[9],"queries":[10],"over":[11],"spreadsheets.":[12],"provides":[15],"expressive":[17],"query":[18],"environment":[19],"which":[20],"has":[21],"knowledge":[22,32],"on":[23],"the":[24,35,39],"business":[25],"logic":[26],"of":[27],"spreadsheets,":[28],"and":[29],"by":[30],"this":[31],"it":[33],"assists":[34],"user":[36],"in":[37],"defining":[38],"intended":[40],"queries.":[41]},"counts_by_year":[{"year":2014,"cited_by_count":1}],"updated_date":"2026-05-03T08:25:01.440150","created_date":"2025-10-10T00:00:00"}