SQL statement generation method, device and equipment and storage medium

A storage medium and statement technology, applied in the field of financial technology, can solve the problems of high SQL statement cost, large number of feature binning rules, low efficiency, etc., to improve generation efficiency, reduce labor cost and time cost, and improve modeling efficiency. Effect

Pending Publication Date: 2020-03-24
WEBANK (CHINA)
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, the current method of manually writing SQL codes is inefficient and has a high error rate, especially when users need to frequently perform interactive binning adjustments, the binning rules will be iteratively updated frequently, resulting in excessive pressure o

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
  • SQL statement generation method, device and equipment and storage medium
  • SQL statement generation method, device and equipment and storage medium
  • SQL statement generation method, device and equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0063] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0064] like figure 1 as shown, figure 1 It is a schematic diagram of the device structure of the hardware operating environment involved in the solution of the embodiment of the present invention.

[0065] The device in this embodiment of the present invention may be a PC or a server device.

[0066] like figure 1 As shown, the device may include: a processor 1001 , such as a CPU, a network interface 1004 , a user interface 1003 , a memory 1005 , and a communication bus 1002 . Wherein, the communication bus 1002 is used to realize connection and communication between these components. The user interface 1003 may include a display screen (Display), an input unit such as a keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface and a wireless interface. Optionally, the ...

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 relates to the field of financial science and technology, and discloses an SQL statement generation method and device, SQL statement generation equipment and a storage medium. The SQL statement generation method comprises the steps: obtaining each feature binning rule, and carrying out the analysis of each feature binning rule according to a preset binning rule library, so as to obtain the feature type of each feature binning rule; obtaining a target grammar matching rule corresponding to each feature binning rule according to each feature type; and generating SQL statements corresponding to the feature binning rules based on the feature binning rules and the target grammar matching rules corresponding to the feature binning rules. The characteristic binning model is automatically converted into the SQL statement system, the labor cost and the time cost for outputting the model to run in the production environment are reduced, and the generation efficiency of the SQL statement is improved.

Description

technical field [0001] The present invention relates to the technical field of financial technology, in particular to a method, device, equipment and storage medium for generating an SQL statement. Background technique [0002] With the development of computer technology, more and more technologies (big data, distributed, blockchain, artificial intelligence, etc.) The industry's security and real-time requirements also put forward higher requirements for technology. [0003] Feature binning is a feature processing method that divides interval eigenvalues ​​into multiple discrete values ​​or groups discrete eigenvalues, which can make the eigenvalues ​​more stable and improve the robustness of the model. The feature binning algorithm is widely used in various scene modeling. After the modeler builds the binning model, he needs to write the SQL code according to the binning rules and send it to the database administrator to deploy it to the production environment for operatio...

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
IPC IPC(8): G06F16/242
CPCG06F16/2433
Inventor 陈瑞钦黄启军李诗琦唐兴兴林冰垠
Owner WEBANK (CHINA)
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