一种支持容错的关系型数据库查询方法、系统、设备及存储介质
By adding thread count and the EXACT keyword to the SQL statement of a relational database, and using a method of parallel computation by the main thread and the check thread, the problem of inaccurate queries caused by silent CPU errors in financial-grade databases is solved, achieving efficient and low-cost fault-tolerant queries that meet the elastic expansion requirements of modern databases.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- HARBIN HARBIN CONSUMER FINANCE CO LTD
- Filing Date
- 2025-10-10
- Publication Date
- 2026-07-17
AI Technical Summary
Existing financial-grade relational databases cannot identify and correct silent CPU errors, resulting in inaccurate query results. Furthermore, they have high deployment costs and resource consumption, making them difficult to adapt to the elastic scaling requirements of modern databases.
By adding the thread count n and the EXACT keyword to the SQL statement of the relational database, and through parallel computation by the main thread and multiple checking threads, dynamic verification and cross-validation of intermediate results, fine-grained resource scheduling and elastic fault tolerance mechanism are achieved, reducing redundant computation.
It provides accurate query results in the event of a silent CPU error, reducing deployment costs, improving resource utilization, reducing unnecessary resource overhead, and achieving an efficient fault tolerance mechanism.
Smart Images
Figure CN121277977B_ABST