{"id":"https://openalex.org/W3084910657","doi":"https://doi.org/10.14778/3415478.3415492","title":"SQUARES","display_name":"SQUARES","publication_year":2020,"publication_date":"2020-08-01","ids":{"openalex":"https://openalex.org/W3084910657","doi":"https://doi.org/10.14778/3415478.3415492","mag":"3084910657"},"language":"en","primary_location":{"id":"doi:10.14778/3415478.3415492","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3415478.3415492","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5082828525","display_name":"Pedro Orvalho","orcid":"https://orcid.org/0000-0002-7407-5967"},"institutions":[{"id":"https://openalex.org/I121345201","display_name":"Instituto de Engenharia de Sistemas e Computadores Investiga\u00e7\u00e3o e Desenvolvimento","ror":"https://ror.org/04mqy3p58","country_code":"PT","type":"nonprofit","lineage":["https://openalex.org/I121345201","https://openalex.org/I4210125590"]}],"countries":["PT"],"is_corresponding":true,"raw_author_name":"Pedro Orvalho","raw_affiliation_strings":["INESC-ID, Lisboa, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"INESC-ID, Lisboa, Portugal","institution_ids":["https://openalex.org/I121345201"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018333103","display_name":"Miguel Terra-Neves","orcid":"https://orcid.org/0000-0003-4089-7206"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Miguel Terra-Neves","raw_affiliation_strings":["OutSystems, Lisboa, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"OutSystems, Lisboa, Portugal","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5065074033","display_name":"Miguel Ventura","orcid":"https://orcid.org/0000-0002-4233-1348"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Miguel Ventura","raw_affiliation_strings":["OutSystems, Lisboa, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"OutSystems, Lisboa, Portugal","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101995804","display_name":"Ruben Martins","orcid":"https://orcid.org/0000-0003-1525-1382"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ruben Martins","raw_affiliation_strings":["CMU"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"CMU","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5033377932","display_name":"Vasco Manquinho","orcid":"https://orcid.org/0000-0002-4205-2189"},"institutions":[{"id":"https://openalex.org/I4210105462","display_name":"Lus\u00edada University of Lisbon","ror":"https://ror.org/00zjprf31","country_code":"PT","type":"education","lineage":["https://openalex.org/I4210105462","https://openalex.org/I4401200244"]},{"id":"https://openalex.org/I141596103","display_name":"University of Lisbon","ror":"https://ror.org/01c27hj86","country_code":"PT","type":"education","lineage":["https://openalex.org/I141596103"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Vasco Manquinho","raw_affiliation_strings":["Universidade de Lisboa, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universidade de Lisboa, Portugal","institution_ids":["https://openalex.org/I4210105462","https://openalex.org/I141596103"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5082828525"],"corresponding_institution_ids":["https://openalex.org/I121345201"],"apc_list":null,"apc_paid":null,"fwci":1.133,"has_fulltext":false,"cited_by_count":15,"citation_normalized_percentile":{"value":0.80498283,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"13","issue":"12","first_page":"2853","last_page":"2856"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9962000250816345,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9962000250816345,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T11719","display_name":"Data Quality and Management","score":0.9907000064849854,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9884999990463257,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.7970823049545288},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.792608380317688},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.791392982006073},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5650359988212585},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5621969103813171},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.49154481291770935},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.44761449098587036},{"id":"https://openalex.org/keywords/data-manipulation-language","display_name":"Data manipulation language","score":0.447553426027298},{"id":"https://openalex.org/keywords/domain","display_name":"Domain (mathematical analysis)","score":0.419051855802536},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.4058651328086853},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.38542231917381287},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.36305785179138184},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3429313898086548},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.33717966079711914},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.2377007007598877},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.14148390293121338},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.11869120597839355},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.07639503479003906}],"concepts":[{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.7970823049545288},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.792608380317688},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.791392982006073},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5650359988212585},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5621969103813171},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.49154481291770935},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.44761449098587036},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.447553426027298},{"id":"https://openalex.org/C36503486","wikidata":"https://www.wikidata.org/wiki/Q11235244","display_name":"Domain (mathematical analysis)","level":2,"score":0.419051855802536},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4058651328086853},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.38542231917381287},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.36305785179138184},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3429313898086548},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.33717966079711914},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2377007007598877},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.14148390293121338},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.11869120597839355},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.07639503479003906},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3415478.3415492","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3415478.3415492","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4","score":0.7099999785423279}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":73,"referenced_works":["https://openalex.org/W979215280","https://openalex.org/W1527197079","https://openalex.org/W1538240903","https://openalex.org/W1590649805","https://openalex.org/W1655078475","https://openalex.org/W1737156267","https://openalex.org/W1791762382","https://openalex.org/W1911540707","https://openalex.org/W1977279860","https://openalex.org/W1985554184","https://openalex.org/W1992665668","https://openalex.org/W1996508547","https://openalex.org/W2003879744","https://openalex.org/W2012401665","https://openalex.org/W2012436850","https://openalex.org/W2013167115","https://openalex.org/W2024958874","https://openalex.org/W2032374895","https://openalex.org/W2036265926","https://openalex.org/W2037237472","https://openalex.org/W2038123353","https://openalex.org/W2048027175","https://openalex.org/W2057513751","https://openalex.org/W2060610732","https://openalex.org/W2097335450","https://openalex.org/W2099239777","https://openalex.org/W2103219113","https://openalex.org/W2108862644","https://openalex.org/W2114376731","https://openalex.org/W2122947685","https://openalex.org/W2131146089","https://openalex.org/W2132525863","https://openalex.org/W2134734244","https://openalex.org/W2143861926","https://openalex.org/W2157976942","https://openalex.org/W2158615804","https://openalex.org/W2275996142","https://openalex.org/W2276356546","https://openalex.org/W2293101314","https://openalex.org/W2294628582","https://openalex.org/W2295596515","https://openalex.org/W2338508724","https://openalex.org/W2398191069","https://openalex.org/W2466191210","https://openalex.org/W2548125635","https://openalex.org/W2550100435","https://openalex.org/W2550120381","https://openalex.org/W2550471858","https://openalex.org/W2561055248","https://openalex.org/W2611064819","https://openalex.org/W2612269136","https://openalex.org/W2612337100","https://openalex.org/W2626990892","https://openalex.org/W2753109262","https://openalex.org/W2753710282","https://openalex.org/W2762513422","https://openalex.org/W2763179278","https://openalex.org/W2768510408","https://openalex.org/W2785774944","https://openalex.org/W2786248241","https://openalex.org/W2794518369","https://openalex.org/W2798866333","https://openalex.org/W2889117239","https://openalex.org/W2953054522","https://openalex.org/W2963929497","https://openalex.org/W2964342690","https://openalex.org/W2971324190","https://openalex.org/W2973690622","https://openalex.org/W2976890614","https://openalex.org/W3104044769","https://openalex.org/W3173654454","https://openalex.org/W4255584681","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W319014924","https://openalex.org/W2374912898","https://openalex.org/W2406556739","https://openalex.org/W2554271401","https://openalex.org/W2970853428","https://openalex.org/W4244527061","https://openalex.org/W2334227691","https://openalex.org/W2152149667","https://openalex.org/W2186703450","https://openalex.org/W644450836"],"abstract_inverted_index":{"Nowadays,":[0],"many":[1,15],"data":[2,22,81,87],"analysts":[3,82],"are":[4,25],"domain":[5],"experts,":[6],"but":[7,24],"they":[8],"lack":[9],"programming":[10],"skills.":[11],"As":[12],"a":[13,51,70],"result,":[14],"of":[16,21,41,45],"them":[17],"can":[18,79],"provide":[19],"examples":[20,77],"transformations":[23],"unable":[26],"to":[27,59,83],"produce":[28],"the":[29,43,61,97],"desired":[30],"query.":[31],"Hence,":[32],"there":[33],"is":[34],"an":[35],"increasing":[36],"need":[37],"for":[38],"systems":[39,57],"capable":[40],"solving":[42],"problem":[44],"Query":[46],"Reverse":[47],"Engineering":[48],"(QRE).":[49],"Given":[50],"database":[52],"and":[53,85,92],"output":[54],"table,":[55],"these":[56],"have":[58],"find":[60],"query":[62],"that":[63,78],"generated":[64],"this":[65],"table.":[66],"We":[67],"present":[68],"SQUARES,":[69],"program":[71],"synthesis":[72],"tool":[73],"based":[74],"on":[75],"input-output":[76],"help":[80],"extract":[84],"transform":[86],"by":[88],"synthesizing":[89],"SQL":[90],"queries,":[91],"table":[93],"manipulation":[94],"programs":[95],"using":[96],"R":[98],"language.":[99]},"counts_by_year":[{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2}],"updated_date":"2026-04-25T08:17:42.794288","created_date":"2020-09-21T00:00:00"}