Distributed database distribution strategy generation method, device, equipment and storage medium

By analyzing the pre -processing and relative relationship of SQL, the distribution strategy of distributed databases is generated, and the performance decline in the performance of distributed databases in the data table correlation operation is solved, and more efficient related performance and business operating efficiency are achieved.

CN119003662BActive Publication Date: 2025-01-28JINZHUAN INFORMATION TECHNOLOGY CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202411471863.7
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-10-22
Publication Date
2025-01-28
Estimated Expiration
2044-10-22

AI Technical Summary

Technical Problem

When performing data table association operations, existing distributed databases need to pull data to the computing node for calculation, resulting in a degradation of correlation performance and affecting operational efficiency.

Method used

By pre -processing the full amount of SQL information, generate SQL aggregate information, analyze the relationship between relatives, calculate the cost of grouping and association, and generate the distribution strategy of a distributed database based on these results.

Benefits of technology

The distributed database distribution strategy generated can minimize data table associations, reduce cross -chip operation, improve correlation performance and business operation efficiency, and reduce the cost of associated.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119003662B_ABST
    Figure CN119003662B_ABST
Patent Text Reader

Abstract

The present application relates to the technical field of distributed databases, and in particular to a distributed database distribution strategy generation method, apparatus, device and storage medium, wherein the method comprises: pre-processing SQL full information to obtain SQL aggregate information; performing kinship analysis on the SQL aggregate information to obtain analysis results; the analysis results include the source table, source table fields, target table, target table fields, the number of executions and the average execution time corresponding to the second SQLID; grouping the analysis results based on the source table to obtain grouping results, and performing association cost calculation based on the grouping results to obtain source table field association costs; obtaining a distributed database distribution strategy based on the source table field association costs, the source table and a preset source table data volume threshold; the present application facilitates improving the operating efficiency of the distributed database.
Need to check novelty before this filing date? Find Prior Art

Citation Information

Patent Citations

  • Data processing and creating method and device for distributed database and electronic equipment

    CN112395366A

  • Association relation extraction method and device and computer equipment

    CN115062016A