Invention Grant
- Patent Title: Divided backup of data warehouse
- Patent Title (中): 数据仓库的分割备份
-
Application No.: US11691922Application Date: 2007-03-27
-
Publication No.: US07769716B2Publication Date: 2010-08-03
- Inventor: Trifon M. Anguelov
- Applicant: Trifon M. Anguelov
- Applicant Address: US CA Sunnyvale
- Assignee: Yahoo! Inc.
- Current Assignee: Yahoo! Inc.
- Current Assignee Address: US CA Sunnyvale
- Agency: Weaver Austin Villeneuve & Sampson LLP
- Main IPC: G06F7/00
- IPC: G06F7/00

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
- US20080243949A1 DIVIDED BACKUP OF DATA WAREHOUSE Public/Granted day:2008-10-02
Information query