{"id":"https://openalex.org/W4399164394","doi":"https://doi.org/10.14778/3654621.3654626","title":"Mixed Covers of Keys and Functional Dependencies for Maintaining the Integrity of Data under Updates","display_name":"Mixed Covers of Keys and Functional Dependencies for Maintaining the Integrity of Data under Updates","publication_year":2024,"publication_date":"2024-03-01","ids":{"openalex":"https://openalex.org/W4399164394","doi":"https://doi.org/10.14778/3654621.3654626"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.14778/3654621.3654626","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"journal-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/A5091624476","display_name":"Zhuoxing Zhang","orcid":null},"institutions":[{"id":"https://openalex.org/I154130895","display_name":"University of Auckland","ror":"https://ror.org/03b94tp07","country_code":"NZ","type":"education","lineage":["https://openalex.org/I154130895"]}],"countries":["NZ"],"is_corresponding":false,"raw_author_name":"Zhuoxing Zhang","raw_affiliation_strings":["The University of Auckland, Auckland, New Zealand"],"affiliations":[{"raw_affiliation_string":"The University of Auckland, Auckland, New Zealand","institution_ids":["https://openalex.org/I154130895"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5069839542","display_name":"Sebastian Link","orcid":"https://orcid.org/0000-0002-1816-2863"},"institutions":[{"id":"https://openalex.org/I154130895","display_name":"University of Auckland","ror":"https://ror.org/03b94tp07","country_code":"NZ","type":"education","lineage":["https://openalex.org/I154130895"]}],"countries":["NZ"],"is_corresponding":false,"raw_author_name":"Sebastian Link","raw_affiliation_strings":["The University of Auckland, Auckland, New Zealand"],"affiliations":[{"raw_affiliation_string":"The University of Auckland, Auckland, New Zealand","institution_ids":["https://openalex.org/I154130895"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":0,"max":84},"biblio":{"volume":"17","issue":"7","first_page":"1578","last_page":"1590"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9996,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9996,"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.9995,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.998,"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/data-integrity","display_name":"Data integrity","score":0.7535743},{"id":"https://openalex.org/keywords/complement","display_name":"Complement","score":0.5764959},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.5289721},{"id":"https://openalex.org/keywords/set-cover-problem","display_name":"Set cover problem","score":0.43693644}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.78561854},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.7535743},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.67780274},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.6376559},{"id":"https://openalex.org/C2776036281","wikidata":"https://www.wikidata.org/wiki/Q48769818","display_name":"Constraint (computer-aided design)","level":2,"score":0.58749247},{"id":"https://openalex.org/C2780428219","wikidata":"https://www.wikidata.org/wiki/Q16952335","display_name":"Cover (algebra)","level":2,"score":0.58665025},{"id":"https://openalex.org/C112313634","wikidata":"https://www.wikidata.org/wiki/Q7886648","display_name":"Complement (music)","level":5,"score":0.5764959},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.5289721},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.52397007},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4872107},{"id":"https://openalex.org/C100808899","wikidata":"https://www.wikidata.org/wiki/Q1192100","display_name":"Set cover problem","level":3,"score":0.43693644},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.41234598},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.36617044},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.13040224},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.12035608},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.110189974},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.10364136},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.094592184},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"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/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C188082640","wikidata":"https://www.wikidata.org/wiki/Q1780899","display_name":"Complementation","level":4,"score":0.0},{"id":"https://openalex.org/C127716648","wikidata":"https://www.wikidata.org/wiki/Q104053","display_name":"Phenotype","level":3,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.14778/3654621.3654626","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.47}],"grants":[],"datasets":[],"versions":[],"referenced_works_count":32,"referenced_works":["https://openalex.org/W1493938990","https://openalex.org/W180578187","https://openalex.org/W1908227512","https://openalex.org/W1975125888","https://openalex.org/W1994193726","https://openalex.org/W2000773957","https://openalex.org/W2012644520","https://openalex.org/W2032386524","https://openalex.org/W2050562762","https://openalex.org/W2063645305","https://openalex.org/W2066837227","https://openalex.org/W2096658167","https://openalex.org/W2135105491","https://openalex.org/W2171332293","https://openalex.org/W2266772167","https://openalex.org/W2439326083","https://openalex.org/W2487473571","https://openalex.org/W2747774925","https://openalex.org/W2803396353","https://openalex.org/W2963803628","https://openalex.org/W2970727798","https://openalex.org/W2982581272","https://openalex.org/W2997756720","https://openalex.org/W3004034804","https://openalex.org/W3168935107","https://openalex.org/W3171487259","https://openalex.org/W3173860497","https://openalex.org/W4321448321","https://openalex.org/W4366660538","https://openalex.org/W4375948223","https://openalex.org/W4380433121","https://openalex.org/W4386123440"],"related_works":["https://openalex.org/W73317730","https://openalex.org/W3177130241","https://openalex.org/W2965659132","https://openalex.org/W2134762009","https://openalex.org/W2116767780","https://openalex.org/W2007610702","https://openalex.org/W194318731","https://openalex.org/W1858419289","https://openalex.org/W158126298","https://openalex.org/W1512401680"],"abstract_inverted_index":{"Covers":[0],"for":[1,10,69,84,101],"a":[2,70,82,106],"set":[3,71,76,86,108],"of":[4,13,54,66,72,77,87,109,120,143,159],"functional":[5],"dependencies":[6],"(FDs)":[7],"are":[8,127],"fundamental":[9],"many":[11],"areas":[12],"data":[14,25],"management,":[15],"such":[16],"as":[17],"integrity":[18,29,148],"maintenance,":[19],"query":[20],"optimization,":[21],"database":[22,36],"design,":[23],"and":[24,98,111,162],"cleaning.":[26],"When":[27],"declaring":[28],"constraints,":[30],"keys":[31,55,79],"enjoy":[32],"native":[33],"support":[34],"in":[35,118,130],"systems":[37],"while":[38],"FDs":[39,89],"need":[40],"to":[41],"be":[42],"enforced":[43],"by":[44,91],"triggers":[45],"or":[46,132],"at":[47],"application":[48],"level.":[49],"Consequently,":[50],"maximizing":[51],"the":[52,58,63,75,85,92,139,157,166],"use":[53],"will":[56],"provide":[57],"best":[59],"support.":[60],"We":[61,95,150],"propose":[62],"new":[64],"notion":[65],"mixed":[67,103,137,154],"cover":[68,83],"FDs,":[73,110],"comprising":[74],"minimal":[78],"together":[80],"with":[81],"non-key":[88],"implied":[90],"FD":[93,125],"set.":[94],"establish":[96],"sequential":[97],"parallel":[99],"algorithms":[100],"computing":[102],"covers":[104,126,155],"from":[105],"given":[107],"illustrate":[112],"that":[113],"they":[114],"complement":[115],"each":[116],"other":[117],"terms":[119],"their":[121,135],"performance.":[122],"Even":[123],"though":[124],"typically":[128],"smaller":[129],"number":[131],"size":[133],"than":[134],"corresponding":[136],"cover,":[138],"latter":[140],"generate":[141],"orders":[142],"magnitude":[144],"lower":[145],"overheads":[146],"during":[147],"maintenance.":[149],"also":[151],"quantify":[152],"how":[153],"improve":[156],"performance":[158],"query,":[160],"refresh":[161],"insert":[163],"operations":[164],"on":[165],"TPC-H":[167],"benchmark":[168],"under":[169],"different":[170],"constraint":[171],"workloads.":[172]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4399164394","counts_by_year":[],"updated_date":"2024-12-08T13:23:55.243401","created_date":"2024-05-31"}