公开(公告)号：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.

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

公开(公告)号：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.

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

公开(公告)号：US20080027987A1

公开(公告)日：2008-01-31

申请号：US11496949

申请日：2006-07-31

申请人： Nimar Arora ,  Lik Wong ,  Neeraj Shodhan ,  Anand Lakshminath ,  Edwina Lu ,  Byron Wang ,  Thuvan Hoang

发明人： Nimar Arora ,  Lik Wong ,  Neeraj Shodhan ,  Anand Lakshminath ,  Edwina Lu ,  Byron Wang ,  Thuvan Hoang

IPC分类号： G06F17/00

CPC分类号： G06F17/30575 ,  G06F17/30212 ,  G06F17/30569

摘要： A method and apparatus for replicating data between heterogeneous databases is provided. Data is replicated between two heterogeneous databases with the use of a volatile storage queue, enabling the rapid replication of data across databases provided by different vendors or operating on different platforms. According to one embodiment, an in-memory queue is used to queue change operations to be performed on a target data repository. The change operations may be operations that were applied to a source data repository. An apply process retrieves the change operations from in-memory queue and commits the change operations to persistent storage. When the change operations have been committed, the apply process notifies the source platform that the particular change operation has been stored.

摘要翻译： 提供了一种用于在异构数据库之间复制数据的方法和装置。 数据通过使用易失性存储队列在两个异构数据库之间进行复制，从而可以跨不同供应商提供的数据或在不同平台上运行的数据快速复制数据。 根据一个实施例，使用内存中队列来对要在目标数据存储库上执行的更改操作进行排队。 更改操作可能是应用于源数据存储库的操作。 应用进程从内存队列中检索更改操作，并将更改操作提交给持久存储。 当更改操作已经提交时，应用程序通知源平台已经存储了特定的更改操作。

公开(公告)号：US07668878B2

公开(公告)日：2010-02-23

申请号：US11496949

申请日：2006-07-31

申请人： Nimar Arora ,  Lik Wong ,  Neeraj Shadhan ,  Anand Lakshminath ,  Edwina Lu ,  Byron Wang ,  Thuvan Hoang

发明人： Nimar Arora ,  Lik Wong ,  Neeraj Shadhan ,  Anand Lakshminath ,  Edwina Lu ,  Byron Wang ,  Thuvan Hoang

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

CPC分类号： G06F17/30575 ,  G06F17/30212 ,  G06F17/30569

摘要： A method and apparatus for replicating data between heterogeneous databases is provided. Data is replicated between two heterogeneous databases with the use of a volatile storage queue, enabling the rapid replication of data across databases provided by different vendors or operating on different platforms. According to one embodiment, an in-memory queue is used to queue change operations to be performed on a target data repository. The change operations may be operations that were applied to a source data repository. An apply process retrieves the change operations from in-memory queue and commits the change operations to persistent storage. When the change operations have been committed, the apply process notifies the source platform that the particular change operation has been stored.

摘要翻译： 提供了一种用于在异构数据库之间复制数据的方法和装置。 数据通过使用易失性存储队列在两个异构数据库之间进行复制，从而可以跨不同供应商提供的数据或在不同平台上运行的数据快速复制数据。 根据一个实施例，使用内存中队列来对要在目标数据存储库上执行的更改操作进行排队。 更改操作可能是应用于源数据存储库的操作。 应用进程从内存队列中检索更改操作，并将更改操作提交给持久存储。 当更改操作已经提交时，应用程序通知源平台已经存储了特定的更改操作。

公开(公告)号：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.

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

公开(公告)号：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.

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

公开(公告)号：US07702741B2

公开(公告)日：2010-04-20

申请号：US11831810

申请日：2007-07-31

申请人： Jun Yuan ,  Alan Downing ,  Lik Wong ,  Nimar Arora ,  Patricia H. McElroy ,  Byron Wang ,  Lei Gao ,  Anand Lakshminath ,  Ramkumar Venkatesan

发明人： Jun Yuan ,  Alan Downing ,  Lik Wong ,  Nimar Arora ,  Patricia H. McElroy ,  Byron Wang ,  Lei Gao ,  Anand Lakshminath ,  Ramkumar Venkatesan

IPC分类号： G06F15/173

CPC分类号： G06F17/30575

摘要： Configuring an n-way multi-master information sharing topology. Adding a new node (e.g., database server) to the information sharing topology can be implemented as follows. Initially, the new node is added as a slave of a particular co-master in the information sharing topology. The objects to replicate are instantiated on the new node by propagating data from the particular co-master to the new node. Furthermore, a capture process is created on the particular co-master to send changes to the objects to the slave. Meanwhile, the co-masters continue to propagate changes to each other. To promote the slave to a master, changes to objects stored at the slave are propagated to each of the co-masters. Furthermore, changes at each of the masters are propagated to the promoted node.

摘要翻译： 配置n-way多主机信息共享拓扑。 将新节点（例如，数据库服务器）添加到信息共享拓扑可以如下实现。 最初，新的节点被添加为信息共享拓扑中特定共主机的从属。 通过将数据从特定共主机传播到新节点，将在新节点上实例化要复制的对象。 此外，在特定共同主机上创建捕获过程，以将对象的更改发送到从站。 同时，联合主人继续传播变化。 为了将从属设备升级到主设备，将存储在从站中的对象的更改传播到每个主站。 此外，每个主机的变化被传播到被推进的节点。

公开(公告)号：US20090037553A1

公开(公告)日：2009-02-05

申请号：US11831810

申请日：2007-07-31

申请人： Jun Yuan ,  Alan Downing ,  Lik Wong ,  Nimar Arora ,  Patricia H. McElroy ,  Byron Wang ,  Lei Gao ,  Anand Lakshminath ,  Ramkumar Venkatesan

发明人： Jun Yuan ,  Alan Downing ,  Lik Wong ,  Nimar Arora ,  Patricia H. McElroy ,  Byron Wang ,  Lei Gao ,  Anand Lakshminath ,  Ramkumar Venkatesan

IPC分类号： G06F15/16

CPC分类号： G06F17/30575

摘要： Configuring an n-way multi-master information sharing topology. Adding a new node (e.g., database server) to the information sharing topology can be implemented as follows. Initially, the new node is added as a slave of a particular co-master in the information sharing topology. The objects to replicate are instantiated on the new node by propagating data from the particular co-master to the new node. Furthermore, a capture process is created on the particular co-master to send changes to the objects to the slave. Meanwhile, the co-masters continue to propagate changes to each other. To promote the slave to a master, changes to objects stored at the slave are propagated to each of the co-masters. Furthermore, changes at each of the masters are propagated to the promoted node.

摘要翻译： 配置n-way多主机信息共享拓扑。 将新节点（例如，数据库服务器）添加到信息共享拓扑可以如下实现。 最初，新的节点被添加为信息共享拓扑中特定共主机的从属。 通过将数据从特定共主机传播到新节点，将在新节点上实例化要复制的对象。 此外，在特定共同主机上创建捕获过程，以将对象的更改发送到从站。 同时，联合主人继续传播变化。 为了将从属设备升级到主设备，将存储在从站中的对象的更改传播到每个主站。 此外，每个主机的变化被传播到被推进的节点。

公开(公告)号：US07899785B2

公开(公告)日：2011-03-01

申请号：US11831798

申请日：2007-07-31

申请人： Jun Yuan ,  Alan Downing ,  Lik Wong ,  Nimar Arora ,  Patricia H. McElroy ,  Byron Wang ,  Lei Gao ,  Anand Lakshminath ,  Ramkumar Venkatesan

发明人： Jun Yuan ,  Alan Downing ,  Lik Wong ,  Nimar Arora ,  Patricia H. McElroy ,  Byron Wang ,  Lei Gao ,  Anand Lakshminath ,  Ramkumar Venkatesan

IPC分类号： G06F17/30

CPC分类号： G06F17/30575

摘要： Splitting and merging database object information sharing streams. Streams are also referred to herein as “propagations”. Splitting and merging information sharing streams can be used to improve performance in a information sharing environment when a failed or slow DBS impacts the performance. In one embodiment, an auto split process monitors the progress of applying changes at each node and detects the presence of a failed or a slow node. Once the failed or slow node is identified, the auto split process splits the propagation such that the offending node is sent through a separate propagation. Furthermore, an auto merge process can be started to monitor the newly created separate propagation. At a later point, the new propagation can be merged back into the original stream. For example, if the offending node catches up with other nodes, the auto merge process merges the newly created propagation back to the original propagation.

摘要翻译： 分割和合并数据库对象信息共享流。 流在本文中也称为“传播”。 当失败或缓慢的DBS影响性能时，可以使用分割和合并信息共享流来提高信息共享环境中的性能。 在一个实施例中，自动拆分过程监视在每个节点处应用变化的进度，并检测故障或慢节点的存在。 一旦确定了故障或慢节点，自动拆分过程就会分裂传播，从而通过单独的传播发送违规节点。 此外，可以开始自动合并处理来监视新创建的单独传播。 稍后，新的传播可以合并回原始流。 例如，如果违规节点赶上其他节点，则自动合并过程将新创建的传播合并到原始传播。

公开(公告)号：US20080126354A1

公开(公告)日：2008-05-29

申请号：US11604529

申请日：2006-11-27

申请人： Byron Wang ,  Nimar Arora ,  Lik Wong ,  Jingwei Wu ,  Jun Yuan

发明人： Byron Wang ,  Nimar Arora ,  Lik Wong ,  Jingwei Wu ,  Jun Yuan

IPC分类号： G06F17/30

CPC分类号： G06F17/30575 ,  G06F11/3409 ,  G06F11/3452 ,  G06F11/3495 ,  G06F2201/80 ,  Y10S707/966

摘要： Systems, methodologies, media, and other embodiments associated with managing of a distributed database are described. One exemplary system embodiment includes an input logic configured to obtain information associated with a distributed database where the distributed database comprises a plurality of databases. An analysis logic analyzes the information obtained from the distributed database to determine performance information associated with the distributed database and, an output logic can provide information regarding the performance information associated with the distributed database.

摘要翻译： 描述了与分布式数据库的管理相关联的系统，方法，介质和其他实施例。 一个示例性系统实施例包括被配置为获得与分布式数据库相关联的信息的输入逻辑，其中分布式数据库包括多个数据库。 分析逻辑分析从分布式数据库获得的信息以确定与分布式数据库相关联的性能信息，并且输出逻辑可以提供关于与分布式数据库相关联的性能信息的信息。