Database physical backup recovery processing method and system

The invention relates to the related field of data management, and discloses a database physical backup recovery processing method and system.The data in a database is subjected to popularity division based on popularity monitoring of the data, meanwhile, the database is divided into a plurality of...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: GONG YANFU, AN SHIHENG, SHAO CHANGZHENG
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The invention relates to the related field of data management, and discloses a database physical backup recovery processing method and system.The data in a database is subjected to popularity division based on popularity monitoring of the data, meanwhile, the database is divided into a plurality of sub-databases, and the sub-databases are used for storing data content with different popularity; and the sub-database for storing the static data is used as a basic storage interval and is used for realizing backup and recovery work of the data between the basic storage interval and other heat sub-databases when the heat of the data is changed. The problem that service life loss of the storage device is not coordinated due to cache of high and low hotspot data can be effectively solved, and the utilization rate of the storage device is optimized. 本发明涉及数据管理相关领域,公开了一种数据库物理备份恢复处理方法和系统,基于对数据的热度监控将数据库中的数据进行热度划分,同时将数据库分割为多个子数据库,并分别用于存储不同热度的数据内容,并将存储静态数据的子数据库作为基础存储区间,用于实现数据热度变化时,数据在基础存储区间及其他热度子数据库间的备份与恢复工作,相较于现有技术中的数据库执行