{"id":"https://openalex.org/W4380433121","doi":"https://doi.org/10.1145/3588693","title":"Composite Object Normal Forms: Parameterizing Boyce-Codd Normal Form by the Number of Minimal Keys","display_name":"Composite Object Normal Forms: Parameterizing Boyce-Codd Normal Form by the Number of Minimal Keys","publication_year":2023,"publication_date":"2023-05-26","ids":{"openalex":"https://openalex.org/W4380433121","doi":"https://doi.org/10.1145/3588693"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/3588693","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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/A5079968544","display_name":"Zhuoxing Zhang","orcid":"https://orcid.org/0000-0001-6736-4501"},"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":["University of Auckland, Auckland, New Zealand"],"affiliations":[{"raw_affiliation_string":"University of Auckland, Auckland, New Zealand","institution_ids":["https://openalex.org/I154130895"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100329158","display_name":"Wu Chen","orcid":"https://orcid.org/0000-0002-5041-6122"},"institutions":[{"id":"https://openalex.org/I142108993","display_name":"Southwest University","ror":"https://ror.org/01kj4z117","country_code":"CN","type":"education","lineage":["https://openalex.org/I142108993"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Wu Chen","raw_affiliation_strings":["Southwest University, Chongqing, China"],"affiliations":[{"raw_affiliation_string":"Southwest University, Chongqing, China","institution_ids":["https://openalex.org/I142108993"]}]},{"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":["University of Auckland, Auckland, New Zealand"],"affiliations":[{"raw_affiliation_string":"University of Auckland, Auckland, New Zealand","institution_ids":["https://openalex.org/I154130895"]}]}],"institution_assertions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.185,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.809319,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":84,"max":87},"biblio":{"volume":"1","issue":"1","first_page":"1","last_page":"25"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997,"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.9997,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9994,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9992,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5068682},{"id":"https://openalex.org/keywords/normalization","display_name":"Normalization","score":0.49601755}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.72233117},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.6177216},{"id":"https://openalex.org/C81081738","wikidata":"https://www.wikidata.org/wiki/Q55542","display_name":"Lossless compression","level":3,"score":0.55854756},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5068682},{"id":"https://openalex.org/C136886441","wikidata":"https://www.wikidata.org/wiki/Q926129","display_name":"Normalization (sociology)","level":2,"score":0.49601755},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.46902338},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4411042},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.4279105},{"id":"https://openalex.org/C2781238097","wikidata":"https://www.wikidata.org/wiki/Q175026","display_name":"Object (grammar)","level":2,"score":0.427319},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.28104126},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2521342},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.17443982},{"id":"https://openalex.org/C78548338","wikidata":"https://www.wikidata.org/wiki/Q2493","display_name":"Data compression","level":2,"score":0.15530586},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.09617141},{"id":"https://openalex.org/C144024400","wikidata":"https://www.wikidata.org/wiki/Q21201","display_name":"Sociology","level":0,"score":0.0},{"id":"https://openalex.org/C19165224","wikidata":"https://www.wikidata.org/wiki/Q23404","display_name":"Anthropology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/3588693","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":37,"referenced_works":["https://openalex.org/W134251457","https://openalex.org/W1493938990","https://openalex.org/W1969117892","https://openalex.org/W1971475250","https://openalex.org/W1978767174","https://openalex.org/W1988902465","https://openalex.org/W2000773957","https://openalex.org/W2002649781","https://openalex.org/W2004699875","https://openalex.org/W2008396232","https://openalex.org/W2023663289","https://openalex.org/W2026139222","https://openalex.org/W2030551444","https://openalex.org/W2041601261","https://openalex.org/W2050562762","https://openalex.org/W2063141664","https://openalex.org/W2063645305","https://openalex.org/W2086065621","https://openalex.org/W2086073919","https://openalex.org/W2098102356","https://openalex.org/W2104094070","https://openalex.org/W2110810394","https://openalex.org/W2122323423","https://openalex.org/W2125552274","https://openalex.org/W2128114397","https://openalex.org/W2135105491","https://openalex.org/W2142421097","https://openalex.org/W2143182259","https://openalex.org/W2439326083","https://openalex.org/W2568350940","https://openalex.org/W2797060975","https://openalex.org/W2936448214","https://openalex.org/W3168935107","https://openalex.org/W3173860497","https://openalex.org/W4254776357","https://openalex.org/W4372267129","https://openalex.org/W87041057"],"related_works":["https://openalex.org/W3106969033","https://openalex.org/W2948148442","https://openalex.org/W2591697403","https://openalex.org/W2584736212","https://openalex.org/W2377158164","https://openalex.org/W2357988910","https://openalex.org/W2187600494","https://openalex.org/W2186939576","https://openalex.org/W2114030128","https://openalex.org/W2093003289"],"abstract_inverted_index":{"We":[0,17],"parameterize":[1],"schemata":[2,101,110,141,162],"in":[3,103,163],"Boyce-Codd":[4],"Normal":[5],"Form":[6],"(BCNF)":[7],"by":[8,40],"the":[9,35,45,55,74,97,114,117,135,151,156,173],"number":[10,36,56],"n":[11,20,119,137,154,166],"of":[12,37,57,76,99,153,175],"minimal":[13,167],"keys":[14],"they":[15],"exhibit.":[16],"show":[18,170],"that":[19,89],"quantifies":[21],"a":[22,91,124],"trade-off":[23],"between":[24],"access":[25,31],"variety":[26,32],"and":[27,107,147,158,169],"update":[28,51,157],"complexity.":[29],"Indeed,":[30],"refers":[33,53],"to":[34,54,64,79,116],"different":[38],"ways":[39],"which":[41,61],"every":[42],"entity":[43],"over":[44,161],"schema":[46],"is":[47,105,142],"represented":[48],"uniquely,":[49],"while":[50],"complexity":[52],"attribute":[58],"sets":[59],"for":[60],"uniqueness":[62],"needs":[63],"be":[65],"preserved":[66],"during":[67,83],"updates.":[68],"As":[69],"normalization":[70],"aims":[71],"at":[72],"minimizing":[73],"level":[75],"effort":[77],"required":[78],"preserve":[80],"data":[81,149],"consistency":[82],"updates,":[84],"we":[85],"establish":[86],"an":[87],"algorithm":[88,131,177],"returns":[90,132],"lossless,":[92,125],"dependency-preserving":[93,126],"3NF":[94],"decomposition":[95,128],"where":[96,134],"subset":[98],"output":[100,140],"not":[102],"BCNF":[104,109,127,164],"minimized":[106],"redundant":[108],"are":[111],"eliminated":[112],"from":[113],"highest":[115],"lowest":[118],"exhibited.":[120],"In":[121],"particular,":[122],"if":[123],"exists,":[129],"our":[130,176],"one":[133],"maximum":[136],"across":[138],"all":[139],"minimized.":[143],"Experiments":[144],"with":[145,165],"synthetic":[146],"real-world":[148],"quantify":[150],"impact":[152],"on":[155],"query":[159],"performance":[160],"keys,":[168],"insight":[171],"into":[172],"efficacy":[174],"suite.":[178]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4380433121","counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1}],"updated_date":"2025-01-18T10:56:53.284227","created_date":"2023-06-14"}