Method and device for updating column storage table

A technology of column storage and row storage, which is applied in the field of updating column storage tables, can solve the problems of column storage response delay and low column storage efficiency, and achieve the effect of reducing response delay and improving column storage efficiency

Active Publication Date: 2017-04-05
BEIJING GRIDSUM TECH CO LTD
View PDF3 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] The embodiment of the present invention provides a method and device for updating a column storage table, so as to at least solve the problem of column storage caused by the amount of data in the row storage in the related art that is converted into the data volume in the column storage only when the preset threshold is reached. Technical issues of response delay and low column storage efficiency

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 updating column storage table
  • Method and device for updating column storage table

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0025] According to an embodiment of the present invention, an embodiment of a method for updating a column storage table is provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, Also, although a logical sequence is shown in the flowchart, in some cases, the steps shown or described may be performed in a different order than here.

[0026] figure 1 Is a flowchart of an optional method for updating a column storage table according to an embodiment of the present invention, such as figure 1 As shown, the method includes the following steps:

[0027] Step S102, obtaining the data volume of the currently deleted data in the column storage table of the database and the data volume of the currently stored data in the row storage table of the database;

[0028] Step S104: Determine whether to update the column storage index in the column storage table according t...

Embodiment 2

[0054] According to an embodiment of the present invention, an embodiment of an apparatus for updating a column storage table is provided.

[0055] figure 2 It is a schematic diagram of an optional device for updating a column storage table according to an embodiment of the present invention, such as figure 2 As shown, the device includes: an acquiring unit 202, configured to acquire the amount of data currently deleted in the column storage table of the database and the amount of data currently stored in the row storage table of the database; a determining unit 204, configured to obtain The data volume of the currently deleted data and the data volume of the currently stored data determine whether to update the column storage index in the column storage table.

[0056] Because the statistical information table in the database stores metadata, such as sys indexes, where the metadata includes the row number field Rows, the statistical information table can be queried through 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 method and device for updating column storage table. The method comprises the following steps of: obtaining the data size of data which is deleted at present in the column storage table of a database and the data size of data which is stored at present in the line storage table of the database; and according to the obtained data size of the data which is deleted at present and the obtained data size of the data which is stored at present, determining whether a column storage index in the column storage table is updated or not. By use of the method, the technical problems of column storage response time delay and low column storage efficiency since the data size in the line storage can be converted into the data size in the column storage only when the data size in the line storage achieves a preset threshold value in the prior art are solved.

Description

Technical field [0001] The present invention relates to the field of databases, in particular to a method and device for updating column storage tables. Background technique [0002] Column store index can save the occupation of database storage space through column store compression technology, thereby improving database performance. [0003] In related technologies, the column storage process can be divided into three stages, namely: (1) Group the data in the row storage table by rows to obtain multiple so-called row groups, each row group can hold 102,400 to 1,048,576 Data rows; (2) Divide each row group into multiple column fragments by column; (3) After compressing each column fragment, insert it into the actual column storage table as a column storage index. [0004] For the above column storage procedure, on the one hand, when dividing row groups, there may be cases where the number of rows in the row storage table does not meet the minimum conditions for row group division. ...

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): G06F17/30
Inventor 黄健
Owner BEIJING GRIDSUM 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