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

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

公开(公告)号：US09009104B2

公开(公告)日：2015-04-14

申请号：US12853991

申请日：2010-08-10

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

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

IPC分类号： G06F17/30

CPC分类号： G06F17/30368

摘要： Techniques for replicating data between database systems without taking checkpoints are provided. In an embodiment, a capture process restarts. Upon restarting, the capture process reestablishes an association with an apply process. A particular logical time maintained by the apply process is then communicated to the capture process. Upon receiving the particular logical time, the capture process restarts mining from this particular logical time.

摘要翻译： 提供了在不使用检查点的情况下在数据库系统之间复制数据的技术。 在一个实施例中，捕获过程重新启动。 重新启动后，捕获进程重新建立与应用进程的关联。 然后将应用过程维护的特定逻辑时间传达给捕获进程。 在接收到特定的逻辑时间之后，捕获过程从该特定逻辑时间重新启动挖掘。

公开(公告)号：US20110010392A1

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

申请号：US12853991

申请日：2010-08-10

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

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

IPC分类号： G06F17/30

CPC分类号： G06F17/30368

摘要： Techniques for replicating data between database systems without taking checkpoints are provided. In an embodiment, a capture process restarts. Upon restarting, the capture process reestablishes an association with an apply process. A particular logical time maintained by the apply process is then communicated to the capture process. Upon receiving the particular logical time, the capture process restarts mining from this particular logical time.

摘要翻译： 提供了在不使用检查点的情况下在数据库系统之间复制数据的技术。 在一个实施例中，捕获过程重新启动。 重新启动后，捕获进程重新建立与应用进程的关联。 然后将应用过程维护的特定逻辑时间传达给捕获进程。 在接收到特定的逻辑时间之后，捕获过程从该特定逻辑时间重新启动挖掘。

公开(公告)号：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更改。 当进程需要更改一行时，进程将使用基于表的共享状态的可变状态。

公开(公告)号：US08504522B2

公开(公告)日：2013-08-06

申请号：US13346188

申请日：2012-01-09

申请人： Jingwei Wu ,  Nimar S. Arora ,  Lik Wong

发明人： Jingwei Wu ,  Nimar S. Arora ,  Lik Wong

IPC分类号： G06F17/30

CPC分类号： G06F11/3495 ,  G06F11/3423 ,  G06F2201/80 ,  G06F2201/81 ,  G06F2201/86

摘要： A computer is programmed to parse a network that interconnects databases in a distributed database system, into a number of paths, wherein each path starts in a source database that is a source of changes and ends in a destination database that uses the changes to replicate the source database. The computer identifies databases that occur within each path in the network, and queries the identified databases to obtain statistics for each path. Statistics along each path are analyzed automatically, to identify a component in each path as a candidate for further investigation. The identified component may be marked as a bottleneck e.g. if there are no other paths connected to it. Alternatively the identified component may be a source of changes for another path that has a bottleneck or that has another candidate for further investigation. The identified bottleneck is displayed to the user with recommendations for improvement.

摘要翻译： 计算机被编程为解析将分布式数据库系统中的数据库互连到多个路径的网络，其中每个路径在作为变化源的源数据库中开始，并且在目的地数据库中结束，使用该变化来复制 源数据库。 计算机识别出现在网络中每个路径内的数据库，并查询已标识的数据库以获取每个路径的统计信息。 自动分析每个路径的统计信息，以便将每个路径中的一个组件标识为进一步调查的候选者。 识别的组件可以被标记为瓶颈，例如。 如果没有其他路径连接到它。 或者，所识别的组件可以是具有瓶颈或具有用于进一步调查的另一候选者的另一路径的变化源。 识别出的瓶颈将向用户显示，并提出改进建议。

公开(公告)号：US20120109889A1

公开(公告)日：2012-05-03

申请号：US13346188

申请日：2012-01-09

申请人： Jingwei Wu ,  Nimar S. Arora ,  Lik Wong

发明人： Jingwei Wu ,  Nimar S. Arora ,  Lik Wong

IPC分类号： G06F7/00

CPC分类号： G06F11/3495 ,  G06F11/3423 ,  G06F2201/80 ,  G06F2201/81 ,  G06F2201/86

摘要： A computer is programmed to parse a network that interconnects databases in a distributed database system, into a number of paths, wherein each path starts in a source database that is a source of changes and ends in a destination database that uses the changes to replicate the source database. The computer identifies databases that occur within each path in the network, and queries the identified databases to obtain statistics for each path. Statistics along each path are analyzed automatically, to identify a component in each path as a candidate for further investigation. The identified component may be marked as a bottleneck e.g. if there are no other paths connected to it. Alternatively the identified component may be a source of changes for another path that has a bottleneck or that has another candidate for further investigation. The identified bottleneck is displayed to the user with recommendations for improvement.

摘要翻译： 计算机被编程为解析将分布式数据库系统中的数据库互连到多个路径的网络，其中每个路径在作为变化源的源数据库中开始，并且在目的地数据库中结束，使用该变化来复制 源数据库。 计算机识别出现在网络中每个路径内的数据库，并查询已标识的数据库以获取每个路径的统计信息。 自动分析每个路径的统计信息，以便将每个路径中的一个组件标识为进一步调查的候选者。 所标识的组件可以被标记为瓶颈，例如，如果没有连接到其的路径。 或者，所识别的组件可以是具有瓶颈或具有用于进一步调查的另一候选者的另一路径的变化源。 识别出的瓶颈将向用户显示，并提出改进建议。