Kenneth C Jacobs

US Patent:

7941408, May 10, 2011

Filed:

Sep 3, 2004

Appl. No.:

10/934079

Inventors:

Bipul Sinha - Foster City CA, US
Vivekanandhan Raja - Foster City CA, US
Amit Ganesh - San Jose CA, US
Kenneth R. Jacobs - San Mateo CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 7/00
G06F 17/00

US Classification:

707685

Abstract:

Disclosed is a mechanism, system, interface, and process to allow specification of a new table decoration clause to obtain one or more past version of one or more data items. The version query provides for a direct interface to get multiple versions of the row(s). In addition, information about the past versions can be retrieved and displayed along with the past versions. Also disclosed are algorithms, mechanisms, and processes that are employed to implement a query upon past versions. In one approach, the version query can be defined as either “rowid”-based access or non-rowid based access. With rowid based access, a given rowid is used to identify the data for which past versions are desired. Also disclosed is a process for determining one or more life intervals when given a key.

US Patent:

58707581, Feb 9, 1999

Filed:

Mar 11, 1996

Appl. No.:

8/613026

Inventors:

Roger J. Bamford - Woodside CA
Kenneth R. Jacobs - San Mateo CA

Assignee:

Oracle Corporation - Redwood Shores CA

International Classification:

G06F 1740

US Classification:

707201

Abstract:

A method and system for providing isolation levels in a database system is provided. A serializable isolation level is provided by causing all statements in a transaction to see a "snapshot" of the database. A snapshot includes only those changes made to the database by a particular set of transactions. For example, the snapshot for a given transaction may include only the changes made by transactions that committed prior to the execution of the given transaction. The set of all transactions whose changes are included in a particular snapshot of the database is referred to as the snapshot set. Concurrently executing transactions may update the database while a serializable transaction is being executed. Updates that are not included in the snapshot of the serializable transaction are undone prior to processing each statement in the serializable transaction to recreate the data as it existed in the snapshot. If a serializable transaction attempts to update data that was updated by a transaction that is not in the snapshot set of the serializable transaction, then the serializable transaction is rolled back.

US Patent:

60472855, Apr 4, 2000

Filed:

Apr 6, 1998

Appl. No.:

9/056392

Inventors:

Kenneth R. Jacobs - San Mateo CA
Robert J. Jenkins - Foster City CA

Assignee:

Oracle Corporation - Redwood Shores CA

International Classification:

G06F 1730

US Classification:

707 4

Abstract:

The present invention provides a uniqueness-required index and a corresponding non-uniqueness count to support deferred uniqueness constraint enforcement. A uniqueness-required index stores duplicate occurrences of indexed data values that occur during statement or transaction processing. The non-uniqueness count associated with the uniqueness-required index provides a count of the number of indexed data values that occur more than once in the index. Where a non-uniqueness count is not equal to zero, a uniqueness constraint violation remains unresolved. Where an unresolved constraint violation exists at enforcement time, the effects of the processing are removed. A currently non-unique count can be used to represent the number of uniqueness-required indexes that are "currently non-unique". The currently non-unique count can be examined to determine whether there are any unresolved uniqueness constraint violations. Constraints can be enforced at the end of the processing of a statement, a transaction, or within a transaction at a savepoint.

US Patent:

61050253, Aug 15, 2000

Filed:

Mar 8, 1996

Appl. No.:

8/612562

Inventors:

Kenneth R. Jacobs - San Mateo CA
Robert J. Jenkins - Foster City CA

Assignee:

Oracle Corporation - Redwood Shores CA

International Classification:

G06F 1730

US Classification:

707 8

Abstract:

The present invention provides a uniqueness-required index and a corresponding non-uniqueness count to support deferred uniqueness constraint enforcement. A uniqueness-required index stores duplicate occurrences of indexed data values that occur during statement or transaction processing. The non-uniqueness count associated with the uniqueness-required index provides a count of the number of indexed data values that occur more than once in the index. Where a non-uniqueness count is not equal to zero, a uniqueness constraint violation remains unresolved. Where an unresolved constraint violation exists at enforcement time, the effects of the processing are removed. A currently non-unique count can be used to represent the number of uniqueness-required indexes that are "currently non-unique". The currently non-unique count can be examined to determine whether there are any unresolved uniqueness constraint violations. Constraints can be enforced at the end of the processing of a statement, a transaction, or within a transaction at a savepoint.