Tahir Alyas1, Ali Alzahrani2, Yazed Alsaawy2, Khalid Alissa3, Qaiser Abbas2, Nadia Tabassum4,*
CMC-Computers, Materials & Continua, Vol.74, No.1, pp. 2317-2330, 2023, DOI:10.32604/cmc.2023.032454
Abstract The query optimizer uses cost-based optimization to create an execution plan with the least cost, which also consumes the least amount of resources. The challenge of query optimization for relational database systems is a combinatorial optimization problem, which renders exhaustive search impossible as query sizes rise. Increases in CPU performance have surpassed main memory, and disk access speeds in recent decades, allowing data compression to be used—strategies for improving database performance systems. For performance enhancement, compression and query optimization are the two most factors. Compression reduces the volume of data, whereas query optimization minimizes execution time. Compressing the database reduces… More >
Login
Register
