Raymond Guzman

US Patent:

7082435, Jul 25, 2006

Filed:

Jan 3, 2000

Appl. No.:

09/476141

Inventors:

Raymond Guzman - Amherst NH, US
Goutam D. Kulkarni - Nashua NH, US
Joydip Kundu - Nashua NH, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/30

US Classification:

707102, 707 9, 707 10, 707103 R, 706 16, 709 9, 709226

Abstract:

The present invention is directed to a method and mechanism for encoding multiple virtual tables into one or more source tables. An aspect of the invention is directed to the access of a virtual table virtual table without requiring separate entries for the virtual table in the meta-data of a database system. Another aspect of the invention is directed to a virtual table that has different column signatures than its underlying source table(s).

US Patent:

7222136, May 22, 2007

Filed:

May 23, 2002

Appl. No.:

10/153034

Inventors:

Archie W. Brown - Milford NH, US
Raymond Guzman - Amherst NH, US
Richard L. Frank - Groton MA, US
Goutam D. Kulkarni - Nashua NH, US
Joydip Kundu - Nashua NH, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/30

US Classification:

707202, 707204

Abstract:

A system, method, and computer program product communicate data dictionary information of database objects through a redo stream in the form of metadata, which provides the association between the internal numbers used by a database schema to identify database objects and the corresponding user-defined names of the database objects, in the redo stream itself, so that the association information may be easily and quickly used in the analysis of the redo stream of the database transactions. A method of communicating data dictionary information of database objects through a redo stream comprises the steps of performing a change to a first database data table, logging redo information representing the change to the first database data table to a redo stream, and logging information relating to internal identifier mapping information associated with the first database data table to the redo stream.

US Patent:

7627584, Dec 1, 2009

Filed:

Nov 22, 2006

Appl. No.:

11/603504

Inventors:

George H. Claborn - Amherst NH, US
Stephen John Vivian - Londonderry NH, US
Robert R. McGuirk - Nashua NH, US
Mahesh Baburao Girkar - Cupertino CA, US
Raymond Guzman - Amherst NH, US
Douglas Voss - Nashua NH, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 7/00

US Classification:

707100, 707 10, 707101, 707102, 7071041, 707204, 714 4, 714712, 714718

Abstract:

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.

US Patent:

7668879, Feb 23, 2010

Filed:

Nov 22, 2006

Appl. No.:

11/603503

Inventors:

Stephen John Vivian - Londonderry NH, US
Robert R. McGulrk - Nashua NH, US
George H. Claborn - Amherst NH, US
Mahesh Baburao Girkar - Cupertino CA, US
Raymond Guzman - Amherst NH, US
Douglas Voss - Nashua NH, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 12/00

US Classification:

707204, 707 8, 707 10, 707202, 707205, 714 4, 714770, 709204

Abstract:

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.

US Patent:

7734596, Jun 8, 2010

Filed:

Nov 24, 2006

Appl. No.:

11/604064

Inventors:

Stephen John Vivian - Londonderry NH, US
Raymond Guzman - Amherst NH, US
Douglas Andrew Voss - Nashua NH, US

International Classification:

G06F 17/00

US Classification:

707674, 714 1, 714E11007, 714 2, 714 6, 707609, 707636

Abstract:

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.

US Patent:

8255369, Aug 28, 2012

Filed:

Nov 24, 2006

Appl. No.:

11/604063

Inventors:

Jiangbin Luo - Nashua NH, US
George H. Claborn - Amherst NH, US
Stephen John Vivian - Londonderry NH, US
Steve Tiahung Lee - Hollis NH, US
Raymond Guzman - Amherst NH, US
Douglas Andrew Voss - Nashua NH, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/00

US Classification:

707674, 707609

Abstract:

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.

US Patent:

8630985, Jan 14, 2014

Filed:

Aug 22, 2012

Appl. No.:

13/592152

Inventors:

Jiangbin Luo - Nashua NH, US
George H. Claborn - Amherst NH, US
Stephen John Vivian - Londonderry NH, US
Steve Taihung Lee - Hollis NH, US
Raymond Guzman - Amherst NH, US
Douglas Andrew Voss - Nashua NH, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/00

US Classification:

707674, 707609

Abstract:

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.

US Patent:

20030220935, Nov 27, 2003

Filed:

Apr 17, 2003

Appl. No.:

10/417724

Inventors:

Stephen Vivian - Londonderry NH, US
Raymond Guzman - Amherst NH, US

International Classification:

G06F017/00

US Classification:

707/102000

Abstract:

A method of logical database snapshot for log-based replication in described that need not incur a quiescence of an operational database. Baselines for the overall snapshot operation and for each table replication are recorded in such a way that subsequent log-based replication can distinguish which redo records to apply and which to discard. The baselines may be recorded as system change numbers negotiated according to a distributed protocol for synchronizing a sequence number, and records from the redo log are applied on the logical standby system based on the recorded system change numbers.