公开(公告)号：US07571173B2

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

申请号：US10966961

申请日：2004-10-15

Applicant: Wanli Yang ,  Bipul Sinha ,  Amit Ganesh ,  Wei Hu ,  Alok Pareek ,  Alexander H. Hwang ,  Steven Charles Wertheimer ,  Francisco M. Sanchez ,  Dmitry Mikhailovich Potapov ,  Shen-Ban Meng ,  Juan R. Loaiza ,  William H. Bridge ,  J. William Lee

Inventor： Wanli Yang ,  Bipul Sinha ,  Amit Ganesh ,  Wei Hu ,  Alok Pareek ,  Alexander H. Hwang ,  Steven Charles Wertheimer ,  Francisco M. Sanchez ,  Dmitry Mikhailovich Potapov ,  Shen-Ban Meng ,  Juan R. Loaiza ,  William H. Bridge ,  J. William Lee

IPC: G06F7/00

CPC classification number: G06F17/30569 ,  Y10S707/99942

Abstract: A method and apparatus for creating a target database on a target platform based on a source database on a source platform is provided. A target database is created on the target platform based on data, metadata (for example, data in the system tablespace and control files), and external objects (for example, password files and externally stored tables) comprised within the source database. Data and metadata stored in tablespaces of the source database are converted to the format compatible with the target platform. The conversion of the data and metadata may be performed either at the source database or the target database. Redo information and undo information of the source database are not copied from the source database to the target database. Certain files, e.g., a password files, and links to externally stored object may be recreated on the target database.

Abstract translation: 提供了一种用于在源平台上基于源数据库在目标平台上创建目标数据库的方法和装置。 基于源数据库中包含的数据，元数据（例如，系统表空间和控制文件中的数据）以及外部对象（例如，密码文件和外部存储的表），在目标平台上创建目标数据库。 存储在源数据库的表空间中的数据和元数据将转换为与目标平台兼容的格式。 可以在源数据库或目标数据库执行数据和元数据的转换。 源数据库的重做信息和撤消信息不会从源数据库复制到目标数据库。 可以在目标数据库上重新创建某些文件，例如密码文件和到外部存储对象的链接。

公开(公告)号：US20090106327A1

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

申请号：US12253897

申请日：2008-10-17

Applicant: Mark Dilman ,  Michael James Stewart ,  Wei-Ming Hu ,  Alok Pareek ,  Lawrence HinLuen To, JR. ,  Vinay H. Srihari

Inventor： Mark Dilman ,  Michael James Stewart ,  Wei-Ming Hu ,  Alok Pareek ,  Lawrence HinLuen To, JR. ,  Vinay H. Srihari

IPC: G06F17/30

CPC classification number: G06F11/0727 ,  G06F11/0793 ,  G06F11/1004 ,  G06F11/1469 ,  G06F11/1471 ,  G06F11/327

Abstract: A computer is programmed to identify failures and perform recovery of data. Specifically, in several embodiments, the computer is programmed to automatically check integrity of data in a storage structure to identify a set of failures related to the storage structure. The computer is further programmed in some embodiments to identify, based on one failure in the set of failures, a group of repairs to fix that one failure. Each repair in the group of repairs is alternative to another repair in the group. The computer is also programmed in some embodiments to execute at least one repair in the group of repairs, so as to generate corrected data to fix the one failure. In certain embodiments, the corrected data is stored in non-volatile storage media of the computer.

Abstract translation: 计算机被编程为识别故障并执行数据恢复。 具体地，在几个实施例中，计算机被编程为自动检查存储结构中的数据的完整性以识别与存储结构相关的一组故障。 在一些实施例中，计算机被进一步编程，以基于该组故障中的一个故障来识别修复该一个故障的一组修复。 维修组中的每个维修都是组中另一个维修的替代方案。 在一些实施例中，计算机也被编程为在维修组中执行至少一个修复，以便产生校正数据以修复一个故障。 在某些实施例中，校正的数据被存储在计算机的非易失性存储介质中。

公开(公告)号：US07039773B2

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

申请号：US10426471

申请日：2003-04-29

Applicant: Wei Ming Hu ,  Juan R. Loaiza ,  Roger J. Bamford ,  Vikram Joshi ,  Arvind Nithrakashyap ,  Tudor Bosman ,  Vinay Srihari ,  Alok Pareek

Inventor： Wei Ming Hu ,  Juan R. Loaiza ,  Roger J. Bamford ,  Vikram Joshi ,  Arvind Nithrakashyap ,  Tudor Bosman ,  Vinay Srihari ,  Alok Pareek

IPC: G06F12/00

CPC classification number: G06F17/30595 ,  Y10S707/99953

Abstract: An improved method, mechanism, and system for implementing, generating, and maintaining records, such as redo records and redo logs in a database system, are disclosed. Multiple sets of records may be created and combined into a partially ordered (or non-ordered) group of records, which are later collectively ordered or sorted as needed to create an fully ordered set of records. With respect to a database system, redo generation bottleneck is minimized by providing multiple in-memory redo buffers that are available to hold redo records generated by multiple threads of execution. When the in-memory redo buffers are written to a persistent storage medium, no specific ordering needs to be specified with respect to the redo records from the different in-memory redo buffers. While the collective group of records may not be ordered, the written-out redo records may be partially ordered based upon the ordered redo records from within individual in-memory redo buffers. At recovery, ordering and/or merging of redo records may occur to satisfy database consistency requirements.

Abstract translation: 公开了一种用于在数据库系统中实现，生成和维护记录（如重做记录和重做日志）的改进方法，机制和系统。 可以创建多组记录，并将其组合成部分有序（或非有序）的记录组，这些记录集合随后根据需要进行统一排序或排序以创建完全有序的记录集。 对于数据库系统，通过提供多个可用于保存由多个执行线程生成的重做记录的内存中重做缓冲区，可以使重做生成瓶颈最小化。 当内存中重做缓冲区被写入持久存储介质时，不需要针对来自不同内存中重做缓冲区的重做记录指定特定顺序。 虽然可能不会对集体记录进行排序，但是写出的重做记录可能会根据内部存储器重做缓冲区内的重做记录进行部分排序。 在恢复时，可能会发生重做记录的排序和/或合并，以满足数据库一致性要求。

公开(公告)号：US20050253739A1

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

申请号：US10966679

申请日：2004-10-14

Applicant: Wei Hu ,  Alexander Hwang ,  Shen-Ban Meng ,  Alok Pareek ,  Dmitry Potapov ,  Francisco Sanchez

Inventor： Wei Hu ,  Alexander Hwang ,  Shen-Ban Meng ,  Alok Pareek ,  Dmitry Potapov ,  Francisco Sanchez

IPC: G06F12/00 ,  G06F17/30

CPC classification number: G06F17/30569

Abstract: Stored data, such as tablespaces, are transported between different systems having different platforms by converting the format of the stored data into a common format either before or after transmitting the stored data from the source database system to the target database system. The common format may be a format that is universal in that the common format is not machine dependent. The stored data may be kept in the common format at the target database system and never converted to another format. Optionally, the stored data may be converted from the common format to a format associated with the target database system, thereby facilitating backward compatibility. A tool may be provided for performing the conversion. In an embodiment each of the target and source database systems have a copy of the tool.

Abstract translation: 通过将存储的数据从源数据库系统发送到目标数据库系统之前或之后将所存储的数据的格式转换成通用格式，将诸如表空间的存储的数据传送到具有不同平台的不同系统之间。 通用格式可以是通用的格式，因为通用格式不依赖于机器。 存储的数据可以在目标数据库系统中保持为通用格式，并且不会转换为另一种格式。 可选地，存储的数据可以从公共格式转换成与目标数据库系统相关联的格式，从而有助于向后兼容。 可以提供用于执行转换的工具。 在一个实施例中，目标和源数据库系统中的每一个具有工具的副本。

公开(公告)号：US08429121B2

公开(公告)日：2013-04-23

申请号：US12969012

申请日：2010-12-15

Applicant: Alok Pareek ,  Eric Ian Fish

Inventor： Alok Pareek ,  Eric Ian Fish

IPC: G06F17/30

CPC classification number: G06F11/2097 ,  G06F11/1466 ,  G06F11/1662

Abstract: A method of processing data includes identifying a capture redo byte address, initiating a capture process at the capture redo byte address, creating a clone of a source database to a logical change number, and initiating an apply process at a target database.

Abstract translation: 处理数据的方法包括识别捕获重做字节地址，在捕获重做字节地址处发起捕获处理，将源数据库的克隆创建为逻辑更改号，以及在目标数据库上启动应用进程。

公开(公告)号：US20120030172A1

公开(公告)日：2012-02-02

申请号：US13077760

申请日：2011-03-31

Applicant: Alok Pareek ,  Mahadevan Lakshminarayanan ,  Avinash Dubey ,  Scott Corbin

Inventor： Alok Pareek ,  Mahadevan Lakshminarayanan ,  Avinash Dubey ,  Scott Corbin

IPC: G06F17/30 ,  G06F7/00

CPC classification number: G06F17/30575 ,  G06F11/1471 ,  G06F11/2094 ,  G06F11/2097 ,  G06F17/30067 ,  G06F17/30581 ,  G06F17/30657

Abstract: A system and method for transferring data between different types of systems, and in particular uses log-based replication to transfer data between, e.g. a MySQL database or system, and another type of database or system. In accordance with an embodiment, the system can be used to perform a one-time or initial copy of the MySQL data from a source database system to a target database system, and/or to replicate the on-going transactions captured from a MySQL database's binary log into one or additional non-MySQL database(s) on a continuous basis, such that the two systems are synchronized for transactions of interest. In accordance with an embodiment, full or partial data changes can be extracted from the MySQL binary log, optionally transformed, skipped or augmented, output or written to a file (which in accordance with an embodiment can be implemented as a trail file, or an Oracle GoldenGate trail file), and then applied at any of one or more target systems (e.g. another MySQL database, or a non-MySQL database), thereby synchronizing the source and target systems.

Abstract translation: 用于在不同类型的系统之间传送数据的系统和方法，特别是使用基于日志的复制来在数据之间传送数据。 一个MySQL数据库或系统，另一种类型的数据库或系统。 根据一个实施例，该系统可用于执行MySQL数据从源数据库系统到目标数据库系统的一次性或初始拷贝，和/或复制从MySQL数据库的 二进制日志记录到一个或另外的非MySQL数据库中，以使两个系统为感兴趣的事务同步。 根据实施例，可以从MySQL二进制日志中提取全部或部分数据改变，可选地变换，跳过或扩充，输出或写入文件（根据实施例可以将其实现为跟踪文件，或者 Oracle GoldenGate跟踪文件），然后应用于一个或多个目标系统（例如另一个MySQL数据库或非MySQL数据库）中的任何一个，从而同步源和目标系统。

公开(公告)号：US07885922B2

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

申请号：US11551678

申请日：2006-10-20

Applicant: Alok Pareek ,  Eric Ian Fish

Inventor： Alok Pareek ,  Eric Ian Fish

IPC: G06F17/30

CPC classification number: G06F11/2097 ,  G06F11/1466 ,  G06F11/1662

Abstract: A method of processing data includes identifying a capture redo byte address, initiating a capture process at the capture redo byte address, creating a clone of a source database to a logical change number, and initiating an apply process at a target database.

Abstract translation: 处理数据的方法包括识别捕获重做字节地址，在捕获重做字节地址处发起捕获处理，将源数据库的克隆创建为逻辑更改号，以及在目标数据库上启动应用进程。

公开(公告)号：US09251311B2

公开(公告)日：2016-02-02

申请号：US13077800

申请日：2011-03-31

Applicant: Shenoda Guirguis ,  Alok Pareek ,  Stephen Wilkes

Inventor： Shenoda Guirguis ,  Alok Pareek ,  Stephen Wilkes

IPC: G06F19/00 ,  G06F21/62 ,  G06F17/30

Abstract: A system and method for providing transactional data privacy while maintaining data usability, including the use of different obfuscation functions for different data types to securely obfuscate the data, in real-time, while maintaining its statistical characteristics. In accordance with an embodiment, the system comprises an obfuscation process that captures data while it is being received in the form of data changes at a first or source system, selects one or more obfuscation techniques to be used with the data according to the type of data captured, and obfuscates the data, using the selected one or more obfuscation techniques, to create an obfuscated data, for use in generating a trail file containing the obfuscated data, or applying the data changes to a target or second system.

公开(公告)号：US08650155B2

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

申请号：US12037761

申请日：2008-02-26

Applicant: Scott Roger Corbin ,  Joel Shepherd ,  Alok Pareek ,  Chris McAllister

Inventor： Scott Roger Corbin ,  Joel Shepherd ,  Alok Pareek ,  Chris McAllister

IPC: G06F7/00

CPC classification number: G06F9/466 ,  G06F17/30368 ,  G06F17/30377 ,  G06F17/30545

Abstract: A computer readable storage medium includes executable instructions to read source node transaction logs to capture transaction data, including local transaction data, global transaction identifiers and participating node data. The global transaction identifiers and participating node data are stored in target node queues. The target node queues are accessed to form global transaction data. Target tables are constructed based upon the local transaction data and the global transaction data.

Abstract translation: 计算机可读存储介质包括用于读取源节点事务日志以捕获交易数据（包括本地事务数据，全局事务标识符和参与节点数据）的可执行指令。 全局事务标识符和参与节点数据存储在目标节点队列中。 访问目标节点队列以形成全局事务数据。 目标表基于本地事务数据和全局事务数据构建。

公开(公告)号：US08510270B2

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

申请号：US13077760

申请日：2011-03-31

Applicant: Alok Pareek ,  Mahadevan Lakshminarayanan ,  Avinash Dubey ,  Scott Corbin

Inventor： Alok Pareek ,  Mahadevan Lakshminarayanan ,  Avinash Dubey ,  Scott Corbin

IPC: G06F7/00 ,  G06F17/00

CPC classification number: G06F17/30575 ,  G06F11/1471 ,  G06F11/2094 ,  G06F11/2097 ,  G06F17/30067 ,  G06F17/30581 ,  G06F17/30657

Abstract: A system and method for transferring data between different types of systems, and in particular uses log-based replication to transfer data between different types of systems. In accordance with an embodiment, the system can be used to perform a one-time or initial copy of the MySQL data from a source database system to a target database system, and/or to replicate the on-going transactions captured from a MySQL database's binary log into one or additional non-MySQL database(s) on a continuous basis, such that the two systems are synchronized for transactions of interest. In accordance with an embodiment, full or partial data changes can be extracted from the MySQL binary log, optionally transformed, skipped or augmented, output or written to a file, and then applied at any of one or more target systems (e.g. another MySQL database, or a non-MySQL database), thereby synchronizing the source and target systems.

Abstract translation: 用于在不同类型的系统之间传输数据的系统和方法，特别是使用基于日志的复制来在不同类型的系统之间传输数据。 根据一个实施例，该系统可用于执行MySQL数据从源数据库系统到目标数据库系统的一次性或初始拷贝，和/或复制从MySQL数据库的 二进制日志记录到一个或另外的非MySQL数据库中，以使两个系统为感兴趣的事务同步。 根据一个实施例，可以从MySQL二进制日志中提取全部或部分数据改变，可选择地转换，跳过或扩充，输出或写入文件，然后应用于一个或多个目标系统（例如另一个MySQL数据库 ，或非MySQL数据库），从而同步源系统和目标系统。