{"id":"https://openalex.org/W2443450302","doi":"https://doi.org/10.1561/2500000018","title":"Computer-Assisted Query Formulation","display_name":"Computer-Assisted Query Formulation","publication_year":2016,"publication_date":"2016-06-14","ids":{"openalex":"https://openalex.org/W2443450302","doi":"https://doi.org/10.1561/2500000018","mag":"2443450302"},"language":"en","primary_location":{"id":"doi:10.1561/2500000018","is_oa":false,"landing_page_url":"https://doi.org/10.1561/2500000018","pdf_url":null,"source":{"id":"https://openalex.org/S4210233022","display_name":"Foundations and Trends\u00ae in Programming Languages","issn_l":"2325-1107","issn":["2325-1107","2325-1131"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318575","host_organization_name":"Now Publishers","host_organization_lineage":["https://openalex.org/P4310318575"],"host_organization_lineage_names":["Now Publishers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Foundations and Trends\u00ae in Programming Languages","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/A5059427197","display_name":"Alvin Cheung","orcid":"https://orcid.org/0000-0001-6261-6263"},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alvin Cheung","raw_affiliation_strings":["University of Washington","University of Washington, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Washington","institution_ids":["https://openalex.org/I201448701"]},{"raw_affiliation_string":"University of Washington, USA","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5010786661","display_name":"Armando Solar-Lezama","orcid":"https://orcid.org/0000-0001-7604-8252"},"institutions":[{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Armando Solar-Lezama","raw_affiliation_strings":["MIT CSAIL","Massachusetts Institute of Technology, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MIT CSAIL","institution_ids":[]},{"raw_affiliation_string":"Massachusetts Institute of Technology, USA","institution_ids":["https://openalex.org/I63966007"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.7726,"has_fulltext":false,"cited_by_count":9,"citation_normalized_percentile":{"value":0.86651003,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"3","issue":"1","first_page":"1","last_page":"94"},"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.9995999932289124,"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.9995999932289124,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.998199999332428,"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/T12072","display_name":"Machine Learning and Algorithms","score":0.998199999332428,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"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.8816021680831909},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.7307479381561279},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.558374285697937},{"id":"https://openalex.org/keywords/bridge","display_name":"Bridge (graph theory)","score":0.5109909772872925},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4738999903202057},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.4586162567138672},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.44611456990242004},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.42647507786750793},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.41092872619628906},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.3054724931716919}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8816021680831909},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.7307479381561279},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.558374285697937},{"id":"https://openalex.org/C100776233","wikidata":"https://www.wikidata.org/wiki/Q2532492","display_name":"Bridge (graph theory)","level":2,"score":0.5109909772872925},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4738999903202057},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.4586162567138672},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.44611456990242004},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.42647507786750793},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.41092872619628906},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.3054724931716919},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0},{"id":"https://openalex.org/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","level":0,"score":0.0},{"id":"https://openalex.org/C126322002","wikidata":"https://www.wikidata.org/wiki/Q11180","display_name":"Internal medicine","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1561/2500000018","is_oa":false,"landing_page_url":"https://doi.org/10.1561/2500000018","pdf_url":null,"source":{"id":"https://openalex.org/S4210233022","display_name":"Foundations and Trends\u00ae in Programming Languages","issn_l":"2325-1107","issn":["2325-1107","2325-1131"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318575","host_organization_name":"Now Publishers","host_organization_lineage":["https://openalex.org/P4310318575"],"host_organization_lineage_names":["Now Publishers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Foundations and Trends\u00ae in Programming Languages","raw_type":"journal-article"},{"id":"pmh:oai:cds.cern.ch:2761884","is_oa":false,"landing_page_url":"http://cds.cern.ch/record/2761884","pdf_url":null,"source":{"id":"https://openalex.org/S4306402195","display_name":"CERN Document Server (European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":""}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":83,"referenced_works":["https://openalex.org/W156574570","https://openalex.org/W1519503479","https://openalex.org/W1528113134","https://openalex.org/W1565838812","https://openalex.org/W1812582761","https://openalex.org/W1831729862","https://openalex.org/W1965446936","https://openalex.org/W1966982815","https://openalex.org/W1970165929","https://openalex.org/W1977101058","https://openalex.org/W1988504473","https://openalex.org/W1997640482","https://openalex.org/W2003251288","https://openalex.org/W2008187947","https://openalex.org/W2010418442","https://openalex.org/W2012312630","https://openalex.org/W2012401665","https://openalex.org/W2013167115","https://openalex.org/W2016943912","https://openalex.org/W2023878327","https://openalex.org/W2030315716","https://openalex.org/W2032374895","https://openalex.org/W2036440640","https://openalex.org/W2038123353","https://openalex.org/W2038765730","https://openalex.org/W2042133273","https://openalex.org/W2048905912","https://openalex.org/W2057178786","https://openalex.org/W2064766209","https://openalex.org/W2066210260","https://openalex.org/W2069171862","https://openalex.org/W2069300761","https://openalex.org/W2077850509","https://openalex.org/W2089340995","https://openalex.org/W2092019763","https://openalex.org/W2093634202","https://openalex.org/W2100852567","https://openalex.org/W2110338707","https://openalex.org/W2110848488","https://openalex.org/W2111950041","https://openalex.org/W2113352466","https://openalex.org/W2117700306","https://openalex.org/W2121344286","https://openalex.org/W2125357166","https://openalex.org/W2127018826","https://openalex.org/W2134179408","https://openalex.org/W2134734244","https://openalex.org/W2136327713","https://openalex.org/W2139202656","https://openalex.org/W2143661363","https://openalex.org/W2145618437","https://openalex.org/W2146105230","https://openalex.org/W2147543351","https://openalex.org/W2149236697","https://openalex.org/W2153876009","https://openalex.org/W2154268919","https://openalex.org/W2158395308","https://openalex.org/W2161159055","https://openalex.org/W2162775068","https://openalex.org/W2162960800","https://openalex.org/W2165084107","https://openalex.org/W2165382777","https://openalex.org/W2165467455","https://openalex.org/W2168787502","https://openalex.org/W2170577595","https://openalex.org/W2171844899","https://openalex.org/W2185907055","https://openalex.org/W2266068989","https://openalex.org/W2269738476","https://openalex.org/W2288244345","https://openalex.org/W2294628582","https://openalex.org/W2294895571","https://openalex.org/W2412440871","https://openalex.org/W2435937086","https://openalex.org/W2903158431","https://openalex.org/W2951100097","https://openalex.org/W2987907651","https://openalex.org/W3085162807","https://openalex.org/W3138367763","https://openalex.org/W3146075203","https://openalex.org/W4210732998","https://openalex.org/W4253960100","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2554271401","https://openalex.org/W4244527061","https://openalex.org/W2556786504","https://openalex.org/W2406556739","https://openalex.org/W2152149667","https://openalex.org/W2186703450","https://openalex.org/W175663584","https://openalex.org/W2413368787","https://openalex.org/W3125756434","https://openalex.org/W4242370757"],"abstract_inverted_index":{"Database":[0],"management":[1,49,84,132],"systems":[2,85,119,133,158,177,196],"(DBMS)":[3],"typically":[4],"provide":[5,159],"an":[6],"application":[7,93,113],"programming":[8],"interface":[9],"for":[10,27,91,111],"users":[11,46,106],"to":[12,58,72,121,164,197],"issue":[13,55],"queries":[14,56,67,110],"using":[15,179],"query":[16,79,127,148],"languages":[17,23,80],"such":[18,22,118,157],"as":[19],"SQL.":[20],"Many":[21],"were":[24],"originally":[25],"designed":[26],"business":[28],"data":[29,48,63,70],"processing":[30],"applications.":[31],"While":[32],"these":[33,92],"applications":[34,42,53],"are":[35,86,142],"still":[36],"relevant,":[37],"two":[38],"other":[39,191],"classes":[40],"of":[41,47,102,117,137,176],"have":[43],"become":[44],"important":[45],"systems:":[50],"(a)":[51],"web":[52],"that":[54,68,104,141,156],"programmatically":[57],"the":[59,123,135,152,161],"DBMS,":[60],"and":[61,134,160,183,190],"(b)":[62],"analytics":[64],"involving":[65],"complex":[66],"allow":[69],"scientists":[71],"better":[73],"understand":[74],"their":[75],"datasets.":[76],"Unfortunately,":[77],"existing":[78,147],"provided":[81,129],"by":[82,130,146],"database":[83,109,131],"often":[87],"far":[88],"from":[89],"ideal":[90],"domains.":[94,114],"In":[95,168],"this":[96],"tutorial,":[97],"we":[98,170],"describe":[99],"a":[100,173],"set":[101],"technologies":[103],"assist":[105],"in":[107,187,194],"specifying":[108],"different":[112,138,153],"The":[115],"goal":[116],"is":[120],"bridge":[122],"gap":[124],"between":[125],"current":[126],"interfaces":[128],"needs":[136],"usage":[139],"scenarios":[140],"not":[143],"well":[144],"served":[145],"languages.":[149],"We":[150],"discuss":[151,185],"interaction":[154],"modes":[155],"algorithms":[162],"used":[163,193],"infer":[165,198],"user":[166,199],"queries.":[167,200],"particular,":[169],"focus":[171],"on":[172],"new":[174],"class":[175],"built":[178],"program":[180],"synthesis":[181,189],"techniques,":[182],"furthermore":[184],"opportunities":[186],"combining":[188],"methods":[192],"prior":[195]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":2}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}