Line migration elimination method and device, computer equipment and storage medium

A computer program and post-migration technology, applied in the field of cloud data, can solve problems such as inability to delete data rows, affecting database performance, not considering foreign key constraints, etc., to improve data processing performance, reduce I/O operations, and eliminate row migration. Effect

Pending Publication Date: 2022-04-01
PING AN SECURITIES CO LTD
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this processing method does not consider the foreign key constraints, which will result in the inability to delete the data rows with foreign key constraints and row migration, which will affect the performance of 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
  • Line migration elimination method and device, computer equipment and storage medium
  • Line migration elimination method and device, computer equipment and storage medium
  • Line migration elimination method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0054] In order to make the purpose, technical solution and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, and are not intended to limit the present application.

[0055] The row migration elimination method provided by the embodiment of this application can be applied to such as figure 1shown in the application environment. Wherein, the terminal 102 communicates with the server 104 through the network. The terminal 102 can be used to configure the trigger condition of the row migration elimination event. When the server detects that the trigger condition is met, the row migration elimination event is triggered to perform the row migration elimination. The server 104 performs row migration elimination processing, which specifically ...

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 relates to the technical field of cloud data, and provides a line migration elimination method and device, computer equipment, a storage medium and a computer program product. The method comprises the steps of detecting a recording line with line migration, determining a line identifier corresponding to the recording line, searching a current data block where the recording line is located after line migration and an original data block where the recording line is located before line migration based on the line identifier, and performing line migration on the current data block and the original data block. And determining a residual free space of the original data block and a storage space occupied by the record line, when the residual free space is not smaller than the storage space, migrating the record line in the current data block into the original data block, and deleting a pointer pointing to the current data block in the original data block, the additional I/O operation of the database is reduced, and the data processing performance of the database is improved on the whole.

Description

technical field [0001] The present application relates to the technical field of cloud data, in particular to a row migration elimination method, device, computer equipment, storage medium and computer program product. Background technique [0002] When modifying non-row-linked rows in oracle (relational database management system), the length of the modified row is greater than the length of the row before modification, and when the data block cannot accommodate the modified row, the data of the entire row will be migrated to another Data block, and keep a pointer to the new location of the row in the original data block, this case is row migration. When querying row-migrated data, the performance of the database will be degraded, and additional I / O operations will be generated. [0003] The traditional solution is to store the data with row migration in the temporary table, delete the data with row migration in the original table, take out the data from the temporary tabl...

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/21G06F16/23G06F16/28
Inventor 金鑫
Owner PING AN SECURITIES CO LTD
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