Unlock instant, AI-driven research and patent intelligence for your innovation.

Data query monitoring method and device, electronic equipment and storage medium

A data query and data technology, applied in the field of data processing, can solve problems affecting database stability, database performance impact, database performance impact, etc., and achieve the effects of early identification of risks, stable service performance, and fast query speed.

Pending Publication Date: 2021-06-25
CTRIP TRAVEL NETWORK TECH SHANGHAI0
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Implicit conversion has a great impact on the performance of the database, especially in the scenario of highly concurrent large data table query, which will have a great impact on the performance of the database and affect the stability of the database

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
  • Data query monitoring method and device, electronic equipment and storage medium
  • Data query monitoring method and device, electronic equipment and storage medium
  • Data query monitoring method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of the example embodiments to those skilled in the art.

[0028] The drawings are merely schematic illustrations of the invention and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus repeated descriptions thereof will be omitted. Some of the block diagrams shown in the drawings are functional entities and do not necessarily correspond to physically or logically separate entities. These functional entities may be implemented in software, or in one or more hardware modules or integrated circuits, or in different network and / or processor means...

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 relates to the technical field of data processing, and provides a data query monitoring method and device, electronic equipment and a storage medium. The data query monitoring method comprises the following steps: in a test process of an application service, collecting an execution plan of a query statement of the application service in real time; analyzing the execution plan, and judging whether the query statement needs implicit conversion or not; if yes, obtaining implicit conversion information containing the query statement; and monitoring performance consumption data of a database for executing the query statement, generating alarm information according to the implicit conversion information and the performance consumption data, and pushing the alarm information to a test end of the application service. Whether the query statement has implicit conversion or not is automatically detected in the testing process of the application service, the risk is efficiently recognized in advance, the situation that an online database is impacted after the query statement with implicit conversion is published to the production environment is avoided, and the stability of the database can be ensured.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a data query monitoring method, device, electronic equipment and storage medium. Background technique [0002] SQL (Structured Query Language, Structured Query Language) query statement can be used to perform data query on a relational database (such as SQL Server). [0003] When the data type in the SQL query statement is inconsistent with the actual data type in the database, usually when two different data types are compared in the WHERE clause or JOIN clause, implicit conversion will be involved, which will take up a lot of time in the database. CPU (Central Processing Unit, central processing unit) resources, IO (Input / Output, input and output) resources and memory. [0004] For example, if the data type of a certain field in the data table structure of the database is varchar(20), and the data type of the field in the WHERE condition of the SQL query statement is n...

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/36G06F11/30G06F11/32G06F11/34
CPCG06F11/3664G06F11/3688G06F11/302G06F11/3093G06F11/327G06F11/3476G06F2201/80G06F2201/865
Inventor 余聪
Owner CTRIP TRAVEL NETWORK TECH SHANGHAI0