Archie W Brown

US Patent:

7236993, Jun 26, 2007

Filed:

Apr 16, 2003

Appl. No.:

10/414027

Inventors:

Archie W. Brown - Milford NH, US
Goutam D. Kulkarni - Nashua NH, US
Joydip Kundu - Derry NH, US
Douglas Voss - Nashua NH, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 12/00
G06F 17/30
G06F 17/00

US Classification:

707203

Abstract:

A method, system, and computer program product provides a data dictionary that can represent multiple versions of the schema objects, and which provides improved performance, reduced computing costs, and more accurate results in a variety of applications, such as in a database redo log mining system. A method of providing a data dictionary comprises the steps of determining whether information about the data object is present in a denormalized data dictionary history table, and if the information about the data object is not present in the denormalized data dictionary history table, then querying a normalized data dictionary to obtain the information about the data object, including a version identifier of the data object, and storing the version identifier and the obtained information about the data object including the version identifier in the denormalized data dictionary history table.

US Patent:

20080162590, Jul 3, 2008

Filed:

Jan 3, 2007

Appl. No.:

11/649180

Inventors:

Joydip Kundu - Derry NH, US
Archie W. Brown - Milford NH, US
Douglas A. Voss - Nashua NH, US
Qinqin Wang - Nashua NH, US

Assignee:

ORACLE INTERNATIONAL CORPORATION - REDWOOD SHORES CA

International Classification:

G06F 17/30

US Classification:

707202, 707E17001

Abstract:

A database rollback processor allows rollback, or rewind, of the data and metadata to a point at which a failover or other metadata change occurred, therefore “rewinding” the metadata to a previous consistent point. The rollback processor identifies transaction entries in a redo log resulting in changes to the metadata. The changes are identified backward to a target recovery time. Transactions affecting the metadata are stored in a stack. The transactions are then backed out of the metadata according to the stack to restore the metadata to the state at the target recovery time. Data changes from the redo log may then be applied to the corresponding metadata as it existed at the target recovery time. Since the target recovery time is not bound by the timing of the snapshots, but rather may be at an arbitrary point chosen as the target recovery time, a failover, replication or recovery operation need not rely on the snapshot time.

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.