Sybase, Inc.

Stephen Shepherd

Xun Cheng

Heping Shang

Ping Zhou

Yanhong Wang

Elton P Wildermuth

Mihnea Andre

Jianbing Zhu

Chengzi Xu

Hai-Yan Chen

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.

Replication support for heterogeneous data types

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.

Non-disruptive data movement and node rebalancing in extreme OLTP environments

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.

Replication support for structured data

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.

Auto-correction in database replication

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.

Replication resynchronization

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.

Growing community of inventors

Lakewood, CO, United States of America

Stephen Shepherd