CN109408326A - The method and system of monitoring data library security audit product treatment SQL message efficiency - Google Patents
The method and system of monitoring data library security audit product treatment SQL message efficiency Download PDFInfo
- Publication number
- CN109408326A CN109408326A CN201811153877.9A CN201811153877A CN109408326A CN 109408326 A CN109408326 A CN 109408326A CN 201811153877 A CN201811153877 A CN 201811153877A CN 109408326 A CN109408326 A CN 109408326A
- Authority
- CN
- China
- Prior art keywords
- sql message
- client
- product treatment
- security audit
- monitoring data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3065—Monitoring arrangements determined by the means or processing involved in reporting the monitored data
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computer And Data Communications (AREA)
- Debugging And Monitoring (AREA)
Abstract
The present invention provides a kind of method of monitoring data library security audit product treatment SQL message efficiency, include the following steps: that one first process and one second process is arranged in step S1, client；Step S2, the first process continuously transmits the packet data with SQL message to client；Step S3, the second process is monitored the ephemeral data of client every the period of setting；Step S4, the second process saves monitored results in real time to database；Step S5, the monitored results in client reading database, and real-time update of drawing a diagram is shown.The present invention has the advantages that improving the efficiency and accuracy of monitoring data library security audit product treatment SQL message.
Description
Technical field
The present invention relates to computer fields, refer in particular to a kind of monitoring data library security audit product treatment SQL message efficiency
Method and system.
Background technique
Method of Database Secure Audit product needs to be monitored the SQL message in targeting database server, and monitor
The links such as the collection, filtering and analysis of SQL message are further related in the process, and can be generated and be faced in the treatment process of each link
When data.In the after treatment of each link, the hold-up of ephemeral data directly reflect the efficiency of each link processing with
And accuracy.
Currently, mainly as follows to the test method of Method of Database Secure Audit product treatment SQL message efficiency: being received by monitoring
The size and quantity of the ephemeral datas caused by links such as collection, filtering and analysis assesses each link processing SQL message
Efficiency and accuracy.
But there are following problems for this method: one is the format of ephemeral data caused by each link is often not
Together, great inconvenience is brought to the processing analysis of data；The second is the quantity of ephemeral data caused by each link is very huge,
It generally requires that ephemeral data is carried out to be packaged compression and the operation of decompression, consequently leads to the inefficiency of test, test
Accuracy is not high.
Summary of the invention
One of the technical problem to be solved in the present invention is to provide a kind of monitoring data library security audit product treatment SQL
The method of message efficiency, for improving the efficiency and accuracy of monitoring data library security audit product treatment SQL message.
The present invention is implemented as follows: a kind of method of monitoring data library security audit product treatment SQL message efficiency, institute
The method of stating includes the following steps:
Step S1, one first process and one second process is arranged in client；
Step S2, the first process continuously transmits the packet data with SQL message to client；
Step S3, the second process is monitored the ephemeral data of client every the period of setting；
Step S4, the second process saves monitored results in real time to database；
Step S5, the monitored results in client reading database, and real-time update of drawing a diagram is shown.
Further, in the step S1, first process is for simulating agent side.
Further, the step S3 specifically: the second process is produced every the period of setting, each link of monitor client
The SQL message of raw ephemeral data is detained quantity.
Further, in the step S3, the period set is 1 second.
Further, in the step S5, the real-time update of drawing a diagram is shown specifically: is detained according to SQL message
Quantity draws curve graph on html page and real-time update is shown.
The second technical problem to be solved by the present invention is to provide a kind of monitoring data library security audit product treatment SQL
The system of message efficiency, for improving the efficiency and accuracy of monitoring data library security audit product treatment SQL message.
The present invention is implemented as follows: a kind of system of monitoring data library security audit product treatment SQL message efficiency, institute
The system of stating includes following module:
One first process and one second process is arranged for client in process setup module；
Packet data sending module continuously transmits the packet data with SQL message to client for the first process；
Monitoring module, for the second process every the period of setting, the ephemeral data of client is monitored；
Preserving module is saved monitored results in real time to database for the second process；
Display module, for the monitored results in client reading database, and real-time update of drawing a diagram is shown.
Further, in the process setup module, first process is for simulating agent side.
Further, the monitoring module specifically includes: the second process is every the period of setting, each ring of monitor client
The SQL message for saving the ephemeral data generated is detained quantity.
Further, in the monitoring module, the period set is 1 second.
Further, in the display module, the real-time update of drawing a diagram, which is shown, to be specifically included: according to SQL message
It is detained quantity, draws curve graph on html page and real-time update is shown.
The present invention has the advantages that
1, the SQL message of the ephemeral data generated by each link of monitor client is detained quantity, improves monitoring data
The accuracy of library security audit product treatment SQL message, because circulation is equal in the SQL message quantity of each link；
2, the SQL message of the ephemeral data generated by each link of monitor client is detained quantity, improves monitoring data
The efficiency of library security audit product treatment SQL message, because monitoring SQL message quantity is unrelated with the format of ephemeral data；
3, it is shown by the monitored results in client reading database and real-time update of drawing a diagram, so that engineer can
With intuitive, quantity is detained to SQL message in real time and is monitored.
Detailed description of the invention
The present invention is further illustrated in conjunction with the embodiments with reference to the accompanying drawings.
Fig. 1 is the flow chart of the method and system of monitoring data library security audit product treatment SQL message efficiency of the present invention.
Specific embodiment
Please refer to shown in Fig. 1, the method for monitoring data library security audit product treatment SQL message efficiency of the present invention it is preferable
Embodiment includes the following steps:
Step S1, one first process and one second process is arranged in client (Client)；Client is database security
The deployment end of audit product；
Step S2, the first process continuously transmits the packet data with SQL message to client；
Step S3, the second process is monitored the ephemeral data of client every the period of setting；
Step S4, the second process saves monitored results in real time to database；
Step S5, the monitored results in client reading database, and real-time update of drawing a diagram is shown.
In the step S1, first process is for simulating agent side (Agent)；Agent side is target database service
The deployment end of device.
The step S3 specifically: the second process generates interim every the period of setting, each link of monitor client
The SQL message of data is detained quantity；Improve the accuracy and effect of monitoring data library security audit product treatment SQL message
Rate because circulation is equal in the SQL message quantity of each link, and monitor the format of SQL message quantity and ephemeral data without
It closes.
In the step S3, the period set is 1 second.
In the step S5, the real-time update of drawing a diagram is shown specifically: it is detained quantity according to SQL message,
Curve graph is drawn on html page and real-time update is shown；Allow engineer intuitive, number is detained to SQL message in real time
Amount is monitored.
The preferred embodiment of the system of monitoring data library security audit product treatment SQL message efficiency of the present invention, including such as
Lower module:
One first process and one second process is arranged for client (Client) in process setup module；Client is
The deployment end of Method of Database Secure Audit product；
Packet data sending module continuously transmits the packet data with SQL message to client for the first process；
Monitoring module, for the second process every the period of setting, the ephemeral data of client is monitored；
Preserving module is saved monitored results in real time to database for the second process；
Display module, for the monitored results in client reading database, and real-time update of drawing a diagram is shown.
Further, in the process setup module, first process is for simulating agent side (Agent)；Agent side
For the deployment end of targeting database server.
Further, the monitoring module specifically includes: the second process is every the period of setting, each ring of monitor client
The SQL message for saving the ephemeral data generated is detained quantity；Improve the standard of monitoring data library security audit product treatment SQL message
True property and efficiency because circulation is equal in the SQL message quantity of each link, and monitor SQL message quantity and nonce
According to format it is unrelated.
Further, in the monitoring module, the period set is 1 second.
Further, in the display module, the real-time update of drawing a diagram, which is shown, to be specifically included: according to SQL message
It is detained quantity, draws curve graph on html page and real-time update is shown；Allow engineer intuitive, it is right in real time
SQL message is detained quantity and is monitored.
In conclusion the present invention has the advantages that
1, the SQL message of the ephemeral data generated by each link of monitor client is detained quantity, improves monitoring data
The accuracy of library security audit product treatment SQL message, because circulation is equal in the SQL message quantity of each link；
2, the SQL message of the ephemeral data generated by each link of monitor client is detained quantity, improves monitoring data
The efficiency of library security audit product treatment SQL message, because monitoring SQL message quantity is unrelated with the format of ephemeral data；
3, it is shown by the monitored results in client reading database and real-time update of drawing a diagram, so that engineer can
With intuitive, quantity is detained to SQL message in real time and is monitored.
Although specific embodiments of the present invention have been described above, those familiar with the art should be managed
Solution, we are merely exemplary described specific embodiment, rather than for the restriction to the scope of the present invention, it is familiar with this
The technical staff in field should be covered of the invention according to modification and variation equivalent made by spirit of the invention
In scope of the claimed protection.
Claims (10)
1. a kind of method of monitoring data library security audit product treatment SQL message efficiency, it is characterised in that: the method includes
Following steps:
Step S1, one first process and one second process is arranged in client；
Step S2, the first process continuously transmits the packet data with SQL message to client；
Step S3, the second process is monitored the ephemeral data of client every the period of setting；
Step S4, the second process saves monitored results in real time to database；
Step S5, the monitored results in client reading database, and real-time update of drawing a diagram is shown.
2. the method for monitoring data library security audit product treatment SQL message efficiency as described in claim 1, feature exist
In:
In the step S1, first process is for simulating agent side.
3. the method for monitoring data library security audit product treatment SQL message efficiency as described in claim 1, feature exist
In:
The step S3 specifically: the ephemeral data that the second process is generated every the period of setting, each link of monitor client
SQL message be detained quantity.
4. the method for monitoring data library security audit product treatment SQL message efficiency as described in claim 1, feature exist
In: in the step S3, the period set is 1 second.
5. the method for monitoring data library security audit product treatment SQL message efficiency as described in claim 1, feature exist
In:
In the step S5, the real-time update of drawing a diagram is shown specifically: is detained quantity according to SQL message, in HTML page
Curve graph is drawn on face and real-time update is shown.
6. a kind of system of monitoring data library security audit product treatment SQL message efficiency, it is characterised in that: the system comprises
Following module:
One first process and one second process is arranged for client in process setup module；
Packet data sending module continuously transmits the packet data with SQL message to client for the first process；
Monitoring module, for the second process every the period of setting, the ephemeral data of client is monitored；
Preserving module is saved monitored results in real time to database for the second process；
Display module, for the monitored results in client reading database, and real-time update of drawing a diagram is shown.
7. the system of monitoring data library security audit product treatment SQL message efficiency as claimed in claim 6, feature exist
In:
In the process setup module, first process is for simulating agent side.
8. the system of monitoring data library security audit product treatment SQL message efficiency as claimed in claim 6, feature exist
In:
The monitoring module specifically includes: the second process generates interim every the period of setting, each link of monitor client
The SQL message of data is detained quantity.
9. the system of monitoring data library security audit product treatment SQL message efficiency as claimed in claim 6, feature exist
In:
In the monitoring module, the period set is 1 second.
10. the system of monitoring data library security audit product treatment SQL message efficiency as claimed in claim 6, feature exist
In:
In the display module, the real-time update of drawing a diagram, which is shown, to be specifically included: it is detained quantity according to SQL message,
Curve graph is drawn on html page and real-time update is shown.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811153877.9A CN109408326B (en) | 2018-09-30 | 2018-09-30 | Method and system for monitoring SQL message processing efficiency of database security audit product |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811153877.9A CN109408326B (en) | 2018-09-30 | 2018-09-30 | Method and system for monitoring SQL message processing efficiency of database security audit product |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109408326A true CN109408326A (en) | 2019-03-01 |
| CN109408326B CN109408326B (en) | 2021-11-30 |
Family
ID=65465709
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811153877.9A Active CN109408326B (en) | 2018-09-30 | 2018-09-30 | Method and system for monitoring SQL message processing efficiency of database security audit product |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109408326B (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050086579A1 (en) * | 2003-06-13 | 2005-04-21 | Stephen Leitner | Systems and processes for automated criteria and attribute generation, searching, auditing and reporting of data |
| US8504412B1 (en) * | 2012-05-15 | 2013-08-06 | Sap Ag | Audit automation with survey and test plan |
| CN104618192A (en) * | 2015-02-12 | 2015-05-13 | 网神信息技术（北京）股份有限公司 | Testing method and device of audit device of database |
| CN105844142A (en) * | 2016-03-16 | 2016-08-10 | 上海新炬网络信息技术有限公司 | Safe centralized management and control method of database account |
| CN107766207A (en) * | 2017-10-20 | 2018-03-06 | 中国人民财产保险股份有限公司 | Distributed automatic monitoring method, system, computer-readable recording medium and terminal device |
| CN207150256U (en) * | 2017-06-21 | 2018-03-27 | 国网浙江乐清市供电公司 | A kind of house power distribution facility O＆M automated system |
| CN108173838A (en) * | 2017-12-26 | 2018-06-15 | 福建星瑞格软件有限公司 | A kind of control auditing method accessed the network equipment |
-
2018
- 2018-09-30 CN CN201811153877.9A patent/CN109408326B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050086579A1 (en) * | 2003-06-13 | 2005-04-21 | Stephen Leitner | Systems and processes for automated criteria and attribute generation, searching, auditing and reporting of data |
| US8504412B1 (en) * | 2012-05-15 | 2013-08-06 | Sap Ag | Audit automation with survey and test plan |
| CN104618192A (en) * | 2015-02-12 | 2015-05-13 | 网神信息技术（北京）股份有限公司 | Testing method and device of audit device of database |
| CN105844142A (en) * | 2016-03-16 | 2016-08-10 | 上海新炬网络信息技术有限公司 | Safe centralized management and control method of database account |
| CN207150256U (en) * | 2017-06-21 | 2018-03-27 | 国网浙江乐清市供电公司 | A kind of house power distribution facility O＆M automated system |
| CN107766207A (en) * | 2017-10-20 | 2018-03-06 | 中国人民财产保险股份有限公司 | Distributed automatic monitoring method, system, computer-readable recording medium and terminal device |
| CN108173838A (en) * | 2017-12-26 | 2018-06-15 | 福建星瑞格软件有限公司 | A kind of control auditing method accessed the network equipment |
Non-Patent Citations (2)
| Title |
|---|
| 曾明霏等: "基于SQL和表设计的Oracle数据库开发审计研究", 《软件导刊》 * |
| 科技之佳的店: "数据库审计***测试方案", 《HTTPS://WENKU.BAIDU.COM/VIEW/A82D0A66CD7931B765CE0508763231126EDB779A.HTML》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109408326B (en) | 2021-11-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11023896B2 (en) | Systems and methods for real-time processing of data streams | |
| CN106294091B (en) | It is a kind of to intercept method for analyzing performance and system without intrusive log | |
| US20160110359A1 (en) | Method and Apparatus for Logging Data Records | |
| CN102340415A (en) | Server cluster system and monitoring method thereof | |
| CN113157545A (en) | Method, device and equipment for processing service log and storage medium | |
| CN104980421B (en) | Batch request processing method and system | |
| CN104933127A (en) | Cross-machine-room database synchronization equipment and method based on MariaDB | |
| US10698927B1 (en) | Multiple sensor session and log information compression and correlation system | |
| CN111327636B (en) | S7-300PLC private protocol reverse method relating to network security | |
| WO2021068607A1 (en) | Multi-system multi-store order integrating method and apparatus, computer device and storage medium | |
| CN110442628A (en) | A kind of data monitoring method, system and computer equipment | |
| CN105243499A (en) | Order distribution method and system | |
| CN107885634B (en) | Method and device for processing abnormal information in monitoring | |
| CN110807050B (en) | Performance analysis method, device, computer equipment and storage medium | |
| WO2019118365A1 (en) | Systems and methods for ingesting and processing data in a data processing environment | |
| CN111767262A (en) | Log display method, device, equipment and storage medium | |
| CN109408326A (en) | The method and system of monitoring data library security audit product treatment SQL message efficiency | |
| CN110750299A (en) | Intelligent software quality tracking system, method and storage medium | |
| CN104298918A (en) | Virus scanning method and system based on data block in virtual machine | |
| US20170132052A1 (en) | Analyzing and automating work-flow in a computerized user-interface | |
| CN115361450B (en) | Request information processing method, apparatus, electronic device, medium, and program product | |
| CN110633191A (en) | Method and system for monitoring service health degree of software system in real time | |
| CN104462484B (en) | Data processing method, data processor and system | |
| CN106503173A (en) | KV data bank access methods and device | |
| CN107995273B (en) | iOS network management method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 350000 21 / F, building 5, f District, Fuzhou Software Park, 89 software Avenue, Gulou District, Fuzhou City, Fujian Province Applicant after: FUJIAN SINOREGAL SOFTWARE Co.,Ltd. Address before: Floor 20-21, building 5, area F, Fuzhou Software Park, 89 software Avenue, Gulou District, Fuzhou City, Fujian Province 350000 Applicant before: FUJIAN SINOREGAL SOFTWARE Co.,Ltd. |
|
| CB02 | Change of applicant information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |