Method and device for restoring parameters in Oracle database access traffic

A technology for accessing traffic and databases, which is applied in the field of computer-readable storage media and parameter restoration. It can solve the problems of inaccessible traffic packet parameter restoration, disordered parameter value list, and affecting the audit effect of access traffic packets, so as to improve the audit effect. Effect

Pending Publication Date: 2021-11-30
杭州安恒信息安全技术有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, when collecting operation and maintenance records at present, it is found that the parameter value list submitted after the SQL statement is easy to appear in the PL / SQL Developer information, which leads to the inability to accurately restore the parameters contained in the access traffic package, which affects the access traffic package. audit effect

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
  • Method and device for restoring parameters in Oracle database access traffic
  • Method and device for restoring parameters in Oracle database access traffic
  • Method and device for restoring parameters in Oracle database access traffic

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0052] In order to enable those skilled in the art to better understand the solution of the present invention, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments. Apparently, the described embodiments are only some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0053] see figure 1 , figure 1 It is an implementation flowchart of a method for restoring parameters in Oracle database access traffic in an embodiment of the present invention, and the method may include the following steps:

[0054] S101: Analyze the received access traffic packet for the Oracle database, and obtain the client information of the sender corresponding to the access traffic packet.

[0055]...

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 a method for restoring parameters in Oracle database access traffic, which comprises the following steps: analyzing a received access traffic packet aiming at an Oracle database to obtain client information of a sending end corresponding to the access traffic packet; judging whether the client side information contains the PL/SQLDEVELOPER information or not; if yes, obtaining an SQL statement request from the access traffic packet; judging whether the SQL statement request contains lock information or not; if yes, acquiring a parameter type set contained in the access traffic packet; judging whether the parameter type set contains a special character string type or not; and if yes, performing parameter reduction according to a preset parameter reduction sequence. According to the invention, the parameters contained in the access traffic packet are accurately restored, and the audit effect of the access traffic packet is improved. The invention further discloses a device, equipment and a storage medium, which have corresponding technical effects.

Description

technical field [0001] The present invention relates to the field of storage technology, in particular to a parameter restoration method, device, equipment and computer-readable storage medium in Oracle database access traffic. Background technique [0002] When the client needs to access the Oracle database, when the Oracle database receives the access traffic packet, it needs to analyze and obtain the content to be queried specifically contained in the access traffic packet, and audit the content to be queried. Only when the audit passes, can the Respond to access requests. [0003] However, when collecting operation and maintenance records at present, it is found that the parameter value list submitted after the SQL statement is easy to appear in the PL / SQL Developer information, which leads to the inability to accurately restore the parameters contained in the access traffic package, which affects the access traffic package. audit effect. [0004] To sum up, how to eff...

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 Applications(China)
IPC IPC(8): G06F16/242G06F16/2455G06F16/28G06F21/62
CPCG06F16/2433G06F16/2455G06F16/285G06F21/6227G06F2221/2141
Inventor 李绍平龙文洁
Owner 杭州安恒信息安全技术有限公司
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