数据库处理方法、装置、电子设备及计算机可读介质
By acquiring and comparing baseline and target directory data, database change statements are generated, solving the problems of low efficiency and low accuracy in large-scale database structure change delivery projects, and achieving efficient database structure changes.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- JD DIGITS HAIYI INFORMATION TECHNOLOGY CO LTD
- Filing Date
- 2024-07-01
- Publication Date
- 2026-07-17
AI Technical Summary
In large-scale database structure change delivery projects, database processing is inefficient and inaccurate, especially when there are hundreds or even thousands of databases, which existing technologies struggle to address effectively.
By responding to database processing requests, the system obtains baseline directory data and target directory data, performs set calculations to obtain difference sets and intersection sets, compares the syntax trees of databases with the same name at the table level, generates database change statements, and finally changes the structure of the target directory data to the structure of the baseline directory data.
It improves the efficiency and accuracy of database processing, enabling rapid and batch comparison and modification of database differences between two environments, thus enhancing processing efficiency.
Smart Images
Figure CN118796832B_ABST