{"id":"https://openalex.org/W3019871180","doi":"https://doi.org/10.1145/3318464.3389767","title":"QueryVis: Logic-based Diagrams help Users Understand Complicated SQL Queries Faster","display_name":"QueryVis: Logic-based Diagrams help Users Understand Complicated SQL Queries Faster","publication_year":2020,"publication_date":"2020-05-29","ids":{"openalex":"https://openalex.org/W3019871180","doi":"https://doi.org/10.1145/3318464.3389767","mag":"3019871180"},"language":"en","primary_location":{"id":"doi:10.1145/3318464.3389767","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3318464.3389767","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3318464.3389767","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["arxiv","crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3318464.3389767","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Aristotelis Leventidis","orcid":null},"institutions":[{"id":"https://openalex.org/I12912129","display_name":"Northeastern University","ror":"https://ror.org/04t5xt781","country_code":"US","type":"education","lineage":["https://openalex.org/I12912129"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Aristotelis Leventidis","raw_affiliation_strings":["Northeastern University, Boston, MA, USA"],"affiliations":[{"raw_affiliation_string":"Northeastern University, Boston, MA, USA","institution_ids":["https://openalex.org/I12912129"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Jiahui Zhang","orcid":null},"institutions":[{"id":"https://openalex.org/I12912129","display_name":"Northeastern University","ror":"https://ror.org/04t5xt781","country_code":"US","type":"education","lineage":["https://openalex.org/I12912129"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jiahui Zhang","raw_affiliation_strings":["Northeastern University, Boston, MA, USA"],"affiliations":[{"raw_affiliation_string":"Northeastern University, Boston, MA, USA","institution_ids":["https://openalex.org/I12912129"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Cody Dunne","orcid":null},"institutions":[{"id":"https://openalex.org/I12912129","display_name":"Northeastern University","ror":"https://ror.org/04t5xt781","country_code":"US","type":"education","lineage":["https://openalex.org/I12912129"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Cody Dunne","raw_affiliation_strings":["Northeastern University, Boston, MA, USA"],"affiliations":[{"raw_affiliation_string":"Northeastern University, Boston, MA, USA","institution_ids":["https://openalex.org/I12912129"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Wolfgang Gatterbauer","orcid":null},"institutions":[{"id":"https://openalex.org/I12912129","display_name":"Northeastern University","ror":"https://ror.org/04t5xt781","country_code":"US","type":"education","lineage":["https://openalex.org/I12912129"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Wolfgang Gatterbauer","raw_affiliation_strings":["Northeastern University, Boston, MA, USA"],"affiliations":[{"raw_affiliation_string":"Northeastern University, Boston, MA, USA","institution_ids":["https://openalex.org/I12912129"]}]},{"author_position":"middle","author":{"id":null,"display_name":"H.V. Jagadish","orcid":null},"institutions":[{"id":"https://openalex.org/I27837315","display_name":"University of Michigan\u2013Ann Arbor","ror":"https://ror.org/00jmfr291","country_code":"US","type":"education","lineage":["https://openalex.org/I27837315"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"H.V. Jagadish","raw_affiliation_strings":["University of Michigan, Ann Arbor, MI, USA"],"affiliations":[{"raw_affiliation_string":"University of Michigan, Ann Arbor, MI, USA","institution_ids":["https://openalex.org/I27837315"]}]},{"author_position":"last","author":{"id":null,"display_name":"Mirek Riedewald","orcid":null},"institutions":[{"id":"https://openalex.org/I12912129","display_name":"Northeastern University","ror":"https://ror.org/04t5xt781","country_code":"US","type":"education","lineage":["https://openalex.org/I12912129"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mirek Riedewald","raw_affiliation_strings":["Northeastern University, Boston, MA, USA"],"affiliations":[{"raw_affiliation_string":"Northeastern University, Boston, MA, USA","institution_ids":["https://openalex.org/I12912129"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I12912129"],"apc_list":null,"apc_paid":null,"fwci":1.7666,"has_fulltext":true,"cited_by_count":34,"citation_normalized_percentile":{"value":0.8708763,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":96,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"2303","last_page":"2318"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10799","display_name":"Data Visualization and Analytics","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T10799","display_name":"Data Visualization and Analytics","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9710999727249146,"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"}},{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.965499997138977,"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/diagrammatic-reasoning","display_name":"Diagrammatic reasoning","score":0.7659000158309937},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.73580002784729},{"id":"https://openalex.org/keywords/meaning","display_name":"Meaning (existential)","score":0.4909999966621399},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4544000029563904},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.453000009059906},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.38580000400543213},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.3774000108242035},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.3684000074863434},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.34929999709129333}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8047000169754028},{"id":"https://openalex.org/C106624574","wikidata":"https://www.wikidata.org/wiki/Q5270387","display_name":"Diagrammatic reasoning","level":2,"score":0.7659000158309937},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.73580002784729},{"id":"https://openalex.org/C2780876879","wikidata":"https://www.wikidata.org/wiki/Q3054749","display_name":"Meaning (existential)","level":2,"score":0.4909999966621399},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4684000015258789},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4544000029563904},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.453000009059906},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.38580000400543213},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.3774000108242035},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.3684000074863434},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3635999858379364},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.34929999709129333},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.34360000491142273},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3400000035762787},{"id":"https://openalex.org/C527412718","wikidata":"https://www.wikidata.org/wiki/Q855395","display_name":"Interpretation (philosophy)","level":2,"score":0.3391999900341034},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.33489999175071716},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.30630001425743103},{"id":"https://openalex.org/C192328126","wikidata":"https://www.wikidata.org/wiki/Q4514647","display_name":"Schematic","level":2,"score":0.28540000319480896},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.2847999930381775},{"id":"https://openalex.org/C99436015","wikidata":"https://www.wikidata.org/wiki/Q1722436","display_name":"Relational calculus","level":4,"score":0.28119999170303345},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.26899999380111694},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.2655999958515167},{"id":"https://openalex.org/C186399060","wikidata":"https://www.wikidata.org/wiki/Q959962","display_name":"Diagram","level":2,"score":0.26170000433921814},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.2614000141620636},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2572999894618988},{"id":"https://openalex.org/C150012506","wikidata":"https://www.wikidata.org/wiki/Q6031185","display_name":"Information schema","level":5,"score":0.25690001249313354},{"id":"https://openalex.org/C64357122","wikidata":"https://www.wikidata.org/wiki/Q1149766","display_name":"Causality (physics)","level":2,"score":0.25369998812675476},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.2517000138759613},{"id":"https://openalex.org/C2780878386","wikidata":"https://www.wikidata.org/wiki/Q1659648","display_name":"Visual language","level":2,"score":0.2515000104904175}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3318464.3389767","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3318464.3389767","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3318464.3389767","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:2004.11375","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2004.11375","pdf_url":"https://arxiv.org/pdf/2004.11375","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"}],"best_oa_location":{"id":"doi:10.1145/3318464.3389767","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3318464.3389767","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3318464.3389767","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G2699994585","display_name":"CAREER: Scaling Approximate Inference and Approximation-Aware Learning","funder_award_id":"1762268","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G4789595704","display_name":null,"funder_award_id":"OTA N000141890001","funder_id":"https://openalex.org/F4320338399","funder_display_name":"Office of Academic Research, U.S. Naval Academy"},{"id":"https://openalex.org/G4856071244","display_name":null,"funder_award_id":"CAREER IIS-1762268, ACI-1640575","funder_id":"https://openalex.org/F4320315254","funder_display_name":"Innovative Research Group Project of the National Natural Science Foundation of China"},{"id":"https://openalex.org/G5213409069","display_name":null,"funder_award_id":"CAREER IIS-1762268","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G5921281487","display_name":null,"funder_award_id":"number","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G6061594050","display_name":"CIF21 DIBBs: EI: Continuous Capture of Metadata for Statistical Data","funder_award_id":"1640575","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G6671297155","display_name":null,"funder_award_id":"CAREER","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G848032724","display_name":null,"funder_award_id":"Science","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G8940519433","display_name":null,"funder_award_id":"ACI-1640575","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320315254","display_name":"Innovative Research Group Project of the National Natural Science Foundation of China","ror":null},{"id":"https://openalex.org/F4320338399","display_name":"Office of Academic Research, U.S. Naval Academy","ror":null}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3019871180.pdf","grobid_xml":"https://content.openalex.org/works/W3019871180.grobid-xml"},"referenced_works_count":45,"referenced_works":["https://openalex.org/W884650706","https://openalex.org/W1527664624","https://openalex.org/W1994720930","https://openalex.org/W2003251288","https://openalex.org/W2032133388","https://openalex.org/W2042453489","https://openalex.org/W2047705935","https://openalex.org/W2057178786","https://openalex.org/W2060565253","https://openalex.org/W2071353749","https://openalex.org/W2073800769","https://openalex.org/W2095026299","https://openalex.org/W2098961002","https://openalex.org/W2102449305","https://openalex.org/W2103219113","https://openalex.org/W2110065044","https://openalex.org/W2114877339","https://openalex.org/W2126354234","https://openalex.org/W2126728600","https://openalex.org/W2127875809","https://openalex.org/W2132516581","https://openalex.org/W2132881639","https://openalex.org/W2136530502","https://openalex.org/W2142493242","https://openalex.org/W2185907055","https://openalex.org/W2286501037","https://openalex.org/W2293040502","https://openalex.org/W2294695527","https://openalex.org/W2295144739","https://openalex.org/W2336392079","https://openalex.org/W2398042895","https://openalex.org/W2401893145","https://openalex.org/W2408017125","https://openalex.org/W2416272719","https://openalex.org/W2468929674","https://openalex.org/W2471282380","https://openalex.org/W2659760177","https://openalex.org/W2783946743","https://openalex.org/W2890585661","https://openalex.org/W2943497741","https://openalex.org/W4229977739","https://openalex.org/W4250587856","https://openalex.org/W4252684946","https://openalex.org/W4293857795","https://openalex.org/W4300645984"],"related_works":[],"abstract_inverted_index":{"Understanding":[0],"the":[1,26,40,54,80,89,143,252],"meaning":[2,55,90],"of":[3,29,43,56,84,91,102,115,153,222,237,242],"existing":[4,150],"SQL":[5,15,63,85,194,223],"queries":[6,44,57,137,158,185],"is":[7,36,128],"critical":[8],"for":[9,22,251],"code":[10],"maintenance":[11],"and":[12,59,86,108,146,156,230,235,248,258],"reuse.":[13],"Yet":[14],"can":[16,50,87,224],"be":[17],"hard":[18],"to":[19,38,142,219,227],"read,":[20],"even":[21],"expert":[23],"users":[24,52,168],"or":[25],"original":[27],"creator":[28],"a":[30,99,112,160,177,228],"query.":[31],"We":[32,66,213],"conjecture":[33],"that":[34,49,71,76,124,134,174,200,215],"it":[35],"possible":[37],"capture":[39,88],"logical":[41],"intent":[42],"in":[45,70,106,123,133,159,205],"automatically-generated":[46],"visual":[47,74,126,151,202],"diagrams":[48,75,96,190,203],"help":[51],"understand":[53],"faster":[58,187],"more":[60,216,232],"accurately":[61],"than":[62,191,210],"text":[64],"alone.":[65,195],"present":[67],"initial":[68],"steps":[69],"direction":[72],"with":[73,138,175,188,211,245],"are":[77,121,131,261],"based":[78],"on":[79,169],"first-order":[81],"logic":[82,107],"foundation":[83],"deeply":[92],"nested":[93],"queries.":[94],"Our":[95],"build":[97],"upon":[98],"rich":[100],"history":[101],"diagrammatic":[103,220],"reasoning":[104],"systems":[105],"were":[109],"designed":[110],"using":[111],"large":[113],"body":[114],"human-computer":[116],"interaction":[117],"best":[118],"practices:":[119],"they":[120,130,147],"minimal":[122],"no":[125,135],"element":[127],"superfluous;":[129],"unambiguous":[132],"two":[136],"different":[139],"semantics":[140],"map":[141],"same":[144],"visualization;":[145],"extend":[148],"previously":[149],"representations":[152,221],"relational":[154],"schemata":[155],"conjunctive":[157],"natural":[161],"way.":[162],"An":[163],"experimental":[164,253],"evaluation":[165],"involving":[166],"42":[167],"Amazon":[170],"Mechanical":[171],"Turk":[172],"shows":[173],"only":[176],"2--3":[178],"minute":[179],"static":[180],"tutorial,":[181],"participants":[182,206],"could":[183],"interpret":[184],"meaningfully":[186],"our":[189,201],"when":[192],"reading":[193],"Moreover,":[196],"we":[197],"have":[198],"evidence":[199],"result":[204],"making":[207],"fewer":[208],"errors":[209],"SQL.":[212,238],"believe":[214],"regular":[217],"exposure":[218],"give":[225],"rise":[226],"pattern-based":[229],"thus":[231],"intuitive":[233],"use":[234],"re-use":[236],"A":[239],"full":[240],"version":[241],"this":[243],"paper":[244],"all":[246],"appendices":[247],"supplemental":[249],"material":[250],"study":[254],"(stimuli,":[255],"raw":[256],"data,":[257],"analysis":[259],"code)":[260],"available":[262],"at":[263],"https://osf.io/btszh.":[264]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":8},{"year":2024,"cited_by_count":7},{"year":2023,"cited_by_count":9},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":6}],"updated_date":"2026-04-14T08:04:32.555800","created_date":"2020-05-01T00:00:00"}