Check patentability & draft patents in minutes with Patsnap Eureka AI!

Method and device for SQL inspection

An inspection method and technology to be inspected, applied in the computer field, can solve problems such as inability to inspect and reduce the burden of DBA, and achieve the effects of reducing the burden of DBA, saving costs, and ensuring accuracy

Active Publication Date: 2014-01-15
ADVANCED NEW TECH CO LTD
View PDF2 Cites 20 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The technical problem to be solved in this application is to provide a SQL checking method and device to solve the problem that the existing SQL REVIEW cannot effectively check the changed SQL, can not reduce the burden on the DBA, and save the cost of SQL REVIEW

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 SQL inspection
  • Method and device for SQL inspection
  • Method and device for SQL inspection

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0019] refer to figure 1 , shows a flow chart of steps of an SQL checking method according to Embodiment 1 of the present application.

[0020] The SQL checking method of the present embodiment comprises the following steps:

[0021] Step S102: Obtain the file to be checked according to the file change type.

[0022] The file change type refers to the type of SQL changes made by the developer to the file, such as: modify, add, delete, etc. Correspondingly, the changed file type can be modified file, added file, deleted file Wait.

[0023] The file to be checked is a file that has been modified by SQL, and the file that has been modified by SQL is a file of a modified type, that is, a file that has been modified by SQL on the basis of the original file. Of course, a new SQL file, that is, an added type of SQL file can also be considered as a file to be checked.

[0024] Step S104: Perform SQL modification filtering on the file to be checked to obtain the SQL modification to...

Embodiment 2

[0034] refer to figure 2 , shows a flow chart of steps of an SQL checking method according to Embodiment 2 of the present application.

[0035] The SQL check in this embodiment is based on the version management tool SVN and the IBATIS framework. Among them, the IBATIS framework is an open source project of Apache, which is a Java-based persistence layer framework. The persistence layer framework provided by IBATIS includes SQL Maps and Data Access Objects (DAO), which is a "semi-automatic" implementation of ORM (Object Relational Mapping). However, those skilled in the art should understand that systems using similar architectures and tools can refer to this embodiment to perform SQL checking.

[0036] The SQL checking method of the present embodiment comprises the following steps:

[0037] Step S202: Check whether there is an invalidly modified file among the files that have undergone SQL modification, if yes, do not perform SQL check on the invalidly modified file; if n...

Embodiment 3

[0062] refer to image 3 , shows a flow chart of steps of an SQL check method according to Embodiment 3 of the present application.

[0063] The SQL inspection of this embodiment is based on the version management tool SVN and the IBATIS framework, utilizes the Perl language to call the SVN command in the operating system, and obtains the SVN branch information of the project, according to the branch information of the SVN, obtains the information of all files, processes the files, Perform REVIEW, print the execution plan, and make intelligent judgments on the execution plan. It should be noted that the language, framework, and tools in this embodiment are only exemplary descriptions, and systems that use similar languages, frameworks, and tools can refer to this embodiment to perform SQL checks.

[0064] The SQL checking method of the present embodiment comprises the following steps:

[0065] Step S302: Search for SVN items.

[0066] In this embodiment, the Perl language i...

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 method and device for SQL inspection. The SQL inspection method includes the steps that a document to be inspected is obtained according to a document change type and is a document which SQL modification is carried out on; SQL modification filtering is carried out on the document to be inspected to obtain an SQL modification to be inspected; the SQL modification to be inspected is converted into an SQL statement; an SQL execution plan corresponding to the SQL statement is obtained and inspected. By the adoption of the method and device, changed SQL is effectively inspected through an SQL REVIEW, DBA burdens are relieved, and cost of the SQL REVIEW is saved.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to a SQL (Structured Query Language, Structured Query Language) checking method and device. Background technique [0002] At present, with the application of computer technology more and more widely, the work and operation of many enterprises need computers, and the development of enterprises also depends on the development of computer technology to a certain extent. For these enterprises, with the rapid development of business, the application system of the enterprise is gradually expanding, and along with a large number of transformation work in business and structure, there will be continuous project launch, even a large number of projects will be launched every week. Typically, these projects are versioned through SVN (subversion). SVN is a version management tool that has emerged in recent years. Version management is the basis of software configuration management....

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): G06F17/30G06F9/44
CPCG06F16/2433G06F40/194G06F40/211
Inventor 樊振华
Owner ADVANCED NEW TECH CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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