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.

CN118535604BActive Publication Date: 2024-11-26JINDIAN TECH DEV CENT
View PDF 4 Cites 0 Cited by

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

Technical Problem

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.

Method used

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.

Benefits of technology

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.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118535604B_ABST
    Figure CN118535604B_ABST
Patent Text Reader

Abstract

The present invention discloses a stored procedure replacement system and method based on artificial intelligence, and relates to the field of data access technology. The present invention divides the stored procedure into multiple subtasks, thereby facilitating the subsequent parsing of the entire stored procedure, and the parsing is more refined, thereby making the replacement process more accurate. In the query process, statements such as conditional judgment and cursors can be applied, which has strong flexibility and can complete complex judgments and more complex operations. When the query is returned, the query result and the final verification result are converted into a consistent JSON format, which is convenient for business personnel to process and analyze data. At the same time, multiple complex functions can be combined through a simple rule logic, thereby simplifying complex business processes. When using this system, developers should be able to directly manage the pre-configured rules in the product, and in view of the fact that the business rules of the financial system often change, the configuration is convenient and flexible, and takes effect in real time, effectively reducing the purpose of operating costs and development costs.
Need to check novelty before this filing date? Find Prior Art

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