异构数据库表结构转化方法及装置、设备、存储介质
By obtaining the index and constraint information of the Oracle database, the unique target index type of the MySQL database table can be determined, which solves the problem of useless indexes occupying disk space and reducing utilization, and achieves the reduction of disk space and efficient utilization of table space.
CN115794816BActive Publication Date: 2026-07-17PING AN PAY ELECTRONIC PAYMENT CO LTD
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- PING AN PAY ELECTRONIC PAYMENT CO LTD
- Filing Date
- 2022-11-09
- Publication Date
- 2026-07-17
AI Technical Summary
Technical Problem
The process of converting data from an Oracle database to a MySQL database generates a large number of useless indexes, which consume disk space, increase costs, cause tablespace fragmentation, and reduce utilization.
Method used
By obtaining the index and constraint information of the Oracle database, the unique target index type of each database table in MySQL can be determined, and indexes of the same type can be generated to avoid creating redundant indexes.
Benefits of technology
Reduce disk space usage, reduce tablespace fragmentation, improve tablespace utilization, and avoid production line issues.
✦ Generated by Eureka AI based on patent content.
Smart Images
Figure CN115794816B_ABST
Abstract
本发明涉及一种异构数据库表结构转化方法及装置、设备、存储介质，所述异构数据库表结构转化方法包括：获取oracle数据库中各个数据库表对应的索引信息和约束信息；基于所述索引信息中的索引类型和约束信息中对应的约束类型，确定mysql中各个数据库表分别对应的唯一目标索引类型；基于所述各个数据库表分别对应的唯一目标索引类型在mysql生成各个数据库表的索引。基于此，能够实现将oracle数据库的数据转化为mysql数据库的数据时，避免产生大量的无用索引而引发产线问题，并且实现减少磁盘空间的占用率，并减少表空间碎片，提高整个表空间的利用率。
Need to check novelty before this filing date? Find Prior Art