{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,2,21]],"date-time":"2025-02-21T22:38:59Z","timestamp":1740177539881,"version":"3.37.3"},"reference-count":34,"publisher":"Institute of Electrical and Electronics Engineers (IEEE)","issue":"3","license":[{"start":{"date-parts":[[2024,5,1]],"date-time":"2024-05-01T00:00:00Z","timestamp":1714521600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/ieeexplore.ieee.org\/Xplorehelp\/downloads\/license-information\/IEEE.html"},{"start":{"date-parts":[[2024,5,1]],"date-time":"2024-05-01T00:00:00Z","timestamp":1714521600000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-029"},{"start":{"date-parts":[[2024,5,1]],"date-time":"2024-05-01T00:00:00Z","timestamp":1714521600000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-037"}],"funder":[{"DOI":"10.13039\/501100001809","name":"National Natural Science Foundation of China","doi-asserted-by":"publisher","award":["62102201","62062002"],"award-info":[{"award-number":["62102201","62062002"]}],"id":[{"id":"10.13039\/501100001809","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/501100004772","name":"Natural Science Foundation of Ningxia Province","doi-asserted-by":"publisher","award":["2022AAC05010","2021BEB04054","2021AAC03034"],"award-info":[{"award-number":["2022AAC05010","2021BEB04054","2021AAC03034"]}],"id":[{"id":"10.13039\/501100004772","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["IEEE Trans. Sustain. Comput."],"published-print":{"date-parts":[[2024,5]]},"DOI":"10.1109\/tsusc.2023.3279382","type":"journal-article","created":{"date-parts":[[2023,6,5]],"date-time":"2023-06-05T18:00:55Z","timestamp":1685988055000},"page":"409-421","source":"Crossref","is-referenced-by-count":0,"title":["Thorough Data Pruning for Join Query in Database System"],"prefix":"10.1109","volume":"9","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-2206-2013","authenticated-orcid":false,"given":"Gao","family":"Jintao","sequence":"first","affiliation":[{"name":"School of Information Engineering, Key Laboratory of the Internet of Water, Digital Water Governance of the Yellow River in Ningxia, Ningxia University, Ningxia, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0003-6936-5745","authenticated-orcid":false,"given":"Li","family":"Zhanhuai","sequence":"additional","affiliation":[{"name":"School of Computer, Northwestern Polytechnical University, Beilin, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0005-3415-4512","authenticated-orcid":false,"given":"Sun","family":"Jian","sequence":"additional","affiliation":[{"name":"School of Computer, North Minzu University, Yinchuan, China"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"263","reference":[{"key":"ref1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2882917"},{"key":"ref3","doi-asserted-by":"publisher","DOI":"10.14778\/3090163.3090167"},{"key":"ref4","first-page":"603","volume-title":"Discrete Mathematics and its Applications","author":"Kenneth","year":"2011"},{"key":"ref5","doi-asserted-by":"publisher","DOI":"10.1145\/3186728.3164145"},{"volume-title":"Data Base System Concepts","year":"2010","author":"Silberschatz","key":"ref6"},{"article-title":"Statistics in postgresql","year":"2021","author":"Stonebraker","key":"ref7"},{"key":"ref8","doi-asserted-by":"publisher","DOI":"10.1017\/9781108779302"},{"key":"ref9","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-017-0480-7"},{"key":"ref10","doi-asserted-by":"publisher","DOI":"10.14778\/3389133.3389138"},{"key":"ref11","doi-asserted-by":"publisher","DOI":"10.14778\/3236187.3236191"},{"key":"ref12","first-page":"96","article-title":"Query optimization by predicate movearound","volume-title":"Proc. 20th Int. Conf. Very Large Data Bases","author":"Levy"},{"key":"ref13","doi-asserted-by":"publisher","DOI":"10.1145\/191839.191860"},{"key":"ref14","doi-asserted-by":"publisher","DOI":"10.1145\/235968.233360"},{"key":"ref15","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2014.6816727"},{"key":"ref16","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3064053"},{"year":"2017","key":"ref17","article-title":"Columnstore index performance: Rowgroup elimination"},{"year":"2018","key":"ref18","article-title":"Processing petabytes of data in seconds with databricks delta"},{"key":"ref19","doi-asserted-by":"publisher","DOI":"10.14778\/1454159.1454166"},{"year":"2020","key":"ref20","article-title":"The introduction for query optimization"},{"key":"ref21","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2004.1320002"},{"key":"ref22","doi-asserted-by":"publisher","DOI":"10.14778\/3192965.3192969"},{"key":"ref23","doi-asserted-by":"publisher","DOI":"10.14778\/3425879.3425880"},{"key":"ref24","doi-asserted-by":"publisher","DOI":"10.26483\/ijarcs.v9i2.5731"},{"key":"ref25","doi-asserted-by":"publisher","DOI":"10.17485\/ijst\/2018\/v11i18\/119112"},{"key":"ref26","doi-asserted-by":"publisher","DOI":"10.14778\/3199517.3199518"},{"year":"2006","key":"ref27","article-title":"Query execution bitmap filters"},{"key":"ref28","doi-asserted-by":"publisher","DOI":"10.14778\/3494124.3494136"},{"key":"ref29","doi-asserted-by":"publisher","DOI":"10.14778\/3368289.3368292"},{"key":"ref30","doi-asserted-by":"publisher","DOI":"10.1145\/3127479.3131613"},{"first-page":"1115","volume-title":"Proc. Int. Conf. Manage. Data","author":"Sun","key":"ref31"},{"key":"ref32","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2015.7113294"},{"key":"ref33","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-018-0507-8"},{"key":"ref35","doi-asserted-by":"publisher","DOI":"10.1016\/j.bdr.2020.100178"},{"key":"ref36","doi-asserted-by":"publisher","DOI":"10.1109\/tcc.2022.3161297"}],"container-title":["IEEE Transactions on Sustainable Computing"],"original-title":[],"link":[{"URL":"http:\/\/xplorestaging.ieee.org\/ielx7\/7274860\/10550109\/10144258.pdf?arnumber=10144258","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,6,25]],"date-time":"2024-06-25T21:07:34Z","timestamp":1719349654000},"score":1,"resource":{"primary":{"URL":"https:\/\/ieeexplore.ieee.org\/document\/10144258\/"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,5]]},"references-count":34,"journal-issue":{"issue":"3"},"URL":"https:\/\/doi.org\/10.1109\/tsusc.2023.3279382","relation":{},"ISSN":["2377-3782","2377-3790"],"issn-type":[{"type":"electronic","value":"2377-3782"},{"type":"electronic","value":"2377-3790"}],"subject":[],"published":{"date-parts":[[2024,5]]}}}