Abstract: A method is for use with a primary online transactional processing (OLTP) database, to maintain a secondary storage usable by a backup OLTP database, wherein the primary storage, of the primary OLTP database, includes data files. In accordance with the method, as transaction indications for the primary OLTP database are recorded in at least one transaction log file, in the primary storage of the primary OLTP database, the transaction indications are caused to be mirrored to the secondary storage. At the file system level of the storage of the primary OLTP database and of the secondary storage, a state of data files of the primary OLTP database is occasionally caused to be duplicated from the primary storage to the secondary storage.

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.

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.

Abstract: A method is for use with a primary online transactional processing (OLTP) database, to maintain a secondary storage usable by a backup OLTP database, wherein the primary storage, of the primary OLTP database, includes data files. In accordance with the method, as transaction indications for the primary OLTP database are recorded in at least one transaction log file, in the primary storage of the primary OLTP database, the transaction indications are caused to be mirrored to the secondary storage. At the file system level of the storage of the primary OLTP database and of the secondary storage, a state of data files of the primary OLTP database is occasionally caused to be duplicated from the primary storage to the secondary storage.