公开(公告)号：US20130282666A1

公开(公告)日：2013-10-24

申请号：US13454799

申请日：2012-04-24

申请人： Steven McGee ,  Jiangbin Luo ,  Benedicto Garin ,  Mahesh Girkar ,  Michael Harvey ,  Nitin Karkhanis ,  Steve Lee ,  Juan Loaiza ,  Robert McGuirk ,  Hongjie Yang

发明人： Steven McGee ,  Jiangbin Luo ,  Benedicto Garin ,  Mahesh Girkar ,  Michael Harvey ,  Nitin Karkhanis ,  Steve Lee ,  Juan Loaiza ,  Robert McGuirk ,  Hongjie Yang

IPC分类号： G06F17/30

CPC分类号： G06F17/30581

摘要： Disclosed are methods and apparatuses to provide a redo repeater that allows for no data loss protection without the performance impact to the primary database even when a significant geographical distance separates the primary and standby databases. The Repeater is a lightweight entity that receives redo from the primary database with the purpose of redistributing that redo throughout the primary/standby system configuration. The Repeater able to extend no data loss protection and switchover functionality to terminal standby databases even though the primary database does not need to have a direct connection with those destinations.

摘要翻译： 公开了提供重做中继器的方法和装置，即使当主要和备用数据库的重要地理距离分离时，也不允许没有对主数据库的性能影响的数据丢失保护。 Repeater是一个轻量级的实体，从主数据库接收重做，目的是在整个主/备系统配置中重新分配重做。 即使主数据库不需要与这些目的地的直接连接，中继器也不会将数据丢失保护和切换功能扩展到终端备用数据库。

公开(公告)号：US20050262170A1

公开(公告)日：2005-11-24

申请号：US10927927

申请日：2004-08-27

申请人： Mahesh Girkar ,  Benedicto Garin ,  Joydip Kundu

发明人： Mahesh Girkar ,  Benedicto Garin ,  Joydip Kundu

IPC分类号： G06F17/30

CPC分类号： G06F17/30575

摘要： A method and apparatus for applying changes to a standby database in real-time is provided. According to one aspect, a change is applied to data contained in a standby database. The standby database functions as a replica of a primary database. The primary database has a current online redo log file to which a particular redo block was written. According to one aspect, prior to the archiving of the current online redo log file, the particular redo block is received at a process associated with the standby database. A change indicated by the particular redo block is applied to the data contained in the standby database.

摘要翻译： 提供了一种用于对实时数据库进行更改的方法和装置。 根据一个方面，对备用数据库中包含的数据应用更改。 备用数据库用作主数据库的副本。 主数据库具有写入特定重做块的当前在线重做日志文件。 根据一个方面，在存档当前在线重做日志文件之前，在与备用数据库相关联的进程处接收到特定重做块。 由特定重做块指示的更改应用于备用数据库中包含的数据。

公开(公告)号：US20130282667A1

公开(公告)日：2013-10-24

申请号：US13454888

申请日：2012-04-24

申请人： Steven MCGEE ,  Mahesh GIRKAR ,  Robert MCGUIRK ,  Jiangbin LUO ,  Steve LEE

发明人： Steven MCGEE ,  Mahesh GIRKAR ,  Robert MCGUIRK ,  Jiangbin LUO ,  Steve LEE

IPC分类号： G06F17/30

CPC分类号： G06F16/275

摘要： Disclosed are methods and apparatuses to provide a redo repeater that allows for no data loss protection without the performance impact to the primary database even when a significant geographical distance separates the primary and standby databases. The Repeater is a lightweight entity that receives redo from the primary database with the purpose of redistributing that redo throughout the primary/standby system configuration. The Repeater able to extend no data loss protection and switchover functionality to terminal standby databases even though the primary database does not need to have a direct connection with those destinations.

摘要翻译： 公开了提供重做中继器的方法和装置，即使当主要和备用数据库的重要地理距离分离时，也不允许没有对主数据库的性能影响的数据丢失保护。 Repeater是一个轻量级的实体，从主数据库接收重做，目的是在整个主/备系统配置中重新分配重做。 即使主数据库不需要与这些目的地的直接连接，中继器也不会将数据丢失保护和切换功能扩展到终端备用数据库。

公开(公告)号：US07464113B1

公开(公告)日：2008-12-09

申请号：US09852008

申请日：2001-05-10

申请人： Mahesh Girkar ,  Richard J. Anderson ,  Steve Lee ,  Joydip Kundu

发明人： Mahesh Girkar ,  Richard J. Anderson ,  Steve Lee ,  Joydip Kundu

IPC分类号： G06F17/30

CPC分类号： G06F11/2074 ,  G06F11/1471 ,  G06F11/1474 ,  G06F17/30575 ,  G06F17/30595

摘要： A data recovery methodology with bound transaction data loss is described in which a database operator is allowed to set a bound that limits the number of transactions that can be lost. Transactions are placed in a buffer to be sent asynchronously to the standby system and synchronized based on the predetermined bound and on the number of transactions currently in the buffer.

摘要翻译： 描述了具有绑定事务数据丢失的数据恢复方法，其中允许数据库运算符设置限制可以丢失的事务的数量的绑定。 事务被放置在缓冲器中以被异步地发送到备用系统并且基于预定边界和当前在缓冲器中的事务数量来同步。

公开(公告)号：US20070124348A1

公开(公告)日：2007-05-31

申请号：US11603504

申请日：2006-11-22

申请人： George Claborn ,  Stephen Vivian ,  Robert McGuirk ,  Mahesh Girkar ,  Benedito Garin ,  Raymond Guzman ,  Douglas Voss

发明人： George Claborn ,  Stephen Vivian ,  Robert McGuirk ,  Mahesh Girkar ,  Benedito Garin ,  Raymond Guzman ,  Douglas Voss

IPC分类号： G06F17/30

CPC分类号： G06F11/2028 ,  G06F11/2025 ,  G06F11/2074 ,  G06F11/2076 ,  G06F11/2082 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99945 ,  Y10S707/99953

摘要： Techniques used in an automatic failover configuration having a primary database system, a standby database system, and an observer for preventing divergence among the primary and standby database systems while increasing the availability of the primary database system. In the automatic failover configuration, the primary database system remains available even in the absence of both the standby and the observer as long as the standby and the observer become absent sequentially. The failover configuration further permits automatic failover only when the observer is present and the standby and the primary are synchronized and inhibits state changes during failover. The database systems and the observer have copies of failover configuration state and the techniques include techniques for propagating the most recent version of the state among the databases and the observer and techniques for using carefully-ordered writes to ensure that state changes are propagated in a fashion which prevents divergence.

公开(公告)号：US06378043B1

公开(公告)日：2002-04-23

申请号：US09224381

申请日：1998-12-31

申请人： Mahesh Girkar ,  Prabuddha Biswas ,  Ashok Joshi

发明人： Mahesh Girkar ,  Prabuddha Biswas ,  Ashok Joshi

IPC分类号： G06F1212

CPC分类号： G06F12/121

摘要： A method and apparatus for buffering is provided. A set of buffers is maintained in an ordered list based on a profit value generated for each buffer. The profit value for a buffer reflects multiple access characteristics of the buffer. The list of buffers is partitioned into divisions referred to as buckets. Each bucket contains a set of buffers and is associated with a subrange of the fall range of profit values that may be generated. The bucket that covers the very top of the list is associated with highest profit value subrange, the bucket that covers the bottom of the list is associated with the lowest profit value subrange. When data is first placed in a buffer, the buffer's position within the buffer list is not immediately based on its profit value. Instead, an access history is first accumulated for the buffer and, once accumulated, the buffer's profit value earns the buffer's place in the list. Specifically, after new data is added to a buffer, it is placed at the insertion point for the list. When the buffer is next accessed, it is placed at the top of list. As other buffers are added to the top of the list above the buffer, the buffer is pushed down the list. As the buffer is pushed down, its access history is updated, but its order within the list is left unchanged. When the buffer reaches a certain position within the list, the buffer's profit value dictates the buffer's place in the list.

摘要翻译： 提供一种用于缓冲的方法和装置。 基于为每个缓冲器生成的利润值，在一个有序列表中维护一组缓冲区。 缓冲区的利润值反映了缓冲区的多个访问特性。 缓冲区列表被划分为称为桶的分区。 每个桶包含一组缓冲区，并且与可能生成的利润值的下降范围的子范围相关联。 覆盖列表顶部的桶与最高利润值子范围相关联，覆盖列表底部的桶与最低利润值子范围相关联。 当数据首先放在缓冲区中时，缓冲区在缓冲区列表中的位置不会立即根据其利润值。 相反，首先为缓冲区累积访问历史，并且一旦累积了缓冲区的利润值就可以获得缓冲区在列表中的位置。 具体来说，在将新数据添加到缓冲区之后，它被放置在列表的插入点处。 当下一次访问缓冲区时，它被放置在列表的顶部。 由于其他缓冲区被添加到缓冲区上方列表的顶部，缓冲区被按下列表。 当缓冲区被按下时，其访问历史记录被更新，但其列表中的顺序保持不变。 当缓冲区达到列表中的某个位置时，缓冲区的利润值决定了缓冲区在列表中的位置。

公开(公告)号：US20070083574A1

公开(公告)日：2007-04-12

申请号：US11261221

申请日：2005-10-28

申请人： Benedicto Garin ,  Robert McGuirk ,  Mahesh Girkar

发明人： Benedicto Garin ,  Robert McGuirk ,  Mahesh Girkar

IPC分类号： G06F17/30

CPC分类号： G06F16/275

摘要： Systems, methods, and other embodiments associated with remote database maintenance using parallel file transfers are described. One exemplary system includes a processor configured to run a database management system (DBMS) that is in turn configured to manage a database (DB). The DBMS may maintain a database log file that stores information about changes to the database. The system may also include a connection logic for establishing data transfer connections between the computing system and a remote computing system storing the database replica. The system may also include a partition logic that separates the database log file into multiple portions and a distribution logic that provides the multiple file portions in parallel to the remote computing system through the multiple data transfer connections.

摘要翻译： 描述了使用并行文件传输与远程数据库维护相关联的系统，方法和其他实施例。 一个示例性系统包括被配置为运行数据库管理系统（DBMS）的处理器，DBMS又被配置为管理数据库（DB）。 DBMS可以维护数据库日志文件，该文件存储有关数据库更改的信息。 系统还可以包括用于在计算系统和存储数据库副本的远程计算系统之间建立数据传输连接的连接逻辑。 该系统还可以包括将数据库日志文件分成多个部分的分区逻辑，以及通过多个数据传输连接向远程计算系统并行提供多个文件部分的分发逻辑。

公开(公告)号：US06598059B1

公开(公告)日：2003-07-22

申请号：US09557590

申请日：2000-04-22

申请人： Ramesh Vasudevan ,  Gopalan Arun ,  Mahesh Girkar

发明人： Ramesh Vasudevan ,  Gopalan Arun ,  Mahesh Girkar

IPC分类号： G06F1200

CPC分类号： G06F17/30309 ,  Y10S707/99954

摘要： A version control system is described for use in connection with a database management system to facilitate versioning of a database table, the system including a database table and a version control module. The database table comprises a plurality of records, each record including at least one data field for storing user data and at least some of the records including a version control field including version control information. The version control module is configured to, in response to a user query related to the database table and related to a version, generate an augmented query for processing by the data base management system, the augmented query relating to the user query and the version control information. The version control module facilitates association of versions of the database with respective ones of a hierarchy of states and allows conflicts therebetween to be resolved, data to be posted from child states to respective parent states in the hierarchy, and referential constraints between tables to be preserved.

摘要翻译： 描述了与数据库管理系统结合使用的版本控制系统，以促进数据库表的版本化，该系统包括数据库表和版本控制模块。 数据库表包括多个记录，每个记录包括用于存储用户数据的至少一个数据字段，并且至少一些记录包括包括版本控制信息的版本控制字段。 版本控制模块被配置为响应于与数据库表相关并且与版本相关的用户查询，生成用于由数据库管理系统处理的增强查询，与用户查询相关的增强查询和版本控制 信息。 版本控制模块便于将数据库的版本与状态层次结构中的各个相关联，并允许其间解决冲突，从子状态发布的数据到层次结构中的相应的父状态以及要保留的表之间的引用约束 。

公开(公告)号：US10102266B2

公开(公告)日：2018-10-16

申请号：US13454799

申请日：2012-04-24

申请人： Steven McGee ,  Jiangbin Luo ,  Benedicto Garin ,  Mahesh Girkar ,  Michael Harvey ,  Nitin Karkhanis ,  Steve Lee ,  Juan Loaiza ,  Robert McGuirk ,  Hongjie Yang

发明人： Steven McGee ,  Jiangbin Luo ,  Benedicto Garin ,  Mahesh Girkar ,  Michael Harvey ,  Nitin Karkhanis ,  Steve Lee ,  Juan Loaiza ,  Robert McGuirk ,  Hongjie Yang

IPC分类号： G06F17/30

摘要： Disclosed are methods and apparatuses to provide a redo repeater that allows for no data loss protection without the performance impact to the primary database even when a significant geographical distance separates the primary and standby databases. The Repeater is a lightweight entity that receives redo from the primary database with the purpose of redistributing that redo throughout the primary/standby system configuration. The Repeater able to extend no data loss protection and switchover functionality to terminal standby databases even though the primary database does not need to have a direct connection with those destinations.

公开(公告)号：US07996363B2

公开(公告)日：2011-08-09

申请号：US10927927

申请日：2004-08-27

申请人： Mahesh Girkar ,  Benedicto Garin ,  Joydip Kundu

发明人： Mahesh Girkar ,  Benedicto Garin ,  Joydip Kundu

IPC分类号： G06F17/00

CPC分类号： G06F17/30575

摘要： A method and apparatus for applying changes to a standby database in real-time. According to one aspect, a change is applied to data contained in a standby database. The standby database functions as a replica of a primary database. The primary database has a current online redo log file to which a particular redo block was written. According to one aspect, prior to the archiving of the current online redo log file, the particular redo block is received at a process associated with the standby database. A change indicated by the particular redo block is applied to the data contained in the standby database.

摘要翻译： 一种用于对备用数据库进行实时更改的方法和装置。 根据一个方面，对备用数据库中包含的数据应用更改。 备用数据库用作主数据库的副本。 主数据库具有写入特定重做块的当前在线重做日志文件。 根据一个方面，在存档当前在线重做日志文件之前，在与备用数据库相关联的进程处接收到特定重做块。 由特定重做块指示的更改应用于备用数据库中包含的数据。