Database statement checking method and device

An inspection method and inspection device technology, applied in the field of data processing, can solve the problems of low inspection efficiency, time-consuming and labor-consuming, serious system problems, etc., and achieve the effect of improving inspection efficiency and realizing automatic inspection.

Inactive Publication Date: 2018-03-27
BANK OF CHINA
View PDF4 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the development process of database operation statements, a small flaw may be infinitely magnified, and eventually lead to serious problems in the system
[0003] In the construction of large-scale enterprise-level systems, due to the large scale, numerous participants, frequent system iterations, and different levels of developers, it is inevitable that there will be problems in performance and grammar during the development of database operation statements, and program review relies on manpower and time-consuming Power consumption, low inspection efficiency

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
  • Database statement checking method and device
  • Database statement checking method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0053] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0054] Aiming at the problem of low inspection efficiency caused by checking database sentences by manual screening in the prior art, this application discloses a method for checking database sentences, see figure 1 , the method can include:

[0055] Step S101: Obtain the database script of the target database to be detected;

[0056] The database script is a text file of a database operation statement, and the database operation statement is a programming la...

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 provides a database statement checking method and device. According to the method, a target database script is checked according to prestored database script checking rules after the target database script is acquired, checking results are outputted, the target database script is automatically checked, and the checking efficiency of a database script is improved.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a database sentence checking method and device. Background technique [0002] Database is an essential part of system construction, and with the explosion of the information age, all kinds of information are overwhelming, the amount and scale of information are increasing day by day, and the requirements for database operation are getting higher and higher. In the development process of database operation statements, a small flaw may be infinitely magnified, and eventually lead to serious problems in the system. [0003] In the construction of large-scale enterprise-level systems, due to the large scale, numerous participants, frequent system iterations, and different levels of developers, it is inevitable that there will be problems in performance and grammar during the development of database operation statements, and program review relies on manpower and time-consuming...

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 Applications(China)
IPC IPC(8): G06F11/36G06F17/30
CPCG06F11/366G06F16/2433
Inventor 赵亮王倩张晶
Owner BANK OF 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