{"id":"https://openalex.org/W2071285637","doi":"https://doi.org/10.1007/bf02074878","title":"Inferring null join dependencies in relational databases","display_name":"Inferring null join dependencies in relational databases","publication_year":1992,"publication_date":"1992-09-01","ids":{"openalex":"https://openalex.org/W2071285637","doi":"https://doi.org/10.1007/bf02074878","mag":"2071285637"},"language":"en","primary_location":{"id":"doi:10.1007/bf02074878","is_oa":false,"landing_page_url":"https://doi.org/10.1007/bf02074878","pdf_url":null,"source":{"id":"https://openalex.org/S125499977","display_name":"BIT Numerical Mathematics","issn_l":"0006-3835","issn":["0006-3835","1572-9125"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"BIT","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/A5015725705","display_name":"Mark Levene","orcid":"https://orcid.org/0000-0001-8632-4732"},"institutions":[{"id":"https://openalex.org/I45129253","display_name":"University College London","ror":"https://ror.org/02jx3x895","country_code":"GB","type":"education","lineage":["https://openalex.org/I124357947","https://openalex.org/I45129253"]},{"id":"https://openalex.org/I98259816","display_name":"Birkbeck, University of London","ror":"https://ror.org/02mb95055","country_code":"GB","type":"education","lineage":["https://openalex.org/I124357947","https://openalex.org/I98259816"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Mark Levene","raw_affiliation_strings":["Department of Computer Science, Birkbeck College, Malet Street, WC1E 7HX, London, UK","Department of Computer Science, University College London, Gower Street, WC1E 6BT, London, UK","Department of Computer Science, University College London, London, UK","Department of Computer Science, Birkbeck College, London, UK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Birkbeck College, Malet Street, WC1E 7HX, London, UK","institution_ids":["https://openalex.org/I98259816"]},{"raw_affiliation_string":"Department of Computer Science, University College London, Gower Street, WC1E 6BT, London, UK","institution_ids":["https://openalex.org/I45129253"]},{"raw_affiliation_string":"Department of Computer Science, University College London, London, UK","institution_ids":["https://openalex.org/I45129253"]},{"raw_affiliation_string":"Department of Computer Science, Birkbeck College, London, UK","institution_ids":["https://openalex.org/I98259816"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5024905226","display_name":"George Loizou","orcid":"https://orcid.org/0000-0002-9376-9243"},"institutions":[{"id":"https://openalex.org/I45129253","display_name":"University College London","ror":"https://ror.org/02jx3x895","country_code":"GB","type":"education","lineage":["https://openalex.org/I124357947","https://openalex.org/I45129253"]},{"id":"https://openalex.org/I98259816","display_name":"Birkbeck, University of London","ror":"https://ror.org/02mb95055","country_code":"GB","type":"education","lineage":["https://openalex.org/I124357947","https://openalex.org/I98259816"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"George Loizou","raw_affiliation_strings":["Department of Computer Science, Birkbeck College, Malet Street, WC1E 7HX, London, UK","Department of Computer Science, University College London, Gower Street, WC1E 6BT, London, UK","Department of Computer Science, University College London, London, UK","Department of Computer Science, Birkbeck College, London, UK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Birkbeck College, Malet Street, WC1E 7HX, London, UK","institution_ids":["https://openalex.org/I98259816"]},{"raw_affiliation_string":"Department of Computer Science, University College London, Gower Street, WC1E 6BT, London, UK","institution_ids":["https://openalex.org/I45129253"]},{"raw_affiliation_string":"Department of Computer Science, University College London, London, UK","institution_ids":["https://openalex.org/I45129253"]},{"raw_affiliation_string":"Department of Computer Science, Birkbeck College, London, UK","institution_ids":["https://openalex.org/I98259816"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":{"value":2390,"currency":"EUR","value_usd":2990},"apc_paid":null,"fwci":0.9813,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.79263991,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"32","issue":"3","first_page":"413","last_page":"429"},"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.9997000098228455,"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.9997000098228455,"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/T11719","display_name":"Data Quality and Management","score":0.9968000054359436,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.996399998664856,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/null","display_name":"Null (SQL)","score":0.7980011105537415},{"id":"https://openalex.org/keywords/dependency-theory","display_name":"Dependency theory (database theory)","score":0.78514564037323},{"id":"https://openalex.org/keywords/decidability","display_name":"Decidability","score":0.7566252946853638},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.7122648358345032},{"id":"https://openalex.org/keywords/chase","display_name":"Chase","score":0.679288387298584},{"id":"https://openalex.org/keywords/inference","display_name":"Inference","score":0.6723355054855347},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6254184246063232},{"id":"https://openalex.org/keywords/functional-dependency","display_name":"Functional dependency","score":0.5965141654014587},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.4889920949935913},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.46131110191345215},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4533103108406067},{"id":"https://openalex.org/keywords/dependency","display_name":"Dependency (UML)","score":0.43451613187789917},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.33892297744750977},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.33269351720809937},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3292495608329773},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.20089614391326904},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.19889631867408752},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.09532493352890015}],"concepts":[{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.7980011105537415},{"id":"https://openalex.org/C40683218","wikidata":"https://www.wikidata.org/wiki/Q5260625","display_name":"Dependency theory (database theory)","level":4,"score":0.78514564037323},{"id":"https://openalex.org/C153269930","wikidata":"https://www.wikidata.org/wiki/Q430001","display_name":"Decidability","level":2,"score":0.7566252946853638},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.7122648358345032},{"id":"https://openalex.org/C131924884","wikidata":"https://www.wikidata.org/wiki/Q5087085","display_name":"Chase","level":2,"score":0.679288387298584},{"id":"https://openalex.org/C2776214188","wikidata":"https://www.wikidata.org/wiki/Q408386","display_name":"Inference","level":2,"score":0.6723355054855347},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6254184246063232},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.5965141654014587},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4889920949935913},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.46131110191345215},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4533103108406067},{"id":"https://openalex.org/C19768560","wikidata":"https://www.wikidata.org/wiki/Q320727","display_name":"Dependency (UML)","level":2,"score":0.43451613187789917},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.33892297744750977},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.33269351720809937},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3292495608329773},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.20089614391326904},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.19889631867408752},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.09532493352890015}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1007/bf02074878","is_oa":false,"landing_page_url":"https://doi.org/10.1007/bf02074878","pdf_url":null,"source":{"id":"https://openalex.org/S125499977","display_name":"BIT Numerical Mathematics","issn_l":"0006-3835","issn":["0006-3835","1572-9125"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"BIT","raw_type":"journal-article"},{"id":"pmh:oai:eprints.bbk.ac.uk.oai2:44740","is_oa":false,"landing_page_url":"https://eprints.bbk.ac.uk/id/eprint/44740/","pdf_url":null,"source":{"id":"https://openalex.org/S4306400466","display_name":"BIROn (Birkbeck, University of London)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I98259816","host_organization_name":"Birkbeck, University of London","host_organization_lineage":["https://openalex.org/I98259816"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4399999976158142,"id":"https://metadata.un.org/sdg/10","display_name":"Reduced inequalities"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W63514999","https://openalex.org/W1564646625","https://openalex.org/W1774916018","https://openalex.org/W1971247055","https://openalex.org/W1975057558","https://openalex.org/W1977825979","https://openalex.org/W1978775628","https://openalex.org/W1985581502","https://openalex.org/W1990391007","https://openalex.org/W2008296878","https://openalex.org/W2028222220","https://openalex.org/W2056147406","https://openalex.org/W2059144726","https://openalex.org/W2061407262","https://openalex.org/W2066837227","https://openalex.org/W2089954064","https://openalex.org/W2104498537","https://openalex.org/W2111304450","https://openalex.org/W2162621793","https://openalex.org/W2162715748","https://openalex.org/W2912355966","https://openalex.org/W4213061376"],"related_works":["https://openalex.org/W1968137129","https://openalex.org/W2125223317","https://openalex.org/W2177745035","https://openalex.org/W1985581502","https://openalex.org/W1992305137","https://openalex.org/W4205505456","https://openalex.org/W2592732175","https://openalex.org/W1484388782","https://openalex.org/W1989849441","https://openalex.org/W2098395122"],"abstract_inverted_index":null,"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}