Unlock instant, AI-driven research and patent intelligence for your innovation.

Column-storage-based data insertion method and device, server, and storage medium

A data insertion and column storage technology, applied in the database field, can solve problems such as cumbersome small data operations, and achieve the effect of improving insertion efficiency

Active Publication Date: 2018-12-18
SHANGHAI DAMENG DATABASE
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, an embodiment of the present invention provides a column storage-based data insertion method, device, server, and storage medium to solve the problem of cumbersome operations when frequently inserting small data

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
  • Column-storage-based data insertion method and device, server, and storage medium
  • Column-storage-based data insertion method and device, server, and storage medium
  • Column-storage-based data insertion method and device, server, and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0030] figure 1 It is a flow chart of the column storage-based data insertion method provided by Embodiment 1 of the present invention. This embodiment can be applied to a data insertion system, and the method can be executed by a data insertion device, such as figure 1 As shown, the technical solution provided in this embodiment specifically includes the following steps:

[0031] Step 110, acquire the data to be inserted into the column storage table.

[0032] Column storage is to store data in units of columns, and its specific storage rules and management implementation methods will directly determine the operation efficiency of column storage tables. The data that the user needs to insert is the data to be inserted, and the column storage table to be inserted is specified.

[0033] The data to be inserted in this embodiment of the application can be any data object that needs to be inserted, for example, it can be a student data object, where the student data object usua...

Embodiment 2

[0073] figure 2 A flowchart of a data insertion method based on column storage provided by Embodiment 2 of the present invention is given. This embodiment provides a preferred embodiment based on the foregoing embodiments, and for details not described in detail in this embodiment, refer to the foregoing Embodiment 1. like figure 2 As shown, a column-based data insertion method provided in this embodiment includes the following steps:

[0074] Step 210, acquiring data to be inserted into the column storage table.

[0075] Step 220, according to the data to be inserted, obtain data in an insertion auxiliary table corresponding to the column storage table, and the insertion auxiliary table is used to record insertion data less than a preset number of rows.

[0076] Step 230, judging whether the total number of rows of the data to be inserted and the data inserted into the auxiliary table is less than the preset number of rows, if yes, execute step 240, if not, execute step ...

Embodiment 3

[0086] image 3 A flowchart of a data insertion method based on column storage provided by Embodiment 3 of the present invention is given. This embodiment provides a preferred embodiment based on the above-mentioned second embodiment. For details not described in detail in this embodiment, refer to the above-mentioned second embodiment. like image 3 As shown, a column-based data insertion method provided in this embodiment includes the following steps:

[0087] Step 301, acquire the data to be inserted into the column storage table.

[0088] Step 302, according to the data to be inserted, obtain data in an insertion auxiliary table corresponding to the column storage table, and the insertion auxiliary table is used to record insertion data less than a preset number of rows.

[0089] Step 303, judging that the total number of rows of the data to be inserted and the data inserted into the auxiliary table is less than the preset number of rows, if yes, execute step 304, other...

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 column-storage-based data insertion method and device, a server, and a storage medium, which relate to the field of database. The method comprises the following steps: obtaining data to be inserted of a column storage table; obtaining data inserted into the auxiliary table corresponding to the column storage table; if the total number of rows to be inserted into the dataand the data to be inserted into the auxiliary table is less than the preset number of rows, inserting the data to be inserted into the insertion auxiliary table; if the total number of rows of the data to be inserted and the data to be inserted in the auxiliary table is greater than or equal to the preset number of rows, storing the data to be inserted and the data to be inserted in the auxiliarytable as one or more data areas according to the preset number of rows, emptying the insertion auxiliary table, and storing the remaining data in the insertion auxiliary table. One or more data areasare saved as a data file of a column storage table, and control information and statistical information of each data area obtained are inserted into a column storage auxiliary table corresponding tothe column storage table. The invention adopts the technical proposal and improves the data insertion efficiency of the column storage table.

Description

technical field [0001] Embodiments of the present invention relate to database technologies, and in particular, to a data insertion method, device, server and storage medium based on column storage. Background technique [0002] In order to improve the performance of data query, the method of storing data in the form of column storage came into being. The query performance of the column storage table is better than that of the row storage table, but conversely, the insertion performance of the column storage table is lower than that of the row storage table. [0003] The basic idea of ​​the column storage table is to store the data in the table in units of columns. The physical location of the data storage of a row is not continuous. Therefore, when a single row (or a few rows) is frequently inserted, the performance of the column storage table will be very poor. Difference. Contents of the invention [0004] In view of this, embodiments of the present invention provide ...

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 SHANGHAI DAMENG DATABASE