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
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
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...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
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