Joining method and associated apparatus

By generating hash graphs and optimizing database join instructions using execution trees, the problem of low efficiency in data table joins was solved, thus improving the efficiency and performance of database joins.

CN112835888BActive Publication Date: 2026-07-14HUAWEI CLOUD COMPUTING TECHNOLOGIES CO LTD

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
HUAWEI CLOUD COMPUTING TECHNOLOGIES CO LTD
Filing Date
2019-11-25
Publication Date
2026-07-14

AI Technical Summary

Technical Problem

The existing database suffers from inefficient joins between tables, which urgently need to be improved.

Method used

By generating a hash map and execution tree for the data table, the execution order of join instructions is optimized, the functional complexity of the running instructions is reduced, and the join efficiency is improved.

Benefits of technology

It effectively improves the efficiency of data table joins, reduces the execution time of running instructions, and enhances database performance.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN112835888B_ABST
    Figure CN112835888B_ABST
Patent Text Reader

Abstract

The application provides a joining method and related equipment. The method comprises: receiving a preliminary instruction input by a user; performing parameter legality checking on the preliminary instruction to a joining instruction, and generating a hash graph of a first data table, the joining instruction being used to indicate joining at least the first data table and a second data table; in the case that the parameter legality checking is qualified, receiving a running instruction input by the user; and executing the running instruction to run the joining instruction, so as to join at least the first data table and the second data table according to the hash graph of the first data table.
Need to check novelty before this filing date? Find Prior Art