公开(公告)号：US08589346B2

公开(公告)日：2013-11-19

申请号：US13094676

申请日：2011-04-26

申请人： Edwina Lu ,  James Stamos ,  Nimar Arora ,  Lik Wong ,  Haobo Xu ,  Thuvan Hoang ,  Byron Wang ,  Lakshminaray Chidambaran

发明人： Edwina Lu ,  James Stamos ,  Nimar Arora ,  Lik Wong ,  Haobo Xu ,  Thuvan Hoang ,  Byron Wang ,  Lakshminaray Chidambaran

IPC分类号： G06F17/30

CPC分类号： G06F17/30575 ,  G06F17/30578

摘要： Techniques for replicating data in database systems are described. In an example embodiment, a set of changes is received at a destination database, where the set of changes has been applied at a source database and is being replicated from the source database to the destination database. The set of changes is analyzed and it is determined that the set of changes includes two or more of: a subset of row-level changes, a subset of statement-level changes, and a subset of procedure-level changes. A set of dependencies is determined at least between the changes that are included in the subsets of changes. The changes, in the subsets of changes, are assigned to two or more processing elements. The set of changes is applied to the destination database by executing the two or more processing elements in parallel to each other and based on the set of dependencies.

摘要翻译： 描述了在数据库系统中复制数据的技术。 在示例实施例中，在目的地数据库处接收一组改变，其中该变更集合已经在源数据库处应用并且正在从源数据库复制到目的地数据库。 分析一组变化，并且确定该组更改包括以下两个或多个：行级更改的子集，语句级更改的子集以及过程级更改的子集。 至少在更改子集中包含的更改之间确定一组依赖关系。 更改子集中的更改分配给两个或多个处理元素。 通过相互并行并基于一组依赖关系执行两个或多个处理元件，将该组更改应用于目的地数据库。

公开(公告)号：USD645294S1

公开(公告)日：2011-09-20

申请号：US29363006

申请日：2010-06-03

申请人： Kunyu Tsai ,  Haobo Xu

设计人： Kunyu Tsai ,  Haobo Xu

公开(公告)号：US09230002B2

公开(公告)日：2016-01-05

申请号：US12363557

申请日：2009-01-30

申请人： Lik Wong ,  Nimar Arora ,  Lei Gao ,  Thuvan Hoang ,  Haobo Xu

发明人： Lik Wong ,  Nimar Arora ,  Lei Gao ,  Thuvan Hoang ,  Haobo Xu

IPC分类号： G06F17/00 ,  G06F7/00 ,  G06F17/30 ,  G06F9/54

CPC分类号： G06F17/30578 ,  G06F9/544 ,  G06F9/546

摘要： A method for sharing information between a publisher and multiple subscribers is provided. The publisher uses a latch-free, single publisher, multiple subscriber shared queue to share information. Logical change records representing changes made to a database are enqueued in the shared queue as messages in a stream of messages, and subscribers read the logical change records. Subscribers may filter logical change records before sending to apply processes for processing. An identifying property of the source instance of a change encapsulated in a logical change record may be included with each message enqueued.

摘要翻译： 提供了一种在发布者和多个订户之间共享信息的方法。 发行商使用无闩锁的单个发布者，多用户共享队列来共享信息。 表示对数据库所做更改的逻辑更改记录作为消息流中的消息排入队列中，订阅者读取逻辑更改记录。 订阅者可以在发送之前过滤逻辑更改记录以应用进程进行处理。 封装在逻辑更改记录中的更改的源实例的标识属性可以包含在每个排队的消息中。

公开(公告)号：US20120278282A1

公开(公告)日：2012-11-01

申请号：US13094676

申请日：2011-04-26

申请人： Edwina Lu ,  James Stamos ,  Nimar Arora ,  Lik Wong ,  Haobo Xu ,  Thuvan Hoang ,  Byron Wang ,  Lakshminaray Chidambaran

发明人： Edwina Lu ,  James Stamos ,  Nimar Arora ,  Lik Wong ,  Haobo Xu ,  Thuvan Hoang ,  Byron Wang ,  Lakshminaray Chidambaran

IPC分类号： G06F17/30

CPC分类号： G06F17/30575 ,  G06F17/30578

摘要： Techniques for replicating data in database systems are described. In an example embodiment, a set of changes is received at a destination database, where the set of changes has been applied at a source database and is being replicated from the source database to the destination database. The set of changes is analyzed and it is determined that the set of changes includes two or more of: a subset of row-level changes, a subset of statement-level changes, and a subset of procedure-level changes. A set of dependencies is determined at least between the changes that are included in the subsets of changes. The changes, in the subsets of changes, are assigned to two or more processing elements. The set of changes is applied to the destination database by executing the two or more processing elements in parallel to each other and based on the set of dependencies.

摘要翻译： 描述了在数据库系统中复制数据的技术。 在示例实施例中，在目的地数据库处接收一组改变，其中该变更集合已经在源数据库处应用并且正在从源数据库复制到目的地数据库。 分析一组变化，并且确定该组更改包括以下两个或多个：行级更改的子集，语句级更改的子集以及过程级别更改的子集。 至少在更改子集中包含的更改之间确定一组依赖关系。 更改子集中的更改分配给两个或多个处理元素。 通过相互并行并基于一组依赖关系执行两个或多个处理元件，将该组更改应用于目的地数据库。

公开(公告)号：US20100198920A1

公开(公告)日：2010-08-05

申请号：US12363557

申请日：2009-01-30

申请人： Lik Wong ,  Nimar Arora ,  Lei Gao ,  Thuvan Hoang ,  Haobo Xu

发明人： Lik Wong ,  Nimar Arora ,  Lei Gao ,  Thuvan Hoang ,  Haobo Xu

IPC分类号： G06F17/30 ,  G06F15/16

CPC分类号： G06F17/30578 ,  G06F9/544 ,  G06F9/546

摘要： A method for sharing information between a publisher and multiple subscribers is provided. The publisher uses a latch-free, single publisher, multiple subscriber shared queue to share information. Logical change records representing changes made to a database are enqueued in the shared queue as messages in a stream of messages, and subscribers read the logical change records. Subscribers may filter logical change records before sending to apply processes for processing. An identifying property of the source instance of a change encapsulated in a logical change record may be included with each message enqueued.

摘要翻译： 提供了一种在发布者和多个订户之间共享信息的方法。 发行商使用无闩锁的单个发布者，多用户共享队列来共享信息。 表示对数据库所做更改的逻辑更改记录作为消息流中的消息排入队列中，订阅者读取逻辑更改记录。 订阅者可以在发送之前过滤逻辑更改记录以应用进程进行处理。 封装在逻辑更改记录中的更改的源实例的标识属性可以包含在每个排队的消息中。