{"id":"https://openalex.org/W4221160504","doi":"https://doi.org/10.48550/arxiv.2203.07284","title":"Relational Diagrams: a pattern-preserving diagrammatic representation of non-disjunctive Relational Queries","display_name":"Relational Diagrams: a pattern-preserving diagrammatic representation of non-disjunctive Relational Queries","publication_year":2022,"publication_date":"2022-03-14","ids":{"openalex":"https://openalex.org/W4221160504","doi":"https://doi.org/10.48550/arxiv.2203.07284"},"language":"en","primary_location":{"id":"pmh:oai:arXiv.org:2203.07284","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2203.07284","pdf_url":"https://arxiv.org/pdf/2203.07284","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":"","raw_type":null},"type":"preprint","indexed_in":["arxiv","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2203.07284","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"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Gatterbauer, Wolfgang","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063230893","display_name":"Cody Dunne","orcid":"https://orcid.org/0000-0002-1609-9776"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Dunne, Cody","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5049802784","display_name":"Mirek Riedewald","orcid":"https://orcid.org/0000-0002-6102-7472"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Riedewald, Mirek","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5086781628"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"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.9994999766349792,"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.9994999766349792,"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/T11106","display_name":"Data Management and Algorithms","score":0.9864000082015991,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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.9828000068664551,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/diagrammatic-reasoning","display_name":"Diagrammatic reasoning","score":0.8317384719848633},{"id":"https://openalex.org/keywords/relational-calculus","display_name":"Relational calculus","score":0.73153156042099},{"id":"https://openalex.org/keywords/codds-theorem","display_name":"Codd's theorem","score":0.6980462670326233},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.658918559551239},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5866960287094116},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"Relational algebra","score":0.5534225702285767},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.552456259727478},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4774256646633148},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.44878390431404114},{"id":"https://openalex.org/keywords/fragment","display_name":"Fragment (logic)","score":0.4486449360847473},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.40338531136512756},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.28287187218666077},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.21222278475761414}],"concepts":[{"id":"https://openalex.org/C106624574","wikidata":"https://www.wikidata.org/wiki/Q5270387","display_name":"Diagrammatic reasoning","level":2,"score":0.8317384719848633},{"id":"https://openalex.org/C99436015","wikidata":"https://www.wikidata.org/wiki/Q1722436","display_name":"Relational calculus","level":4,"score":0.73153156042099},{"id":"https://openalex.org/C16739119","wikidata":"https://www.wikidata.org/wiki/Q5139948","display_name":"Codd's theorem","level":5,"score":0.6980462670326233},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.658918559551239},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5866960287094116},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.5534225702285767},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.552456259727478},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4774256646633148},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.44878390431404114},{"id":"https://openalex.org/C2776235265","wikidata":"https://www.wikidata.org/wiki/Q18392052","display_name":"Fragment (logic)","level":2,"score":0.4486449360847473},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.40338531136512756},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.28287187218666077},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.21222278475761414}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:arXiv.org:2203.07284","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2203.07284","pdf_url":"https://arxiv.org/pdf/2203.07284","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":"","raw_type":null},{"id":"doi:10.48550/arxiv.2203.07284","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2203.07284","pdf_url":null,"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":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2203.07284","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2203.07284","pdf_url":"https://arxiv.org/pdf/2203.07284","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":"","raw_type":null},"sustainable_development_goals":[{"score":0.6899999976158142,"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2089781037","https://openalex.org/W2085988990","https://openalex.org/W2005835473","https://openalex.org/W2056340443","https://openalex.org/W2095263945","https://openalex.org/W2243465518","https://openalex.org/W1516375613","https://openalex.org/W1969375478","https://openalex.org/W3174970460","https://openalex.org/W206482712"],"abstract_inverted_index":{"Analyzing":[0],"relational":[1,22,39,69,84,105,116,130,153,160],"languages":[2,86,93],"by":[3],"their":[4,43,46],"logical":[5,96,143,181],"expressiveness":[6,82,97],"is":[7,17,133,168,173],"well":[8,12],"understood.":[9],"Something":[10],"not":[11,134],"understood":[13],"or":[14,48],"even":[15],"formalized":[16],"the":[18,56,68,79,112,146,169,184],"vague":[19],"concept":[20,57],"of":[21,42,58,64,71,83,92,115,128,151],"query":[23,27,35,59,85],"patterns.":[24],"What":[25],"are":[26,164],"patterns?":[28],"And":[29],"how":[30],"can":[31,107,139,178],"we":[32,54,163],"reason":[33],"about":[34],"patterns":[36,60,110,144,182],"across":[37],"different":[38,99],"languages,":[40],"irrespective":[41],"syntax":[44],"and":[45,87,124,148,176],"procedural":[47],"declarative":[49],"nature?":[50],"In":[51,102],"this":[52,103,167],"paper,":[53],"formalize":[55],"with":[61,94],"a":[62,90],"variant":[63],"pattern-preserving":[65],"mappings":[66],"between":[67],"atoms":[70],"queries.":[72],"This":[73],"formalism":[74],"allows":[75],"us":[76],"to":[77,88],"analyze":[78],"relative":[80],"pattern":[81,100],"create":[89],"hierarchy":[91],"equal":[95],"yet":[98],"expressiveness.":[101],"analysis,":[104],"calculus":[106,131],"expressive":[108],"more":[109],"than":[111],"basic":[113],"operators":[114],"algebra.":[117],"We":[118],"additionally":[119],"contribute":[120],"an":[121],"intuitive,":[122],"complete,":[123,137],"sound":[125],"diagrammatic":[126,157],"representation":[127],"safe":[129],"that":[132,162,172,177],"only":[135,170],"relationally":[136,174],"but":[138],"also":[140],"express":[141],"all":[142,156,180],"for":[145,159],"large":[147],"useful":[149],"fragment":[150],"non-disjunctive":[152,185],"calculus.":[154],"Among":[155],"representations":[158],"queries":[161],"aware":[165],"of,":[166],"one":[171],"complete":[175],"represent":[179],"in":[183],"fragment.":[186]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1}],"updated_date":"2025-11-06T06:51:31.235846","created_date":"2025-10-10T00:00:00"}