Optimizing Database Systems for Parallel Processing in Multi-core Environments

In contemporary times, parallel database systems have gained widespread acceptance, finding applications in both online transaction processing (OLTP) servers and online analytical processing (OLAP) servers. These advancements encompass the realms of parallel database processing and querying. A pivotal technique in enhancing the efficiency of parallel database systems, particularly in the context of data warehousing, is parallel query optimization. When presented with an SQL query, parallel query optimization diligently explores parallel plans to identify the one that yields the query result most swiftly. The focal point of this research article revolves around introducing an innovative strategy for parallelizing the execution of multithreaded queries in relational databases. The objective is to optimize the utilization of CPU and memory resources to their fullest potential. This approach adeptly addresses the challenge of reducing response time for concurrent database queries, thereby significantly enhancing their efficiency.