The invention relates to the technical field of distributed databases and
query optimization, and discloses a data routing method, device and equipment based on
metadata indexing.The method comprises the steps that query predicate information of a
data query request is analyzed; reading
metadata index information associated with the data fragments when the query does not contain the fragment key; executing multi-stage filtering analysis based on the
metadata index and generating a matching analysis result; according to a matching analysis result, data fragments which do not contain the target data are removed to form a target fragment
list; selecting a routing strategy in combination with
system operation state information and data distribution characteristics; and generating a query
execution plan according to the routing strategy, and carrying out aggregation
processing on query results returned by the target data fragments to obtain a final query result. According to the method, the query range is narrowed through multi-stage filtering, the routing strategy is selected based on the
system state, invalid fragment access is reduced, resource overhead is reduced, and query performance is improved.