Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A method and a device for detecting SQL codes in an application system

An application system and code technology, applied in the computer field, can solve problems such as waste of SQL code application system resources, lack of management methods for SQL code, and affect customer experience, so as to reduce possibility, control development quality, and ensure accuracy and stability Effect

Active Publication Date: 2018-12-11
BANK OF CHINA
View PDF9 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] SQL code refers to a SQL statement. Improper use of SQL code may cause serious waste of application system resources and seriously affect customer experience
At this stage, the management of SQL code in most applications is only at the primary level of code version release management, lacking a complete and reliable management method to ensure the sustainable, accurate and efficient operation of SQL code

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
  • A method and a device for detecting SQL codes in an application system
  • A method and a device for detecting SQL codes in an application system
  • A method and a device for detecting SQL codes in an application system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0052] 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.

[0053] Before specifically introducing the method for detecting SQL codes in the application system provided by the present invention, the applicant first explains the relevant technical terms involved in the present invention.

[0054] SQL statement: A structured query language (Structured Query Language) for operating databases.

[0055] SQL code: typically refers to the same SQL statement, and can also be different SQL statements if the operation functions ...

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 a device for detecting SQL codes in an application system. The method includes: in each stage of software engineering, when a change of SQL code is detected, collecting a content item state of all current SQL codes in a working environment corresponding to the work progress of the software engineering according to the work progress of the software engineering; creating a main baseline based on the collected content item status of all SQL codes, and setting a baseline identifier for the main baseline; comparing a content item of a main baseline with a contentitem of a historical main baseline in a work environment to determine a first SQL change range; prompting each SQL code in the first SQL change scope so that the worker discovers each changed SQL code in a timely manner, and confirming the risk of each changed SQL code. The invention realizes the change risk of scientific and emphatical management of the SQL code in different stages of the software engineering, so as to ensure the sustainable, accurate and efficient operation of the SQL code.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for detecting SQL codes in an application system. Background technique [0002] At present, the data of the application system is mostly stored in the database. For the system using the database, the quality of the SQL statement directly affects the performance of the system. Research shows that many application system performance bottlenecks are caused by the poor quality of SQL statements. In practical applications, a poor-quality SQL statement may drag down the entire application system, and even cause the database server to crash in extreme cases. Therefore, ensuring stable and efficient SQL statements is extremely important to the application system, which directly affects the customer's experience in using the application system. [0003] SQL code refers to a SQL statement. Improper use of SQL code may cause serious waste of application system resour...

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): G06F11/36
CPCG06F11/3672
Inventor 万小妹易金华李纤纤
Owner BANK OF CHINA
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap 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