A method and device for processing large-field data

Abstract

The invention discloses a processing method and device of big-field data. The processing method comprises the following steps: receiving a processing instruction for processing the big-field data of an appointed database table; and if the data length of the big-field data is smaller than or equal to a pre-set threshold value, determining a data page to which the big-field data belongs according to the processing instruction and carrying out corresponding processing on the big-field data, wherein the data page is recorded as a big-field recording page, and the big-field recording page is used for storing data information of at least two big-field data. With the adoption of the processing method, the data page to which the big-field data belongs stores data information of the two big-field data at least, so that a storage space of a database can be saved and resource wastes of the storage space are reduced; and furthermore, a data page loading amount can also be reduced when the big-field data is processed and input / output cost is reduced when the big-field data is processed, so that the executing efficiency of the database is improved.

Description

technical field [0001] The embodiments of the present invention relate to the field of database-related technologies, and in particular, to a method and device for processing large-field data. Background technique [0002] A large field is a data type in the database, and the data stored in the large field type is called large field data. Generally, the data stored in the large field type can be divided into two categories: one is long text, the common text type can only store up to 4000 Chinese characters, and the long text stored based on the large field type can be far greater than 4000 characters; the other One type is binary information, such as pictures or files. Compared to other data types, large fields require special storage. [0003] Because the size of large field data is generally large, even larger than the maximum row size specified by the database. This means that many large field data cannot be stored directly in the row unit of the database table. In th...

AI Technical Summary

Problems solved by technology

[0004] For this simple large-field independent storage method, the limitation is: for storing large-field data, at least one large-field data page is required, however, for a large-field data page, it can only be used to store one large field data

However, in practical applications, the length of many large field data will not exceed half of the data page. In this case, after a large field data page stores a large field data, there will be a large amount of free space left, and these free spaces are also Can no longer be used to store other data

This results in a waste of space for large-field data pages; at the same time, when batch queries are performed on large-field data, the input and output costs of large-field data pages will also be increased, thereby reducing the execution efficiency of the database

Images