Patent ID: 7769716
Filing Date: 2010-08-03
Classification: G06F

Abstract:
1. A computer-implemented method to backup a data warehouse characterized by a database comprising a plurality of fact tables and at least one dimension table, the database characterized by a database structure, the method being executed by at least one computing device, and the method comprising: for fact tables of the database that are static as characterized by being indicated in the database as read-only, by the at least one computing device executing computer program instructions stored in a computer-readable medium, backing up those fact tables of the database using a first backup method, at a file system level underlying the database structure, without consideration of the database structure; for fact tables of the database that are dynamic, as characterized by being indicated in the database as read/write, by the at least one computing device executing computer program instructions stored in a computer-readable medium, backing up those fact tables using a second backup method, at a database level, with consideration of the database structure; and by the at least one computing device executing computer program instructions stored in a computer-readable medium, backing up the at least one dimension table.