公开(公告)号：US09760617B2

公开(公告)日：2017-09-12

申请号：US14290421

申请日：2014-05-29

申请人： Heping Shang ,  Guo Gang Ye ,  Zheng-wei Wang

发明人： Heping Shang ,  Guo Gang Ye ,  Zheng-wei Wang

IPC分类号： G06F17/30

CPC分类号： G06F17/30578

摘要： System, method, computer program product embodiments and combinations and sub-combinations thereof for data replication in a database system environment are described. In an aspect, the data replication includes grouping, in-memory, a plurality of transactions to be replicated as a single transaction from a source database system to a target database system. A plurality of net row changes is compiled for the plurality of transactions, and data inconsistency detection and resolution within a command application order are performed. The plurality of net row changes are organized in segments and the segments can be applied simultaneously in bulk to the target database system.

公开(公告)号：US09424145B2

公开(公告)日：2016-08-23

申请号：US14315138

申请日：2014-06-25

申请人： Heping Shang ,  Ming-Chen Lo ,  Fei Zhou ,  Tom Campbell ,  Frank de Lange ,  Guo Gang Ye ,  Xia-ge Dai

发明人： Heping Shang ,  Ming-Chen Lo ,  Fei Zhou ,  Tom Campbell ,  Frank de Lange ,  Guo Gang Ye ,  Xia-ge Dai

IPC分类号： G06F11/00 ,  G06F11/16 ,  G06F11/14 ,  G06F11/20

CPC分类号： G06F17/30351 ,  G06F11/1448 ,  G06F11/1474 ,  G06F11/1658 ,  G06F11/2094 ,  G06F17/30368 ,  G06F17/30371 ,  G06F17/30595 ,  G06F2201/80 ,  G06F2201/805 ,  G06F2201/82

摘要： Disclosed in some examples is a method, the method including detecting that an RDMS is recovering from a failure; sending a request for a last committed transaction on a replication component to the replication component; receiving, from the replication component, the last committed transaction which identifies a transaction that was the last committed transaction at a replication component at a time of RDMS failure; determining that a transaction log on the RDMS includes a transaction that had not yet been replicated at the time of RDMS failure which was committed on the transaction log subsequent to the last committed transaction received from the replication component; and based on that determination rolling back the transaction that had not yet been replicated at the time of RDMS failure.

摘要翻译： 在一些示例中公开了一种方法，该方法包括检测RDMS正在从故障中恢复; 向复制组件发送对复制组件上的最后提交的事务的请求; 从复制组件接收在RDMS故障时识别在复制组件处最后提交的事务的事务的最后提交的事务; 确定RDMS上的事务日志包括在从复制组件接收的最后一个提交的事务之后的事务日志上提交的RDMS故障时尚未复制的事务; 并且基于该确定将在RDMS失败时尚未被复制的事务回滚。

公开(公告)号：US20150378840A1

公开(公告)日：2015-12-31

申请号：US14315138

申请日：2014-06-25

申请人： Heping Shang ,  Ming-Chen Lo ,  Fei Zhou ,  Tom Campbell ,  Frank de Lange ,  Guo Gang Ye ,  Xia-ge Dai

发明人： Heping Shang ,  Ming-Chen Lo ,  Fei Zhou ,  Tom Campbell ,  Frank de Lange ,  Guo Gang Ye ,  Xia-ge Dai

IPC分类号： G06F11/14

CPC分类号： G06F17/30351 ,  G06F11/1448 ,  G06F11/1474 ,  G06F11/1658 ,  G06F11/2094 ,  G06F17/30368 ,  G06F17/30371 ,  G06F17/30595 ,  G06F2201/80 ,  G06F2201/805 ,  G06F2201/82

摘要： Disclosed in some examples is a method, the method including detecting that an RDMS is recovering from a failure; sending a request for a last committed transaction on a replication component to the replication component; receiving, from the replication component, the last committed transaction which identifies a transaction that was the last committed transaction at a replication component at a time of RDMS failure; determining that a transaction log on the RDMS includes a transaction that had not yet been replicated at the time of RDMS failure which was committed on the transaction log subsequent to the last committed transaction received from the replication component; and based on that determination rolling back the transaction that had not yet been replicated at the time of RDMS failure.

摘要翻译： 在一些示例中公开了一种方法，该方法包括检测RDMS正在从故障中恢复; 向复制组件发送对复制组件上的最后提交的事务的请求; 从复制组件接收在RDMS故障时识别在复制组件处最后提交的事务的事务的最后提交的事务; 确定RDMS上的事务日志包括在从复制组件接收的最后一个提交的事务之后的事务日志上提交的RDMS故障时尚未复制的事务; 并且基于该确定将在RDMS失败时尚未被复制的事务回滚。

公开(公告)号：US09672126B2

公开(公告)日：2017-06-06

申请号：US13326892

申请日：2011-12-15

申请人： Rhett Dondi Dewall ,  Heping Shang

发明人： Rhett Dondi Dewall ,  Heping Shang

IPC分类号： G06F17/30 ,  G06F7/00 ,  G06F11/20 ,  G06F11/16

CPC分类号： G06F11/2097 ,  G06F11/1662 ,  G06F17/30368 ,  G06F17/30377 ,  G06F17/30575 ,  G06F2201/80 ,  G06F2201/84

摘要： System, method, computer program product embodiments and combinations and sub-combinations thereof for hybrid data replication are described. Aspects include identifying a type of database data replication, the type including a combination of replication approaches, and managing replication based on the identified type, including coordinated switching from one replication approach to another automatically with transactional consistency maintained among source and target databases.

公开(公告)号：US20150186484A1

公开(公告)日：2015-07-02

申请号：US14142037

申请日：2013-12-27

申请人： Heping Shang ,  Randall L. Hughes ,  Yu Wang

发明人： Heping Shang ,  Randall L. Hughes ,  Yu Wang

IPC分类号： G06F17/30

CPC分类号： G06F17/30575

摘要： A system, method and computer-readable mediums for replicating data, are provided. A replication logic description describing how data is replicated in a replication path and a resource description describing a replication environment are specified. The replication logic description is bound to at least one resource in the resource description. Once bound, an object representing a bound replication logic description and the resource description is generated and deployed in the replication environment. Once deployed the object replicates data in the replication path while ensuring transaction consistency and delivery during replication of the data.

摘要翻译： 提供了用于复制数据的系统，方法和计算机可读介质。 指定描述如何在复制路径中复制数据的复制逻辑描述以及描述复制环境的资源描述。 复制逻辑描述被绑定到资源描述中的至少一个资源。 绑定后，将在复制环境中生成并部署表示绑定复制逻辑描述和资源描述的对象。 部署后，对象会在复制路径中复制数据，同时确保数据复制期间事务的一致性和传递。

公开(公告)号：US20110153568A1

公开(公告)日：2011-06-23

申请号：US12646321

申请日：2009-12-23

申请人： Heping Shang ,  Mingchen Lo

发明人： Heping Shang ,  Mingchen Lo

IPC分类号： G06F17/00 ,  G06F12/16

CPC分类号： G06F11/2094 ,  G06F11/2097 ,  G06F17/30575 ,  G06F2201/80 ,  G06F2201/82

摘要： System, method, computer program product embodiments and combinations and sub-combinations thereof for data replication in a database system environment are described. In an aspect, the data replication includes grouping, in-memory, a plurality of transactions to be replicated as a single transaction from a source database system to a target database system. A plurality of net row changes is compiled for the plurality of transactions, and data inconsistency detection and resolution within a command application order are performed. Further included is bulk application of the plurality of net row changes to the target database system.

摘要翻译： 描述了用于数据库系统环境中的数据复制的系统，方法，计算机程序产品实施例及其组合和子组合。 在一方面，数据复制包括将要从源数据库系统复制为单个事务的多个事务分组到目标数据库系统。 针对多个事务编辑多个净行更改，并且执行命令应用顺序内的数据不一致性检测和解析。 还包括将多个网络行更改批量应用于目标数据库系统。

公开(公告)号：US10423498B2

公开(公告)日：2019-09-24

申请号：US14446172

申请日：2014-07-29

申请人： Heping Shang ,  Ming-Chen Lo ,  Elena Lora-Gallardo ,  Xia-ge Dai

发明人： Heping Shang ,  Ming-Chen Lo ,  Elena Lora-Gallardo ,  Xia-ge Dai

IPC分类号： G06F16/00 ,  G06F11/14 ,  G06F11/16 ,  G06F11/20 ,  G06F16/18 ,  G06F16/23

摘要： A method for reliable data synchronization within a network is disclosed. The producer system stories data in a persistent data store and produces one or more data updates. The producer system simultaneously transmits the data updates to a consumer system and initiating storage of the data updates at the producer system. When storage of the data updates at the producer system is complete, the producer system transmits a first acknowledgment to the consumer system. The producer system determines whether a second acknowledgment has been received from the consumer system, wherein the second acknowledgment indicates that the consumer system has successfully stored the data updates at the consumer system. In accordance with a determination that the second acknowledgment has been received from the consumer system, the producer system changes the temporary status of the data updates stored at the producer system to a permanent status.

公开(公告)号：US07346633B2

公开(公告)日：2008-03-18

申请号：US10709974

申请日：2004-06-10

申请人： Heping Shang ,  Zhenpeng Li

发明人： Heping Shang ,  Zhenpeng Li

IPC分类号： G06F17/30

CPC分类号： G06F17/3033 ,  Y10S707/99943 ,  Y10S707/99952 ,  Y10S707/99953

摘要： A system providing methodology for replication subscription resolution. In one embodiment, for example, a system of the present invention for determining subscribers to which a published item of data should be replicated comprises: an interface module for receiving user input of lists of a plurality of subscribers, each list specifying items of data to be replicated to a given subscriber, a build module for building an index based on the lists of the plurality of subscribers containing entries indicating subscribers For each item of data specified in the lists and a default list of subscribers for items of data not matching any of the entries; and a resolution module for receiving a published item of data and determining subscribers to which the published item should be replicated based on the index.

摘要翻译： 提供复制订阅解析方法的系统。 在一个实施例中，例如，本发明的用于确定应该复制已发布数据项目的用户的本发明的系统包括：接口模块，用于接收多个用户的列表的用户输入，每个列表指定数据项 被复制到给定订户，构建模块，用于基于包含指示订户的条目的多个订户的列表来构建索引。对于列表中指定的每个数据项目，以及用于不符合任何 条目; 以及分辨率模块，用于接收已发布的数据项，并且基于所述索引确定应该发布已发布项目的用户。

公开(公告)号：US20050278346A1

公开(公告)日：2005-12-15

申请号：US10709974

申请日：2004-06-10

申请人： Heping Shang ,  Zhenpeng Li

发明人： Heping Shang ,  Zhenpeng Li

IPC分类号： G06F7/00

CPC分类号： G06F17/3033 ,  Y10S707/99943 ,  Y10S707/99952 ,  Y10S707/99953

摘要： A system providing methodology for replication subscription resolution is described. In one embodiment, for example, a system of the present invention for determining subscribers to which a published item of data should be replicated is described that comprises: an interface module for receiving user input of lists of a plurality of subscribers, each list specifying items of data to be replicated to a given subscriber; a build module for building an index based on the lists of the plurality of subscribers containing entries indicating subscribers for each item of data specified in the lists and a default list of subscribers for items of data not matching any of the entries; and a resolution module for receiving a published item of data and determining subscribers to which the published item should be replicated based on the index.

摘要翻译： 描述了提供复制订阅解析方法的系统。 在一个实施例中，例如，描述了本发明的用于确定应该复制已发布数据项目的订户的系统，其包括：接口模块，用于接收多个订户的列表的用户输入，每个列表指定项目 要复制到给定用户的数据; 用于基于所述多个订户的列表构建索引的构建模块，其包含指示在所述列表中指定的每个数据项的订户的条目，以及用于不符合任何条目的数据的数据的订户的默认列表; 以及分辨率模块，用于接收已发布的数据项，并且基于所述索引确定应该发布已发布项目的用户。

公开(公告)号：US20150378845A1

公开(公告)日：2015-12-31

申请号：US14446172

申请日：2014-07-29

申请人： Heping Shang ,  Ming-Chen Lo ,  Elena Lora-Gallardo ,  Xia-ge Dai

发明人： Heping Shang ,  Ming-Chen Lo ,  Elena Lora-Gallardo ,  Xia-ge Dai

IPC分类号： G06F11/14 ,  G06F11/16 ,  G06F11/20 ,  G06F17/30

摘要： A method for reliable data synchronization within a network is disclosed. The producer system stories data in a persistent data store and produces one or more data updates. The producer system simultaneously transmits the data updates to a consumer system and initiating storage of the data updates at the producer system. When storage of the data updates at the producer system is complete, the producer system transmits a first acknowledgment to the consumer system. The producer system determines whether a second acknowledgment has been received from the consumer system, wherein the second acknowledgment indicates that the consumer system has successfully stored the data updates at the consumer system. In accordance with a determination that the second acknowledgment has been received from the consumer system, the producer system changes the temporary status of the data updates stored at the producer system to a permanent status.

摘要翻译： 公开了一种在网络内可靠数据同步的方法。 生产者系统将持久性数据存储中的数据进行故事并产生一个或多个数据更新。 生产者系统同时将数据更新传送到消费者系统，并在生产者系统上启动数据更新的存储。 当生产者系统的数据更新的存储完成时，生产者系统向消费者系统发送第一确认。 生产者系统确定是否已经从消费者系统接收到第二确认，其中第二确认指示消费者系统已经在消费者系统上成功存储数据更新。 根据从消费者系统接收到第二确认的确定，生产者系统将存储在生产者系统中的数据更新的临时状态改变为永久状态。