{"id":"https://openalex.org/W2026080208","doi":"https://doi.org/10.1016/s0020-0255(96)00201-0","title":"A unified treatment of null values using constraints","display_name":"A unified treatment of null values using constraints","publication_year":1997,"publication_date":"1997-05-01","ids":{"openalex":"https://openalex.org/W2026080208","doi":"https://doi.org/10.1016/s0020-0255(96)00201-0","mag":"2026080208"},"language":"en","primary_location":{"id":"doi:10.1016/s0020-0255(96)00201-0","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s0020-0255(96)00201-0","pdf_url":null,"source":{"id":"https://openalex.org/S192650101","display_name":"Information Sciences","issn_l":"0020-0255","issn":["0020-0255","1872-6291"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Sciences","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/A5003070145","display_name":"K. Sel\u00e7uk Candan","orcid":"https://orcid.org/0000-0003-4977-6646"},"institutions":[{"id":"https://openalex.org/I4322298","display_name":"Towson University","ror":"https://ror.org/044w7a341","country_code":"US","type":"education","lineage":["https://openalex.org/I4322298"]},{"id":"https://openalex.org/I66946132","display_name":"University of Maryland, College Park","ror":"https://ror.org/047s2c258","country_code":"US","type":"education","lineage":["https://openalex.org/I66946132"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"K. Sel\u00e7uk Candan","raw_affiliation_strings":["Department of Computer Science, University of Maryland, College Park, Maryland 20742, USA","Department of Computer and Information Sciences, Towson State University, Towson, Maryland 21204, USA","Department of Computer Science, University of Maryland, College Park, Maryland 20742, USA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Maryland, College Park, Maryland 20742, USA","institution_ids":["https://openalex.org/I66946132"]},{"raw_affiliation_string":"Department of Computer and Information Sciences, Towson State University, Towson, Maryland 21204, USA","institution_ids":["https://openalex.org/I4322298"]},{"raw_affiliation_string":"Department of Computer Science, University of Maryland, College Park, Maryland 20742, USA#TAB#","institution_ids":["https://openalex.org/I66946132"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5078922929","display_name":"John Grant","orcid":"https://orcid.org/0000-0001-7503-7703"},"institutions":[{"id":"https://openalex.org/I4322298","display_name":"Towson University","ror":"https://ror.org/044w7a341","country_code":"US","type":"education","lineage":["https://openalex.org/I4322298"]},{"id":"https://openalex.org/I66946132","display_name":"University of Maryland, College Park","ror":"https://ror.org/047s2c258","country_code":"US","type":"education","lineage":["https://openalex.org/I66946132"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"John Grant","raw_affiliation_strings":["Department of Computer Science, University of Maryland, College Park, Maryland 20742, USA","Department of Computer and Information Sciences, Towson State University, Towson, Maryland 21204, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Maryland, College Park, Maryland 20742, USA","institution_ids":["https://openalex.org/I66946132"]},{"raw_affiliation_string":"Department of Computer and Information Sciences, Towson State University, Towson, Maryland 21204, USA","institution_ids":["https://openalex.org/I4322298"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5038645035","display_name":"V. S. Subrahmanian","orcid":"https://orcid.org/0000-0001-7191-0296"},"institutions":[{"id":"https://openalex.org/I143663144","display_name":"Research Institute for Advanced Computer Science","ror":"https://ror.org/022qmyy53","country_code":"US","type":"facility","lineage":["https://openalex.org/I1329765538","https://openalex.org/I143663144"]},{"id":"https://openalex.org/I4322298","display_name":"Towson University","ror":"https://ror.org/044w7a341","country_code":"US","type":"education","lineage":["https://openalex.org/I4322298"]},{"id":"https://openalex.org/I66946132","display_name":"University of Maryland, College Park","ror":"https://ror.org/047s2c258","country_code":"US","type":"education","lineage":["https://openalex.org/I66946132"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"V.S. Subrahmanian","raw_affiliation_strings":["Department of Computer Science, Institute for Advanced Computer Studies and Institute for Systems Research, University of Maryland, College Park, Maryland 20742, USA","Department of Computer Science, University of Maryland, College Park, Maryland 20742, USA","Department of Computer and Information Sciences, Towson State University, Towson, Maryland 21204, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Institute for Advanced Computer Studies and Institute for Systems Research, University of Maryland, College Park, Maryland 20742, USA","institution_ids":["https://openalex.org/I143663144","https://openalex.org/I66946132"]},{"raw_affiliation_string":"Department of Computer Science, University of Maryland, College Park, Maryland 20742, USA","institution_ids":["https://openalex.org/I66946132"]},{"raw_affiliation_string":"Department of Computer and Information Sciences, Towson State University, Towson, Maryland 21204, USA","institution_ids":["https://openalex.org/I4322298"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":{"value":3330,"currency":"USD","value_usd":3330},"apc_paid":null,"fwci":0.4996,"has_fulltext":false,"cited_by_count":24,"citation_normalized_percentile":{"value":0.72872076,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"98","issue":"1-4","first_page":"99","last_page":"156"},"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.9994000196456909,"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.9994000196456909,"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9984999895095825,"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/T11106","display_name":"Data Management and Algorithms","score":0.9980999827384949,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/null","display_name":"Null (SQL)","score":0.9090789556503296},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.724678099155426},{"id":"https://openalex.org/keywords/null-model","display_name":"Null model","score":0.6843894720077515},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"Relational algebra","score":0.5974487066268921},{"id":"https://openalex.org/keywords/missing-data","display_name":"Missing data","score":0.5972656607627869},{"id":"https://openalex.org/keywords/null-hypothesis","display_name":"Null hypothesis","score":0.570742130279541},{"id":"https://openalex.org/keywords/operator","display_name":"Operator (biology)","score":0.5296083688735962},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5282261371612549},{"id":"https://openalex.org/keywords/relation","display_name":"Relation (database)","score":0.5160455703735352},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.4273780584335327},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.39109113812446594},{"id":"https://openalex.org/keywords/algebra-over-a-field","display_name":"Algebra over a field","score":0.38289740681648254},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.3739684820175171},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.34886258840560913},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.26503849029541016},{"id":"https://openalex.org/keywords/pure-mathematics","display_name":"Pure mathematics","score":0.2487977147102356},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2475104033946991},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.13662827014923096},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.1043846607208252},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.08944818377494812}],"concepts":[{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.9090789556503296},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.724678099155426},{"id":"https://openalex.org/C36382193","wikidata":"https://www.wikidata.org/wiki/Q7068966","display_name":"Null model","level":2,"score":0.6843894720077515},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.5974487066268921},{"id":"https://openalex.org/C9357733","wikidata":"https://www.wikidata.org/wiki/Q6878417","display_name":"Missing data","level":2,"score":0.5972656607627869},{"id":"https://openalex.org/C191988596","wikidata":"https://www.wikidata.org/wiki/Q628374","display_name":"Null hypothesis","level":2,"score":0.570742130279541},{"id":"https://openalex.org/C17020691","wikidata":"https://www.wikidata.org/wiki/Q139677","display_name":"Operator (biology)","level":5,"score":0.5296083688735962},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5282261371612549},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.5160455703735352},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.4273780584335327},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.39109113812446594},{"id":"https://openalex.org/C136119220","wikidata":"https://www.wikidata.org/wiki/Q1000660","display_name":"Algebra over a field","level":2,"score":0.38289740681648254},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3739684820175171},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.34886258840560913},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.26503849029541016},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.2487977147102356},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2475104033946991},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.13662827014923096},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.1043846607208252},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.08944818377494812},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C158448853","wikidata":"https://www.wikidata.org/wiki/Q425218","display_name":"Repressor","level":4,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C86339819","wikidata":"https://www.wikidata.org/wiki/Q407384","display_name":"Transcription factor","level":3,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1016/s0020-0255(96)00201-0","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s0020-0255(96)00201-0","pdf_url":null,"source":{"id":"https://openalex.org/S192650101","display_name":"Information Sciences","issn_l":"0020-0255","issn":["0020-0255","1872-6291"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Sciences","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":42,"referenced_works":["https://openalex.org/W63514999","https://openalex.org/W101983502","https://openalex.org/W189317106","https://openalex.org/W210289109","https://openalex.org/W1486310914","https://openalex.org/W1496815773","https://openalex.org/W1497921804","https://openalex.org/W1524670672","https://openalex.org/W1558832481","https://openalex.org/W1586944681","https://openalex.org/W1590628344","https://openalex.org/W1602383444","https://openalex.org/W1990391007","https://openalex.org/W1994581962","https://openalex.org/W2003017562","https://openalex.org/W2010272308","https://openalex.org/W2041605033","https://openalex.org/W2056093042","https://openalex.org/W2056147406","https://openalex.org/W2056177422","https://openalex.org/W2066837227","https://openalex.org/W2091433498","https://openalex.org/W2103343882","https://openalex.org/W2122789628","https://openalex.org/W2142864156","https://openalex.org/W2147110225","https://openalex.org/W2167272239","https://openalex.org/W2915738127","https://openalex.org/W2917695274","https://openalex.org/W4206031975","https://openalex.org/W6604169916","https://openalex.org/W6607611666","https://openalex.org/W6629123387","https://openalex.org/W6629850417","https://openalex.org/W6631452047","https://openalex.org/W6633543881","https://openalex.org/W6635038051","https://openalex.org/W6635272632","https://openalex.org/W6636251524","https://openalex.org/W6642623622","https://openalex.org/W6664661262","https://openalex.org/W6683895068"],"related_works":["https://openalex.org/W2085988990","https://openalex.org/W119841348","https://openalex.org/W2056340443","https://openalex.org/W2171948294","https://openalex.org/W4249985813","https://openalex.org/W2046615742","https://openalex.org/W2015372451","https://openalex.org/W2143485006","https://openalex.org/W2005835473","https://openalex.org/W3174970460"],"abstract_inverted_index":null,"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":2},{"year":2012,"cited_by_count":3}],"updated_date":"2026-06-22T06:23:43.705686","created_date":"2025-10-10T00:00:00"}