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

Data recording operation method, apparatus and device and storage medium

A technology of data recording and operation method, applied in the field of database processing, can solve the problems of omission, low efficiency, insufficient ordering and organization method, etc., and achieve the effect of improving efficiency

Active Publication Date: 2018-05-25
SHANGHAI DAMENG DATABASE
View PDF7 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] But when adding columns to the table, there are deficiencies in the method of ordering and organization
The data field corresponding to the newly added column in the record may be between other fields, and the subsequent fields cannot be omitted according to the length of the record. Therefore, for the existing data, the data must be rebuilt when adding a column, which will cause the data table to add a column operation Generate a lot of IO, the efficiency is very low

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 recording operation method, apparatus and device and storage medium
  • Data recording operation method, apparatus and device and storage medium
  • Data recording operation method, apparatus and device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0030] figure 1 It is a flow chart of a data record operation method provided by Embodiment 1 of the present invention. This embodiment is applicable to the situation of organizing and analyzing data records in row storage mode in any database technology. A data recording operation method provided in this embodiment can be executed by a data recording operation device, which can be implemented by means of software and / or hardware, and integrated into the device that executes the method. In this embodiment The device for executing the method may be any intelligent terminal capable of operating data records, such as a tablet computer, a desktop computer, and a notebook. Specifically, refer to figure 1 , the method specifically includes the following steps:

[0031] S110. Obtain a record organization description corresponding to the data record.

[0032] Specifically, data records are row records in the table structure. In order to add columns to the table where the data reco...

Embodiment 2

[0052] figure 2 It is a flowchart of a method for generating a record organization description in the method provided by Embodiment 2 of the present invention. Embodiment 2 of the present invention further exemplifies the flow of record organization description generated according to the data dictionary on the basis of the above embodiments.

[0053] Such as figure 2 As shown, the record organization description is automatically generated according to the data dictionary of the database, and the generation steps are roughly divided into two steps.

[0054] The first step is to traverse the field objects of all columns in the table where the data record after adding the extended field is located, and fill in the information of each field. For the original field, count the number of fixed-length fields and the sum of the data length in the field before this field. Among them, if it is a fixed-length field, set its physical ID to the number of fixed-length fields before this...

Embodiment 3

[0061] image 3 It is a flowchart of a data recording operation method provided by Embodiment 3 of the present invention. This embodiment optimizes the organization method of data in each field in the data record on the basis of the above embodiments. see image 3 , the method of this embodiment specifically includes:

[0062] S210. Organize the original fields according to the ordering manner, and determine the data offset of the first extended field.

[0063] Specifically, when organizing the data of each field in the data record, the data offset of the first variable-length field does not change according to the method of organizing the records in sequence. Further, according to the data length of each variable-length field in the original field, the sum of the data lengths of the variable-length fields is determined, starting from the data offset of the first variable-length field, the data of the variable-length fields is organized sequentially, and organized according t...

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 embodiment of the invention discloses a data recording operation method, apparatus and device and a storage medium. The method includes distinguishing an extended field corresponding to a column added by an operation of modifying a table structure from an original field corresponding to an original column at the time of the construction of a table when recording organization and parsing are performed. The method specifically includes obtaining a record organization description of the table where the data record is located, and causing the record organization description to obtain the number of original columns and added columns in the table, and determining a physical identifier of the extended field according to the number of the original columns and the number of other added columnsbefore the added columns; based on the sum of the data length of the original field and the data length of other extended fields before the extended fields, determining the data offset of the extendedfields; and according to the physical identifier of the extended fields and the data offset, sequentially organizing the field data into the data records. According to the technical scheme, when thecolumns are added to the table, only a data dictionary is operated, the reconstruction of the data is not required, which improves the efficiency of adding columns to the table.

Description

technical field [0001] The embodiments of the present invention relate to the field of database processing, and in particular, to an operation method, device, equipment and storage medium for data recording. Background technique [0002] The most common way to organize the row records of the data list in the database is to organize each field according to the order of the columns defined in the table. We call it the sequential organization method. Long-type fields and variable-length-type fields are collected together to adjust the organization order of the fields in the record, which we call the ordering organization method. For example, the definition of the table TAB is (C1 VARCHAR(10), C2 INT, C3 VARBINARY(10), C4 INT); according to the sequential organization method, the order of the fields is C1, C2, C3, C4, according to the sequence organization method, Columns C2 and C4 in table TAB are fixed-length, columns C1 and C3 are variable-length, and the order of fields is ...

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
CPCG06F16/2282
Inventor 王攀王家贤
Owner SHANGHAI DAMENG DATABASE