Mahesh K Subramaniam

US Patent:

7103612, Sep 5, 2006

Filed:

Mar 26, 2003

Appl. No.:

10/400225

Inventors:

Wayne E. Smith - Palo Alto CA, US
Jing Liu - Pacifica CA, US
James Stamos - Saratoga CA, US
Mahesh Subramaniam - Foster City CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/30

US Classification:

707103R, 707100, 707101, 707102, 7071041

Abstract:

A method and system are provided for instantiating objects for participation in information sharing relationships. According to one technique, a copy of an object is made, where the copy includes all changes made prior to a particular point in time, and no changes made after the particular point in time. The copy is used to create a second object. Data that reflects the particular point in time is stored, and subsequently used to determine which changes should be applied to the second object. Data that indicates that the creation time of the second object is stored, and subsequently used to determine which changes should be applied to the original object.

US Patent:

7158994, Jan 2, 2007

Filed:

Dec 5, 2001

Appl. No.:

10/006605

Inventors:

Wayne Smith - Palo Alto CA, US
Mahesh Subramaniam - Foster City CA, US
Subramanian Muralidhar - Foster City CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 7/00
G06F 17/00
G06F 17/30

US Classification:

707103R, 707 2, 707102

Abstract:

Techniques are provided for creating object-oriented materialized views. The object-oriented materialized views may be object materialized views or object-relational materialized views. The base tables may be object tables, object relational tables, or relational tables. The object-oriented materialized views may be refreshed, fully or incrementally. When an object-oriented materialized view is created, refresh code is generated for it. Through the use of object-oriented materialized views, users gain both the efficiency of materialized views and the power of the object-oriented paradigm.

US Patent:

7769714, Aug 3, 2010

Filed:

Nov 6, 2007

Appl. No.:

11/935939

Inventors:

Edwina Lu - Palo Alto CA, US
Mahesh Subramaniam - Foster City CA, US
Lik Wong - Union City CA, US
James Stamos - Saratoga CA, US
Nimar Singh Arora - Union City CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/30

US Classification:

707610

Abstract:

An approach is provided to automatically resolve conflict between instantiation and ongoing data replication operations. In an embodiment, incremental change records that describe one or more database operations are received at a sink entity. Here, all of the one or more database operations have occurred in a second database after a particular time. A first database operation in the one or more database operations to a particular row in the first database is applied. When a conflict with a second database operation that operates on the particular row is detected, one or more compensating actions, which may, but are not limited to, be a different database operation and/or an operation that creates a conflict log entry, may be performed. Here, the second database operation has occurred in the second database prior to the particular time. When the second database operation is to be performed, an appropriate operation may be performed.

US Patent:

20030009431, Jan 9, 2003

Filed:

May 28, 1999

Appl. No.:

09/322153

Inventors:

BENNY SOUDER - BELMONT CA, US
ALAN ROBERT DOWNING - FREMONT CA, US
HARRY SUN - REDWOOD CITY CA, US
ALAN J. DEMERS - BOULDER CREEK CA, US
JAMES WILLIAM STAMOS - SARATOGA CA, US
JOHN C. GRAHAM - PALO ALTO CA, US
CURTIS ELSBERND - BELMONT CA, US
MAHESH SUBRAMANIAM - FOSTER CITY CA, US
WAYNE E. SMITH - PALO ALTO CA, US

International Classification:

G06F007/00

US Classification:

707/001000

Abstract:

Replication for front office automation involves the use of snapshots that are instantiated on laptops, in which refreshing the snapshots is driven from a master site with a high-performance protocol. All of the necessary snapshot metadata for performing the snapshot refreshes is stored at the master site, so that the laptop only needs to send a single refresh request. In response to the refresh request, the master site reconciles the differences between the master tables and the laptop's snapshots and transmits the differences to the laptop, reducing the necessary network traffic for updating a snapshot to a single round trip.