{"id":"https://openalex.org/W1618713168","doi":"https://doi.org/10.1016/s1571-0661(04)81007-7","title":"Three approaches to partiality in the sketch data model1 1Research partially supported by the Australian Research Council and NSERC Canada.","display_name":"Three approaches to partiality in the sketch data model1 1Research partially supported by the Australian Research Council and NSERC Canada.","publication_year":2003,"publication_date":"2003-04-01","ids":{"openalex":"https://openalex.org/W1618713168","doi":"https://doi.org/10.1016/s1571-0661(04)81007-7","mag":"1618713168"},"language":"en","primary_location":{"id":"doi:10.1016/s1571-0661(04)81007-7","is_oa":true,"landing_page_url":"https://doi.org/10.1016/s1571-0661(04)81007-7","pdf_url":null,"source":{"id":"https://openalex.org/S50368787","display_name":"Electronic Notes in Theoretical Computer Science","issn_l":"1571-0661","issn":["1571-0661"],"is_oa":true,"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":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Electronic Notes in Theoretical Computer Science","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://doi.org/10.1016/s1571-0661(04)81007-7","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5049401183","display_name":"Michael Johnson","orcid":"https://orcid.org/0000-0001-9858-5542"},"institutions":[{"id":"https://openalex.org/I99043593","display_name":"Macquarie University","ror":"https://ror.org/01sf06y89","country_code":"AU","type":"education","lineage":["https://openalex.org/I99043593"]}],"countries":["AU"],"is_corresponding":true,"raw_author_name":"Michael Johnson","raw_affiliation_strings":["Departments of Mathematics and Computing, Macquarie University Sydney, Australia"],"affiliations":[{"raw_affiliation_string":"Departments of Mathematics and Computing, Macquarie University Sydney, Australia","institution_ids":["https://openalex.org/I99043593"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5035287875","display_name":"Robert Rosebrugh","orcid":null},"institutions":[{"id":"https://openalex.org/I163902620","display_name":"Mount Allison University","ror":"https://ror.org/03grc6f14","country_code":"CA","type":"education","lineage":["https://openalex.org/I163902620"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Robert Rosebrugh","raw_affiliation_strings":["Department of Mathematics and Computer Science, Mount Allison University Sackville, NB, Canada","Department of Mathematics and Computer Science, Mount Allison University, Sackville, NB, Canada"],"affiliations":[{"raw_affiliation_string":"Department of Mathematics and Computer Science, Mount Allison University Sackville, NB, Canada","institution_ids":["https://openalex.org/I163902620"]},{"raw_affiliation_string":"Department of Mathematics and Computer Science, Mount Allison University, Sackville, NB, Canada","institution_ids":["https://openalex.org/I163902620"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5049401183"],"corresponding_institution_ids":["https://openalex.org/I99043593"],"apc_list":null,"apc_paid":null,"fwci":0.5856,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.65399386,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"78","issue":null,"first_page":"82","last_page":"99"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9993000030517578,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9993000030517578,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9990000128746033,"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.9921000003814697,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/sketch","display_name":"Sketch","score":0.9735163450241089},{"id":"https://openalex.org/keywords/equivalence","display_name":"Equivalence (formal languages)","score":0.7714897394180298},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6690460443496704},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.40756064653396606},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.377994179725647},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.2297341227531433},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.19690629839897156},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.11816611886024475}],"concepts":[{"id":"https://openalex.org/C2779231336","wikidata":"https://www.wikidata.org/wiki/Q7534724","display_name":"Sketch","level":2,"score":0.9735163450241089},{"id":"https://openalex.org/C2780069185","wikidata":"https://www.wikidata.org/wiki/Q7977945","display_name":"Equivalence (formal languages)","level":2,"score":0.7714897394180298},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6690460443496704},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.40756064653396606},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.377994179725647},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.2297341227531433},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.19690629839897156},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.11816611886024475}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1016/s1571-0661(04)81007-7","is_oa":true,"landing_page_url":"https://doi.org/10.1016/s1571-0661(04)81007-7","pdf_url":null,"source":{"id":"https://openalex.org/S50368787","display_name":"Electronic Notes in Theoretical Computer Science","issn_l":"1571-0661","issn":["1571-0661"],"is_oa":true,"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":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Electronic Notes in Theoretical Computer Science","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1016/s1571-0661(04)81007-7","is_oa":true,"landing_page_url":"https://doi.org/10.1016/s1571-0661(04)81007-7","pdf_url":null,"source":{"id":"https://openalex.org/S50368787","display_name":"Electronic Notes in Theoretical Computer Science","issn_l":"1571-0661","issn":["1571-0661"],"is_oa":true,"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":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Electronic Notes in Theoretical Computer Science","raw_type":"journal-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.4399999976158142}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":31,"referenced_works":["https://openalex.org/W163872530","https://openalex.org/W189831587","https://openalex.org/W197474260","https://openalex.org/W199513821","https://openalex.org/W1498786002","https://openalex.org/W1535752721","https://openalex.org/W1555181227","https://openalex.org/W1578654632","https://openalex.org/W1579321744","https://openalex.org/W1603256736","https://openalex.org/W2021257181","https://openalex.org/W2049578111","https://openalex.org/W2056147406","https://openalex.org/W2070270825","https://openalex.org/W2070604980","https://openalex.org/W2085988990","https://openalex.org/W2095324918","https://openalex.org/W2096517802","https://openalex.org/W2097402427","https://openalex.org/W2100985648","https://openalex.org/W2123215901","https://openalex.org/W2138709157","https://openalex.org/W2144192824","https://openalex.org/W2152012515","https://openalex.org/W2248155926","https://openalex.org/W2396455998","https://openalex.org/W2483136972","https://openalex.org/W2484356930","https://openalex.org/W2520545447","https://openalex.org/W3049332276","https://openalex.org/W6682130026"],"related_works":["https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2378994405","https://openalex.org/W2385974820","https://openalex.org/W2373478030","https://openalex.org/W2378679551","https://openalex.org/W3149739944","https://openalex.org/W2392363776","https://openalex.org/W2063051341","https://openalex.org/W1494563618"],"abstract_inverted_index":{"Partial":[0],"information":[1,74,91],"is":[2,50,66,119],"common":[3],"in":[4,92],"real-world":[5],"databases.":[6],"Yet":[7],"the":[8,93,122,133,138],"theoretical":[9],"foundations":[10],"of":[11,125,148],"data":[12,22,32,48,64,95],"models":[13],"are":[14,102,115,141],"not":[15],"designed":[16],"to":[17,20,55,69,72,88,128],"support":[18,43,70],"references":[19,71],"missing":[21,73],"(often":[23],"termed":[24],"nulls).":[25],"Instead,":[26],"we":[27,84,106,145],"usually":[28],"analyse":[29],"a":[30,51],"clean":[31],"model":[33,49,65],"based":[34,58],"on":[35,59],"assumptions":[36],"about":[37],"complete":[38],"information,":[39],"and":[40,105,144],"later":[41],"retro\u00a3t":[42],"for":[44],"nulls.":[45],"The":[46,62,97],"sketch":[47,63,94],"recently":[52],"developed":[53],"approach":[54],"database":[56],"speci\u00a3cation":[57],"category":[60],"theory.":[61],"general":[67],"enough":[68],"within":[75],"itself":[76],"(rather":[77],"than":[78],"by":[79],"retro\u00a3tting).":[80],"In":[81],"this":[82,131],"paper":[83],"explore":[85,146],"three":[86,139],"approaches":[87,140],"incorporating":[89],"partial":[90],"model.":[96],"approaches,":[98],"while":[99],"fundamentally":[100],"different,":[101,143],"closely":[103],"related,":[104],"show":[107],"that":[108],"under":[109],"certain":[110],"fairly":[111],"strong":[112],"hypotheses":[113],"they":[114,120],"Morita":[116],"equivalent":[117],"(that":[118],"have":[121],"same":[123],"categories":[124],"models,":[126],"up":[127],"equivalence).":[129],"Despite":[130],"equivalence,":[132],"query":[134],"languages":[135],"arising":[136],"from":[137],"subtly":[142],"some":[147],"these":[149],"differences.":[150]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}
