A stored procedure replacement system and method based on artificial intelligence
Through the artificial intelligence-based stored procedures replacement system, the stored procedures are decomposed and parsed, and the soft checks and hard checks are performed, the consistency and debugging problems of database stored procedures under distributed deployment are solved, the enterprise development costs are reduced, and the enterprise development costs are increased. System portability and ease of debugging.
Patent Information
- Application Number
- CN202410623541.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-05-20
- Publication Date
- 2024-11-26
- Estimated Expiration
- 2044-05-20
AI Technical Summary
Stored procedures in existing databases face consistency, query and transaction problems under distributed deployment, with high debugging costs, poor portability, difficulty in debugging, and high coupling, which increases enterprise development costs.
Using a stored procedure replacement system based on artificial intelligence, soft or hard calibration is performed by decomposing stored procedures into multiple subtasks, subtask parsing module, parameter replacement module, subtask execution verification module and verification result return module. Verify, simplify business processes, directly call built-in functions of the database, and generate query results in JSON format.
It reduces operational and development costs, improves portability and debugging simplicity, realizes flexible combination and precise replacement of complex business logic, and supports rapid rule configuration and adjustment of business scenarios such as finance.
Smart Images

Figure CN118535604B_ABST
Abstract
Citation Information
Patent Citations
Monitoring stored procedure execution
CN103842973A
Method for generating statement from natural language to SQL in business scene based on large model
CN117708162A
Storage process conversion method and device, equipment and medium
CN117827879A
Predictive prefetching to improve parallelization of document generation subtasks
US7331038B1
