Query rewriting method for sub-database and sub-table routing strategy of distributed database

• Main Authors: WEN QISHU, YAN ZHICHAO, YANG XIONG
• Format: Patent
• Language: Chinese; English
• Published: 29.09.2023
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

The invention discloses a query rewriting method for a sub-database and sub-table routing strategy of a distributed database, and relates to the technical field of e-commerce database application, the method comprises the following steps: step S1, establishing data routing tables of different dimensions according to different service types; s2, scanning a database, and establishing data service identifiers in different routers; s3, the query statements are disassembled, and different query statements are established; s4, computing resources are distributed for different sub-queries, and query is executed; s5, rewriting the identifier and updating the route according to whether the query statement is hit or not; and S6, summarizing calculation results. According to the query rewriting method for the sub-database sub-table routing strategy of the distributed database, the distributed database is subjected to query retrieval by adopting a query sub-writing mode, full data retrieval is avoided through routing set