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

SQL query-based network service monitoring method, apparatus and device, and storage medium

A network business and business technology, applied in the computer field, can solve the problems of inability to monitor network business, inability to do it, and low portability, and achieve the effect of improving portability

Pending Publication Date: 2020-07-31
CHINA PING AN LIFE INSURANCE CO LTD
View PDF0 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of the embodiment of the present application is to propose a SQL query-based network service monitoring method, device, device, and storage medium to solve the problem that the existing network service monitoring methods or monitoring systems have low portability and cannot be used in different services. The monitoring of network services in the system and the inability to achieve real-time and automatic monitoring

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 query-based network service monitoring method, apparatus and device, and storage medium
  • SQL query-based network service monitoring method, apparatus and device, and storage medium
  • SQL query-based network service monitoring method, apparatus and device, and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0065] In the embodiments provided by this application, the execution subject of each step may be the bypass monitoring system, please refer to figure 1 , figure 1 Shows an exemplary system architecture diagram of a bypass monitoring system in an SQL query-based network service monitoring method according to an embodiment of the present application. The bypass monitoring system 102 is composed of a traffic capture component 121, a monitoring center 122, and a cache 123. The traffic The capture component 121 captures the network traffic transmitted on the middleware 101, the monitoring center 122 analyzes the captured network traffic to obtain the SQL statement, and the cache 123 caches the parsed SQL statement. Further, the monitoring center 122 performs SQL operations on the database of the business system according to the obtained SQL statement to obtain the first SQL operation result, and compares the first SQL operation result with the second SQL operation result obtained ...

Embodiment 2

[0141] further reference Figure 9 , as for the above figure 2 The realization of the shown method, the application provides an embodiment of the network service monitoring device based on SQL query, the device embodiment is the same as figure 2 Corresponding to the illustrated method embodiments, the apparatus can be specifically applied to various electronic devices. The network service monitoring device based on SQL query includes:

[0142] A traffic capture module 901, configured to capture network traffic on at least one business system;

[0143] The traffic analysis module 902 is used to analyze the network traffic and obtain the SQL statement in the network traffic;

[0144] The SQL operation module 903 is configured to perform SQL operations on the target database according to the SQL statement to obtain first SQL operation information, wherein the target database is a database of at least one business system;

[0145] The SQL query module 904 is used to obtain t...

Embodiment 3

[0174] In order to solve the above technical problems, the embodiment of the present application further provides computer equipment. For details, please refer to Figure 10 , Figure 10 It is a basic structural block diagram of the computer equipment of this embodiment.

[0175] The computer device 6 includes a memory 61 , a processor 62 , and a network interface 63 connected to each other through a system bus. It should be noted that only the computer device 6 is shown with components 61-63, but it should be understood that it is not required to implement all the components shown, and more or fewer components may be implemented instead. Among them, those skilled in the art can understand that the computer device here is a device that can automatically perform numerical calculation and / or information processing according to preset or stored instructions, and its hardware includes but is not limited to microprocessors, dedicated Integrated Circuit (Application Specific Inte...

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 an SQL query-based network service monitoring method, apparatus and device, and a storage medium, and belongs to the technical field of computers. The monitoring method comprises the steps of capturing network traffic on at least one service system; analyzing the network flow to obtain an SQL statement in the network flow; performing SQL operation on the target database according to the SQL statement to obtain first SQL operation information; obtaining a log file of the target database, and querying second SQL operation information corresponding to the SQL statement inthe log file of the target database; comparing the first SQL operation information with the second SQL operation information, and judging whether the network service is abnormal or not according to acomparison result; and if the comparison result is not the null value and the comparison result is the same, determining that the network service is a normal service, otherwise, determining that the network service is an abnormal service. The network service monitoring method provided by the invention can realize automatic monitoring of the network service in different service systems.

Description

technical field [0001] The present application relates to the field of computer technology, and in particular to a SQL query-based network service monitoring method, device, equipment and storage medium. Background technique [0002] At present, most enterprises will develop and operate one or more sets of business systems that match their own business needs according to their own business needs. Due to different business needs, developers need to use different systems when developing systems. There are certain differences in the data processing methods of the various systems developed in the end, and when it is necessary to monitor the network traffic of these business systems, developers need to base on the different structural frameworks of the business systems To develop a monitoring system to realize the network traffic monitoring of different business systems, that is, each business system needs to develop a network traffic monitoring system that matches itself, which ...

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): G06F16/9532G06F16/951
CPCG06F16/951G06F16/9532
Inventor 张文军
Owner CHINA PING AN LIFE INSURANCE CO LTD
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