{"id":"https://openalex.org/W2118190202","doi":"https://doi.org/10.1109/icde.1987.7272401","title":"What do you mean \u201cnull\u201d? Turning null responses into quality responses","display_name":"What do you mean \u201cnull\u201d? Turning null responses into quality responses","publication_year":1987,"publication_date":"1987-02-01","ids":{"openalex":"https://openalex.org/W2118190202","doi":"https://doi.org/10.1109/icde.1987.7272401","mag":"2118190202"},"language":"en","primary_location":{"id":"doi:10.1109/icde.1987.7272401","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.1987.7272401","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"1987 IEEE Third International Conference on Data Engineering","raw_type":"proceedings-article"},"type":"conference-paper","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/A5110126123","display_name":"Mimi A Kao","orcid":null},"institutions":[{"id":"https://openalex.org/I18014758","display_name":"Simon Fraser University","ror":"https://ror.org/0213rcc28","country_code":"CA","type":"education","lineage":["https://openalex.org/I18014758"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Mimi Kao","raw_affiliation_strings":["Laboratory for Computer and Communications Research, School of Computing Science, Simon Fraser University, Bumaby, British Columbia, CANADA V5A 1S6"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Laboratory for Computer and Communications Research, School of Computing Science, Simon Fraser University, Bumaby, British Columbia, CANADA V5A 1S6","institution_ids":["https://openalex.org/I18014758"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5105530330","display_name":"Nick Cercone","orcid":null},"institutions":[{"id":"https://openalex.org/I18014758","display_name":"Simon Fraser University","ror":"https://ror.org/0213rcc28","country_code":"CA","type":"education","lineage":["https://openalex.org/I18014758"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Nick Cercone","raw_affiliation_strings":["Laboratory for Computer and Communications Research, School of Computing Science, Simon Fraser University, Bumaby, British Columbia, CANADA V5A 1S6"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Laboratory for Computer and Communications Research, School of Computing Science, Simon Fraser University, Bumaby, British Columbia, CANADA V5A 1S6","institution_ids":["https://openalex.org/I18014758"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5071758024","display_name":"Wo-Shun Luk","orcid":null},"institutions":[{"id":"https://openalex.org/I18014758","display_name":"Simon Fraser University","ror":"https://ror.org/0213rcc28","country_code":"CA","type":"education","lineage":["https://openalex.org/I18014758"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"WoShun Luk","raw_affiliation_strings":["Laboratory for Computer and Communications Research, School of Computing Science, Simon Fraser University, Bumaby, British Columbia, CANADA V5A 1S6"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Laboratory for Computer and Communications Research, School of Computing Science, Simon Fraser University, Bumaby, British Columbia, CANADA V5A 1S6","institution_ids":["https://openalex.org/I18014758"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I18014758"],"apc_list":null,"apc_paid":null,"fwci":0.6555,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.72149695,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":93},"biblio":{"volume":null,"issue":null,"first_page":"356","last_page":"364"},"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9979000091552734,"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.996399998664856,"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.8853926658630371},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7446287870407104},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6118495464324951},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6078521013259888},{"id":"https://openalex.org/keywords/null-hypothesis","display_name":"Null hypothesis","score":0.5268878936767578},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.28341054916381836},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.232036292552948},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2159099578857422},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.2021009624004364},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.09972614049911499}],"concepts":[{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.8853926658630371},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7446287870407104},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6118495464324951},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6078521013259888},{"id":"https://openalex.org/C191988596","wikidata":"https://www.wikidata.org/wiki/Q628374","display_name":"Null hypothesis","level":2,"score":0.5268878936767578},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.28341054916381836},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.232036292552948},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2159099578857422},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.2021009624004364},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.09972614049911499}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.1987.7272401","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.1987.7272401","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"1987 IEEE Third International Conference on Data Engineering","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education","score":0.8399999737739563}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":4,"referenced_works":["https://openalex.org/W225652311","https://openalex.org/W1550288092","https://openalex.org/W2061141062","https://openalex.org/W2264742718"],"related_works":["https://openalex.org/W4306992803","https://openalex.org/W2979681497","https://openalex.org/W2382973082","https://openalex.org/W4306992794","https://openalex.org/W4312632526","https://openalex.org/W4306992806","https://openalex.org/W2590542766","https://openalex.org/W4239137652","https://openalex.org/W1999826675","https://openalex.org/W4306992821"],"abstract_inverted_index":{"When":[0],"natural":[1],"language":[2,33],"front-ends":[3],"are":[4,73],"introduced":[5],"to":[6,44,94],"database":[7,31],"management":[8],"systems,":[9],"generation":[10],"of":[11,70,79],"quality":[12],"responses":[13],"have":[14],"proven":[15],"problematical":[16],"in":[17,26],"situations":[18],"when":[19,98],"null":[20,45,100],"values":[21],"arise.":[22],"In":[23],"our":[24],"work,":[25],"which":[27],"we":[28,36,51],"assume":[29],"the":[30,77,80],"query":[32],"is":[34,87,92,102],"SQL,":[35],"present":[37],"methods":[38],"for":[39],"responding":[40],"with":[41],"appropriate":[42],"answers":[43],"value":[46],"responses.":[47],"To":[48,75],"do":[49],"so":[50],"use":[52],"a":[53,83,99],"knowledge":[54,81,85],"base":[55,86],"based":[56],"on":[57],"RM/T,":[58],"an":[59],"extended":[60],"relational":[61],"model":[62],"proposed":[63],"by":[64],"E.":[65],"F.":[66],"Codd.":[67],"The":[68],"advantages":[69],"this":[71],"approach":[72],"described.":[74],"demonstrate":[76],"utility":[78],"base,":[82],"simple":[84],"constructed.":[88],"A":[89],"detailed":[90],"algorithm":[91],"given":[93],"provide":[95],"additional":[96],"information":[97],"answer":[101],"returned.":[103]},"counts_by_year":[{"year":2021,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2016-06-24T00:00:00"}