Operator parallel optimization strategy for distributed databases
With the continuous development of network technology,the scale of data has shown explosive growth,which leads gradually to replacing traditional single machine databases with distributed databases.Distributed data-bases solve large-scale data storage problems through collaborative work among nodes,but due to increased commu-nication costs between nodes,its query efficiency is not as good as a standalone database.In a distributed architec-ture,the data of storage nodes is only used as redundancy for multiple backups,providing data recovery in case of system failure,and it is not utilized to improve query efficiency.In response to the above issues,this article propo-ses an operator parallel optimization strategy for distributed databases.By splitting key physical operators,the split sub requests are evenly distributed to multiple nodes in the storage layer,which are processed in parallel by multi-ple nodes,thereby reducing query response time.The above strategy has been applied on distributed database CBase,and experiments have shown that the parallel optimization strategy proposed in this paper can significantly shorten SQL request query time and improve system resource utilization.
万方数据
维普
