{"id":"https://openalex.org/W4379382260","doi":"https://doi.org/10.1109/tsusc.2023.3279382","title":"Thorough Data Pruning for Join Query in Database System","display_name":"Thorough Data Pruning for Join Query in Database System","publication_year":2023,"publication_date":"2023-06-05","ids":{"openalex":"https://openalex.org/W4379382260","doi":"https://doi.org/10.1109/tsusc.2023.3279382"},"language":"en","primary_location":{"id":"doi:10.1109/tsusc.2023.3279382","is_oa":false,"landing_page_url":"http://dx.doi.org/10.1109/tsusc.2023.3279382","pdf_url":null,"source":{"id":"https://openalex.org/S4210221417","display_name":"IEEE Transactions on Sustainable Computing","issn_l":"2377-3782","issn":["2377-3782","2377-3790"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Sustainable Computing","raw_type":"journal-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/A5060570984","display_name":"Gao Jintao","orcid":"https://orcid.org/0000-0002-2206-2013"},"institutions":[{"id":"https://openalex.org/I21642278","display_name":"Ningxia University","ror":"https://ror.org/04j7b2v61","country_code":"CN","type":"education","lineage":["https://openalex.org/I21642278"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Gao Jintao","raw_affiliation_strings":["School of Information Engineering, Key Laboratory of the Internet of Water, Digital Water Governance of the Yellow River in Ningxia, Ningxia University, Ningxia, China","School of Information Engineering, Ningxia University, China"],"raw_orcid":"https://orcid.org/0000-0002-2206-2013","affiliations":[{"raw_affiliation_string":"School of Information Engineering, Key Laboratory of the Internet of Water, Digital Water Governance of the Yellow River in Ningxia, Ningxia University, Ningxia, China","institution_ids":["https://openalex.org/I21642278"]},{"raw_affiliation_string":"School of Information Engineering, Ningxia University, China","institution_ids":["https://openalex.org/I21642278"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041615627","display_name":"Zhanhuai Li","orcid":"https://orcid.org/0009-0003-6936-5745"},"institutions":[{"id":"https://openalex.org/I17145004","display_name":"Northwestern Polytechnical University","ror":"https://ror.org/01y0j0j86","country_code":"CN","type":"education","lineage":["https://openalex.org/I17145004"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Li Zhanhuai","raw_affiliation_strings":["School of Computer, Northwestern Polytechnical University, Beilin, China"],"raw_orcid":"https://orcid.org/0009-0003-6936-5745","affiliations":[{"raw_affiliation_string":"School of Computer, Northwestern Polytechnical University, Beilin, China","institution_ids":["https://openalex.org/I17145004"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5114549769","display_name":"Sun Jian","orcid":"https://orcid.org/0009-0005-3415-4512"},"institutions":[{"id":"https://openalex.org/I3019309368","display_name":"North Minzu University","ror":"https://ror.org/05xjevr11","country_code":"CN","type":"education","lineage":["https://openalex.org/I3019309368"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Sun Jian","raw_affiliation_strings":["School of Computer, North Minzu University, Yinchuan, China"],"raw_orcid":"https://orcid.org/0009-0005-3415-4512","affiliations":[{"raw_affiliation_string":"School of Computer, North Minzu University, Yinchuan, China","institution_ids":["https://openalex.org/I3019309368"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"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.0682243,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"9","issue":"3","first_page":"409","last_page":"421"},"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.9998000264167786,"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.9998000264167786,"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/T11106","display_name":"Data Management and Algorithms","score":0.9998000264167786,"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/T12292","display_name":"Graph Theory and Algorithms","score":0.996399998664856,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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.6877428293228149},{"id":"https://openalex.org/keywords/robustness","display_name":"Robustness (evolution)","score":0.6518439054489136},{"id":"https://openalex.org/keywords/pruning","display_name":"Pruning","score":0.6149699687957764},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.4722927212715149},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.39359283447265625},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.39083272218704224},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.24147245287895203}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6877428293228149},{"id":"https://openalex.org/C63479239","wikidata":"https://www.wikidata.org/wiki/Q7353546","display_name":"Robustness (evolution)","level":3,"score":0.6518439054489136},{"id":"https://openalex.org/C108010975","wikidata":"https://www.wikidata.org/wiki/Q500094","display_name":"Pruning","level":2,"score":0.6149699687957764},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.4722927212715149},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.39359283447265625},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.39083272218704224},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.24147245287895203},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"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/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","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/C6557445","wikidata":"https://www.wikidata.org/wiki/Q173113","display_name":"Agronomy","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tsusc.2023.3279382","is_oa":false,"landing_page_url":"http://dx.doi.org/10.1109/tsusc.2023.3279382","pdf_url":null,"source":{"id":"https://openalex.org/S4210221417","display_name":"IEEE Transactions on Sustainable Computing","issn_l":"2377-3782","issn":["2377-3782","2377-3790"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Sustainable Computing","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.5400000214576721}],"awards":[{"id":"https://openalex.org/G1181177085","display_name":null,"funder_award_id":"2021BEB04054","funder_id":"https://openalex.org/F4320322877","funder_display_name":"Natural Science Foundation of Ningxia Province"},{"id":"https://openalex.org/G3024207840","display_name":null,"funder_award_id":"62102201","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G5617976402","display_name":null,"funder_award_id":"2021AAC03034","funder_id":"https://openalex.org/F4320322877","funder_display_name":"Natural Science Foundation of Ningxia Province"},{"id":"https://openalex.org/G8547729479","display_name":null,"funder_award_id":"2022AAC05010","funder_id":"https://openalex.org/F4320322877","funder_display_name":"Natural Science Foundation of Ningxia Province"},{"id":"https://openalex.org/G914663430","display_name":"\u9762\u5411\u591a\u6d41\u56fa\u6001\u76d8\u7684\u6027\u80fd\u4f18\u5316\u6280\u672f\u7814\u7a76","funder_award_id":"62062002","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320322877","display_name":"Natural Science Foundation of Ningxia Province","ror":null}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":28,"referenced_works":["https://openalex.org/W1512840853","https://openalex.org/W1513730131","https://openalex.org/W1594122454","https://openalex.org/W2026354416","https://openalex.org/W2087796842","https://openalex.org/W2119400430","https://openalex.org/W2400908863","https://openalex.org/W2440477515","https://openalex.org/W2612705754","https://openalex.org/W2613226836","https://openalex.org/W2755385361","https://openalex.org/W2756982556","https://openalex.org/W2798603477","https://openalex.org/W2800798464","https://openalex.org/W2803541036","https://openalex.org/W2806395320","https://openalex.org/W2888876958","https://openalex.org/W2992496917","https://openalex.org/W2999791986","https://openalex.org/W3022398217","https://openalex.org/W3107842002","https://openalex.org/W3111294584","https://openalex.org/W4210814924","https://openalex.org/W4220873097","https://openalex.org/W4221135977","https://openalex.org/W4242142158","https://openalex.org/W4245765815","https://openalex.org/W6675450584"],"related_works":["https://openalex.org/W4245395944","https://openalex.org/W2143551613","https://openalex.org/W2138823233","https://openalex.org/W1979740464","https://openalex.org/W2143345456","https://openalex.org/W1789991335","https://openalex.org/W2562731034","https://openalex.org/W4315705795","https://openalex.org/W2101053337","https://openalex.org/W1870651561"],"abstract_inverted_index":{"The":[0,166],"improvement":[1],"of":[2,24,59],"robustness":[3,48,137],"and":[4,49,66,77,94,127,138,156,162],"efficiency":[5,50,139,184],"for":[6,13,80,100,135],"multi-way":[7,180],"equijoin":[8,181],"query":[9,29,182],"is":[10,69],"challenging,":[11],"no-matter":[12],"centralized":[14],"database":[15,19],"systems":[16],"or":[17],"distributed":[18],"systems.":[20],"Due":[21],"to":[22,114,154,172],"lots":[23],"unnecessary":[25,43,107],"data":[26,44,81,97,174],"existing":[27],"during":[28],"processing,":[30],"these":[31],"two":[32],"metrics":[33],"will":[34,51],"be":[35,52],"seriously":[36],"reduced.":[37],"If":[38],"we":[39],"can":[40,178],"thoroughly":[41,105],"prune":[42],"in":[45,131,148],"advance,":[46],"the":[47,56,129,143],"highly":[53],"improved.":[54],"However,":[55],"pruning":[57,87,98,102,106,117,175],"power":[58],"current":[60],"strategies,":[61],"such":[62],"as":[63],"predicate":[64],"push-down":[65],"algebraic":[67],"equivalence,":[68],"limited.":[70],"We":[71,145],"present":[72],"deepDP,":[73],"a":[74,121],"powerful,":[75],"generalized,":[76],"efficient":[78],"strategy":[79,99,113],"pruning.":[82],"deepDP":[83,109,147,158,177],"builds":[84],"multiple":[85],"independent":[86],"spaces":[88,134],"by":[89,185],"generating":[90],"longest":[91],"transitive":[92],"closures":[93],"applies":[95],"appropriate":[96],"each":[101,116],"space.":[103],"For":[104],"data,":[108],"employs$\\alpha":[110],"\\cdot":[111],"\\beta$pruning":[112],"clean":[115],"space":[118],"based":[119],"on":[120,159,183],"newly":[122],"designed":[123],"statistic":[124],"information-Hollow":[125],"Range":[126],"re-shuffles":[128],"elements":[130],"all":[132],"pruned":[133],"maximizing":[136],"benefits":[140],"meanwhile":[141],"minimizing":[142],"invasion.":[144],"implement":[146],"PostgreSQL":[149],"but":[150],"are":[151],"not":[152],"limited":[153],"it,":[155],"evaluate":[157],"TPC-H,":[160],"JOB,":[161],"our":[163],"synthesis":[164],"benchmark\u2013DHR.":[165],"experiment":[167],"results":[168],"show":[169],"that":[170],"compared":[171],"traditional":[173],"strategy,":[176],"improve":[179],"3.5x.":[186]},"counts_by_year":[],"updated_date":"2026-07-29T09:40:50.615796","created_date":"2025-10-10T00:00:00"}