Transportable database
    3.
    发明申请
    Transportable database 有权
    可运输数据库

    公开(公告)号:US20050256908A1

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

    申请号:US10966961

    申请日:2004-10-15

    IPC分类号: G06F7/00 G06F17/30

    摘要: 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.

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

    Method and mechanism for efficient implementation of ordered records
    4.
    发明授权
    Method and mechanism for efficient implementation of ordered records 有权
    有效执行有序记录的方法和机制

    公开(公告)号:US07039773B2

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

    申请号:US10426471

    申请日:2003-04-29

    IPC分类号: G06F12/00

    摘要: 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.

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

    Data Recovery Advisor
    6.
    发明申请
    Data Recovery Advisor 审中-公开
    数据恢复顾问

    公开(公告)号:US20090106327A1

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

    申请号:US12253897

    申请日:2008-10-17

    IPC分类号: G06F17/30

    摘要: 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.

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

    Cross platform transportable tablespaces
    7.
    发明申请
    Cross platform transportable tablespaces 有权
    跨平台可运输的表空间

    公开(公告)号:US20050253739A1

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

    申请号:US10966679

    申请日:2004-10-14

    IPC分类号: G06F12/00 G06F17/30

    CPC分类号: G06F17/30569

    摘要: 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.

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

    Apparatus and method for creating a real time database replica
    8.
    发明授权
    Apparatus and method for creating a real time database replica 有权
    用于创建实时数据库副本的设备和方法

    公开(公告)号:US08429121B2

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

    申请号:US12969012

    申请日:2010-12-15

    IPC分类号: G06F17/30

    摘要: 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.

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

    MYSQL DATABASE HETEROGENEOUS LOG BASED REPLICATION
    9.
    发明申请
    MYSQL DATABASE HETEROGENEOUS LOG BASED REPLICATION 有权
    MYSQL数据库异构日志复制

    公开(公告)号:US20120030172A1

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

    申请号:US13077760

    申请日:2011-03-31

    IPC分类号: G06F17/30 G06F7/00

    摘要: 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.

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

    Apparatus and method for creating a real time database replica
    10.
    发明授权
    Apparatus and method for creating a real time database replica 有权
    用于创建实时数据库副本的设备和方法

    公开(公告)号:US07885922B2

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

    申请号:US11551678

    申请日:2006-10-20

    IPC分类号: G06F17/30

    摘要: 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.

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