{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,1,28]],"date-time":"2025-01-28T05:17:00Z","timestamp":1738041420683,"version":"3.33.0"},"reference-count":30,"publisher":"World Scientific Pub Co Pte Ltd","issue":"01","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Int. J. Unc. Fuzz. Knowl. Based Syst."],"published-print":{"date-parts":[[2025,1]]},"abstract":"<jats:p> Instead of storing data in rows, a columnar database is a type of Database Management System (DBMS). To speed up the processing and reply to a question, a columnar database\u2019s job is to efficiently write and read data to and from hard disc storage. One of the most crucial methods in the creation of column-oriented database systems is compression. For columns with Zero-length string types, all heavier and light-in-weight compression techniques have limitations. Processing of transactions online,\u00a0these databases are substantially more effective for online analytical processing than for online transactional processing. This indicates that although they are made to examine transactions, they are not very effective at updating them. To overcome these issues a Zero Length Recurrent based Fruit Fly Optimization (ZLRFF) model is used. Additionally, a reduction technique is known as ZLRFF was designed to achieve a high compression ratio and allow straight lookups on compressed material without decompression first. ZLRFF\u2019s main goal is to divide a Zero-length string written column vertically into smaller columns that can each be compressed using a separate lightweight compression technique. To search directly on compressed data, we also provide a search technique we call FF-search. Extensive testing demonstrates that ZLRFF supports direct searching on compressed data in addition to achieving a decent compression ratio, which enhances query performance. <\/jats:p>","DOI":"10.1142\/s0218488525500023","type":"journal-article","created":{"date-parts":[[2025,1,27]],"date-time":"2025-01-27T06:08:01Z","timestamp":1737958081000},"page":"29-53","source":"Crossref","is-referenced-by-count":0,"title":["An Intelligent Optimized Compression Framework for Columnar Database"],"prefix":"10.1142","volume":"33","author":[{"given":"B. A.","family":"Jadhawar","sequence":"first","affiliation":[{"name":"Research Scholar, Department of Computer Science and Engineering, Sri Satya Sai University of Technology and Medical Sciences, Sehore, MP, India"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Narendra","family":"Sharma","sequence":"additional","affiliation":[{"name":"Associate Professor, Sri Satya Sai University of Technology and Medical Sciences, Sehore, MP, India"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"219","published-online":{"date-parts":[[2025,1,27]]},"reference":[{"key":"S0218488525500023BIB001","doi-asserted-by":"publisher","DOI":"10.1007\/s00766-020-00331-3"},{"key":"S0218488525500023BIB002","author":"Sadineni P. K.","year":"2021","journal-title":"Materials Today: Proceedings"},{"key":"S0218488525500023BIB003","doi-asserted-by":"publisher","DOI":"10.1007\/978-981-15-7421-4_11"},{"key":"S0218488525500023BIB004","volume-title":"2020 15th Iberian Conference on Information Systems and Technologies (CISTI)","author":"Holanda M.","year":"2020"},{"key":"S0218488525500023BIB005","doi-asserted-by":"publisher","DOI":"10.1109\/ICICT50521.2020.00018"},{"key":"S0218488525500023BIB006","volume-title":"International Conference on Intelligent Systems Design and Applications","author":"Dabb\u00e8chi H.","year":"2020"},{"key":"S0218488525500023BIB007","doi-asserted-by":"publisher","DOI":"10.1109\/BigData50022.2020.9378124"},{"key":"S0218488525500023BIB008","doi-asserted-by":"publisher","DOI":"10.1007\/978-981-15-0694-9_39"},{"key":"S0218488525500023BIB009","doi-asserted-by":"publisher","DOI":"10.1109\/ICCSE49874.2020.9201706"},{"key":"S0218488525500023BIB010","doi-asserted-by":"publisher","DOI":"10.3390\/app11104557"},{"key":"S0218488525500023BIB011","doi-asserted-by":"publisher","DOI":"10.1016\/j.bdr.2021.100206"},{"issue":"5","key":"S0218488525500023BIB012","first-page":"104","volume":"8","author":"Binchao Z.","year":"2020","journal-title":"Journal of Environmental Chemical Engineering"},{"key":"S0218488525500023BIB013","author":"Prajwol S.","year":"2020","journal-title":"IEEE Transactions on Big Data"},{"key":"S0218488525500023BIB014","doi-asserted-by":"publisher","DOI":"10.1109\/ICCMC51019.2021.9418441"},{"key":"S0218488525500023BIB015","doi-asserted-by":"publisher","DOI":"10.1002\/ett.4084"},{"key":"S0218488525500023BIB016","first-page":"103","author":"Varsha M.","year":"2021","journal-title":"Inventive Communication and Computational Technologies"},{"key":"S0218488525500023BIB017","doi-asserted-by":"publisher","DOI":"10.1007\/978-981-16-1941-0_43"},{"key":"S0218488525500023BIB018","doi-asserted-by":"publisher","DOI":"10.1109\/ACCESS.2020.3003269"},{"key":"S0218488525500023BIB019","author":"Faezeh M.","year":"2021","journal-title":"IEEE Access"},{"key":"S0218488525500023BIB020","first-page":"100","volume":"25","author":"Lu\u00eds de C. R. C.","year":"2021","journal-title":"Big Data Research"},{"key":"S0218488525500023BIB021","first-page":"102","volume":"54","author":"Franck R.","year":"2020","journal-title":"International Journal of Information Management"},{"issue":"2","key":"S0218488525500023BIB022","first-page":"1731","volume":"27","author":"Dylan C.","year":"2020","journal-title":"IEEE Transactions on Visualization and Computer Graphics"},{"key":"S0218488525500023BIB023","author":"Sohail I.","year":"2020","journal-title":"IEEE\/CAA Journal of AutomaticaSinica"},{"key":"S0218488525500023BIB024","doi-asserted-by":"publisher","DOI":"10.1002\/cpe.5523"},{"key":"S0218488525500023BIB025","first-page":"100","volume":"25","author":"Bryan M.","year":"2021","journal-title":"Big Data Research"},{"key":"S0218488525500023BIB026","doi-asserted-by":"publisher","DOI":"10.1016\/j.procs.2018.05.043"},{"key":"S0218488525500023BIB027","first-page":"100","volume":"31","author":"Wenhai L.","year":"2023","journal-title":"Big Data Research"},{"key":"S0218488525500023BIB028","author":"Faezeh M.","year":"2021","journal-title":"IEEE Access"},{"key":"S0218488525500023BIB029","doi-asserted-by":"publisher","DOI":"10.1016\/j.bdr.2021.100206"},{"key":"S0218488525500023BIB030","doi-asserted-by":"publisher","DOI":"10.14778\/1920841.1920927"}],"container-title":["International Journal of Uncertainty, Fuzziness and Knowledge-Based Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.worldscientific.com\/doi\/pdf\/10.1142\/S0218488525500023","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,1,27]],"date-time":"2025-01-27T06:08:21Z","timestamp":1737958101000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.worldscientific.com\/doi\/10.1142\/S0218488525500023"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,1]]},"references-count":30,"journal-issue":{"issue":"01","published-print":{"date-parts":[[2025,1]]}},"alternative-id":["10.1142\/S0218488525500023"],"URL":"https:\/\/doi.org\/10.1142\/s0218488525500023","relation":{},"ISSN":["0218-4885","1793-6411"],"issn-type":[{"value":"0218-4885","type":"print"},{"value":"1793-6411","type":"electronic"}],"subject":[],"published":{"date-parts":[[2025,1]]}}}