{"id":"https://openalex.org/W2080806970","doi":"https://doi.org/10.1145/588111.588117","title":"Database relations with null values","display_name":"Database relations with null values","publication_year":1982,"publication_date":"1982-03-29","ids":{"openalex":"https://openalex.org/W2080806970","doi":"https://doi.org/10.1145/588111.588117","mag":"2080806970"},"language":"en","primary_location":{"id":"doi:10.1145/588111.588117","doi":"https://doi.org/10.1145/588111.588117","is_oa":true,"landing_page_url":"https://doi.org/10.1145/588111.588117","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/588111.588117","source":{"id":"https://openalex.org/S4393916800","display_name":"ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (PODS)","issn_l":"1055-6338","issn":["1055-6338"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1st ACM SIGACT-SIGMOD symposium on Principles of database systems","raw_type":"proceedings-article"},"volume":null,"type":"conference-paper","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.1145/588111.588117","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5113467760","display_name":"Carlo Zaniolo","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Carlo Zaniolo","raw_affiliation_strings":["Bell Laboratories, Holmdel, New Jersey","Bell Laboratories, Holmdel, New Jersey#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Bell Laboratories, Holmdel, New Jersey","institution_ids":[]},{"raw_affiliation_string":"Bell Laboratories, Holmdel, New Jersey#TAB#","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5113467760"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":7.405,"has_fulltext":true,"cited_by_count":56,"citation_normalized_percentile":{"value":0.97910448,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"27","last_page":"33"},"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.9945999979972839,"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.9945999979972839,"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.0010000000474974513,"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/T10126","display_name":"Logic, programming, and type systems","score":0.0008999999845400453,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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-values","display_name":"null values","score":0.8920000195503235},{"id":"https://openalex.org/keywords/database-relations","display_name":"database relations","score":0.8420000076293945},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"relational algebra","score":0.503000020980835},{"id":"https://openalex.org/keywords/incomplete-information","display_name":"incomplete information","score":0.7210000157356262}],"concepts":[{"id":"https://openalex.org/C2778805511","wikidata":"https://www.wikidata.org/wiki/Q1713","display_name":"Citation","level":2,"score":0.6910473108291626},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6789833307266235},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.594353973865509},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.5519291758537292},{"id":"https://openalex.org/C2991937666","wikidata":"https://www.wikidata.org/wiki/Q206290","display_name":"Citation database","level":4,"score":0.4878580570220947},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.4539406895637512},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.44284167885780334},{"id":"https://openalex.org/C83867959","wikidata":"https://www.wikidata.org/wiki/Q371467","display_name":"Scopus","level":3,"score":0.051614463329315186},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.05141723155975342},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C2779473830","wikidata":"https://www.wikidata.org/wiki/Q1540899","display_name":"MEDLINE","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/588111.588117","doi":"https://doi.org/10.1145/588111.588117","is_oa":true,"landing_page_url":"https://doi.org/10.1145/588111.588117","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/588111.588117","source":{"id":"https://openalex.org/S4393916800","display_name":"ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (PODS)","issn_l":"1055-6338","issn":["1055-6338"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1st ACM SIGACT-SIGMOD symposium on Principles of database systems","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/588111.588117","doi":"https://doi.org/10.1145/588111.588117","is_oa":true,"landing_page_url":"https://doi.org/10.1145/588111.588117","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/588111.588117","source":{"id":"https://openalex.org/S4393916800","display_name":"ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (PODS)","issn_l":"1055-6338","issn":["1055-6338"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1st ACM SIGACT-SIGMOD symposium on Principles of database systems","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/W2080806970.pdf","grobid_xml":"https://content.openalex.org/works/W2080806970.grobid-xml"},"referenced_works_count":16,"referenced_works":["https://openalex.org/W101983502","https://openalex.org/W1968915456","https://openalex.org/W2003017562","https://openalex.org/W2010272308","https://openalex.org/W2034642607","https://openalex.org/W2072191579","https://openalex.org/W2099610462","https://openalex.org/W2103343882","https://openalex.org/W2122789628","https://openalex.org/W2162715748","https://openalex.org/W2489748212","https://openalex.org/W2966001939","https://openalex.org/W4230049890","https://openalex.org/W4235018027","https://openalex.org/W4242261582","https://openalex.org/W6667211271"],"related_works":["https://openalex.org/W2624695650","https://openalex.org/W2926741219","https://openalex.org/W4242299702","https://openalex.org/W2046919561","https://openalex.org/W4250894793","https://openalex.org/W1486310914","https://openalex.org/W2026080208","https://openalex.org/W1575486615","https://openalex.org/W7024131902","https://openalex.org/W7137590132"],"abstract_inverted_index":{"Article":[0],"Free":[1],"Access":[2],"Share":[3],"on":[4,37,89],"Database":[5],"relations":[6],"with":[7],"null":[8],"values":[9],"Author:":[10],"Carlo":[11],"Zaniolo":[12],"Bell":[13,18],"Laboratories,":[14,19],"Holmdel,":[15,20],"New":[16,21,108],"Jersey":[17],"JerseyView":[22],"Profile":[23],"Authors":[24],"Info":[25],"&":[26],"Claims":[27],"PODS":[28],"'82:":[29],"Proceedings":[30],"of":[31,39],"the":[32,90],"1st":[33],"ACM":[34],"SIGACT-SIGMOD":[35],"symposium":[36],"Principles":[38],"database":[40],"systemsMarch":[41],"1982":[42],"Pages":[43],"27\u201333https://doi.org/10.1145/588111.588117Online:29":[44],"March":[45],"1982Publication":[46],"History":[47],"34citation810DownloadsMetricsTotal":[48],"Citations34Total":[49],"Downloads810Last":[50],"12":[51],"Months8Last":[52],"6":[53],"weeks4":[54],"Get":[55],"Citation":[56,58,95],"AlertsNew":[57,94],"Alert":[59],"added!This":[60],"alert":[61,86],"has":[62,81],"been":[63,82],"successfully":[64],"added":[65],"and":[66],"will":[67,71],"be":[68,72],"sent":[69],"to:You":[70],"notified":[73],"whenever":[74],"a":[75,107],"record":[76],"that":[77],"you":[78],"have":[79],"chosen":[80],"cited.To":[83],"manage":[84],"your":[85,100],"preferences,":[87],"click":[88],"button":[91],"below.Manage":[92],"my":[93],"Alert!Please":[96],"log":[97],"in":[98],"to":[99,103,105],"account":[101],"Save":[102],"BinderSave":[104],"BinderCreate":[106],"BinderNameCancelCreateExport":[109],"CitationPublisher":[110],"SiteeReaderPDF":[111]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2026-10-29T09:56:32.521200","created_date":"2016-06-24T00:00:00"}