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

Data delete method and device based on column storage, server, and storage medium

A deletion method and column storage technology, applied in the database field, can solve problems such as low data deletion performance, improve deletion efficiency, avoid reading and writing, and solve low data deletion efficiency.

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

AI Technical Summary

Problems solved by technology

[0004] The column storage method can certainly improve data query performance, but when deleting data, because deleting a row of data needs to locate and delete each column data stored separately, the performance of data deletion is lower than that of the row storage method

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
  • Data delete method and device based on column storage, server, and storage medium
  • Data delete method and device based on column storage, server, and storage medium
  • Data delete method and device based on column storage, server, and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0028] figure 1 It is a flowchart of a data deletion method based on column storage provided by Embodiment 1 of the present invention. This embodiment is applicable to the case of deleting data based on column storage. This method can be performed by a data deletion device based on column storage Execution, the device can be implemented by software and / or hardware, and generally can be integrated in the server, such as figure 1 As shown, the technical solution provided by this embodiment is specifically as follows:

[0029] Step 110, acquire the data to be deleted in the column storage table.

[0030] Optionally, obtaining the data to be deleted of the column storage table may first obtain the deletion statement of the column storage table, and determine the data to be deleted according to the deletion statement.

[0031] Exemplarily, by deleting the statement: delete from t where student number='110628', the student record whose student number is '110628' in table t can be ...

Embodiment 2

[0077] figure 2 A flowchart of a method for deleting data 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. Such as figure 2 As shown, a method for deleting data based on column storage provided in this embodiment includes the following steps:

[0078] Step 210: Obtain the data to be deleted in the column storage table.

[0079] Step 220: Determine the data area in the column storage table where the data to be deleted is located.

[0080] Step 230: Obtain records of the column storage auxiliary table corresponding to the data area.

[0081] In this embodiment, after the data area of ​​the column storage table where the data to be deleted is determined, a record of the data area is found in the column storage auxiliary table. Exemplarily, the record may includ...

Embodiment 3

[0097] image 3 It is a flowchart of an apparatus for deleting data based on column storage provided in Embodiment 4 of the present invention, and the apparatus is used to execute a method for deleting data based on column storage. Such as image 3 As shown, the device includes a data acquisition module 310 , a data area determination module 320 , a line number recording module 330 and a record modification module 340 .

[0098] Wherein, the data obtaining module 310 is used to obtain the data to be deleted in the column storage table;

[0099] A data area determination module 320, configured to determine the data area in the column storage table where the data to be deleted is located;

[0100] A row number recording module 330, configured to record the row number of the data to be deleted in the deletion auxiliary table corresponding to the column storage table according to the data area;

[0101] The record modifying module 340 is configured to determine the statistical ...

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 data deletion method and device based on column storage, a server and a storage medium, which relate to the field of a database. The method includes: obtaining data to be deleted of a column storage table; determining a data area in a column storage table where the data to be deleted is located; according to the data area, recording a row number of the data to be deletedin a deletion auxiliary table corresponding to the column storage table; determining the statistical information after the data area deletes the data to be deleted, and modifying a record corresponding to the statistical information in a column storage auxiliary table corresponding to the column storage table. The invention adopts the technical scheme and improves the deletion efficiency of the data stored based on the column.

Description

technical field [0001] Embodiments of the present invention relate to the technical field of databases, and in particular to a method, device, server and storage medium for deleting data based on column storage. Background technique [0002] With the continuous development of big data technology, the amount of data contained in the database has increased dramatically, which poses a challenge to the query performance of the traditional row-based storage mode. [0003] At present, in order to improve database query performance, people begin to consider a storage method different from traditional row storage—column storage. Column storage technology is to store data tables in units of columns, and the data of the same column is stored in one data file or in multiple files according to the data scale. [0004] The column storage method can certainly improve data query performance, but when deleting data, since deleting a row of data requires locating and deleting each column da...

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