{"id":"https://openalex.org/W2145589985","doi":"https://doi.org/10.1145/582192.582222","title":"Incomplete information and dependencies in relational databases","display_name":"Incomplete information and dependencies in relational databases","alternate_titles":[],"publication_year":1983,"publication_date":"1983-01-01","ids":{"openalex":"https://openalex.org/W2145589985","doi":"https://doi.org/10.1145/582192.582222","mag":"2145589985"},"language":"en","primary_location":{"id":"doi:10.1145/582192.582222","doi":"https://doi.org/10.1145/582192.582222","is_oa":true,"landing_page_url":"https://doi.org/10.1145/582192.582222","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/971695.582222","source":{"id":"https://openalex.org/S4393915683","display_name":"ACM SIGMOD International Conference on Management of Data (SIGMOD)","issn_l":"0730-8078","issn":["0730-8078"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1983 ACM SIGMOD international conference on Management of data - SIGMOD '83","raw_type":"proceedings-article"},"parent_works":[],"lineage":["https://openalex.org/W2145589985"],"child_works_count":0,"type":"conference-abstract","is_traditional":false,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.1145/971695.582222","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5033451922","display_name":"Tomasz Imieli\u0144ski","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I5023651","display_name":"McGill University","ror":"https://ror.org/01pxwe438","country_code":"CA","type":"education","lineage":["https://openalex.org/I5023651"]}],"countries":["CA"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Tomasz Imielinski","raw_affiliation_strings":["McGill University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"McGill University","institution_ids":["https://openalex.org/I5023651"]}]},{"author_position":"last","author":{"id":null,"display_name":"Witold Lipski","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I99542240","display_name":"Polish Academy of Sciences","ror":"https://ror.org/01dr6c206","country_code":"PL","type":"government","lineage":["https://openalex.org/I99542240"]}],"countries":["PL"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Witold Lipski","raw_affiliation_strings":["Polish Academy of Science"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Polish Academy of Science","institution_ids":["https://openalex.org/I99542240"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":48,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"178","last_page":"178"},"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.9940999746322632,"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.9940999746322632,"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.0010999999940395355,"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/T11719","display_name":"Data Quality and Management","score":0.0006000000284984708,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/incomplete-information","display_name":"incomplete information","score":0.9139999747276306},{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.7749999761581421},{"id":"https://openalex.org/keywords/null-values","display_name":"null values","score":0.8489999771118164},{"id":"https://openalex.org/keywords/data-dependencies","display_name":"data dependencies","score":0.9470000267028809},{"id":"https://openalex.org/keywords/query-languages","display_name":"query languages","score":0.7409999966621399},{"id":"https://openalex.org/keywords/natural-join","display_name":"natural join","score":0.5630000233650208},{"id":"https://openalex.org/keywords/projection","display_name":"projection","score":0.6480000019073486},{"id":"https://openalex.org/keywords/positive-selection","display_name":"positive selection","score":0.5220000147819519},{"id":"https://openalex.org/keywords/information-loss","display_name":"information loss","score":0.3190000057220459}],"concepts":[{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.7019080519676208},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6794429421424866},{"id":"https://openalex.org/C2185349","wikidata":"https://www.wikidata.org/wiki/Q190558","display_name":"Negation","level":2,"score":0.6304522752761841},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.5765237808227539},{"id":"https://openalex.org/C40683218","wikidata":"https://www.wikidata.org/wiki/Q5260625","display_name":"Dependency theory (database theory)","level":4,"score":0.5558237433433533},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.553966224193573},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.5416823029518127},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.532921314239502},{"id":"https://openalex.org/C189950617","wikidata":"https://www.wikidata.org/wiki/Q937228","display_name":"Property (philosophy)","level":2,"score":0.45923882722854614},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.44636109471321106},{"id":"https://openalex.org/C57493831","wikidata":"https://www.wikidata.org/wiki/Q3134666","display_name":"Projection (relational algebra)","level":2,"score":0.4381087124347687},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.43623268604278564},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4038788676261902},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.35442304611206055},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.25330740213394165},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.23289284110069275},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/582192.582222","doi":"https://doi.org/10.1145/582192.582222","is_oa":true,"landing_page_url":"https://doi.org/10.1145/582192.582222","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/971695.582222","source":{"id":"https://openalex.org/S4393915683","display_name":"ACM SIGMOD International Conference on Management of Data (SIGMOD)","issn_l":"0730-8078","issn":["0730-8078"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1983 ACM SIGMOD international conference on Management of data - SIGMOD '83","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/582192.582222","doi":"https://doi.org/10.1145/582192.582222","is_oa":true,"landing_page_url":"https://doi.org/10.1145/582192.582222","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/971695.582222","source":{"id":"https://openalex.org/S4393915683","display_name":"ACM SIGMOD International Conference on Management of Data (SIGMOD)","issn_l":"0730-8078","issn":["0730-8078"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1983 ACM SIGMOD international conference on Management of data - SIGMOD '83","raw_type":"proceedings-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2145589985.pdf","grobid_xml":"https://content.openalex.org/works/W2145589985.grobid-xml"},"referenced_works_count":8,"referenced_works":["https://openalex.org/W101983502","https://openalex.org/W1590469553","https://openalex.org/W1985581502","https://openalex.org/W2033652334","https://openalex.org/W2047929536","https://openalex.org/W2059693475","https://openalex.org/W2489748212","https://openalex.org/W4212886450"],"related_works":["https://openalex.org/W2098395122","https://openalex.org/W7095448595","https://openalex.org/W2118045020","https://openalex.org/W2079132386","https://openalex.org/W2071285637","https://openalex.org/W2001946655","https://openalex.org/W1969833016","https://openalex.org/W1824625974","https://openalex.org/W2142864156","https://openalex.org/W4252436487"],"abstract_inverted_index":{"An":[0],"incomplete":[1],"information":[2,9,20,62,91],"relational":[3],"database":[4],"combines":[5],"two":[6],"types":[7],"of":[8,90,103,118,131,134],"about":[10],"the":[11,16,19,35,45,50,71,88,97,101,127,139],"real":[12,46],"world":[13],"modeled":[14],"by":[15,22],"database:":[17],"(a)":[18,67],"represented":[21],"tables":[23],"with":[24,141],"null":[25,142],"values":[26,143],"(\"value":[27],"not":[28,84],"known\")":[29],"allowed":[30],"as":[31,55,126],"entries,":[32],"and":[33,116],"(b)":[34,61],"data":[36,72],"dependencies,":[37,77],"which":[38,58],"are":[39,74],"known":[40,52],"to":[41],"be":[42,94,123],"satisfied":[43],"in":[44,110],"world.":[47],"We":[48],"view":[49,136],"well":[51],"chase":[53],"procedure":[54],"a":[56],"process":[57],"transforms":[59],"type":[60,66],"into":[63],"an":[64],"\"equivalent\"":[65],"form.":[68],"Assuming":[69],"that":[70,80],"dependencies":[73,137],"arbitrary":[75],"implicational":[76],"we":[78],"show":[79],"this":[81],"transformation":[82],"is":[83,144],"quite":[85],"equivalent,":[86],"but":[87],"corruption":[89],"introduced":[92],"cannot":[93],"discovered":[95],"if":[96],"query":[98],"language":[99],"uses":[100],"operations":[102],"projection,":[104],"positive":[105],"selection":[106,111],"(i.e.":[107],"no":[108],"negation":[109],"condition),":[112],"union,":[113],"natural":[114],"join":[115],"renaming":[117],"attributes.":[119],"This":[120],"result":[121],"can":[122],"interpreted":[124],"also":[125,145],"new":[128],"important":[129],"property":[130],"chase.The":[132],"influence":[133],"so-called":[135],"on":[138],"table":[140],"examined.":[146]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2145589985","counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":3}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
