Method for rapidly archiving data and reducing storage space by virtue of partition exchange

A storage space and data technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of database performance pressure, time-consuming, low efficiency, etc., to achieve fast data recovery, fast data archiving process, The effect of fast backup speed

Inactive Publication Date: 2015-06-03
INSPUR TIANYUAN COMM INFORMATION SYST CO LTD
View PDF5 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] 2) Due to the huge storage space occupied by massive data tables, frequent data archiving is required to release storage space in time and reduce the storage pressure of the database. However, when data archiving of large data volume data tables is performed in a conventional way, there are problems of low efficiency and time-consuming Problems, for example, when the Oracle database uses the export command to archive a TB-level data table (stored in table partition mode), it takes about 2 hours to complete, and at the same time, it puts a lot of pressure on the performance of the database itself during data archiving
[0006] Therefore, there is an urgent need for a new data archiving mechanism to solve the problem of low efficiency and time-consuming conventional data archiving methods for large-scale data tables, and cannot effectively reduce storage space.

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
  • Method for rapidly archiving data and reducing storage space by virtue of partition exchange
  • Method for rapidly archiving data and reducing storage space by virtue of partition exchange
  • Method for rapidly archiving data and reducing storage space by virtue of partition exchange

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0038] In order to solve its technical problems in this embodiment, the adopted technical solutions are as follows: figure 1 , figure 2 and image 3 As shown, the business tables are all partitioned tables. If you want to back up the data under a certain partition of the business table, you need to create a swap table in the swap table space that is exactly the same as the , Set the read only mode in the table space where the table partition is located, and then exchange the table partition, so that the storage pointer of the table partition and the storage pointer of the exchange table are exchanged, so as to achieve the purpose of data exchange, so that the data of the table partition is converted to the exchange table down from image 3 It can be seen from the figure that the final result of this partition exchange is that the storage table space of the table partition and the storage table space of the exchange table are exchanged, and the table space storing the data o...

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 data storage, in particular to a method for rapidly archiving data and reducing a storage space by virtue of partition exchange. According to the method, a conventional data archiving manner for the data partition storage of a large-volume data table has the characteristics of low efficiency, high time consumption and the like, and by a rapid data archiving scheme making full use of a database table partition exchange technology and a table space transmission technology, problems about the rapid archiving of the large-volume data table and effective reduction in the storage space are perfectly solved.

Description

technical field [0001] The invention relates to the technical field of data storage, in particular to a method for realizing fast data archiving and reducing storage space by using partition replacement. Background technique [0002] With the rapid development of the information industry today, information data has penetrated into every industry and business function field today and has become an important factor of production. With the advent of the era of big data, there are generally data tables with massive data in the databases of production information systems in various industries. [0003] These data tables with a large amount of data have the following characteristics: [0004] 1) Use table partitioning to store massive business data. The partitioning conditions are usually date-based. Using table partitioning can not only significantly improve data manageability, query performance and availability, but also facilitate regular business data processing. Archiving; ...

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): G06F17/30
Inventor 卢向辉李建明
Owner INSPUR TIANYUAN COMM INFORMATION SYST 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