Cross-source synchronization table index creation method and device, equipment, medium and program product

By receiving query statements, extracting condition fields, calculating dispersion indicators, and automatically creating indexes, the problem of low query efficiency in cross-source data synchronization of online databases is solved, achieving efficient index management and resource utilization.

CN122364217APending Publication Date: 2026-07-10INDUSTRIAL AND COMMERCIAL BANK OF CHINA
0 Cites 0 Cited by

Patent Information

Application Number
CN202610240187.5
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2026-02-28
Publication Date
2026-07-10

AI Technical Summary

Technical Problem

In cross-source data synchronization scenarios, online databases lack suitable indexes, making it impossible to efficiently handle query requests for massive amounts of data. Existing technologies cannot meet the needs of business users for high concurrency and fast queries.

Method used

By receiving query statements, extracting query and condition field sets, calculating dispersion index based on the distribution of condition values ​​in the target table, filtering out target fields and creating indexes, prioritizing the retention of key fields and controlling the number of indexes, the system achieves automated index creation and optimization.

Benefits of technology

It improves the query efficiency of online databases, avoids the problem of low efficiency in manual configuration, ensures that indexes support actual query needs, and controls resource overhead, thereby improving data write performance and storage space utilization.

✦ Generated by Eureka AI based on patent content.
Patent Text Reader

Abstract

The invention provides a cross-source synchronization table index creation method and device, equipment, a storage medium and a program product, and can be applied to the technical field of big data. The method comprises the following steps: receiving a query statement for acquiring data from a data warehouse; extracting a query field set and a condition field set from the query statement; acquiring data from the data warehouse according to the query statement, and synchronizing the acquired data to a target table in the online database, the target table comprising a data column corresponding to the query field set; merging the condition field set into a candidate index field set of the target table; calculating a dispersion index of each field based on condition value distribution corresponding to each field of the candidate index field set in the target table; based on the dispersion index, screening out a target field set from the candidate index field set; an index is created on the target table for each field in the target set of fields.
Need to check novelty before this filing date? Find Prior Art