公开(公告)号：US08880480B2

公开(公告)日：2014-11-04

申请号：US11649180

申请日：2007-01-03

申请人： Joydip Kundu ,  Archie W. Brown ,  Douglas A. Voss ,  Qinqin Wang

发明人： Joydip Kundu ,  Archie W. Brown ,  Douglas A. Voss ,  Qinqin Wang

IPC分类号： G06F17/30 ,  G06F11/14 ,  G06F11/16

CPC分类号： G06F11/1471 ,  G06F11/1662 ,  G06F17/30368 ,  G06F17/30575 ,  G06F2201/80 ,  G06F2201/84 ,  Y10S707/99953

摘要： A database rollback processor allows rollback, or rewind, of the data and metadata to a point at which a failover or other metadata change occurred, therefore “rewinding” the metadata to a previous consistent point. The rollback processor identifies transaction entries in a redo log resulting in changes to the metadata. The changes are identified backward to a target recovery time. Transactions affecting the metadata are stored in a stack. The transactions are then backed out of the metadata according to the stack to restore the metadata to the state at the target recovery time. Data changes from the redo log may then be applied to the corresponding metadata as it existed at the target recovery time. Since the target recovery time is not bound by the timing of the snapshots, but rather may be at an arbitrary point chosen as the target recovery time, a failover, replication or recovery operation need not rely on the snapshot time.

摘要翻译： 数据库回滚处理器允许将数据和元数据回滚或倒回到发生故障转移或其他元数据更改的点，从而将元数据“倒回”到先前的一致点。 回滚处理器识别重做日志中的事务条目，导致元数据的更改。 这些更改被确定为目标恢复时间。 影响元数据的事务存储在堆栈中。 然后根据堆栈将事务从元数据中退出，以将元数据恢复到目标恢复时间的状态。 然后可以将重做日志中的数据更改应用于目标恢复时间所存在的相应元数据。 由于目标恢复时间不受快照的定时约束，而是可能在选定为目标恢复时间的任意点，故障切换，复制或恢复操作不需要依赖快照时间。

公开(公告)号：US20070192384A1

公开(公告)日：2007-08-16

申请号：US11347081

申请日：2006-02-02

申请人： Neeraj Shodhan ,  Qinqin Wang ,  Lik Wong ,  Joydip Kundu

发明人： Neeraj Shodhan ,  Qinqin Wang ,  Lik Wong ,  Joydip Kundu

IPC分类号： G06F17/30

CPC分类号： G06F17/30368

摘要： Computer-implemented methods and computer systems for automatically managing stored checkpoint data are described. The method includes accessing a first user defined time period. The first user defined time period is related to a plurality of stored checkpoint data, and each checkpoint data of the plurality of stored checkpoint data has an associated storage time. Further, the method includes identifying a first set of checkpoint data having storage times that are within the first user defined time period. Moreover, the method includes identifying a second set of checkpoint data having storage times that are older than the first user defined time period. In addition, the method includes pruning the second set of checkpoint data according to a user specified process in proportion to storage time of each checkpoint data of the second set of checkpoint data. The older stored checkpoint data is more heavily pruned over recent stored checkpoint data.

摘要翻译： 描述了用于自动管理存储的检查点数据的计算机实现的方法和计算机系统。 该方法包括访问第一用户定义的时间段。 第一用户定义的时间段与多个存储的检查点数据相关，并且多个存储的检查点数据的每个检查点数据具有相关联的存储时间。 此外，该方法包括识别具有在第一用户定义的时间段内的存储时间的第一组检查点数据。 此外，该方法包括识别具有比第一用户定义的时间段更早的存储时间的第二组检查点数据。 此外，该方法包括根据用户指定的处理与第二组检查点数据的每个检查点数据的存储时间成比例地修剪第二组检查点数据。 较旧的存储检查点数据比最近存储的检查点数据更严格地修剪。

公开(公告)号：US20060004838A1

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

申请号：US10918023

申请日：2004-08-12

申请人： Neeraj Shodhan ,  Goutam Kulkarni ,  Lewis Kaplan ,  Anand Lakshminath ,  Yuhong Gu ,  Joydip Kundu

发明人： Neeraj Shodhan ,  Goutam Kulkarni ,  Lewis Kaplan ,  Anand Lakshminath ,  Yuhong Gu ,  Joydip Kundu

IPC分类号： G06F17/00

CPC分类号： G06F16/2219

摘要： A system and method for efficiently sharing Large Objects (LOBs) is disclosed. Historical records (e.g., redo logs) are kept in which a marker is placed prior to the LOB. The marker includes identifying information, such as the row-column intersection. Using the identifying information in the marker, the LOB may be shared with other systems without staging the LOB at a source database system, prior to transporting the LOB from the source database system to the destination database system. Additionally, using the identifying information, the LOB may be accessed and manipulated prior to being consumed at the destination system.

摘要翻译： 公开了一种高效共享大对象（LOB）的系统和方法。 历史记录（例如，重做日志）保留在LOB之前放置标记的历史记录。 标记包括标识信息，例如行列交点。 在将LOB从源数据库系统传送到目的数据库系统之前，使用标记中的识别信息，LOB可以与其他系统共享，而不会在源数据库系统上分段LOB。 另外，使用识别信息，可以在目的地系统被消费之前访问和操纵LOB。

公开(公告)号：US20050262170A1

公开(公告)日：2005-11-24

申请号：US10927927

申请日：2004-08-27

申请人： Mahesh Girkar ,  Benedicto Garin ,  Joydip Kundu

发明人： Mahesh Girkar ,  Benedicto Garin ,  Joydip Kundu

IPC分类号： G06F17/30

CPC分类号： G06F17/30575

摘要： A method and apparatus for applying changes to a standby database in real-time is provided. According to one aspect, a change is applied to data contained in a standby database. The standby database functions as a replica of a primary database. The primary database has a current online redo log file to which a particular redo block was written. According to one aspect, prior to the archiving of the current online redo log file, the particular redo block is received at a process associated with the standby database. A change indicated by the particular redo block is applied to the data contained in the standby database.

摘要翻译： 提供了一种用于对实时数据库进行更改的方法和装置。 根据一个方面，对备用数据库中包含的数据应用更改。 备用数据库用作主数据库的副本。 主数据库具有写入特定重做块的当前在线重做日志文件。 根据一个方面，在存档当前在线重做日志文件之前，在与备用数据库相关联的进程处接收到特定重做块。 由特定重做块指示的更改应用于备用数据库中包含的数据。

公开(公告)号：US20120059792A1

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

申请号：US13292918

申请日：2011-11-09

申请人： Joydip Kundu ,  Anthony Adams ,  Goutam Kulkarni ,  Roger MacNicol ,  Douglas Voss ,  Qinqin Wang

发明人： Joydip Kundu ,  Anthony Adams ,  Goutam Kulkarni ,  Roger MacNicol ,  Douglas Voss ,  Qinqin Wang

IPC分类号： G06F7/00

CPC分类号： G06F17/30415 ,  G06F17/30368 ,  G06F17/30575

摘要： A method and system that annotates a redo log to provide information concerning the execution of a procedure at a primary database. The annotations include entry and exit markers that indicate the beginning and the end of the execution along with any arguments passed to the procedure, and whether the execution of the procedure was successful. At the standby database, these markers are used to create a logical transaction associated with the procedure. The operations performed by the procedure are grouped into individual transactions, and these individual transactions are grouped as belonging to the logical transaction. If the execution of the procedure was successful at the primary database, then the individual transactions are discarded, and the logical transaction is applied by executing the procedure at the standby database. If the execution of the procedure failed at the primary database, then the individual transactions and the logical transaction are discarded.

摘要翻译： 注释重做日志以提供有关在主数据库中执行过程的信息的方法和系统。 注释包括表示执行的开始和结束以及传递给过程的任何参数的进入和退出标记以及该过程的执行是否成功。 在备用数据库中，这些标记用于创建与该过程相关联的逻辑事务。 由过程执行的操作被分组为单个事务，并且这些单个事务被分组为属于逻辑事务。 如果在主数据库中执行该过程成功，则会丢弃各个事务，并通过在备用数据库中执行该过程来应用逻辑事务。 如果程序的执行在主数据库中失败，则会丢弃各个事务和逻辑事务。

公开(公告)号：US20080162590A1

公开(公告)日：2008-07-03

申请号：US11649180

申请日：2007-01-03

申请人： Joydip Kundu ,  Archie W. Brown ,  Douglas A. Voss ,  Qinqin Wang

发明人： Joydip Kundu ,  Archie W. Brown ,  Douglas A. Voss ,  Qinqin Wang

IPC分类号： G06F17/30

CPC分类号： G06F11/1471 ,  G06F11/1662 ,  G06F17/30368 ,  G06F17/30575 ,  G06F2201/80 ,  G06F2201/84 ,  Y10S707/99953

摘要： A database rollback processor allows rollback, or rewind, of the data and metadata to a point at which a failover or other metadata change occurred, therefore “rewinding” the metadata to a previous consistent point. The rollback processor identifies transaction entries in a redo log resulting in changes to the metadata. The changes are identified backward to a target recovery time. Transactions affecting the metadata are stored in a stack. The transactions are then backed out of the metadata according to the stack to restore the metadata to the state at the target recovery time. Data changes from the redo log may then be applied to the corresponding metadata as it existed at the target recovery time. Since the target recovery time is not bound by the timing of the snapshots, but rather may be at an arbitrary point chosen as the target recovery time, a failover, replication or recovery operation need not rely on the snapshot time.

摘要翻译： 数据库回滚处理器允许将数据和元数据回滚或倒回到发生故障转移或其他元数据更改的点，从而将元数据“倒回”到先前的一致点。 回滚处理器识别重做日志中的事务条目，导致元数据的更改。 这些更改被确定为目标恢复时间。 影响元数据的事务存储在堆栈中。 然后根据堆栈将事务从元数据中退出，以将元数据恢复到目标恢复时间的状态。 然后可以将重做日志中的数据更改应用于目标恢复时间所存在的相应元数据。 由于目标恢复时间不受快照的定时约束，而是可能在选定为目标恢复时间的任意点，故障切换，复制或恢复操作不需要依赖快照时间。

公开(公告)号：US07082435B1

公开(公告)日：2006-07-25

申请号：US09476141

申请日：2000-01-03

申请人： Raymond Guzman ,  Goutam D. Kulkarni ,  Joydip Kundu

发明人： Raymond Guzman ,  Goutam D. Kulkarni ,  Joydip Kundu

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  Y10S707/99939 ,  Y10S707/99943 ,  Y10S707/99944

摘要： The present invention is directed to a method and mechanism for encoding multiple virtual tables into one or more source tables. An aspect of the invention is directed to the access of a virtual table virtual table without requiring separate entries for the virtual table in the meta-data of a database system. Another aspect of the invention is directed to a virtual table that has different column signatures than its underlying source table(s).

摘要翻译： 本发明涉及用于将多个虚拟表编码成一个或多个源表的方法和机制。 本发明的一个方面涉及虚拟表虚拟表的访问，而不需要数据库系统的元数据中的虚拟表的单独条目。 本发明的另一方面涉及具有与其底层源表不同的列签名的虚拟表。

公开(公告)号：US06871222B1

公开(公告)日：2005-03-22

申请号：US09321090

申请日：1999-05-28

申请人： Richard L. Frank ,  Michael J. Cusson ,  Joydip Kundu ,  Daniel E. O'Shaughnessy

发明人： Richard L. Frank ,  Michael J. Cusson ,  Joydip Kundu ,  Daniel E. O'Shaughnessy

IPC分类号： G06F12/00

CPC分类号： H04L67/1097 ,  G06F11/1425 ,  G06F11/2035 ,  G06F11/2046 ,  G06F17/30194

摘要： A quorumless network cluster provides a highly available system by addressing the partition-in-space and partition-in-time problems in network clusters. In a particular solution, a cluster manager (CM) can use disk based messaging to manage the operation of the cluster. Each node within the cluster must have access to a shared disk to operate within the cluster. A particular methodology can operate the cluster in a closed loop between nodes 1 to N. If a node fails to receive a heartbeat message from its predecessor in the loop, it initiates a cluster reconfiguration by sending a reconfiguration message to each other node in the cluster.

摘要翻译： 无间网络集群通过解决网络集群中的分区空间和分时问题来提供高可用性的系统。 在特定的解决方案中，集群管理器（CM）可以使用基于磁盘的消息传递来管理集群的操作。 集群内的每个节点必须能够访问共享磁盘才能在集群内运行。 特定的方法可以在节点1到N之间的闭环中操作集群。如果节点未能在其循环中从其前身接收到心跳消息，则通过向集群中的每个其他节点发送重新配置消息来启动集群重新配置 。

公开(公告)号：US07890466B2

公开(公告)日：2011-02-15

申请号：US10414591

申请日：2003-04-16

申请人： Joydip Kundu ,  Qinqin Wang ,  Goutam Kulkarni

发明人： Joydip Kundu ,  Qinqin Wang ,  Goutam Kulkarni

IPC分类号： G06F7/00

CPC分类号： G06F17/30368

摘要： Techniques for making light-weight checkpoints in logs of streams of transactions and for extending the logs from the checkpoints. The state saved in the light weight checkpoint need only include the state of all transactions that are active at a prior point in the log and are still active at the checkpoint. A log is extended from the checkpoint by processing new transactions in the transaction stream beginning at the prior point to produce the extending log. When the checkpoint is reached, the state saved at the checkpoint is used to continue to produce the extending log. Techniques are further disclosed for selecting points in the stream of transactions at which the checkpoints may be made and for determining the distance between checkpoints. As disclosed, the log in which the checkpoints are used is a logical log made from a physical log produced by a relational database system. The logical log may be used for replication and for data mining.

摘要翻译： 在事务流日志中制作轻量级检查点以及从检查点扩展日志的技术。 保存在轻量级检查点中的状态仅需包含在日志中的先前点处于活动状态的所有事务的状态，并且在检查点仍然处于活动状态。 通过处理从先前点开始的事务流中的新事务，从检查点扩展日志以生成扩展日志。 当到达检查点时，使用保存在检查点的状态继续生成扩展日志。 进一步公开了用于选择可以进行检查点的事务流中的点并确定检查点之间的距离的技术。 如所公开的，使用检查点的日志是由关系数据库系统生成的物理日志制成的逻辑日志。 逻辑日志可用于复制和数据挖掘。

公开(公告)号：US07617254B2

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

申请号：US10635708

申请日：2003-08-05

申请人： Juan R. Loaiza ,  Richard L. Frank ,  Joydip Kundu ,  Michael J. Cusson ,  Dan O'Shaughnessy

发明人： Juan R. Loaiza ,  Richard L. Frank ,  Joydip Kundu ,  Michael J. Cusson ,  Dan O'Shaughnessy

IPC分类号： G06F12/00

CPC分类号： G06F17/30368 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99953

摘要： The present invention is directed to a method and mechanism for accessing recovery log information in a database system. The data stored in the recovery log is presented as a relational database “view,” which can be queried and accessed using relational database statements even though the underlying recovery log data may be stored in a non-relational format. According to an aspect of the invention, the recovery log data is thus encapsulated by the view presented to users of that data.

摘要翻译： 本发明涉及用于访问数据库系统中的恢复日志信息的方法和机制。 存储在恢复日志中的数据被呈现为关系数据库“视图”，其可以使用关系数据库语句来查询和访问，即使基础恢复日志数据可以以非关系格式存储。 根据本发明的一个方面，恢复日志数据因此被呈现给该数据的用户的视图来封装。