公开(公告)号：US07523143B2

公开(公告)日：2009-04-21

申请号：US10909985

申请日：2004-08-02

申请人： Lik Wong ,  Edwina Lu ,  James W. Stamos

发明人： Lik Wong ,  Edwina Lu ,  James W. Stamos

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

CPC分类号： G06F17/30575 ,  Y10S707/99953

摘要： A source database system sends information to a destination database system, and each database system generates a separate set of sequence information. A mapping is maintained between the two sets of sequence information. Using the mapping, the destination database system may be used to restore changes lost at the source database system without reinstating the source database. Additionally, queries associated with a particular point in a sequence associated with the sequence information of the source database may be redirected to the destination database, and the destination database system may serve as a logical standby for the source database system. A variety of methods of maintaining and/or extracting the mapping information are disclosed.

摘要翻译： 源数据库系统向目标数据库系统发送信息，每个数据库系统生成一组单独的序列信息。 在两组序列信息之间保持映射。 使用映射，目标数据库系统可用于恢复源数据库系统丢失的更改，而不会恢复源数据库。 此外，与源数据库的序列信息相关联的序列中的特定点相关联的查询可以被重定向到目的地数据库，并且目的地数据库系统可以用作源数据库系统的逻辑备用。 公开了维护和/或提取映射信息的各种方法。

公开(公告)号：US07613741B2

公开(公告)日：2009-11-03

申请号：US10449873

申请日：2003-05-30

申请人： Edwina Lu ,  Lik Wong ,  Sanjay Kaluskar ,  James Stamos ,  Neerja Bhatt ,  Wei Wang

发明人： Edwina Lu ,  Lik Wong ,  Sanjay Kaluskar ,  James Stamos ,  Neerja Bhatt ,  Wei Wang

IPC分类号： G06F17/30

CPC分类号： G06F17/30575 ,  Y10S707/99953

摘要： Described herein are various approaches that allow rules to be used to specify actions, that alleviate the complexity and burden of developing and maintaining rules in a rules-based messaging system, and that provide more efficient ways of evaluating rules. The approaches allow rules to specify user-defined transformation functions for transforming messages, to specify when and how to perform row migration, and to specify other types of actions. Rules are grouped into rule sets. Several types of rule sets, referred to as positive and negative rule sets, allow users to use rules that are less complex to develop and maintain. Rule sets are evaluated more efficiently by attempting to evaluate the rule set with less information than is needed to evaluate all the rules in the rule set. Also, the results of rules evaluations that are based on a set of values are cached for later retrieval.

摘要翻译： 这里描述了允许规则用于指定动作的各种方法，其减轻了在基于规则的消息传递系统中开发和维护规则的复杂性和负担，并且提供了更有效的评估规则的方式。 这些方法允许规则指定用于转换消息的用户定义的转换功能，指定何时以及如何执行行迁移，并指定其他类型的操作。 规则分为规则集。 称为正和负规则集的几种类型的规则集允许用户使用开发和维护不太复杂的规则。 通过尝试使用比评估规则集中的所有规则所需的信息更少的信息来评估规则集，可以更有效地评估规则集。 此外，基于一组值的规则评估结果被缓存以供以后检索。

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

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

公开(公告)号：US20090119346A1

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

申请号：US11935939

申请日：2007-11-06

申请人： Edwina Lu ,  Mahesh Subramaniam ,  Lik Wong ,  James Stamos ,  Nimar Singh Arora

发明人： Edwina Lu ,  Mahesh Subramaniam ,  Lik Wong ,  James Stamos ,  Nimar Singh Arora

IPC分类号： G06F17/30

CPC分类号： G06F17/30578 ,  G06F11/2097

摘要： An approach is provided to automatically resolve conflict between instantiation and ongoing data replication operations. In an embodiment, incremental change records that describe one or more database operations are received at a sink entity. Here, all of the one or more database operations have occurred in a second database after a particular time. A first database operation in the one or more database operations to a particular row in the first database is applied. When a conflict with a second database operation that operates on the particular row is detected, one or more compensating actions, which may, but are not limited to, be a different database operation and/or an operation that creates a conflict log entry, may be performed. Here, the second database operation has occurred in the second database prior to the particular time. When the second database operation is to be performed, an appropriate operation may be performed.

摘要翻译： 提供了一种方法来自动解决实例化和正在进行的数据复制操作之间的冲突。 在实施例中，描述一个或多个数据库操作的增量更改记录在汇实体处被接收。 这里，在特定时间之后，所有一个或多个数据库操作都发生在第二数据库中。 应用第一个数据库中特定行的一个或多个数据库操作中的第一个数据库操作。 当检测到对在特定行上操作的第二数据库操作的冲突时，一个或多个补偿动作（其可以但不限于是不同的数据库操作和/或创建冲突日志条目的操作）可以 被执行。 这里，第二数据库操作已经在特定时间之前在第二数据库中发生。 当要执行第二数据库操作时，可以执行适当的操作。

公开(公告)号：US07441033B2

公开(公告)日：2008-10-21

申请号：US10917687

申请日：2004-08-12

申请人： Lakshminarayanan Chidambaran ,  James W. Stamos ,  Rajendra Pingte ,  Edwina Lu

发明人： Lakshminarayanan Chidambaran ,  James W. Stamos ,  Rajendra Pingte ,  Edwina Lu

IPC分类号： G06F15/173 ,  G06F12/00

CPC分类号： H04L67/1031 ,  G06F9/5061 ,  H04L41/0668 ,  H04L41/5009 ,  H04L41/5025 ,  H04L67/1034

摘要： An approach efficiently and dynamically allocates and de-allocates database instances and nodes between databases. The approach performs this function in a way that accounts for the users of and services hosted by multiple databases.

摘要翻译： 一种方法可以有效和动态地分配数据库中的数据库实例和节点。 该方法以这样一种方式来执行此功能，从而占用多个数据库托管的用户和服务。

公开(公告)号：US08005802B2

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

申请号：US10452850

申请日：2003-05-30

申请人： Edwina Lu ,  Lik Wong ,  Sanjay Kaluskar ,  James Stamos ,  Neerja Bhatt ,  Wei Wang

发明人： Edwina Lu ,  Lik Wong ,  Sanjay Kaluskar ,  James Stamos ,  Neerja Bhatt ,  Wei Wang

IPC分类号： G06F17/30

CPC分类号： G06F17/30575 ,  Y10S707/99939 ,  Y10S707/99942 ,  Y10S707/99943

摘要： Described herein are various approaches that allow rules to be used to specify actions, that alleviate the complexity and burden of developing and maintaining rules in a rules-based messaging system, and that provide more efficient ways of evaluating rules. The approaches allow rules to specify user-defined transformation functions for transforming messages, to specify when and how to perform row migration, and to specify other types of actions. Rules are grouped into rule sets. Several types of rule sets, referred to as positive and negative rule sets, allow users to use rules that are less complex to develop and maintain. Rule sets are evaluated more efficiently by attempting to evaluate the rule set with less information than is needed to evaluate all the rules in the rule set. Also, the results of rules evaluations that are based on a set of values are cached for later retrieval.

摘要翻译： 这里描述了允许规则用于指定动作的各种方法，其减轻了在基于规则的消息传递系统中开发和维护规则的复杂性和负担，并且提供了更有效的评估规则的方式。 这些方法允许规则指定用于转换消息的用户定义的转换功能，指定何时以及如何执行行迁移，并指定其他类型的操作。 规则分为规则集。 称为正和负规则集的几种类型的规则集允许用户使用开发和维护不太复杂的规则。 通过尝试使用比评估规则集中的所有规则所需的信息更少的信息来评估规则集，可以更有效地评估规则集。 此外，基于一组值的规则评估结果被缓存以供以后检索。

公开(公告)号：US07565379B2

公开(公告)日：2009-07-21

申请号：US10452761

申请日：2003-05-30

申请人： Edwina Lu ,  Lik Wong ,  Sanjay Kaluskar ,  James Stamos ,  Neerja Bhatt ,  Wei Wang

发明人： Edwina Lu ,  Lik Wong ,  Sanjay Kaluskar ,  James Stamos ,  Neerja Bhatt ,  Wei Wang

IPC分类号： G06F17/00

CPC分类号： G06F7/00 ,  Y10S707/99945

摘要： In some messaging system architectures, messages can cycle back to the originator of a message, who may then propagate the message, causing the cycle to be repeated. Described herein are techniques that use rules and fields in a redo log, to manage message flows such that undesired cycles are prevented. The techniques may be used in messaging systems that have various topologies.

摘要翻译： 在一些消息系统架构中，消息可以循环回到消息的发起者，然后谁可以传播消息，导致重复循环。 这里描述的是使用重做日志中的规则和字段来管理消息流的技术，从而防止不期望的周期。 这些技术可以用于具有各种拓扑的消息系统中。

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

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

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

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

公开(公告)号：US07769714B2

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

申请号：US11935939

申请日：2007-11-06

申请人： Edwina Lu ,  Mahesh Subramaniam ,  Lik Wong ,  James Stamos ,  Nimar Singh Arora

发明人： Edwina Lu ,  Mahesh Subramaniam ,  Lik Wong ,  James Stamos ,  Nimar Singh Arora

IPC分类号： G06F17/30

CPC分类号： G06F17/30578 ,  G06F11/2097

摘要： An approach is provided to automatically resolve conflict between instantiation and ongoing data replication operations. In an embodiment, incremental change records that describe one or more database operations are received at a sink entity. Here, all of the one or more database operations have occurred in a second database after a particular time. A first database operation in the one or more database operations to a particular row in the first database is applied. When a conflict with a second database operation that operates on the particular row is detected, one or more compensating actions, which may, but are not limited to, be a different database operation and/or an operation that creates a conflict log entry, may be performed. Here, the second database operation has occurred in the second database prior to the particular time. When the second database operation is to be performed, an appropriate operation may be performed.

摘要翻译： 提供了一种方法来自动解决实例化和正在进行的数据复制操作之间的冲突。 在实施例中，描述一个或多个数据库操作的增量更改记录在汇实体处被接收。 这里，在特定时间之后，所有一个或多个数据库操作都发生在第二数据库中。 应用第一个数据库中特定行的一个或多个数据库操作中的第一个数据库操作。 当检测到对在特定行上操作的第二数据库操作的冲突时，一个或多个补偿动作（其可以但不限于是不同的数据库操作和/或创建冲突日志条目的操作）可以 被执行。 这里，第二数据库操作已经在特定时间之前在第二数据库中发生。 当要执行第二数据库操作时，可以执行适当的操作。