公开(公告)号：US07236993B2

公开(公告)日：2007-06-26

申请号：US10414027

申请日：2003-04-16

申请人： Archie W. Brown ,  Goutam D. Kulkarni ,  Joydip Kundu ,  Douglas Voss

发明人： Archie W. Brown ,  Goutam D. Kulkarni ,  Joydip Kundu ,  Douglas Voss

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

CPC分类号： G06F17/30595 ,  Y10S707/954 ,  Y10S707/99954

摘要： A method, system, and computer program product provides a data dictionary that can represent multiple versions of the schema objects, and which provides improved performance, reduced computing costs, and more accurate results in a variety of applications, such as in a database redo log mining system. A method of providing a data dictionary comprises the steps of determining whether information about the data object is present in a denormalized data dictionary history table, and if the information about the data object is not present in the denormalized data dictionary history table, then querying a normalized data dictionary to obtain the information about the data object, including a version identifier of the data object, and storing the version identifier and the obtained information about the data object including the version identifier in the denormalized data dictionary history table.

摘要翻译： 方法，系统和计算机程序产品提供了可以表示模式对象的多个版本的数据字典，并且其在多种应用中提供改进的性能，降低的计算成本和更准确的结果，例如在数据库重做日志 采矿系统。 提供数据字典的方法包括以下步骤：确定关于数据对象的信息是否存在于非规范化数据字典历史表中，如果关于数据对象的信息不存在于非规范化数据字典历史表中，则查询 归一化数据字典，以获得关于数据对象的信息，包括数据对象的版本标识符，以及将版本标识符和所获取的关于包括版本标识符的数据对象的信息存储在非规范化数据字典历史表中。

公开(公告)号：US07222136B1

公开(公告)日：2007-05-22

申请号：US10153034

申请日：2002-05-23

申请人： Archie W. Brown ,  Raymond Guzman ,  Richard L. Frank ,  Goutam D. Kulkarni ,  Joydip Kundu

发明人： Archie W. Brown ,  Raymond Guzman ,  Richard L. Frank ,  Goutam D. Kulkarni ,  Joydip Kundu

IPC分类号： G06F17/30

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

摘要： A system, method, and computer program product communicate data dictionary information of database objects through a redo stream in the form of metadata, which provides the association between the internal numbers used by a database schema to identify database objects and the corresponding user-defined names of the database objects, in the redo stream itself, so that the association information may be easily and quickly used in the analysis of the redo stream of the database transactions. A method of communicating data dictionary information of database objects through a redo stream comprises the steps of performing a change to a first database data table, logging redo information representing the change to the first database data table to a redo stream, and logging information relating to internal identifier mapping information associated with the first database data table to the redo stream.

摘要翻译： 系统，方法和计算机程序产品通过元数据形式的重做流传送数据库对象的数据字典信息，这提供了数据库模式使用的内部数字之间的关联，以识别数据库对象和相应的用户定义的名称 的数据库对象，在重做流本身中，使得关联信息可以容易且快速地用于分析数据库事务的重做流。 通过重做流传送数据库对象的数据字典信息的方法包括以下步骤：对第一数据库数据表执行改变，将表示第一数据库数据表的改变的重做信息记录到重做流，以及记录与 与第一个数据库数据表相关联的内部标识符映射信息到重做流。

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

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

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

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

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

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

公开(公告)号：US20090157764A1

公开(公告)日：2009-06-18

申请号：US11954583

申请日：2007-12-12

申请人： 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分类号： G06F17/30

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.

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

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

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

公开(公告)号：US08676752B2

公开(公告)日：2014-03-18

申请号：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 ,  G06F17/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.

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

公开(公告)号：US08086564B2

公开(公告)日：2011-12-27

申请号：US11954583

申请日：2007-12-12

申请人： 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 ,  G06F17/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.

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

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

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