Method for positioning slow sql mapping code position through section technology

A code location and aspect technology, applied in the field of Java application software development, can solve problems such as the lack of threshold configuration and real-time alarm fusion implementation in slow SQL, and achieve the effect of facilitating problem analysis and localization and reducing impact.

Pending Publication Date: 2022-04-26
甜橙融资租赁(上海)有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The above technologies are effectively improving and guaranteeing the code quality of the application in all aspects, but there is a lack of fine threshold configuration and real-time alarm integration for slow SQL in Java applications.

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 for positioning slow sql mapping code position through section technology
  • Method for positioning slow sql mapping code position through section technology

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0029] Such as Figure 1-2 , the present invention provides a method for locating the location of the slow sql mapping code through the aspect technology, including the following:

[0030] 1. Recognize the section

[0031] In the case of slow SQL applications in Java, the identification of aspect points can be the methods of all classes under the Mapper or Repository package of the persistence layer;

[0032] 2. Realize face-to-face treatment

[0033] Select @Around to intercept the execution of the method, and then provide a data basis for the next analysis work, mark the time before and after the execution of the intercepted method, and calculate the execution time of jointPoint.proceed();

[0034] 3. Identification and monitoring

[0035] Combined with the configuration system capabilities, finely configure the execution warning threshold of each method. If the execution time of the previous step is greater than the threshold, at the same time, get the method name and in...

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 discloses a method for positioning the position of a slow sql mapping code through a section technology, which comprises the following steps of: 1, identifying a section: in a scene of a Java application slow sql, identifying a section point by all types of methods under a Mapper or Relocation packet of a persistent layer; and 2, section disposal is realized, execution of the method is intercepted by selecting an Around section surrounding mode, then a data basis can be provided for next analysis work, time marking is performed before and after execution of the intercepted method, and consumed time for execution of jointPoint. Process () is calculated. According to the method, hidden danger points can be quickly identified, and the positioning level is a specific code line; according to the method, scene data (information such as code positions, incoming parameters, outgoing parameters and data sizes of the outgoing parameters) of problems can be provided, and problem analysis and positioning are facilitated; the implementation and monitoring early warning scheme of the invention can be applied in a test environment, so that hidden danger problems can be found in advance, and the influence on the stability of a production environment is reduced.

Description

technical field [0001] The invention relates to the technical field of Java application software development, in particular to a method for locating the position of a slow sql mapping code through an aspect technology. Background technique [0002] Enterprise-level Java applications currently have a relatively rich set of tools in terms of development, deployment, and monitoring to improve and ensure the quality of applications and improve the quality of delivery to customers. [0003] During the research and development process, widely applicable protocol inspection tools such as sonar, these tools essentially analyze the syntax tree of the code, and most of the problem code identification methods are based on pattern matching. In addition, most of the problems are improved through code review at present. identify. [0004] In terms of deployment and monitoring, the JMX capability provided by the JVM is mainly used to monitor the entire application operating environment. T...

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 Applications(China)
IPC IPC(8): G06F11/30G06F11/34G06F8/30
CPCG06F11/302G06F11/3051G06F11/3476G06F8/315
Inventor 姜健刘永富陆万川严甜甜
Owner 甜橙融资租赁(上海)有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap