Large-field data release method and device, electronic equipment and storage medium

An electronic device and large-field technology, which is applied in the database field, can solve the problems of large input/output volume of the database, increased concurrent conflicts of large-field columns, and high cost of data release, so as to achieve rapid release, reduce the cost of release, and reduce occupation time Effect

Pending Publication Date: 2022-04-12
SHANGHAI DAMENG DATABASE
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The above method leads to: 1. The input / output volume of the database is large, and the cost of data release is high; 2. The page header information of the first page of the table segment is frequently modified, and the segment header takes too long, resulting in an increase in concurrent conflicts of large field columns in the database

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
  • Large-field data release method and device, electronic equipment and storage medium
  • Large-field data release method and device, electronic equipment and storage medium
  • Large-field data release method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0038] image 3 It is a flow chart of large-field data release provided by Embodiment 1 of the present invention. This embodiment is applicable to the situation of large-field data release. The method can be executed by a large-field data release device, which can use hardware and / or or software, see image 3 , the method provided in the embodiment of the present invention specifically includes the following steps:

[0039] Step 110, collect data page information of the large field data to be released according to the field release information.

[0040] The field release information may be information that triggers the release of memory space occupied by large field data, the field release information may include identification information or address information of large field data, and the field release information may be triggered when large field data is deleted or a transaction is rolled back. The large-field data to be released may be large-field data corresponding to t...

Embodiment 2

[0045] Figure 4 It is another flow chart of large-field data release provided by Embodiment 2 of the present invention. The embodiment of the present invention is based on the embodiment of the above invention. Refer to Figure 4 , the method provided in the embodiment of the present invention specifically includes the following steps:

[0046] Step 210, according to the field release information, obtain the first page of the section of the large-field data to be released and the first page of the data page of the large-field data to be released, and determine the type information of the first page of the data page as the large-field type.

[0047]Among them, the first page of the segment and the first page of the data of the large-field data are locked separately to prevent other operations from modifying the first page of the segment and the first page of the data during this period. The type information can be used to judge whether the data page is a large field type.

...

Embodiment 3

[0064] Figure 6 It is another flowchart of large-field data release provided by Embodiment 3 of the present invention. The embodiment of the present invention is based on the embodiment of the above invention. See Figure 6 , the method provided in the embodiment of the present invention specifically includes the following steps:

[0065] Step 310: Obtain the segment home page of the large field data to be released and the data page home page of the large field data to be released according to the field release information, and determine the type information of the data page home page as the large field type.

[0066] Step 320 , in the case that the control page pointer of the control page is invalid, scan at least one data page occupied by the large-field data to be released in order to obtain data page information.

[0067] Among them, the control page pointer can be a pointer to the control page from the data front page of the large-field data to be released. The control ...

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 large-field data release method and device, electronic equipment and a storage medium, and the method comprises the steps: collecting data page information of to-be-released large-field data according to field release information; and integrally releasing the corresponding data page according to the data page information. According to the embodiment of the invention, the information of each data page corresponding to the large-field data is collected, so that each data page is integrally released, the data release efficiency can be improved, the segment header occupation time can be reduced, and the concurrency conflict of large-field operation in the database processing process can be reduced.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of databases, and in particular to a method, device, electronic equipment and storage medium for releasing large-field data. Background technique [0002] Large fields in databases are commonly used data types, which require huge space in the database. Common large field data types include BLOB, CLOB, TEXT, and IMAGE data types. The data of the large-field data type usually adopts an independent storage method, and the specific data of the large-field data is not stored in the table, but the general information such as its data storage location is stored. Large-field data is generally implemented based on data pages. Large-field data is sequentially written into a series of data pages. These data pages ensure the order of data through the address of the previous page and the address of the next page in the page header information. See figure 1 , the data page can include page heade...

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): G06F16/23G06F9/50
Inventor 刘静王家贤韩朱忠
Owner SHANGHAI DAMENG DATABASE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap