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

SQL (structured query language) information acquiring and auditing system based on MSSQL (Microsoft SQL server) database

An information collection and database technology, applied in the field of database access SQL analysis, can solve problems affecting the performance of application systems, affecting the operating efficiency of MSSQL database servers, etc.

Inactive Publication Date: 2013-04-24
DATCENT TECH
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, these configuration changes of the MSSQL database often greatly affect the operating efficiency of the MSSQL database server, thereby affecting the performance of the entire application system

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 (structured query language) information acquiring and auditing system based on MSSQL (Microsoft SQL server) database
  • SQL (structured query language) information acquiring and auditing system based on MSSQL (Microsoft SQL server) database
  • SQL (structured query language) information acquiring and auditing system based on MSSQL (Microsoft SQL server) database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0049] A kind of SQL information collection and auditing system based on MSSQL database provided by the present embodiment, such as figure 1 and figure 2 As shown, each module is connected to each other through a computer network, including:

[0050] MSSQL communication message analysis module:

[0051] In the application system based on MSSQL database, the communication protocol between the application system client and the MSSQL database adopts the proprietary protocol of Microsoft Corporation. The main function of this module is to analyze the SQL statement of the communication message, the parameters carried by the SQL statement, and the execution result of the SQL statement through the effective analysis of the protocol, so as to provide data sources for other modules.

[0052] This module contains the following protocol analysis functions:

[0053] Basic communication message structure analysis:

[0054] 1 byte 1 byte 2 bytes 4 bytes database t...

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 belongs to the technical field of database access SQL (structured query language) analysis, and relates to an SQL information acquiring and auditing system based on an MSSQL (Microsoft SQL server) database. The system comprises an MSSQL communication message analysis module, an SQL statement grammar analysis module and an MSSQL error code knowledge base analysis module, wherein the MSSQL communication message analysis module is used for completely analyzing SQL statements of a communication message, parameters of the SQL statements and execution results of the SQL statements by analyzing a communication protocol between an application system client side based on the MSSQL database and the MSSQL database so as to provide a data source for other modules; the SQL statement grammar analysis module is used for performing effective structural analysis for the SQL statements so as to form an SQL operational log library; and the MSSQL error code knowledge base analysis module isused for establishing an MSSQL database error code knowledge base and analyzing the running state of the application system based on the MSSQL database by combining a database access request and a response result of the request with the MSSQL database error code knowledge base. The SQL information acquiring and auditing system based on the MSSQL database has the advantages that any configuration modifications and alterations on the application system are not needed, normal operation of the application system is unaffected, and strong support is provided for users and application system providers to timely know the running state of the application system.

Description

technical field [0001] The invention belongs to the technical field of SQL analysis for database access, and relates to a TCP network-based system for collecting, analyzing and auditing network communication between an MSSQL database application client and an MSSQL database server. Background technique [0002] According to the applicant's understanding, in the application system based on the TCP network and using the MSSQL database server, due to the large number of clients, the amount of visits and data transmission is relatively large. As a user, it is difficult to conduct a comprehensive analysis of the access and usage of the MSSQL 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. ...

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): G06F17/30
Inventor 李曙强吕兵
Owner DATCENT TECH
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