Method for parallel query processing of data comprising a replica in distributed database

摘要

The present invention changes a query for data in which a replica exists in a distributed database into a plurality of range condition queries corresponding to the number of nodes in which a replica is stored, and simultaneously executes a range condition query in multiple nodes, thereby allowing a large amount of replicas to exist. The present invention relates to a technique for reducing query execution time for distributed data. According to the present invention, a query parallelization method for a table in which a replica of a distributed database exists is performed by analyzing a query requested from a client in a master server, and when the target table is a distributed table and the target table includes columns that can specify a range. A first step of determining the query as a split target query; a second step of determining whether the number of search target records for the split target query in the master server exceeds a preset reference record number; In case of exceeding the preset reference record number, the third step of checking the slave server where the source and the copy exist, the record area is divided by the master server based on the number of records to be searched and the number of the slave server where the copy exists. To generate a range query to the server And a fifth step of simultaneously transmitting a range query from the master server to each slave server and collecting and merging corresponding range query execution result data from each slave server, thereby generating a result for the query requested from the client. Characterized in that comprises a step.