Method for compressed storage of massive SQL (structured query language) by means of extracting SQL models

A technology of compressed storage and templates, applied in special data processing applications, instruments, electrical digital data processing, etc., can solve the problems of excessive storage space and low utilization rate, and achieve storage space saving, fast storage disk storage, and storage saving. effect of overhead

Inactive Publication Date: 2012-07-25
HANGZHOU ANHENG INFORMATION TECH CO LTD
View PDF3 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The technical problem to be solved by the present invention is to provide a method for compressing and storing massive SQL by extracting SQL templa

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 for compressed storage of massive SQL (structured query language) by means of extracting SQL models
  • Method for compressed storage of massive SQL (structured query language) by means of extracting SQL models
  • Method for compressed storage of massive SQL (structured query language) by means of extracting SQL models

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0031] The following is a typical implementation case of compressing and storing massive SQL by extracting SQL templates:

[0032] Suppose you want to perform database audit on an Oracle10g database.

[0033] First configure an audit object and generate a SQL template string, the specific processing flow is as follows figure 1 shown, including the following steps:

[0034] Step 1-1: Open the audit system;

[0035] Step 1-2: Make necessary configurations for our audit objects;

[0036] Mainly input the database IP, port, version, operating system type and other information.

[0037] Step 1-3: Mirror the bypass traffic to the database audit system

[0038] The so-called bypass traffic refers to the "port mirroring" function of network devices such as switches, which copies the traffic flowing through the designated port of the switch to a certain output port of the switch, and the traffic flowing to this output port is the bypass traffic. The traffic output from this port i...

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 relates to the technology of database information storage and aims to provide a method for compressed storage of massive SQL (structured query language) by means of extracting SQL models. The method includes steps: firstly, using a database audit system to recognize constant parameters of the SQL, extracting the information and replacing the information by sequentially numbered contents with fixed prefixes, and forming strings of SQL behavior models with only variables but particular parameters; secondly, generating only identification codes, denoted by long integer, of the obtained SQL behavior models through hash algorithm and maintaining corresponding relationships of the identification codes and the SQL behavior models in the audit system; thirdly, storing relevant information in a database of the database audit system in practical storage, and replacing the SQL information in a SQL audit record with the only identification codes and the constant parameters. By the method, storage consumption of redundant portion is saved greatly, no harmful effect is brought to integrity of audit contents, and accordingly, fast and space-saving storage on the premise that the integrity of audit records is not damaged is achieved.

Description

technical field [0001] The invention relates to the technical field of information storage of a database audit system. It specifically relates to the compressed storage of massive SQL data, especially a method for fast storage and saving the storage capacity of database audit content. technical background [0002] With the continuous expansion of the operator's user scale, the continuous expansion of enterprise business platforms, and the rise of e-commerce platforms and cloud platforms, the number of operations such as queries and updates per second generated by their business databases is also increasing, which has great impact on the database audit system. Storage capacity requirements are getting higher and higher, and how to save massive amounts of data quickly and economically is becoming more and more urgent. [0003] The storage content of the database audit system is mainly SQL requests and related information, corresponding to different business systems, the lengt...

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 HANGZHOU ANHENG INFORMATION TECH CO LTD
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