Method for solving correlated query of distributed cross-database fragment table

Abstract

The invention discloses a method for solving the correlated query of a distributed cross-database fragment table. The method comprises the following steps: constructing a correlated relationship between a CUSTOMERS fragment table and an ORDERS fragment table; appointing the table name, all distributed nodes, the fragment field and the fragment rule of the CUSTOMERS fragment table; meanwhile, appointing the table name, the foreign key listing and the listing of a list quoted by a foreign key of the ORDERS fragment table; and causing a storage operation of the CUSTOMERS fragment table to be the normal storage operation, and causing the storage operation of the ORDERS fragment table to be executed according to a node where associated CUSTOMERS fragment table data is positioned, wherein the CUSTOMERS fragment table is a conventional fragment table, and the CUSTOMERS fragment table needs to be associated with the conventional fragment table.

Description

Technical field [0001] The invention relates to the technical field of network communication, and in particular to a method for solving distributed cross-database sharding table association queries. Background technique [0002] 1. The current solution to the solution of distributed cross-database sharding table association is to use data redundancy to redundantly all the associated table data to all node databases, so as to solve distributed middle-span database sharding The problem of associative query. Such as figure 1 Shown: If the data of the CUSTOMERS sharded table is distributed in two databases dn1 and dn2, and the CUSTOMERS sharded table needs to be associated with the ORDERS sharded table, then all the data of the ORDERS sharded table is stored in those two In the database (dn1, dn2), the ORDERS sharded table is called the global table at this time, and the data of the ORDERS sharded table must be consistent on all child nodes in the distributed environment. Although ...

AI Technical Summary

Problems solved by technology

[0004] The purpose of the present invention is to solve the defects of the existing technology, provide a method that does not waste additional data storage space, does not cause too much impact on the system performance of each sub-node, and also ensures that the entire distributed cluster can have more efficient table association Query performance The method for solving the associated query of distributed cross-database sharding tables adopts the following technical solutions:

Images