{"id":"https://openalex.org/W4400909754","doi":"https://doi.org/10.1109/icde60146.2024.00407","title":"A Comprehensive Tutorial on Over 100 Years of Diagrammatic Representations of Logical Statements and Relational Queries","display_name":"A Comprehensive Tutorial on Over 100 Years of Diagrammatic Representations of Logical Statements and Relational Queries","alternate_titles":[],"publication_year":2024,"publication_date":"2024-05-13","ids":{"openalex":"https://openalex.org/W4400909754","doi":"https://doi.org/10.1109/icde60146.2024.00407"},"language":"en","primary_location":{"id":"doi:10.1109/icde60146.2024.00407","doi":"https://doi.org/10.1109/icde60146.2024.00407","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde60146.2024.00407","pdf_url":null,"source":{"id":"https://openalex.org/S4210210321","display_name":"IEEE International Conference on Data Engineering (ICDE)","issn_l":"1084-4627","issn":["1084-4627","2375-0286"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","norway-2"],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 IEEE 40th International Conference on Data Engineering (ICDE)","raw_type":"proceedings-article"},"parent_works":[],"lineage":["https://openalex.org/W4400909754"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"indexed_in":["arxiv","crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2404.00007","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5086781628","display_name":"Wolfgang Gatterbauer","orcid":"https://orcid.org/0000-0002-9614-0504","observed_orcids":["https://orcid.org/0000-0002-9614-0504"]},"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,"contributor_roles":[],"raw_author_name":"Wolfgang Gatterbauer","raw_affiliation_strings":["Northeastern University,Boston,USA"],"raw_orcid":"https://orcid.org/0000-0002-9614-0504","affiliations":[{"raw_affiliation_string":"Northeastern University,Boston,USA","institution_ids":["https://openalex.org/I12912129"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5086781628"],"corresponding_institution_ids":["https://openalex.org/I12912129"],"apc_list":null,"apc_paid":null,"fwci":1.2737,"has_fulltext":true,"cited_by_count":8,"citation_normalized_percentile":{"value":0.83866658,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":86,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"5387","last_page":"5392"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.4880000054836273,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.4880000054836273,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.19679999351501465,"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/T10799","display_name":"Data Visualization and Analytics","score":0.1679999977350235,"subfield":{"id":"https://openalex.org/subfields/1704","display_name":"Computer Graphics and Computer-Aided Design"},"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/diagrammatic-representation","display_name":"diagrammatic representation","score":0.7820000052452087},{"id":"https://openalex.org/keywords/relational-database-queries","display_name":"relational queries","score":0.8370000123977661},{"id":"https://openalex.org/keywords/visual-metaphor","display_name":"visual metaphor","score":0.9599999785423279},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"relational algebra","score":0.746999979019165},{"id":"https://openalex.org/keywords/relational-calculus","display_name":"relational calculus","score":1.0},{"id":"https://openalex.org/keywords/logical-statements","display_name":"logical statements","score":0.7979999780654907},{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.593999981880188},{"id":"https://openalex.org/keywords/diagrammatic-reasoning","display_name":"diagrammatic reasoning","score":0.6859999895095825},{"id":"https://openalex.org/keywords/query-understanding","display_name":"query understanding","score":0.6570000052452087},{"id":"https://openalex.org/keywords/visual-alphabet","display_name":"visual alphabet","score":0.574999988079071}],"concepts":[{"id":"https://openalex.org/C106624574","wikidata":"https://www.wikidata.org/wiki/Q5270387","display_name":"Diagrammatic reasoning","level":2,"score":0.9842468500137329},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6908628344535828},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4580307602882385},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4121449291706085},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.14822420477867126}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1109/icde60146.2024.00407","doi":"https://doi.org/10.1109/icde60146.2024.00407","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde60146.2024.00407","pdf_url":null,"source":{"id":"https://openalex.org/S4210210321","display_name":"IEEE International Conference on Data Engineering (ICDE)","issn_l":"1084-4627","issn":["1084-4627","2375-0286"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","norway-2"],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 IEEE 40th International Conference on Data Engineering (ICDE)","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:2404.00007","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2404.00007","pdf_url":"https://arxiv.org/pdf/2404.00007","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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"},{"id":"doi:10.48550/arxiv.2404.00007","doi":"https://doi.org/10.48550/arxiv.2404.00007","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2404.00007","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2404.00007","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2404.00007","pdf_url":"https://arxiv.org/pdf/2404.00007","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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"},"sustainable_development_goals":[],"study_designs":[],"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/G6671297155","display_name":null,"funder_award_id":"CAREER","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G6745713617","display_name":"III: Medium: Table-as-Query: Unifying Data Discovery and Alignment","funder_award_id":"1956096","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"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4400909754.pdf","grobid_xml":"https://content.openalex.org/works/W4400909754.grobid-xml"},"referenced_works_count":65,"referenced_works":["https://openalex.org/W1484550926","https://openalex.org/W1497040040","https://openalex.org/W1519179082","https://openalex.org/W1530810966","https://openalex.org/W1553791847","https://openalex.org/W1555213554","https://openalex.org/W1820567211","https://openalex.org/W1964523235","https://openalex.org/W1970199721","https://openalex.org/W1973644634","https://openalex.org/W1976661258","https://openalex.org/W1986781756","https://openalex.org/W1987269142","https://openalex.org/W2000117114","https://openalex.org/W2016762800","https://openalex.org/W2021151230","https://openalex.org/W2032133388","https://openalex.org/W2064437404","https://openalex.org/W2064650227","https://openalex.org/W2067860008","https://openalex.org/W2069715000","https://openalex.org/W2072031888","https://openalex.org/W2090253867","https://openalex.org/W2095026299","https://openalex.org/W2098961002","https://openalex.org/W2103219113","https://openalex.org/W2113226793","https://openalex.org/W2126770007","https://openalex.org/W2131385151","https://openalex.org/W2150147167","https://openalex.org/W2169434017","https://openalex.org/W2169977585","https://openalex.org/W2275166338","https://openalex.org/W2294695527","https://openalex.org/W2440649536","https://openalex.org/W2495775601","https://openalex.org/W2598209472","https://openalex.org/W2612867423","https://openalex.org/W2795442664","https://openalex.org/W2948919184","https://openalex.org/W2969874558","https://openalex.org/W3019871180","https://openalex.org/W3023361615","https://openalex.org/W3049052537","https://openalex.org/W3125698088","https://openalex.org/W3204059120","https://openalex.org/W3209496184","https://openalex.org/W4237977449","https://openalex.org/W4239726313","https://openalex.org/W4242740768","https://openalex.org/W4245569780","https://openalex.org/W4281754096","https://openalex.org/W4289533774","https://openalex.org/W4289785104","https://openalex.org/W4293819888","https://openalex.org/W4300645984","https://openalex.org/W4300821576","https://openalex.org/W4300928490","https://openalex.org/W4313477803","https://openalex.org/W4386081274","https://openalex.org/W4390810167","https://openalex.org/W4396571402","https://openalex.org/W4399889354","https://openalex.org/W6769930741","https://openalex.org/W7097247227"],"related_works":["https://openalex.org/W4386081274","https://openalex.org/W3019871180","https://openalex.org/W4402348676","https://openalex.org/W4390810167","https://openalex.org/W4409918237","https://openalex.org/W7202344687","https://openalex.org/W4405309087","https://openalex.org/W4221160504","https://openalex.org/W2065132606","https://openalex.org/W6962297381"],"abstract_inverted_index":{"Query":[0],"formulation":[1],"is":[2,29],"increasingly":[3],"performed":[4],"by":[5,147],"systems":[6,155],"that":[7,25,39,68,79],"need":[8],"to":[9,32,64,156],"guess":[10],"a":[11,22,66,136],"user's":[12],"intent":[13],"(e.g.":[14],"via":[15],"spoken":[16],"word":[17],"interfaces).":[18],"But":[19],"how":[20,46],"can":[21,42,47],"user":[23],"know":[24],"the":[26,33,61,70,73,89,105,109,117,129,145,149,157],"computational":[27],"agent":[28],"returning":[30],"answers":[31],"\u201cright\u201d":[34],"query?":[35],"More":[36],"generally,":[37],"given":[38],"relational":[40,52,74,83,101,106,126],"queries":[41],"become":[43],"pretty":[44],"complicated,":[45],"we":[48],"help":[49,80],"users":[50,81],"understand":[51,82],"queries,":[53,127],"whether":[54],"human-generated":[55],"or":[56],"automatically":[57],"generated?":[58],"Now":[59],"seems":[60],"right":[62],"moment":[63],"revisit":[65],"topic":[67],"predates":[69],"birth":[71],"of":[72,97,121,125,138,152,161],"model:":[75],"developing":[76],"visual":[77,91,131,150],"metaphors":[78,92,132],"queries.":[84],"This":[85],"lecture-style":[86],"tutorial":[87],"surveys":[88],"key":[90,130],"developed":[93,133],"for":[94],"diagrammatic":[95,112,123,153],"representations":[96,124],"logical":[98],"statements":[99],"and":[100,108,119,143,159,165],"expressions,":[102],"across":[103],"both":[104],"database":[107],"much":[110],"older":[111],"reasoning":[113],"communities.":[114],"We":[115],"survey":[116],"history":[118],"state-of-the-art":[120],"relationally-complete":[122],"discuss":[128],"in":[134],"over":[135],"century":[137],"investigations":[139],"into":[140],"dia-grammatic":[141],"languages,":[142],"organize":[144],"landscape":[146],"mapping":[148],"alphabets":[151],"representation":[154],"syntax":[158],"semantics":[160],"Relational":[162,166],"Algebra":[163],"(RA)":[164],"Calculus":[167],"(RC).":[168],"Tutorial":[169],"website:":[170],"https://northeastern-datalab.github.io/diagrammatic-representation-tutorial/":[171]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4400909754","counts_by_year":[{"year":2026,"cited_by_count":4},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":1}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2024-07-24T00:00:00"}
