MYSQL (My Structured Query Language) database based SQL information acquisition and audit system

An information collection and database technology, applied in database design/maintenance, digital data processing, structured data retrieval, etc., can solve problems that affect the performance of application systems and the operating efficiency of MYSQL database servers.

Inactive Publication Date: 2014-01-01
DATCENT TECH
View PDF4 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, these configuration changes of the MYSQL database often greatly affect the operating eff...

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
  • MYSQL (My Structured Query Language) database based SQL information acquisition and audit system
  • MYSQL (My Structured Query Language) database based SQL information acquisition and audit system
  • MYSQL (My Structured Query Language) database based SQL information acquisition and audit system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0027] A SQL information collection and auditing system based on a MYSQL database provided in this embodiment, the specific deployment diagram and the system framework diagram are as follows figure 1 and figure 2 shown. The system includes a MYSQL communication message analysis module, a SQL statement syntax analysis module and a MYSQL communication error code module. MYSQL communication message analysis module includes basic communication message structure analysis sub-module, Login login protocol structure analysis sub-module, SQL request message structure analysis sub-module, RPC remote call message structure analysis sub-module, SQL execution return message structure analysis The sub-module and the SQL parameter structure analysis sub-module respectively analyze the basic communication message structure contained in the communication message, the Login login protocol structure, the SQL request message structure, the RPC remote call message structure, the SQL execution re...

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 MYSQL (My Structured Query Language) database based SQL information acquisition and audit system. The MYSQL database based SQL information acquisition and audit system comprises an MYSQL communication message analysis module, an SQL statement syntax parsing module and an MYSQL communication error code module, wherein the MYSQL communication message analysis module is used for completely analyzing SQL statements of a communication message, parameters carried by the SQL statements and execution results of the SQL statements by analyzing a communication protocol between an application system client of an MYSQL database and the MYSQL database, and then data sources are provided for other modules; the SQL statement syntax parsing module is used for carrying out effective structural decomposition on the SQL statements so as to form an SQL operation log library; the MYSQL communication error code module establishes an MYSQL database error code library and analyzes the operating condition of an MYSQL database based application system by combining a database access request and a request response result with the MYSQL database error code library. The MYSQL database based SQL information acquisition and audit system has the advantages that the application system is not required to be subjected to any configuration change and modification, any effect on the normal operation of the application system does not exist, and a powerful support for promptly understanding the operation state of the system can be provided for users and application system providers.

Description

technical field [0001] The invention relates to an information collection and audit system, in particular to a SQL information collection and audit system based on a MYSQL database. Background technique [0002] In the application system based on the TCP network and using the MYSQL database server, due to the large number of clients, the amount of access and data transmission are relatively large. As a user, it is difficult to conduct a comprehensive analysis of the access and usage of the MYSQL database at the system level, so as to understand the operating status of the application system. In this way, the communication process between the client computer and the database server is almost a black box. When an abnormal situation occurs in the application system, the user does not have the historical operation status of the system. [0003] Some traditional methods are to modify some configurations of the MYSQL database server host, so that the database server actively rec...

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): G06F17/30
CPCG06F11/3409G06F16/20G06F16/21
Inventor 李曙强蒋树春吕兵
Owner DATCENT TECH
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