Dictionary data processing method and device, electronic equipment and storage medium
A dictionary data and processing method technology, applied in the database field, can solve problems such as unstable database operation, and achieve the effect of avoiding excessive data volume and improving operation efficiency.
Pending Publication Date: 2022-02-11
BEIJING DAJIA INTERNET INFORMATION TECH CO LTD
View PDF0 Cites 2 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0005] The present disclosure provides a dictionary data processing method, device, electronic equipment and storage medium to at least solve the problem of unstable operation of the database in the related art
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0051] In order to enable ordinary persons in the art to better understand the technical solutions of the present disclosure, the technical solutions in the embodiments of the present disclosure will be clearly and completely described below in conjunction with the accompanying drawings.
[0052] It should be noted that the terms "first" and "second" in the specification and claims of the present disclosure and the above drawings are used to distinguish similar objects, but not necessarily used to describe a specific sequence or sequence. It is to be understood that the data so used are interchangeable under appropriate circumstances such that the embodiments of the disclosure described herein can be practiced in sequences other than those illustrated or described herein. The implementations described in the following exemplary examples do not represent all implementations consistent with the present disclosure. Rather, they are merely examples of apparatuses and methods consi...
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
Login to View More Abstract
The invention relates to a dictionary data processing method and device, electronic equipment and a storage medium. The method comprises the steps of obtaining a to-be-processed data record, for at least one variable-length field contained in the to-be-processed data record, obtaining a target dictionary corresponding to the variable-length field, wherein the variable-length field has at least one field value, for any variable-length field, recording the dictionary codes corresponding to the field values of any variable-length field into a target dictionary corresponding to any variable-length field, if the total number of the dictionary items in the target dictionary reaches a preset number threshold value and the frequency distribution of each dictionary item in the target dictionary does not meet a frequency distribution condition, removing the target dictionary after executing the target data operation, wherein the target data operation is a data query operation generated in response to a data query request of the to-be-processed data record, and the frequency distribution condition is determined according to the frequency distribution of each dictionary item in the effective dictionary. The operation efficiency of the database can be improved.
Description
technical field [0001] The present disclosure relates to the technical field of databases, in particular to a dictionary data processing method, device, electronic equipment and storage medium. Background technique [0002] A database is a "warehouse that organizes, stores and manages data according to the data structure", and is a collection of large amounts of data stored in a computer for a long time, organized, shareable, and uniformly managed. [0003] Dictionary encoding is a commonly used compression algorithm, which encodes fields with limited cardinality (smaller cardinality, that is, limited value range) into a dictionary and a series of indexes of actual values in the dictionary. [0004] In related technologies, when using dictionary encoding for variable-length fields with large base numbers, since the variable-length fields with large base numbers have field content with indistinct data distribution characteristics, the operation overhead of dictionary encodi...
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
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F40/157G06F16/36G06F16/22G06F40/216
CPCG06F40/157G06F16/374G06F16/2282G06F40/216
Inventor 申毅杰
Owner BEIJING DAJIA INTERNET INFORMATION TECH CO LTD