Method and apparatus for performing a near-instantaneous restore of a database
    1.
    发明授权
    Method and apparatus for performing a near-instantaneous restore of a database 有权
    用于执行数据库的近即时恢复的方法和装置

    公开(公告)号:US08433688B2

    公开(公告)日:2013-04-30

    申请号:US12975035

    申请日:2010-12-21

    IPC分类号: G06F7/00 G06F17/00

    摘要: 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

    摘要翻译: 一些实施例提供了用于执行数据库的近瞬时恢复的方法和装置。 在操作期间,系统拦截数据库管理系统恢复请求以将数据库从备份文件恢复到数据文件,其中备份文件包括第一数量(例如,N1)的数据页。 接下来,响应于拦截数据库管理系统恢复请求,系统向数据库管理系统发送指示备份文件包括数据页的第二数量(例如N2)的信息,其中第二数量的数据页小于 第一个数据页数(例如,N2

    METHOD AND APPARATUS FOR PERFORMING A NEAR-INSTANTANEOUS RESTORE OF A DATABASE
    2.
    发明申请
    METHOD AND APPARATUS FOR PERFORMING A NEAR-INSTANTANEOUS RESTORE OF A DATABASE 有权
    用于执行数据库近似恢复的方法和设备

    公开(公告)号:US20120117033A1

    公开(公告)日:2012-05-10

    申请号:US12975035

    申请日:2010-12-21

    IPC分类号: G06F17/30

    摘要: 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

    摘要翻译: 一些实施例提供了用于执行数据库的近瞬时恢复的方法和装置。 在操作期间,系统拦截数据库管理系统恢复请求以将数据库从备份文件恢复到数据文件,其中备份文件包括第一数量(例如,N1)的数据页。 接下来,响应于拦截数据库管理系统恢复请求,系统向数据库管理系统发送指示备份文件包括数据页的第二数量(例如N2)的信息,其中第二数量的数据页小于 第一个数据页数(例如,N2

    System and method for high speed database backup using rapidly adjusted dynamic compression ratios controlled by a feedback loop
    3.
    发明授权
    System and method for high speed database backup using rapidly adjusted dynamic compression ratios controlled by a feedback loop 有权
    使用由反馈回路控制的快速调整的动态压缩比的高速数据库备份的系统和方法

    公开(公告)号:US08566286B1

    公开(公告)日:2013-10-22

    申请号:US12700799

    申请日:2010-02-05

    IPC分类号: G06F17/30

    摘要: 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.

    摘要翻译: 用于备份数据库的系统和方法,系统已读取线程同时运行,写入线程和数据缓冲区。 每个读取线程重复以下操作,直到所有数据被备份:从数据库读取数据块,使用动态压缩比压缩数据,该压缩比在每次压缩之后被初始化和调整,将数据写入可用数据缓冲区直到 数据缓冲区已满,一旦数据缓冲区已满,写入下一个可用的数据缓冲区,并确定新的压缩比。 控制器使用监视系统组件的定时的方法和/或监视CPU消耗的方法来确定新的压缩比。

    Method and System For Database Transaction Log Compression On SQL Server
    4.
    发明申请
    Method and System For Database Transaction Log Compression On SQL Server 审中-公开
    SQL Server上数据库事务日志压缩的方法和系统

    公开(公告)号:US20130262412A1

    公开(公告)日:2013-10-03

    申请号:US13831175

    申请日:2013-03-14

    IPC分类号: G06F17/30

    CPC分类号: G06F16/1744 G06F16/21

    摘要: 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.

    摘要翻译: 本发明提供了一种用于提供数据库事务日志压缩的方法和系统,其中写入事务日志文件的事务日志数据被独立于数据库数据压缩。 根据本发明,该方法和系统提供用于获取要写入数据库事务日志文件的数据,将要写入数据库事务日志文件的数据压缩并将压缩的事务日志数据写入数据库事务日志文件 。