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

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

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

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

公开(公告)号：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影响性能时，可以使用分割和合并信息共享流来提高信息共享环境中的性能。 在一个实施例中，自动拆分过程监视在每个节点处应用变化的进度，并检测故障或慢节点的存在。 一旦确定了故障或慢节点，自动拆分过程就会分裂传播，从而通过单独的传播发送违规节点。 此外，可以开始自动合并处理来监视新创建的单独传播。 稍后，新的传播可以合并回原始流。 例如，如果违规节点赶上其他节点，则自动合并过程将新创建的传播合并到原始传播。

公开(公告)号：US20090037442A1

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

申请号：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影响性能时，可以使用分割和合并信息共享流来提高信息共享环境中的性能。 在一个实施例中，自动拆分过程监视在每个节点处应用变化的进度，并检测故障或慢节点的存在。 一旦确定了故障或慢节点，自动拆分过程就会分裂传播，从而通过单独的传播发送违规节点。 此外，可以开始自动合并处理来监视新创建的单独传播。 稍后，新的传播可以合并回原始流。 例如，如果违规节点赶上其他节点，则自动合并过程将新创建的传播合并到原始传播。

公开(公告)号：US08799213B2

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

申请号：US11831478

申请日：2007-07-31

申请人： Lik Wong ,  Nimar S. Arora ,  Anand Lakshminath ,  Jingwei Wu ,  Lei Gao ,  Thuvan Hoang

发明人： Lik Wong ,  Nimar S. Arora ,  Anand Lakshminath ,  Jingwei Wu ,  Lei Gao ,  Thuvan Hoang

IPC分类号： G06F7/00 ,  G06F17/00

CPC分类号： G06F17/30575

摘要： In accordance with an embodiment of the present invention, an information sharing mechanism comprising a memory structure may be provided in a database system. In an embodiment, mined information transferred by a capture process to an associated apply process can be written into the memory structure without taking any latch. Similarly, the mined information can be read by the apply process from the memory structure without taking any latch. The capture and apply processes may work cooperatively to establish a safe point in log mining under various circumstances such as in an initial startup state, in a steady state, in a process restart scenario in the middle of information sharing. In some embodiments, the information sharing mechanism supports both checkpoint-free and checkpoint modes of log mining by the capture process. In addition, both the capture process and the apply process may employ an eager apply approach to increase processing capacity.

摘要翻译： 根据本发明的实施例，可以在数据库系统中提供包括存储器结构的信息共享机制。 在一个实施例中，通过捕获处理传送到相关联的应用进程的挖掘信息可以被写入存储器结构而不采取任何锁存。 类似地，可以通过应用处理从存储器结构读取挖掘的信息，而不采取任何锁存。 捕获和应用过程可以协同工作，在各种情况下在日志挖掘中建立安全点，例如在初始启动状态，稳定状态下，在信息共享过程中的过程重新启动情况。 在一些实施例中，信息共享机制通过捕获过程支持日志挖掘的无检点和检查点模式。 此外，捕获过程和应用过程都可以采用渴望应用的方法来增加处理能力。

公开(公告)号：US20090037422A1

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

申请号：US11831478

申请日：2007-07-31

申请人： Lik Wong ,  Nimar S. Arora ,  Anand Lakshminath ,  Jingwei Wu ,  Lei Gao ,  Thuvan Hoang

发明人： Lik Wong ,  Nimar S. Arora ,  Anand Lakshminath ,  Jingwei Wu ,  Lei Gao ,  Thuvan Hoang

IPC分类号： G06F17/30

CPC分类号： G06F17/30575

摘要： In accordance with an embodiment of the present invention, an information sharing mechanism comprising a memory structure may be provided in a database system. In an embodiment, mined information transferred by a capture process to an associated apply process can be written into the memory structure without taking any latch. Similarly, the mined information can be read by the apply process from the memory structure without taking any latch. The capture and apply processes may work cooperatively to establish a safe point in log mining under various circumstances such as in an initial startup state, in a steady state, in a process restart scenario in the middle of information sharing. In some embodiments, the information sharing mechanism supports both checkpoint-free and checkpoint modes of log mining by the capture process. In addition, both the capture process and the apply process may employ an eager apply approach to increase processing capacity.

摘要翻译： 根据本发明的实施例，可以在数据库系统中提供包括存储器结构的信息共享机制。 在一个实施例中，通过捕获处理传送到相关联的应用进程的挖掘信息可以被写入存储器结构而不采取任何锁存。 类似地，可以通过应用处理从存储器结构读取挖掘的信息，而不采取任何锁存。 捕获和应用过程可以协同工作，在各种情况下在日志挖掘中建立安全点，例如在初始启动状态，稳定状态下，在信息共享过程中的过程重新启动情况。 在一些实施例中，信息共享机制通过捕获过程支持日志挖掘的无检点和检查点模式。 此外，捕获过程和应用过程都可以采用渴望应用的方法来增加处理能力。

公开(公告)号：US20060224626A1

公开(公告)日：2006-10-05

申请号：US11099203

申请日：2005-04-04

申请人： Anand Lakshminath ,  Benny Souder ,  James Stamos ,  Lik Wong ,  Hung Tran

发明人： Anand Lakshminath ,  Benny Souder ,  James Stamos ,  Lik Wong ,  Hung Tran

IPC分类号： G06F17/00

CPC分类号： G06F16/1873

摘要： Techniques are provided for managing electronic items by storing, within a file group repository, metadata that identifies (a) a plurality of file groups, (b) for each file group, a set of one or more file group versions for the file group, and (c) for each file group version of each file group, a set of one or more items that belong to the version of the file group. Once the metadata has been established, queries may be executed against the metadata to request identification of items that belong to a particular version of a particular file group. This file group framework may be used in a variety of contexts, including the management of a centralized tablespace repository, and periodic purging of versions of file collections, where the files within the collections may be spread across multiple repositories.

摘要翻译： 提供了通过在文件组存储库内存储标识（a）多个文件组的元数据（b）针对每个文件组的文件组的一个或多个文件组版本的集合来管理电子商品的技术， 和（c）对于每个文件组的每个文件组版本，属于文件组版本的一个或多个项目的集合。 一旦建立了元数据，可以针对元数据执行查询，以请求对属于特定文件组的特定版本的项目的标识。 该文件组框架可以用于各种上下文中，包括管理集中式表空间存储库，以及定期清除文件集合的版本，集合中的文件可以分布在多个存储库中。

公开(公告)号：US07873684B2

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

申请号：US10718747

申请日：2003-11-21

申请人： Benny Souder ,  James Stamos ,  Lik Wong ,  John Ciminski ,  Anand Lakshminath ,  Alan Downing

发明人： Benny Souder ,  James Stamos ,  Lik Wong ,  John Ciminski ,  Anand Lakshminath ,  Alan Downing

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

CPC分类号： G06F17/3038

摘要： Approaches described herein may be used for provisioning of databases that requires a bulk transfer of data within a distributed computing environment, such as a grid. The approaches do not require the manual intervention of a DBA to, for example, transfer a tablespace between the file systems of operating systems. Instead, the tablespaces may be provisioned automatically and dynamically by a grid computing system whenever it determines the need to dynamically provision a database. In addition, as copies of tablespaces are provisioned, synchronization mechanisms can also be automatically provisioned to keep the tablespaces and their copies in sync.

摘要翻译： 本文描述的方法可用于提供需要在分布式计算环境（例如网格）内的数据的批量传送的数据库。 这些方法不需要DBA的手动干预，例如在操作系统的文件系统之间传输表空间。 相反，只要它确定动态提供数据库的需要，网格计算系统就可以自动和动态地提供表空间。 另外，由于配置了表空间的副本，因此也可以自动配置同步机制以保持表空间及其副本的同步。