Eureka AIR delivers breakthrough ideas for toughest innovation challenges, trusted by R&D personnel around the world.

SQL statement verification method and device, data acquisition method and device and storage device

A verification method and statement technology, applied in the computer field, can solve problems such as spending a lot of time for manual review

Active Publication Date: 2020-10-30
MASHANG CONSUMER FINANCE CO LTD
View PDF7 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

DBAs mainly rely on their own experience and corresponding database development specifications to evaluate the specifications and performance of SQL statements. In this way, a lot of manual review time will be spent

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 verification method and device, data acquisition method and device and storage device
  • SQL statement verification method and device, data acquisition method and device and storage device
  • SQL statement verification method and device, data acquisition method and device and storage device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] The solutions of the embodiments of the present application will be described in detail below in conjunction with the accompanying drawings.

[0020] see figure 1 , figure 1 It is a schematic flowchart of an embodiment of a method for verifying SQL statements in the present application. Specifically, the method of this embodiment includes the following steps:

[0021] Step S101: Obtain the original SQL statement.

[0022] The original SQL statement can be directly input by the user, or can be obtained from the prepared software. If the original SQL statement is obtained from the written software, first run the software and generate a running log, then analyze the running log to generate the original SQL statement.

[0023] In order to reduce unnecessary verification process and save time and resources, the original SQL statement can be checked before statement verification to ensure the syntax legality of the original SQL statement. Specifically, before step S101, ...

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 discloses an SQL statement verification method and device, a data acquisition method and device and a storage device. The SQL statement verification method comprises the steps of obtaining an original SQL statement; analyzing the original SQL statement so as to analyze the data information to be verified from the original SQL statement; respectively carrying out preset verification on the to-be-verified data information to obtain a verification result of the to-be-verified data information; and based on the verification result, obtaining a verification result that the original SQL statement passes or does not pass the verification. According to the scheme, automatic verification of an SQL statement can be realized, and the verification efficiency of the SQL statement is improved.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to a SQL statement verification method, data acquisition method, equipment and storage device. Background technique [0002] SQL (Structured Query Language, Structured Query Language) is a database query and programming language for accessing data and querying, updating and managing relational database systems. SQL statements are the most commonly used standardized statements for accessing databases. [0003] DBA (Database Administrator, database administrator), is a person responsible for managing and maintaining the database server, whose responsibilities are general monitoring, backup, password modification, in-depth management and research, etc. [0004] At present, the SQL statements used in the program are generally sent to the DBA for manual review. DBAs mainly rely on their own experience and corresponding database development specifications to evaluate the spe...

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): G06F8/41G06F16/242
CPCG06F8/43G06F16/2433
Inventor 谢双林张银全刘洪政
Owner MASHANG CONSUMER FINANCE 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
Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com