Database operation method, system and computer cluster
By creating a session temporary table on disk that is bound to a global temporary table for each session in the distributed database, the problem of metadata loss caused by data node restarts in existing technologies is solved, thus achieving data operation persistence and stability and avoiding resource waste.
CN116842080BActive Publication Date: 2026-02-06SHENZHEN HUAWEI CLOUD COMPUTING TECHNOLOGIES CO LTD
2 Cites 0 Cited by
Patent Information
- Application Number
- CN202310631037.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2023-05-30
- Publication Date
- 2026-02-06
- Estimated Expiration
- 2043-05-30
AI Technical Summary
Technical Problem
In distributed databases, the metadata of global temporary tables is stored in memory, which leads to the loss of metadata when data nodes restart, resulting in resource waste and business interruption.
Method used
By creating a session temporary table in the cloud platform that is bound to a global temporary table for each session, and storing the table file and metadata of the session temporary table on disk, the persistence of data operations is ensured and data loss is avoided.
Benefits of technology
It improves the stability of distributed databases, avoids resource waste, and ensures business continuity and efficient operation.
✦ Generated by Eureka AI based on patent content.
Abstract
The embodiment of the application provides a database operation method, system and computer device, the method is applied to the cloud platform, and comprises the following steps: a coordination node receives a data operation request sent by a user end through a target session; the coordination node determines whether a session temporary table created for a global temporary table and belonging to the target session exists at present, wherein metadata corresponding to the session temporary table is stored in a disk of a data node; in the case that it is determined that the session temporary table does not exist, the coordination node creates the session temporary table in a target data node in a plurality of data nodes, and sends the data operation request to the target data node; in the case that it is determined that the session temporary table exists, the coordination node sends the data operation request to the target data node, and the data operation request is used to instruct the target data node to perform data operation on the session temporary table according to the target data node. By adopting the database operation method provided by the application, the stability of the distributed database can be improved, and resource waste can be avoided.
Need to check novelty before this filing date? Find Prior Art