摘要:
Some embodiments provide methods and apparatuses for performing a near-instantaneous restore of a database. During operation, the system intercepts a database management system restore request to restore a database from a backup file to a data file, wherein the backup file comprises a first number (e.g., N1) of data pages. Next, in response to intercepting the database management system restore request, the system sends information to the database management system indicating that the backup file comprises a second number (e.g., N2) of data pages, wherein the second number of data pages is less than the first number of data pages (e.g., N2
摘要:
Some embodiments provide methods and apparatuses for performing a near-instantaneous restore of a database. During operation, the system intercepts a database management system restore request to restore a database from a backup file to a data file, wherein the backup file comprises a first number (e.g., N1) of data pages. Next, in response to intercepting the database management system restore request, the system sends information to the database management system indicating that the backup file comprises a second number (e.g., N2) of data pages, wherein the second number of data pages is less than the first number of data pages (e.g., N2
摘要:
A system and method for backing up a database, where the system has read threads running simultaneously, write threads, and data buffers. Each read thread repeats the following operations until all the data is backed up: read a block of data from the database, compress the data using a dynamic compression ratio which is initialized and adjusted after every compression, write the data to an available data buffer until the data buffer is full, write to the next available data buffer once the data buffer is full, and determine a new compression ratio. A controller determines the new compression ratio using either a method that monitors the timing of system components and/or a method that monitors CPU consumption.
摘要:
The present invention provides a method and system for providing database transaction log compression, where the transaction log data that is written to the transaction log file is compressed independently from the database data. In accordance with the present invention, the method and system provide for obtaining data to be written to the database transaction log file, compressing the data to be written to the database transaction log file and writing the compressed transaction log data to the database transaction log file.