Check patentability & draft patents in minutes with Patsnap Eureka AI!

Information extraction and audit method of DB2 database operation, device and system thereof

An information extraction and database technology, which is applied in electronic digital data processing, special data processing applications, and computing, etc., can solve problems such as the loss of practical significance of auditing and the inability to accurately audit database operation behavior, and achieve the effect of improving accuracy.

Inactive Publication Date: 2009-10-21
BEIJING VENUS INFORMATION TECH
View PDF0 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This kind of defect in information extraction leads to no difference in the audit results of SQL statements with different assignments of the same variable, and it is impossible to accurately audit database operation behavior, which largely makes auditing lose its practical significance

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
  • Information extraction and audit method of DB2 database operation, device and system thereof
  • Information extraction and audit method of DB2 database operation, device and system thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0056] In this embodiment, the sql statement and its assignment information extracted from the DB2 database data message are used for auditing, but the present invention is not limited thereto, and the extracted information can also be used for other purposes.

[0057] Such as figure 1 As shown, the information extraction and auditing method of DB2 database operation of the present embodiment comprises the following steps:

[0058] Step 110, DB2 database identification step: determine whether the current environment uses a DB2 database, if not, process it separately, the present invention does not involve, if yes, perform subsequent steps;

[0059] Different databases use different communication protocols, for example, Sybase database and sqlserver database use TDS protocol, Oracle database uses TNS protocol, DB2 database uses DRDA protocol and so on. Different databases use different protocols and ports in the data packets exchanged in the actual network environment operatio...

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 information extraction and audit method of DB2 database operation and a device thereof. The method comprises the following steps: acquiring a data message exchanged between a DB2 database client side and a server, and then extracting all sq1 statements; detecting whether the extracted sq1 statements include variables, in the event of detecting the sq1 statements including the variables, identifying types of various variables of the sq1 statements including the variables in the database message; and extracting specific values of various variables of the sq1 statements including the variables from the database message according to the types of various variables. Correspondingly, the device comprises a sq1 statement extractor, a sq1 statement discriminator, a variable type identifier and a variable value extractor which are sequentially connected. The device can accurately extract the variables and the specific values thereof from the data message of the sq1 statements including binding variables and can be used for auditing.

Description

technical field [0001] The invention relates to an information extraction and auditing method for database operation and its device and system, in particular to a DB2 database operation information extraction and auditing method and its device and system. Background technique [0002] At present, many industries use the DB database developed by IBM. The current database operations are all submitted to the background database in the form of sql statements for related processing, and the method of submitting the background database in some operating environments is to use the method of binding variables, which can make the database soft Analysis, effectively improving the speed of executing SQL statements of the database server. At the same time, SQL injection attacks can be avoided to a certain extent. [0003] For example: the traditional SQL statement submitted to the database server is as follows: [0004] INSERT INTO DB2ADMIN.DORIS_T1("COL1") VALUES(1); [0005] INSER...

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
Inventor 孙海波周涛姚熙刘晖
Owner BEIJING VENUS INFORMATION TECH
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com