Supercharge Your Innovation With Domain-Expert AI Agents!

SQL data processing method, system and electronic device

A data processing and data technology, applied in the database field, can solve problems such as resource occupation, and achieve the effect of reducing resource occupation pressure, saving resources, and improving accuracy

Active Publication Date: 2021-08-06
PEOPLE'S INSURANCE COMPANY OF CHINA
View PDF13 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, the purpose of the present invention is to provide a SQL data processing method, system and electronic equipment, to solve the technology that the collection and analysis process of data such as SQL statements in the database will lead to excessive occupation of resources in the prior art question

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0044] A kind of SQL data processing method that the embodiment of the present invention provides, such as figure 1 shown, including:

[0045] S11: The proxy module reads the SQL message from the memory of the database, and performs primary screening on the SQL message to obtain SQL primary selection data.

[0046] Specifically, the agent module (agent) set in the database reads the SQL message from the memory of the database. After the agent module reads the SQL message, it can only send the SQL message whose time length is greater than the preset time period (for example, 2 seconds). The message is sent to the analysis server (that is, the analysis module), that is, the agent module can complete the preliminary screening.

[0047] S12: The analysis module receives the SQL primary selection data, and analyzes the SQL primary selection data through delayed processing based on the idle time of the analysis module, and obtains the analysis result, wherein, the content of the an...

Embodiment 2

[0054] A kind of SQL data processing method that the embodiment of the present invention provides, such as figure 2 shown, including:

[0055] S21: The agent module reads the SQL messages from the memory of the database through the ONSTAT command, and performs initial screening on the SQL messages based on the SQL messages whose dumping time is longer than the preset time threshold, and obtains the SQL primary selection data.

[0056] It should be noted that the method provided by this embodiment is different from the SQL-Tracing in the prior art which obtains system data by reading the system tables. This embodiment obtains the corresponding SQL session data directly from the memory by running the ONSTAT command. The consumption of fetching system tables is low, especially during peak business hours, when the database reads and writes system tables very frequently. If the system tables are read and written again, the performance of the database will be adversely affected.

...

Embodiment 3

[0076] A kind of SQL data processing system that the embodiment of the present invention provides, such as Figure 4 As shown, the SQL data processing system 3 includes: an agent module 31 and an analysis module 32 .

[0077] As an optimal solution, the agent module is used to read SQL messages from the memory of the database, and perform initial screening on the SQL messages to obtain SQL primary data.

[0078] Further, the analysis module is used to receive the SQL primary selection data, and analyze the SQL primary selection data through delay processing based on the idle time of the analysis module to obtain the analysis results, wherein, the content of the analysis module for the SQL primary selection data includes : Perform secondary screening on the SQL primary selection data.

[0079] Therefore, the SQL data processing system can be composed of a SQL capture module and a SQL analysis module. Among them, the SQL capture module is composed of two sub-modules: the SQL c...

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 SQL data processing method, system and electronic equipment, and relates to the technical field of databases. An agent module reads SQL messages from the memory of the database, and performs primary screening on the SQL messages to obtain primary SQL data; analysis The module receives the SQL primary selection data, and analyzes the SQL primary selection data by delay processing based on the idle time of the analysis module to obtain an analysis result, wherein the analysis module analyzes the SQL primary selection data The content includes: secondary screening of the SQL primary selection data, which solves the technical problem existing in the prior art that the process of collecting and analyzing data such as SQL statements in the database will lead to excessive occupation of resources.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to an SQL data processing method, system and electronic equipment. Background technique [0002] In a database application system, the performance of a Structured Query Language (Structured Query Language, SQL for short) statement is very important. Inefficient SQL statements will lead to performance degradation of the entire database application system. In practical applications, it is necessary to monitor the usage of system resources during the running of SQL statements in the database system. [0003] At present, the process of collecting and analyzing data such as SQL statements in the database will lead to excessive occupation of resources. Contents of the invention [0004] In view of this, the purpose of the present invention is to provide a SQL data processing method, system and electronic equipment, to solve the technology that the collection and analysis process of ...

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 Patents(China)
IPC IPC(8): G06F16/242
Inventor 刘鑫邵利铎鹿慧何栋曾少鹏杨理国黄泰松胡大奎张帆杨洁
Owner PEOPLE'S INSURANCE COMPANY 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