Stephen Daniel 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:

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.

US Patent:

20130132345, May 23, 2013

Filed:

Nov 22, 2011

Appl. No.:

13/302272

Inventors:

Hai-Yan Chen - Shanghai, CN
Stephen Shepherd - Lakewood CO, US

Assignee:

SYBASE, INC. - Dublin CA

International Classification:

G06F 17/30

US Classification:

707635, 707E17007

Abstract:

A method, system and computer readable storage medium for replicating database data of heterogeneous data type are disclosed. The method includes determining the data type of an element of heterogeneous data type to be replicated. The element is packed into a predetermined transfer format as an opaque data type, based on the determined data type, and replicated to a replication server. The replication server is instructed to not modify the element noted as opaque.