{"id":"https://openalex.org/W3173860497","doi":"https://doi.org/10.1145/3448016.3459238","title":"Logical Schema Design that Quantifies Update Inefficiency and Join Efficiency","display_name":"Logical Schema Design that Quantifies Update Inefficiency and Join Efficiency","publication_year":2021,"publication_date":"2021-06-09","ids":{"openalex":"https://openalex.org/W3173860497","doi":"https://doi.org/10.1145/3448016.3459238","mag":"3173860497"},"language":"en","primary_location":{"id":"doi:10.1145/3448016.3459238","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3448016.3459238","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2021 International Conference on Management of Data","raw_type":"proceedings-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/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":true,"raw_author_name":"Sebastian Link","raw_affiliation_strings":["University of Auckland, Auckland, New Zealand"],"affiliations":[{"raw_affiliation_string":"University of Auckland, Auckland, New Zealand","institution_ids":["https://openalex.org/I154130895"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5026257009","display_name":"Ziheng Wei","orcid":"https://orcid.org/0000-0002-0973-3759"},"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":"Ziheng Wei","raw_affiliation_strings":["University of Auckland, Auckland, New Zealand"],"affiliations":[{"raw_affiliation_string":"University of Auckland, Auckland, New Zealand","institution_ids":["https://openalex.org/I154130895"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5069839542"],"corresponding_institution_ids":["https://openalex.org/I154130895"],"apc_list":null,"apc_paid":null,"fwci":1.76,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.85301534,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1169","last_page":"1181"},"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/T11719","display_name":"Data Quality and Management","score":0.9991000294685364,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9990000128746033,"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/computer-science","display_name":"Computer science","score":0.6905957460403442},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.6540449857711792},{"id":"https://openalex.org/keywords/normalization","display_name":"Normalization (sociology)","score":0.6243740320205688},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.560875415802002},{"id":"https://openalex.org/keywords/bounded-function","display_name":"Bounded function","score":0.5356457233428955},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5214359164237976},{"id":"https://openalex.org/keywords/redundancy","display_name":"Redundancy (engineering)","score":0.4559912383556366},{"id":"https://openalex.org/keywords/parameterized-complexity","display_name":"Parameterized complexity","score":0.4559611976146698},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.4497626721858978},{"id":"https://openalex.org/keywords/arity","display_name":"Arity","score":0.42837467789649963},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4242013990879059},{"id":"https://openalex.org/keywords/inefficiency","display_name":"Inefficiency","score":0.4111785292625427},{"id":"https://openalex.org/keywords/functional-dependency","display_name":"Functional dependency","score":0.41029423475265503},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.28628361225128174},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.28469622135162354},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.26305145025253296},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.14584851264953613},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.09376639127731323}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6905957460403442},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.6540449857711792},{"id":"https://openalex.org/C136886441","wikidata":"https://www.wikidata.org/wiki/Q926129","display_name":"Normalization (sociology)","level":2,"score":0.6243740320205688},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.560875415802002},{"id":"https://openalex.org/C34388435","wikidata":"https://www.wikidata.org/wiki/Q2267362","display_name":"Bounded function","level":2,"score":0.5356457233428955},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5214359164237976},{"id":"https://openalex.org/C152124472","wikidata":"https://www.wikidata.org/wiki/Q1204361","display_name":"Redundancy (engineering)","level":2,"score":0.4559912383556366},{"id":"https://openalex.org/C165464430","wikidata":"https://www.wikidata.org/wiki/Q1570441","display_name":"Parameterized complexity","level":2,"score":0.4559611976146698},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.4497626721858978},{"id":"https://openalex.org/C110546421","wikidata":"https://www.wikidata.org/wiki/Q1315869","display_name":"Arity","level":2,"score":0.42837467789649963},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4242013990879059},{"id":"https://openalex.org/C2778869765","wikidata":"https://www.wikidata.org/wiki/Q6028363","display_name":"Inefficiency","level":2,"score":0.4111785292625427},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.41029423475265503},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.28628361225128174},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.28469622135162354},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.26305145025253296},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.14584851264953613},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.09376639127731323},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C175444787","wikidata":"https://www.wikidata.org/wiki/Q39072","display_name":"Microeconomics","level":1,"score":0.0},{"id":"https://openalex.org/C19165224","wikidata":"https://www.wikidata.org/wiki/Q23404","display_name":"Anthropology","level":1,"score":0.0},{"id":"https://openalex.org/C144024400","wikidata":"https://www.wikidata.org/wiki/Q21201","display_name":"Sociology","level":0,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3448016.3459238","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3448016.3459238","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2021 International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:oai:researchspace.auckland.ac.nz:2292/58015","is_oa":false,"landing_page_url":"https://hdl.handle.net/2292/58015","pdf_url":null,"source":{"id":"https://openalex.org/S7407055463","display_name":"ResearchSpace (University of Auckland)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I154130895","host_organization_name":"University of Auckland","host_organization_lineage":["https://openalex.org/I154130895"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"https://www.cs.auckland.ac.nz/research/groups/CDMTCS/researchreports/index.php","raw_type":"Technical Report"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":41,"referenced_works":["https://openalex.org/W8304365","https://openalex.org/W180578187","https://openalex.org/W885593463","https://openalex.org/W1513634294","https://openalex.org/W1523340385","https://openalex.org/W1566656512","https://openalex.org/W1596825373","https://openalex.org/W1974153000","https://openalex.org/W1998597078","https://openalex.org/W2003963141","https://openalex.org/W2008396232","https://openalex.org/W2020958835","https://openalex.org/W2041601261","https://openalex.org/W2048848358","https://openalex.org/W2083641979","https://openalex.org/W2088159747","https://openalex.org/W2092011463","https://openalex.org/W2110810394","https://openalex.org/W2112100340","https://openalex.org/W2122115541","https://openalex.org/W2122323423","https://openalex.org/W2125552274","https://openalex.org/W2128114397","https://openalex.org/W2135105491","https://openalex.org/W2139238107","https://openalex.org/W2139484086","https://openalex.org/W2144557957","https://openalex.org/W2266772167","https://openalex.org/W2424050798","https://openalex.org/W2425348221","https://openalex.org/W2439326083","https://openalex.org/W2440730883","https://openalex.org/W2794634184","https://openalex.org/W2798658665","https://openalex.org/W2811492263","https://openalex.org/W2935696900","https://openalex.org/W2936448214","https://openalex.org/W2945526390","https://openalex.org/W2952207484","https://openalex.org/W3094758473","https://openalex.org/W4239086110"],"related_works":["https://openalex.org/W1551739174","https://openalex.org/W2116767780","https://openalex.org/W2168592511","https://openalex.org/W3013395906","https://openalex.org/W165346131","https://openalex.org/W2153639879","https://openalex.org/W1594511838","https://openalex.org/W1507924438","https://openalex.org/W4285259755","https://openalex.org/W2185579824"],"abstract_inverted_index":{"The":[0],"goal":[1,24],"of":[2,16,49,91,166,172,187,209,236],"classical":[3],"normalization":[4],"is":[5,25,104],"to":[6],"maintain":[7],"data":[8,126,217],"consistency":[9],"under":[10],"updates,":[11],"with":[12,213,248],"a":[13,68],"minimum":[14],"level":[15,48,124,134,152,199],"effort.":[17,188],"Given":[18],"functional":[19],"dependencies":[20],"(FDs)":[21],"alone,":[22],"this":[23,113],"only":[26],"achievable":[27],"in":[28,43,98,112,144],"the":[29,47,61,75,88,117,150,170,203,221,234,244],"special":[30],"case":[31],"an":[32],"FD-preserving":[33,157],"Boyce-Codd":[34],"Normal":[35,64,147],"Form":[36,148],"(BCNF)":[37],"decomposition":[38],"exists.":[39],"As":[40],"we":[41,59],"show,":[42],"all":[44,156],"other":[45],"cases":[46],"effort":[50,167],"can":[51],"be":[52],"neither":[53],"controlled":[54],"nor":[55],"quantified.":[56],"In":[57,197],"response,":[58],"establish":[60,139],"l-Bounded":[62,145],"Cardinality":[63,146],"Form,":[65],"parameterized":[66],"by":[67],"positive":[69],"integer":[70],"l.":[71],"For":[72],"every":[73,81,84,92],"l,":[74],"normal":[76,114],"form":[77,115],"condition":[78],"requires":[79],"from":[80,123,226],"instance":[82],"that":[83,110,119,141,183,224],"value":[85],"combination":[86],"over":[87,243],"left-hand":[89],"side":[90],"non-trivial":[93],"FD":[94],"does":[95],"not":[96],"occur":[97],"more":[99],"than":[100],"l":[101,125,135,153,200],"tuples.":[102],"BCNF":[103],"captured":[105],"when":[106],"l=1.":[107],"We":[108,138],"demonstrate":[109],"schemata":[111,143,178,222],"characterize":[116],"instances":[118,242],"are":[120],"i)":[121,161],"free":[122],"redundancy":[127],"and":[128,131,175,206,215,229,238,247],"update":[129,237],"inefficiency,":[130],"ii)":[132,176],"permit":[133],"join":[136,207],"efficiency.":[137],"algorithms":[140,160],"compute":[142],"for":[149],"smallest":[151],"attainable":[154],"across":[155],"decompositions.":[158],"Additional":[159],"attain":[162],"even":[163],"smaller":[164],"levels":[165,186],"based":[168,179],"on":[169,180,241],"loss":[171],"some":[173],"FDs,":[174],"decompose":[177],"prioritized":[181],"FDs":[182],"cause":[184],"high":[185],"Our":[189],"framework":[190],"informs":[191],"de-normalization":[192],"already":[193],"during":[194],"logical":[195],"design.":[196],"particular,":[198],"quantifies":[201],"both":[202],"incremental":[204],"maintenance":[205],"support":[208],"materialized":[210,249],"views.":[211,250],"Experiments":[212],"synthetic":[214],"real-world":[216],"illustrate":[218],"which":[219],"properties":[220,232],"have":[223],"result":[225],"our":[227],"algorithms,":[228],"how":[230],"these":[231],"predict":[233],"performance":[235],"query":[239],"operations":[240],"schemata,":[245],"without":[246]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}