Invention Grant
US07769716B2 Divided backup of data warehouse 有权
数据仓库的分割备份

Divided backup of data warehouse
Abstract:
A data warehouse characterized by a plurality of fact tables and at least one dimension table is backed up. For fact tables that are static, those fact tables are backed up using a first backup method that is, for example, optimized for static data. For example, the first backup method may be at the file system level, below the database level, and can be a very time and computationally efficient way to synchronize blocks of data. Thus, for example, the first method may be a method that is not “database-aware” and does not consider the database structure in its backup processing. For fact tables that are dynamic, those fact tables are backed up using a second backup method. For example, the second backup method may account for the dynamic nature of data in the portion being backed up by being, for example, “database aware.” In addition, the at least one dimension table is backed up. By treating the fact tables in this way for backup, the process of backing up a data warehouse can be made more efficient overall.
Public/Granted literature
Information query
Patent Agency Ranking
0/0