Stephen C Shepherd

US Patent:

7587435, Sep 8, 2009

Filed:

Nov 10, 2006

Appl. No.:

11/309940

Inventors:

Stephen C. Shepherd - Lakewood CO, US

Assignee:

Sybase, Inc. - Dublin CA

International Classification:

G06F 12/00
G06F 17/30

US Classification:

707204, 707203

Abstract:

Replication system with methodology for replicating database sequences is described. In one embodiment, for example, in a database system, a method of the present invention is described for replicating a sequence object from a primary database to a replicate database, the method comprises steps of: monitoring changes to table data at the primary database for capturing information sufficiently characterizing the sequence object to allow its replication, the table data being logged to a log file; reading the log file, for determining changes to apply to the replicate database for replicating the sequence object; and reconstructing the sequence object at the replicate database based on the determined changes.

US Patent:

8412674, Apr 2, 2013

Filed:

Aug 2, 2011

Appl. No.:

13/196308

Inventors:

Jianbing Zhu - Shanghai, CN
Stephen C. Shepherd - Lakewood CO, US

Assignee:

Sybase, Inc. - Dublin CA

International Classification:

G06F 17/30

US Classification:

707610, 707615, 707638, 707640, 707648

Abstract:

System, method, computer program product embodiments and combinations and sub-combinations thereof for replication resynchronization are provided. An embodiment includes providing a mode of operation in a replication control system for repopulating a replicated version of a primary database that does not affect an ability to continue activity in the primary database. Further included is managing the repopulating of the replicated version with attention to at least a resynchronization marker.

US Patent:

8417669, Apr 9, 2013

Filed:

Jun 1, 2011

Appl. No.:

13/150955

Inventors:

Chengzi Xu - Shanghai, CN
Stephen C. Shepherd - Lakewood CO, US

Assignee:

Sybase Inc. - Dublin CA

International Classification:

G06F 17/00

US Classification:

707638

Abstract:

Systems, methods and computer program product embodiments for auto-correction in database replication are disclosed herein. An embodiment includes receiving a log record of one or more database row changes on a table marked for replication. From the received log record, one or more insert operations on the marked table are identified. Each identified insert operation is automatically replaced with a first pair of operations, where each first pair comprises a delete operation associated with a new insert operation. Each first pair, when executed at a replicate database, acts to delete data at a first location identified by each identified insert operation prior to inserting data of the new insert operation at the first location. The embodiment further includes identifying, from the log record, one or more update operations on the marked table, and automatically replacing each identified update operation with a second pair of operations, where each second pair comprises a new delete operation associated with a new insert operation.

US Patent:

20120158650, Jun 21, 2012

Filed:

Apr 21, 2011

Appl. No.:

13/091303

Inventors:

Mihnea Andre - Issy les Moulineaux, FR
Yanhong Wang - San Ramon CA, US
Rajkumar Sen - Pune, IN
Heping Shang - Walnut Creek CA, US
Stephen Shepherd - Lakewood CO, US
Jian Yang - San Ramon CA, US
Peter John Dorfman - Belmont MA, US
Johan Nicolaas Schukkink - Utrecht, NL
Xiao-Yun Wang - Vaucresson, FR
Teja Mupparti - San Ramon CA, US
Andrew D. Scott - San Ramon CA, US

Assignee:

Sybase, Inc. - Dublin CA

International Classification:

G06F 17/30

US Classification:

707611, 707802, 707687, 707613, 707E17005

Abstract:

System, method, computer program product embodiments and combinations and sub-combinations thereof for a distributed data cache database architecture are provided. An embodiment includes providing a scalable distribution of in-memory database (IMDB) system nodes organized as one or more data fabrics. Further included is providing a plurality of data granularity types for storing data within the one or more data fabrics. Database executions are managed via the one or more data fabrics for a plurality of applications compatible with at least one data granularity type.

US Patent:

20120158805, Jun 21, 2012

Filed:

Dec 16, 2010

Appl. No.:

12/970219

Inventors:

Mihnea ANDRE - Issy les Moulineaux, FR
Xun Cheng - Dublin CA, US
Yanhong Wang - San Ramon CA, US
Elton Philip Wildermuth - Oakland CA, US
Heping Shang - Walnut Creek CA, US
Stephen C. Shepherd - Lakewood CO, US

Assignee:

Sybase, Inc. - Dublin CA

International Classification:

G06F 17/30

US Classification:

707827, 707E1701

Abstract:

Systems and methods for non-disruptive cache startup, shutdown, data partition movement, and node rebalancing for a data fabric within a data grid in a database environment. The data grid is a clustered in-memory database (IMDB) cache comprising one or more data fabrics including multiple IMDB cache nodes. The method takes a time tag and moves data from source to destination nodes while allowing updates to data on the source nodes. The method propagates updates occurring after the time tag to destination nodes from source nodes and switches applications and ownership to the destination nodes. Another method slices data for a partitioned fabric and stores slices on nodes. Another method starts a data fabric by moving data from a grid backend to the nodes. In an embodiment, another method rebalances nodes in a non-disruptive manner. When a fabric is shutdown, the method saves data from the nodes to the grid backend.

US Patent:

20120317073, Dec 13, 2012

Filed:

Nov 18, 2011

Appl. No.:

13/300003

Inventors:

Ping Zhou - Shanghai, CN
Stephen Shepherd - Lakewood CO, US

Assignee:

Sybase, Inc. - Dublin CA

International Classification:

G06F 7/00

US Classification:

707610, 707E17005, 707E17044

Abstract:

A method, system and computer readable storage medium for replicating procedures with unsupported table data type arguments such as Boolean arguments. The method includes identifying the argument of an unsupported table data type in a procedure to be replicated, mapping the argument to an equivalent supported value, and creating a table containing a column representing the argument as the supported table data type and sending data corresponding to the unsupported table data type argument to a replication server.

US Patent:

20120317076, Dec 13, 2012

Filed:

Jun 30, 2011

Appl. No.:

13/173429

Inventors:

Jianbing Zhu - Shanghai, CN
Stephen Shepherd - Lakewood CO, US

Assignee:

Sybase, Inc. - Dublin CA

International Classification:

G06F 17/30

US Classification:

707626, 707E17005

Abstract:

System, method and articles of manufacture for filtering a data definition language (DDL) command. The method includes providing a filtering function with one or more rules for filtering the DDL command. The method further includes receiving the DDL command for replication. The method also includes filtering the DDL command from replication based on the one or more rules.

US Patent:

20120317078, Dec 13, 2012

Filed:

Nov 18, 2011

Appl. No.:

13/299931

Inventors:

Ping Zhou - Shanghai, CN
Stephen Shepherd - Lakewood CO, US

Assignee:

Sybase, Inc. - Dublin CA

International Classification:

G06F 7/00

US Classification:

707634, 707610, 707E17005, 707E17044

Abstract:

A method, system and computer readable storage medium for replicating structured data stored in a database. The method includes identifying the stored structured data, mapping the data to an unstructured data type, and sending the mapped data to one or more replicate databases as unstructured data.