Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Processing method and device of big-field data

A processing method and large-field technology, applied in database-related fields, can solve problems that cannot meet application requirements, affect the efficiency of large-field data processing, and redundant input and output operations

Active Publication Date: 2016-11-23
SHANGHAI DAMENG DATABASE
View PDF2 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, when the specified data to be processed is determined by the above positioning method for the large-field data stored based on the independent storage method, before finding the page where the above-mentioned specified data is located, the content of other large-field data pages will also be traversed, but for other The input and output of large-field data page traversal are redundant operations, which greatly affects the processing efficiency of large-field data. From this, it can be seen that the large-field data stored based on the independent storage method, when processing large-field data Can not meet the actual application requirements

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
  • Processing method and device of big-field data
  • Processing method and device of big-field data
  • Processing method and device of big-field data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0019] figure 1 It is a schematic flowchart of a method for processing large-field data provided in Embodiment 1 of the present invention. The method is suitable for processing large-field data, and can be executed by a large-field data processing device, wherein the device can be implemented by software and / or hardware, and is generally integrated into a database management system.

[0020] like figure 1 As shown, a method for processing large-field data provided by Embodiment 1 of the present invention specifically includes the following operations:

[0021] S101. Receive a processing instruction for processing large-field data, where the large-field data is stored in pieces in a designated database table.

[0022] In this embodiment, the large-field data can be specifically understood as data corresponding to a column whose data type is a large field stored in the designated database table, such as long text, picture or file, etc., wherein the The processing of the large...

Embodiment 2

[0033] figure 2 It is a schematic flowchart of a method for processing large-field data provided by Embodiment 2 of the present invention. Embodiment 2 of the present invention is optimized based on the foregoing embodiments. In this embodiment, the processing method further includes: storing the large-field data in pieces in the specified database table.

[0034] On the basis of the above optimization, further optimize "storing the large-field data in pieces in the specified database table" as: a. receiving a storage instruction for storing the large-field data, and obtaining the current large-field to be stored data; b. Determine whether there is a data page linked list corresponding to the large field data in the specified database table based on the storage instruction, if so, execute step c; if not, execute step d; c, obtain the The large field of the data page linked list controls the storage content in the page, and after recording the storage content in the fragmenta...

Embodiment 3

[0085] image 3 It is a schematic flowchart of a method for processing large-field data provided by Embodiment 3 of the present invention. Embodiment 3 of the present invention is optimized on the basis of the above-mentioned embodiments. In this embodiment, "determine the data page linked list formed by the data page storing the large-field data, and add the data page linked list in the data page linked list according to the processing instruction." "Processing the large-field data" is specifically optimized as follows: based on the row records corresponding to the large-field data in the specified database table, determine the data page linked list formed by the data pages that store the large-field data in pieces ; When the processing instruction is an insertion instruction for inserting new data in the large field data, insert the large field data in the data page linked list; when the processing instruction is to delete the large field In the case of a delete instruction...

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 processing method and device of big-field data. The method comprises the following steps: receiving a processing instruction of processing the big-field data, wherein the big-field data are stored in a specified database list in a fragmentation manner; and determining a data page linked list formed by data pages for storing the big-field data, and processing the big-field data in the data page linked list according to the processing instruction, wherein a big-field control page exists in the data page linked list and comprises fragmentation information formed when the big-field data are stored in the fragmentation manner. By the processing method, data to be processed in the data page linked list can be specifically positioned quickly by a positioning means corresponding to fragmentation type storage. Compared with an existing method, the processing method has the characteristics that the amount of traverse to the data pages during processing is reduced greatly, input and output costs during processing of the big-field data are reduced, and integral processing efficiency of the big-field data 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] Large field is a data type in the database. Data stored in large field type becomes large field data. Generally, data stored in large field type can be divided into two categories: one is long text, and ordinary text type It can only store up to 4000 Chinese characters, and the long text stored based on the large field type can be much larger than 4000 characters; the other 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 existing methods for stori...

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
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com