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

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 dimens...

Full description

Saved in:
Bibliographic Details
Main Authors WEN QISHU, YAN ZHICHAO, YANG XIONG
Format Patent
LanguageChinese
English
Published 29.09.2023
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary: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
Bibliography:Application Number: CN202310264230