公开(公告)号：US20070198700A1

公开(公告)日：2007-08-23

申请号：US11565255

申请日：2006-11-30

申请人： Stephen Vivian ,  George Claborn ,  Mahest Girkar

发明人： Stephen Vivian ,  George Claborn ,  Mahest Girkar

IPC分类号： G06F15/173

CPC分类号： G06F11/2028 ,  G06F11/20 ,  G06F11/2023 ,  G06F11/2025 ,  G06F11/2074 ,  G06F11/2076 ,  G06F11/2082 ,  G06F11/2097 ,  G06F17/30578

摘要： Techniques used in an automatic failover configuration having a primary database system, a standby database system, and an observer. 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 may use asynchronous transfer modes to transfer redo to the standby and permits automatic failover only when the observer is present and the failover will not result in data loss due to the asynchronous transfer mode beyond a specified maximum. 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.

摘要翻译： 在具有主数据库系统，备用数据库系统和观察者的自动故障转移配置中使用的技术。 在自动故障切换配置中，只要备用和观察器顺序不存在，主数据库系统即使没有备用和观察器也保持可用。 故障转移配置可能会使用异步传输模式将重做传输到备用数据库，并且只有当观察者存在时才允许自动故障转移，并且由于超出指定最大值的异步传输模式，故障转移不会导致数据丢失。 数据库系统和观察者具有故障切换配置状态的副本，并且技术包括用于在数据库和观察者之间传播最新版本的状态的技术以及使用仔细排序的写入的技术，以确保状态改变以一种方式传播 防止发散。

公开(公告)号：US20070124347A1

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

申请号：US11603503

申请日：2006-11-22

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

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

IPC分类号： G06F17/30

CPC分类号： G06F11/2028 ,  G06F11/2025 ,  G06F11/2074 ,  G06F11/2076 ,  G06F11/2082

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

摘要翻译： 在具有主数据库系统，备用数据库系统和观察者的自动故障转移配置中使用的技术，用于防止主数据库系统和备用数据库系统之间的分歧，同时增加主数据库系统的可用性。 在自动故障切换配置中，只要备用和观察器顺序不存在，主数据库系统即使没有备用和观察器也保持可用。 故障转移配置进一步允许自动故障转移只有当观察者存在并且备用和主要同步并且在故障切换期间禁止状态更改。 数据库系统和观察者具有故障切换配置状态的副本，并且技术包括用于在数据库和观察者之间传播最新版本的状态的技术以及使用仔细排序的写入的技术，以确保状态改变以一种方式传播 防止发散。

公开(公告)号：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.

公开(公告)号：US20050097091A1

公开(公告)日：2005-05-05

申请号：US10936468

申请日：2004-09-07

申请人： Mark Ramacher ,  Sreenath Bodagala ,  Benoit Dageville ,  Alex Tsukerman ,  Stephen Vivian ,  Mohamed Ziauddin

发明人： Mark Ramacher ,  Sreenath Bodagala ,  Benoit Dageville ,  Alex Tsukerman ,  Stephen Vivian ,  Mohamed Ziauddin

IPC分类号： G06F7/00 ,  G06F17/00 ,  G06F17/30

CPC分类号： G06F17/30474 ,  G06F17/30306 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99944

摘要： A computer readable medium storing a database query language statement tuning base in a tuning base memory location is disclosed. The tuning base includes tuning information for one or more query language statements. The tuning information for each statement includes one or more tuning actions for the statement, and a signature to allow an optimizer to identify the one or more tuning actions for the statement.

摘要翻译： 公开了一种在调谐基础存储器位置中存储数据库查询语言调整基座的计算机可读介质。 调优基础包括一个或多个查询语言语句的调整信息。 每个语句的调整信息包括语句的一个或多个调整操作，以及允许优化器识别语句的一个或多个调优操作的签名。

公开(公告)号：US20070168704A1

公开(公告)日：2007-07-19

申请号：US11289974

申请日：2005-11-30

申请人： Sean Connolly ,  Gary Allison ,  Jiangbin Luo ,  Nitin Karkhanis ,  Stephen Vivian ,  Michael Harvey

发明人： Sean Connolly ,  Gary Allison ,  Jiangbin Luo ,  Nitin Karkhanis ,  Stephen Vivian ,  Michael Harvey

IPC分类号： G06F11/00

CPC分类号： G06F11/2025

摘要： A graphical user interface based method of configuring automatic failover from a primary database system to a standby database system that is coupled to the primary database system by a network. Also coupled to the network is an observer process that is independent of the database systems and that initiates the failover process. The observer periodically pings the database systems to determine whether a failover is necessary. The graphical user interface permits a user to specify the primary and secondary database systems, configure the observer, and specify conditions under which a failover may occur and to enable automatic failover. A failover context is created from the inputs to the GUI and stored in persistent storage belonging to the database systems. If the Observer's context is stale, the Observer fetches the database system's context.

摘要翻译： 一种基于图形用户界面的方法，配置从主数据库系统到通过网络耦合到主数据库系统的备用数据库系统的自动故障转移。 还耦合到网络是独立于数据库系统并发起故障转移过程的观察者进程。 观察者会定期ping数据库系统，以确定是否需要故障转移。 图形用户界面允许用户指定主数据库和辅助数据库系统，配置观察器，并指定可能发生故障切换的条件，并启用自动故障切换。 从GUI的输入创建故障转移上下文，并存储在属于数据库系统的持久存储器中。 如果观察者的上下文过时，则观察者将获取数据库系统的上下文。