Partition table backup method and device, electronic equipment and storage medium

A partition table and partition technology, applied in the database field, can solve problems such as backup failure, misoperation, and low efficiency, and achieve the effect of precise backup

Pending Publication Date: 2022-03-11
CHINA CONSTRUCTION BANK
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The database partition table has greatly improved the management and access efficiency of large database tables, but there are also some problems when using partition tables. For example, as the data grows, it is necessary to back up and delete historical data exceeding a certain period. Currently, manual operations are used. There may be misoperations, low efficiency, non-standard backups, and even backup failures

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
  • Partition table backup method and device, electronic equipment and storage medium
  • Partition table backup method and device, electronic equipment and storage medium
  • Partition table backup method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0026] figure 1 It is a schematic flowchart of a method for backing up a partition table provided by Embodiment 1 of the present invention. This embodiment is applicable to situations such as backup and deletion of data tables. For execution, the device may be implemented in software and / or hardware. In a specific embodiment, the apparatus may be integrated into an electronic device, such as a computer, a terminal, and other devices with data processing capabilities and display functions. The following embodiments will be described by taking the device integrated in electronic equipment as an example, as figure 1 As shown, the method specifically includes the following steps:

[0027] S101. Read the partition maintenance configuration table, and determine the first partition table that needs to be automatically maintained according to the partition maintenance configuration table.

[0028] Among them, the partition maintenance configuration table is a data table that stores...

Embodiment 2

[0049] figure 2 It is a schematic flowchart of a method for backing up a partition table provided by Embodiment 2 of the present invention. This embodiment is applicable to situations such as backup and deletion of data tables, and the method can be executed by the backup device for the partition table in the embodiment of the present invention. , the device can be implemented in software and / or hardware, such as figure 2 As shown, the method may specifically include the following steps:

[0050] S201. Read the partition maintenance configuration table, and determine the first partition table that needs to be automatically maintained according to the partition maintenance configuration table.

[0051] In this embodiment, the partition maintenance configuration table is a data table that stores the configuration information of the partition table that needs to be automatically maintained, including user name, table name, range partition period, number of saved partitions, pa...

Embodiment 3

[0116] The partition table backup device provided in Embodiment 3 of the present invention can execute the partition table backup method provided in any of the above embodiments of the present invention, and has corresponding functional modules and beneficial effects for executing the method.

[0117] Figure 4 A schematic structural diagram of a partition table backup device provided in Embodiment 3, such as Figure 4 As shown, the device includes: a first confirmation module 401 , a second confirmation module 402 and a partition replacement module 403 .

[0118] The first confirmation module 401 is configured to read the partition maintenance configuration table, and determine the first partition table that needs to be automatically maintained according to the partition maintenance configuration table.

[0119] The second confirmation module 402 is configured to determine, according to the partition maintenance configuration table, the partitions of the first partition tabl...

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 partition table backup method and device, electronic equipment and a storage medium. Relates to the technical field of databases. The method comprises the steps that a partition maintenance configuration table is read, and a first partition table needing to be automatically maintained is determined according to the partition maintenance configuration table; determining partitions exceeding a preset retention period of the first partition table according to the partition maintenance configuration table, and determining backup tables corresponding to the partitions; and replacing the data of the partitions into the backup table, and deleting the partitions. Through the technical scheme of the invention, the partition table can be backed up simply, efficiently and accurately.

Description

technical field [0001] Embodiments of the present invention relate to the technical field of databases, and in particular, relate to a partition table backup method, device, electronic equipment, and storage medium. Background technique [0002] In order to meet the data management needs of large tables in the database, the large tables are converted into small data and divided into smaller, better-manageable segments. These segments are called partitions, and the corresponding tables are called partition tables. The partitions are physically stored independently of each other, but logically share the relevant attributes of the table. Each partition can be managed independently, and can function independently without relying on other partitions, which has the advantages of easy management and use. [0003] The database partition table has greatly improved the management and access efficiency of large database tables, but there are also some problems when using partition tab...

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): G06F11/14G06F16/22
CPCG06F11/1448G06F16/2282
Inventor 林宜领朱富荣庄佳和何易超涂霖英陈志颖傅莉莉林旺江
Owner CHINA CONSTRUCTION BANK
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