Method and device for realizing stored procedure

A technology of stored procedures and implementation methods, applied in the computer field, can solve problems such as difficult maintenance, code redundancy, and logic confusion, and achieve the effects of easy maintenance, code redundancy resolution, and clear business logic.

Active Publication Date: 2020-09-11
PING AN TECH (SHENZHEN) CO LTD
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, the embodiment of the present invention provides a method and device for implementing a stored procedure to solve the problems of code redundancy, logical confusion, and difficulty in maintenance existing in the existing stored procedure

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for realizing stored procedure
  • Method and device for realizing stored procedure
  • Method and device for realizing stored procedure

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0045] The embodiments of the present invention generate different Type classes according to business objects; then carry out unit tests on the Type classes, and store the Type classes that pass the test in a designated database; when writing stored procedures, call the Type classes To realize the function of the stored procedure; thereby realizing the writing of the stored procedure based on the object-oriented method, abstracting the stored procedure of tens of thousands of lines of code into different Type classes, which are combined and realized by these mutually independent Type classes The fu...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention belongs to the technical field of computers, and provides a storage-process implementation method and device. The method includes the steps that different Type classes are generated according to business objects; the Type classes are subjected to unit testing, Type classes passing testing are stored in specified databases; when the storage process is written, the function of the storage process is achieved by calling the Type classes. According to the storage-process implementation method and device, the function that the storage process is written based on an object-oriented mode, the storage process with thousands of frequent codes is abstracted into the different Type classes, and the storage process is achieved in the mode that the mutually-independent Type classes are combined is achieved, the business logic of the storage process is clearer and easy to maintain, and the problems that an existing storage process is redundancy in code, chaotic in logic and difficult to maintain are solved.

Description

technical field [0001] The invention belongs to the technical field of computers, and in particular relates to a storage procedure realization method and device. Background technique [0002] Stored Procedure (Stored Procedure) is an important object in the database. In a large database system, a stored procedure is stored in the database as a set of SQL statements to complete a specific function. After the first compilation, calling again does not require recompilation. The user specifies the name of the stored procedure and gives parameters ( If the stored procedure has parameters) to execute it. [0003] However, the existing PL / SQL (Procedural Language / SQL) stored procedure is written in a procedure-oriented manner, and the code of the stored procedure is redundant, the logic is chaotic, and it is very difficult to maintain. Contents of the invention [0004] In view of this, the embodiments of the present invention provide a method and device for implementing a stor...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/242G06F16/2455
CPCG06F16/2443G06F16/2455
Inventor 徐光飞
Owner PING AN TECH (SHENZHEN) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap