{"id":"https://openalex.org/W4379135671","doi":"https://doi.org/10.1145/3584372.3588658","title":"Quantifying the Loss of Acyclic Join Dependencies","display_name":"Quantifying the Loss of Acyclic Join Dependencies","publication_year":2023,"publication_date":"2023-06-02","ids":{"openalex":"https://openalex.org/W4379135671","doi":"https://doi.org/10.1145/3584372.3588658"},"language":"en","primary_location":{"id":"doi:10.1145/3584372.3588658","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3584372.3588658","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 42nd ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","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/A5047636495","display_name":"Batya Kenig","orcid":"https://orcid.org/0000-0001-6349-128X"},"institutions":[{"id":"https://openalex.org/I174306211","display_name":"Technion \u2013 Israel Institute of Technology","ror":"https://ror.org/03qryx823","country_code":"IL","type":"education","lineage":["https://openalex.org/I174306211"]}],"countries":["IL"],"is_corresponding":true,"raw_author_name":"Batya Kenig","raw_affiliation_strings":["Technion, Israel Institute of Technology, Haifa, Israel"],"affiliations":[{"raw_affiliation_string":"Technion, Israel Institute of Technology, Haifa, Israel","institution_ids":["https://openalex.org/I174306211"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5076051906","display_name":"Nir Weinberger","orcid":"https://orcid.org/0000-0001-6028-8892"},"institutions":[{"id":"https://openalex.org/I174306211","display_name":"Technion \u2013 Israel Institute of Technology","ror":"https://ror.org/03qryx823","country_code":"IL","type":"education","lineage":["https://openalex.org/I174306211"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Nir Weinberger","raw_affiliation_strings":["Technion, Israel Institute of Technology, Haifa, Israel"],"affiliations":[{"raw_affiliation_string":"Technion, Israel Institute of Technology, Haifa, Israel","institution_ids":["https://openalex.org/I174306211"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5047636495"],"corresponding_institution_ids":["https://openalex.org/I174306211"],"apc_list":null,"apc_paid":null,"fwci":0.5991,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.67379362,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":96,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"329","last_page":"338"},"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.9994999766349792,"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.9994999766349792,"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.9988999962806702,"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/T11106","display_name":"Data Management and Algorithms","score":0.9952999949455261,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.878976583480835},{"id":"https://openalex.org/keywords/upper-and-lower-bounds","display_name":"Upper and lower bounds","score":0.616661012172699},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.520724356174469},{"id":"https://openalex.org/keywords/lossless-compression","display_name":"Lossless compression","score":0.5011885166168213},{"id":"https://openalex.org/keywords/functional-dependency","display_name":"Functional dependency","score":0.4796874225139618},{"id":"https://openalex.org/keywords/relation","display_name":"Relation (database)","score":0.4710542857646942},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.4634532630443573},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.461463987827301},{"id":"https://openalex.org/keywords/divergence","display_name":"Divergence (linguistics)","score":0.44891390204429626},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.43431907892227173},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.3702932298183441},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3678823709487915},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.3125687539577484},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.29363149404525757},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.24706357717514038},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.20560118556022644},{"id":"https://openalex.org/keywords/data-compression","display_name":"Data compression","score":0.15309876203536987},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.10794469714164734}],"concepts":[{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.878976583480835},{"id":"https://openalex.org/C77553402","wikidata":"https://www.wikidata.org/wiki/Q13222579","display_name":"Upper and lower bounds","level":2,"score":0.616661012172699},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.520724356174469},{"id":"https://openalex.org/C81081738","wikidata":"https://www.wikidata.org/wiki/Q55542","display_name":"Lossless compression","level":3,"score":0.5011885166168213},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.4796874225139618},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.4710542857646942},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.4634532630443573},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.461463987827301},{"id":"https://openalex.org/C207390915","wikidata":"https://www.wikidata.org/wiki/Q1230525","display_name":"Divergence (linguistics)","level":2,"score":0.44891390204429626},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.43431907892227173},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.3702932298183441},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3678823709487915},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3125687539577484},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.29363149404525757},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.24706357717514038},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.20560118556022644},{"id":"https://openalex.org/C78548338","wikidata":"https://www.wikidata.org/wiki/Q2493","display_name":"Data compression","level":2,"score":0.15309876203536987},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.10794469714164734},{"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/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3584372.3588658","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3584372.3588658","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 42nd ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G5013039200","display_name":null,"funder_award_id":"1782/22","funder_id":"https://openalex.org/F4320322252","funder_display_name":"Israel Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320322252","display_name":"Israel Science Foundation","ror":"https://ror.org/04sazxf24"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W568673721","https://openalex.org/W1978460233","https://openalex.org/W1985239372","https://openalex.org/W2006772093","https://openalex.org/W2013026082","https://openalex.org/W2110810394","https://openalex.org/W2113123266","https://openalex.org/W2136256269","https://openalex.org/W2139238107","https://openalex.org/W2148417962","https://openalex.org/W2284514301","https://openalex.org/W2948085204","https://openalex.org/W2962991166","https://openalex.org/W3029264065"],"related_works":["https://openalex.org/W2116767780","https://openalex.org/W165346131","https://openalex.org/W1594511838","https://openalex.org/W4285259755","https://openalex.org/W2936448214","https://openalex.org/W2136256269","https://openalex.org/W2535582266","https://openalex.org/W2910962884","https://openalex.org/W1907232082","https://openalex.org/W2059693475"],"abstract_inverted_index":{"Acyclic":[0],"schemes":[1],"posses":[2],"known":[3],"benefits":[4],"for":[5,178],"database":[6,158],"design,":[7],"speeding":[8],"up":[9],"queries,":[10],"and":[11,44,160],"reducing":[12],"space":[13],"requirements.":[14],"An":[15,42],"acyclic":[16,62,90],"join":[17],"dependency":[18],"(AJD)":[19],"is":[20,53,115],"lossless":[21],"with":[22,33,174],"respect":[23],"to":[24,92,131],"a":[25,93,140,156,162],"universal":[26,40,94],"relation":[27],"if":[28],"joining":[29],"the":[30,34,38,54,61,69,84,98,110,118,126,133,145,167,175],"projections":[31],"associated":[32],"schema":[35,91],"results":[36],"in":[37],"original":[39],"relation.":[41],"intuitive":[43],"standard":[45],"measure":[46],"of":[47,56,71,86,104,112,120,135,147,169],"loss":[48,70,111],"entailed":[49],"by":[50,60,78,83],"an":[51,72,79,89,113,151],"AJD":[52,73,114],"number":[55,134],"redundant":[57,136,148,170],"tuples":[58],"generated":[59],"join.":[63],"Recent":[64],"work":[65],"has":[66],"shown":[67],"that":[68,109,125],"can":[74,128],"also":[75],"be":[76,129],"characterized":[77],"information-theoretic":[80],"measure.":[81],"Motivated":[82],"problem":[85],"automatically":[87],"fitting":[88],"relation,":[95],"we":[96,154],"investigate":[97],"connection":[99],"between":[100],"these":[101],"two":[102],"characterizations":[103],"loss.":[105],"We":[106,122,138],"first":[107],"show":[108,124],"captured":[116],"using":[117],"notion":[119],"KL-Divergence.":[121],"then":[123],"KL-divergence":[127],"used":[130],"bound":[132,143,165,177],"tuples.":[137,149],"prove":[139],"deterministic":[141],"lower":[142,176],"on":[144,166],"percentage":[146,168],"For":[150],"upper":[152],"bound,":[153],"propose":[155],"random":[157],"model,":[159],"establish":[161],"high":[163],"probability":[164],"tuples,":[171],"which":[172],"coincides":[173],"large":[179],"databases.":[180]},"counts_by_year":[{"year":2025,"cited_by_count":3}],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-10-10T00:00:00"}