一种目标数据表分区方法、装置、存储介质及电子设备
By constructing and evaluating multiple partitioning schemes, the target partitioning scheme is determined, which solves the problem of inaccurate database table partitioning in existing technologies, achieves more reasonable and accurate partitioning processing, and improves database performance.
CN115391352BActive Publication Date: 2026-07-17PING AN INT FINANCIAL LEASING CO LTD
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- PING AN INT FINANCIAL LEASING CO LTD
- Filing Date
- 2022-09-14
- Publication Date
- 2026-07-17
AI Technical Summary
Technical Problem
The existing database table partitioning scheme is not precise enough, resulting in unreasonable partitioning and affecting the performance and response time of the business system.
Method used
Multiple partitioning schemes are constructed based on each partitioning field and a preset calculation method. The schemes are then partitioned in the verification database and the operation records are replayed. The scoring values are calculated to determine the target partitioning scheme, and finally, the partitioning is performed in the production database.
Benefits of technology
It achieves reasonable and accurate partitioning of database tables, reduces data read and write volume, improves SQL operation response time, and reduces the impact on business systems.
✦ Generated by Eureka AI based on patent content.
Smart Images
Figure CN115391352B_ABST
Abstract
本申请涉及数据库分区技术领域，公开了一种目标数据表分区方法、装置、存储介质及电子设备。其中方法包括：基于各第一分区字段和各预设的字段分区计算方法构建用于对目标数据表进行分区的若干分区方案；在验证数据库中依次基于各分区方案对目标数据表进行分区，获得与各分区方案对应的若干子分区表；基于同一分区方案对应的各子分区表，在验证数据库中对预先获取的若干操作记录进行重放，获得各分区方案对应的重放时间；基于各重放时间，计算获得与各分区方案对应的评分值以确定目标分区方案；基于各所述目标分区方案对生产数据库中的目标数据表进行分区处理，得到分区结果。本申请中的目标数据库表分区方法对目标数据表的分区更加合理、准确。
Need to check novelty before this filing date? Find Prior Art