Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Compression processing method and device for character string type columns

A string type and compression processing technology, applied in the field of data processing, can solve the problems of low compression processing efficiency and achieve the effect of improving compression processing efficiency

Active Publication Date: 2017-12-19
BEIJING GRIDSUM TECH CO LTD
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The main purpose of the present invention is to provide a method and device for compressing string-type columns to solve the problem of low efficiency in the prior art for string-type column compression processing

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
  • Compression processing method and device for character string type columns
  • Compression processing method and device for character string type columns
  • Compression processing method and device for character string type columns

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present invention will be described in detail below with reference to the accompanying drawings and examples.

[0024] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiment of the application will be clearly and completely described below in conjunction with the accompanying drawings in the embodiment of the application. Obviously, the described embodiment is only It is an embodiment of a part of the application, but not all of the embodiments. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the protection scope of this application.

[0025] It should be noted that the terms "first" and "second" in the...

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 compression processing method and a compression processing device of a character string type column. The compression processing method of the character string type column includes: confirming a data list to be compressed; confirming a character string column in the data list to be compressed, wherein using the character string column as the character string type column in the data list to be compressed; confirming key value corresponding to character string value in the character string column, wherein using the key value as value of data types; replacing the character string value in the character string column with the key value corresponding to the character string value in the character string column; obtaining a first storage index, wherein using the first storage index as a corresponding index built according to the key value corresponding to the character string value in the character string column; compressing the data list to be compressed according to the first storage index. The compression processing method and the compression processing device of the character string type column solve the problem that compression processing of the character string type column is low in efficiency in the prior art.

Description

technical field [0001] The present invention relates to the field of data processing, in particular to a compression processing method and device for character string type columns. Background technique [0002] In database storage technology, column storage indexes are stored according to columns. The advantage of the column storage index is that it can greatly improve the performance of the database, and the column storage compression technology can greatly reduce the space usage. [0003] By storing data in the same column together, column storage can maximize the use of duplicate data and perform compression. In the database, different types of data also have a great impact on the efficiency of compression. The string type is not very friendly to compression due to its variable length and the large space occupied by the string itself. Therefore, the compression process is inefficient. [0004] Aiming at the problem of low efficiency of column compression processing of...

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
CPCG06F16/1737
Inventor 黄健
Owner BEIJING GRIDSUM TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

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