公开(公告)号：US20090037494A1

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

申请号：US11831447

申请日：2007-07-31

申请人： Lik Wong ,  Nimar S. Arora ,  Cristina Schmidt ,  Lei Gao ,  Thuvan Hoang

发明人： Lik Wong ,  Nimar S. Arora ,  Cristina Schmidt ,  Lei Gao ,  Thuvan Hoang

IPC分类号： G06F17/30

CPC分类号： G06F17/30368

摘要： A checkpoint free log mining mechanism comprising a capture process and an apply process that are logically associated with each other may be provided in a database system. In an embodiment, log mining information published by the capture process to the apply process comprises a complete set of log information for each interesting transaction. A system change number of a start transaction record of a transaction may be used to represent a start time of the entire transaction. The capture and apply processes may work cooperatively to establish a safe time point in the form of a particular system change number in logs to begin mining, under various circumstances such as in an initial startup state, in a steady state, in a process restart scenario in the middle of checkpoint free log mining, or in a transition between the checkpoint mode and the checkpoint free mode.

摘要翻译： 可以在数据库系统中提供包括彼此逻辑地相关联的捕获进程和应用进程的无检查点日志挖掘机制。 在一个实施例中，由捕获过程发布到应用过程的日志挖掘信息包括用于每个有趣事务的一整套日志信息。 可以使用事务的开始事务记录的系统改变号来表示整个事务的开始时间。 捕获和应用过程可以协同工作，以在日志中的特定系统改变号的形式建立安全时间点，以在稳定状态的各种情况下，在过程重启场景中开始挖掘 在检查点免费日志挖掘中，或在检查点模式和检查点自由模式之间的转换。

公开(公告)号：US07801852B2

公开(公告)日：2010-09-21

申请号：US11831447

申请日：2007-07-31

申请人： Lik Wong ,  Nimar S. Arora ,  Cristina Schmidt ,  Lei Gao ,  Thuvan Hoang

发明人： Lik Wong ,  Nimar S. Arora ,  Cristina Schmidt ,  Lei Gao ,  Thuvan Hoang

IPC分类号： G06F17/30

CPC分类号： G06F17/30368

摘要： A checkpoint free log mining mechanism comprising a capture process and an apply process that are logically associated with each other may be provided in a database system. In an embodiment, log mining information published by the capture process to the apply process comprises a complete set of log information for each interesting transaction. A system change number of a start transaction record of a transaction may be used to represent a start time of the entire transaction. The capture and apply processes may work cooperatively to establish a safe time point in the form of a particular system change number in logs to begin mining, under various circumstances such as in an initial startup state, in a steady state, in a process restart scenario in the middle of checkpoint free log mining, or in a transition between the checkpoint mode and the checkpoint free mode.

摘要翻译： 可以在数据库系统中提供包括彼此逻辑地相关联的捕获进程和应用进程的无检查点日志挖掘机制。 在一个实施例中，由捕获过程发布到应用过程的日志挖掘信息包括用于每个有趣事务的一整套日志信息。 可以使用事务的开始事务记录的系统改变号来表示整个事务的开始时间。 捕获和应用过程可以协同工作，以在日志中的特定系统改变号的形式建立安全时间点，以在稳定状态的各种情况下，在过程重启场景中开始挖掘 在检查点免费日志挖掘中，或在检查点模式和检查点自由模式之间的转换。

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

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

公开(公告)号：US20080281846A1

公开(公告)日：2008-11-13

申请号：US11801930

申请日：2007-05-11

申请人： Thuvan Hoang ,  Anthony Giardullo ,  Amit Ganesh ,  Nimar S. Arora ,  Dheeraj Pandey ,  Lik Wong

发明人： Thuvan Hoang ,  Anthony Giardullo ,  Amit Ganesh ,  Nimar S. Arora ,  Dheeraj Pandey ,  Lik Wong

IPC分类号： G06F17/30

CPC分类号： G06F17/30377

摘要： Performing an operation directly on data stored in a database table provides for avoiding generation and processing of SQL statements. A Data Layer interface, comprising a set of APIs, allows internal database server components to call directly to the Data Layer for making fast row changes to a table. According to an embodiment, before making any row change to a table through this Data Layer interface, a shared state data structure is created to hold the metadata about the table. A single shared state can be used for all DML changes to a particular table regardless of what columns are updated or inserted during each DML operation. When a process needs to change a row, the process uses a mutable state based on the shared state of the table.

摘要翻译： 直接对存储在数据库表中的数据执行操作可避免SQL语句的生成和处理。 包含一组API的数据层接口允许内部数据库服务器组件直接调用数据层，以便对表进行快速行更改。 根据实施例，在通过该数据层接口对表进行任何行更改之前，创建共享状态数据结构以保存关于表的元数据。 无论在每个DML操作期间更新或插入哪些列，单个共享状态可用于对特定表的所有DML更改。 当进程需要更改一行时，进程将使用基于表的共享状态的可变状态。

公开(公告)号：US07769789B2

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

申请号：US11801930

申请日：2007-05-11

申请人： Thuvan Hoang ,  Anthony Giardullo ,  Amit Ganesh ,  Nimar S. Arora ,  Dheeraj Pandey ,  Lik Wong

发明人： Thuvan Hoang ,  Anthony Giardullo ,  Amit Ganesh ,  Nimar S. Arora ,  Dheeraj Pandey ,  Lik Wong

IPC分类号： G06F7/00

CPC分类号： G06F17/30377

摘要： Performing an operation directly on data stored in a database table provides for avoiding generation and processing of SQL statements. A Data Layer interface, comprising a set of APIs, allows internal database server components to call directly to the Data Layer for making fast row changes to a table. According to an embodiment, before making any row change to a table through this Data Layer interface, a shared state data structure is created to hold the metadata about the table. A single shared state can be used for all DML changes to a particular table regardless of what columns are updated or inserted during each DML operation. When a process needs to change a row, the process uses a mutable state based on the shared state of the table.

摘要翻译： 直接对存储在数据库表中的数据执行操作可避免SQL语句的生成和处理。 包含一组API的数据层接口允许内部数据库服务器组件直接调用数据层，以便对表进行快速行更改。 根据实施例，在通过该数据层接口对表进行任何行更改之前，创建共享状态数据结构以保存关于表的元数据。 无论在每个DML操作期间更新或插入哪些列，单个共享状态可用于对特定表的所有DML更改。 当进程需要更改一行时，进程将使用基于表的共享状态的可变状态。

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

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

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

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

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

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