Supercharge Your Innovation With Domain-Expert AI Agents!

SQL information processing method, device, apparatus and system

An information processing method and label information technology, applied in the fields of SQL information processing methods, devices, equipment and systems, and can solve problems such as hysteresis

Pending Publication Date: 2020-10-30
INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF3 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In this way, the problem is usually discovered and solved when the SQL statement exposes the problem online, which can easily lead to a certain lag

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 information processing method, device, apparatus and system
  • SQL information processing method, device, apparatus and system
  • SQL information processing method, device, apparatus and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] In order to enable those skilled in the art to better understand the technical solutions in this specification, the technical solutions in the embodiments of this specification will be clearly and completely described below in conjunction with the drawings in the embodiments of this specification. Obviously, the described The embodiments are only some of the embodiments in this specification, not all of them. Based on one or more embodiments in this specification, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the scope of protection of the embodiments of this specification.

[0018] In order to solve the hysteresis caused by the performance analysis of executing SQL in the prior art, the embodiment of this specification provides a method for processing SQL information. Scan the SQL label information in the target project through source code analysis, dynamically configure SQL parameters, and analyze 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 provides an SQL information processing method, device, apparatus and system. The method comprises: obtaining SQL label information in a target project, wherein the SQL label informationcomprises an SQL label and content corresponding to the SQL label; generating an executable SQL statement corresponding to the SQL label information according to the SQL label information; obtaining an SQL execution plan result table corresponding to the executable SQL statement; and based on the SQL execution plan result table and a preset index set, determining an evaluation result of SQL information in the target project, wherein the preset index set comprises early warning indexes corresponding to the risk SQL statements. According to the embodiment of the invention, early warning can be performed before the target project is online, so that the risk of exposure to a production environment after the target project is online is effectively reduced, and the loss is reduced.

Description

technical field [0001] The present application relates to the technical field of information processing, in particular to a SQL information processing method, device, equipment and system. Background technique [0002] In actual production projects, the database is a more important link. However, the DML (Data Manipulation Language, Data Manipulation Language) operation on the database usually involves the performance problem of the SQL (Structured Query Language, Structured Query Language) statement. [0003] In the prior art, the performance analysis of the executable SQL statement is mainly performed online. In this way, the problem is usually discovered and solved when the SQL statement exposes the problem online, which can easily lead to a certain lag. [0004] Therefore, there is an urgent need for a technical solution that can solve the above-mentioned technical problems in the industry. Contents of the invention [0005] The embodiment of this specification prov...

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/34G06F11/30G06F11/32
CPCG06F11/3409G06F11/302G06F11/327G06F2201/865G06F2201/80Y02D10/00
Inventor 吴昊杨洋陈晓杨峻豪
Owner INDUSTRIAL AND COMMERCIAL BANK OF CHINA
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