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

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

A technology of information extraction and database, which is applied in the direction of electronic digital data processing, special data processing application, calculation, etc., can solve the problems of audit losing practical significance and inaccurate audit database operation behavior, and achieve the effect of improving accuracy

Inactive Publication Date: 2011-04-06
BEIJING VENUS INFORMATION TECH
View PDF0 Cites 0 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
  • 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 to this, and the extracted information can also be used for other purposes.

[0057] Such as figure 1 As shown, the method for extracting and auditing information from DB2 database operations in this embodiment includes the following steps:

[0058] Step 110, DB2 database identification step: determine whether the current environment is a DB2 database, if not, handle it separately, the present invention does not involve it, if it is, perform the 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 data messages exchanged during the actual network environment operation....

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 statementsincluding 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 a method for extracting and auditing information from a database operation and its device and system, in particular to a method for extracting and auditing information from a DB2 database and its device and system. Background technique [0002] At present, many industries use the DB database developed by IBM. The current database operations are submitted to the back-end database in the form of SQL statements for related processing, and the method of submitting the back-end database in some operating environments is to use bind variables. The bind variable method can make the database soft Analyze, effectively improve the speed of SQL statement execution 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] INSERT INTO DB2ADMIN...

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 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