Method and device for establishing synchronized recovery log points
    1.
    发明授权
    Method and device for establishing synchronized recovery log points 有权
    用于建立同步恢复日志点的方法和设备

    公开(公告)号:US07337195B2

    公开(公告)日:2008-02-26

    申请号:US10334892

    申请日:2002-12-31

    IPC分类号: G06F17/30 G06F17/00

    摘要: According to the present invention a method and a system is provided for establishing synchronized recovery log points in an infrastructure comprising at least a first database management system and a second database management system, whereby recovery log files are written and log points are created separately for each database management system. Firstly, log write of all database management systems is suspended, then, the corresponding log points for each database management system forming a global log point are recorded and log writes of all database management systems are resumed.

    摘要翻译: 根据本发明,提供一种方法和系统,用于在包括至少第一数据库管理系统和第二数据库管理系统的基础设施中建立同步的恢复日志点,由此写入恢复日志文件,并且为每个日志点分别创建日志点 数据库管理系统。 首先,暂停所有数据库管理系统的日志写入,然后记录形成全局日志点的每个数据库管理系统的对应日志点,并恢复所有数据库管理系统的日志写入。

    Method and system for reduced lock contention in SQL transactions
    2.
    发明授权
    Method and system for reduced lock contention in SQL transactions 失效
    在SQL事务中减少锁争用的方法和系统

    公开(公告)号:US07080074B2

    公开(公告)日:2006-07-18

    申请号:US10010371

    申请日:2001-11-05

    IPC分类号: G06F17/30

    摘要: According to the method, apparatus, and computer readable medium of the present invention, a scan is performed by accessing all rows of a table in a relational database, evaluating each row to determine whether the row satifies a set of predicates of a database query, and returning the row if it satisfies the set of predicates. According to a preferred embodiment of the present invention, all rows are evaluated regardless of current locks. The scan is continued if the row does not satisfy the set of predicates regardless of the current lock on the row. The locking semantics according to the invention has the advantage that it completely removes the problem of lock contention on the rows that do not satisfy statement predicates.

    摘要翻译: 根据本发明的方法,装置和计算机可读介质,通过访问关系数据库中的表的所有行来执行扫描,评估每行以确定该行是否满足数据库查询的一组谓词, 并返回该行,如果它满足一组谓词。 根据本发明的优选实施例,无论当前的锁如何,都对所有行进行评估。 如果该行不满足该组谓词,而不考虑行上的当前锁定,则继续进行扫描。 根据本发明的锁定语义的优点在于它完全消除了对不满足语句谓词的行的锁争用的问题。

    System and method for avoiding deadlock situations due to pseudo-deleted entries
    3.
    发明授权
    System and method for avoiding deadlock situations due to pseudo-deleted entries 失效
    用于避免由于伪删除条目引起的死锁情况的系统和方法

    公开(公告)号:US06944615B2

    公开(公告)日:2005-09-13

    申请号:US09894090

    申请日:2001-06-28

    IPC分类号: G06F17/30

    摘要: In a database management system (DBMS) (60) for a database application (10) including a database (12) having a table (14, 16, 18) and a unique key index (42) having indexes (44, 46, 48) therefor, the DBMS (60) includes a data manager (64), an index manager (66), a transaction manager (62), and a lock manager (68) which restricts access to the table by assigning locks to elements thereof. In order to avoid deadlock in the database application due to the pseudo-deleted entries, the lock categories include an X-lock and a Conditional S-lock, and have lock attributes including at least a Delete attribute for the X-lock. The Conditional S-lock is compatible (granted by the lock manager) with an X-lock whose Delete attribute is NOT SET, but is not compatible (granted) with an X-lock whose Delete attribute is SET. Each index entry includes a pseudo-delete flag which is SET by the index manager (66) to indicate deletion of the indexed row. Conditional upon locating a pseudo-deleted index key corresponding to a key to be added to the index, the index manager (66) requests a Conditional S-lock on the row indexed thereby, whereby the index manager (66) verifies the Delete transaction which set the pseudo-delete flag has committed.

    摘要翻译: 在数据库应用程序(10)的数据库管理系统(DBMS)(60)中,包括具有表(14,16,18)的数据库(12)和具有索引(44,46,48)的唯一键索引(42) )为此,DBMS(60)包括数据管理器(64),索引管理器(66),事务管理器(62)和锁管理器(68),其通过向其元素分配锁限制对表的访问。 为了避免由于伪删除的条目而导致数据库应用程序中的死锁,锁类别包括X锁和条件S锁,并且具有至少包含X锁的Delete属性的锁属性。 条件S锁与X锁定(其Delete属性未设置)兼容,但与Delete属性为SET的X锁不兼容(授予)。 每个索引条目包括由索引管理器(66)设置为指示删除索引行的伪删除标志。 有条件的是,索引管理器(66)根据与要添加到索引的密钥相对应的伪删除的索引密钥来定位索引的行上的条件S锁定,由此索引管理器(66)验证删除事务, 设置伪删除标志已经提交。

    System and method for performing just-in-time priming of a database cache
    4.
    发明授权
    System and method for performing just-in-time priming of a database cache 有权
    用于执行数据库高速缓存的即时启动的系统和方法

    公开(公告)号:US07912838B2

    公开(公告)日:2011-03-22

    申请号:US11303714

    申请日:2005-12-16

    IPC分类号: G06F7/00 G06F17/30 G06F17/00

    摘要: A system for retrieving stored data and/or index pages, receives a database request, generates an access plan for the database request for accessing data rows and/or index entries according to the statement, and generates a priming process by selecting a set of data and/or index pages. The set of data and/or index pages is a super-set or the exact set of the pages needed for accessing data rows and/or index entries according to the access plan. The present system retrieves the data and/or index pages of the set before executing the database request according to the access plan. The execution of the database request is performed by scanning the index and data pages preloaded into the cache. This reduces the number of necessary disk reads during execution.

    摘要翻译: 一种用于检索存储的数据和/或索引页面的系统,接收数据库请求,根据该语句生成访问数据行和/或索引条目的数据库请求的访问计划,并通过选择一组数据来生成启动过程 和/或索引页。 一组数据和/或索引页是根据访问计划访问数据行和/或索引条目所需的超集或精确的页面集合。 根据访问计划,本系统在执行数据库请求之前检索该集合的数据和/或索引页。 通过扫描预先加载到缓存中的索引和数据页执行数据库请求。 这样可以减少执行期间所需的磁盘读取次数。

    Incremental indexing of a database table in a database
    5.
    发明授权
    Incremental indexing of a database table in a database 失效
    数据库中数据库表的增量索引

    公开(公告)号:US07792839B2

    公开(公告)日:2010-09-07

    申请号:US11271677

    申请日:2005-11-10

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30336

    摘要: The present system indexes a plurality of entries in a database that contains a database table having a base index. As a recent row is inserted in the database table, an index increment is generated based on the inserted row. Preferably, the index increment is smaller in size than the base index because it is recently generated. The smaller size of the index increment facilitates the management of the index increment. An index entry associated with the inserted row is added to the index increment, and the index increment is merged with the base index.

    摘要翻译: 本系统对包含具有基本索引的数据库表的数据库中的多个条目进行索引。 由于最近一行插入到数据库表中,所以根据插入的行生成索引增量。 优选地,索引增量的大小比基本索引更小,因为它最近被生成。 索引增量的较小尺寸有助于指数增量的管理。 与插入行相关联的索引条目被添加到索引增量中,索引增量与基本索引合并。

    DBMS backup without suspending updates and corresponding recovery using separately stored log and data files
    6.
    发明授权
    DBMS backup without suspending updates and corresponding recovery using separately stored log and data files 有权
    DBMS备份而不会使用单独存储的日志和数据文件挂起更新和相应的恢复

    公开(公告)号:US07412460B2

    公开(公告)日:2008-08-12

    申请号:US10600221

    申请日:2003-06-19

    IPC分类号: G06F7/00 G06F17/00

    摘要: A method for performing a system level backup of a log-ahead database management system (DBMS) without suspending updates by application programs is described. The DBMS comprises a database mainline system, a backup utility and a restore utility. The data and log records are stored on separate storage volumes. Log records are written to identify objects that require special handling during the point-in-time recovery. The database engine operates normally during a backup except for suspending actions that would alter the file system catalog or write updates across a storage volume boundary; and by freezing the REDO log point in its checkpoint information. The backup utility copies the data volumes first and optionally the log volumes second while updates are allowed. The resulting inconsistencies are resolved either during a DBMS restart or during a point-in-time (PIT) recovery performed by the restore utility.

    摘要翻译: 描述了用于执行日志提前数据库管理系统(DBMS)的系统级备份而不中止应用程序的更新的方法。 DBMS包括数据库主线系统,备份实用程序和恢复实用程序。 数据和日志记录存储在不同的存储卷上。 日志记录被写入以识别在时间点恢复期间需要特殊处理的对象。 数据库引擎在备份期间正常运行,除了挂起将会更改文件系统目录或在存储卷边界上写入更新的操作; 并通过在其检查点信息中冻结REDO日志点。 备份实用程序首先复制数据卷,并可选地备份日志卷,同时允许更新。 在DBMS重新启动期间或在恢复实用程序执行的时间点(PIT)恢复期间,解决了所产生的不一致。

    System and method for real time statistics collection for use in the automatic management of a database system
    7.
    发明授权
    System and method for real time statistics collection for use in the automatic management of a database system 失效
    用于实时统计收集的系统和方法,用于数据库系统的自动管理

    公开(公告)号:US07181461B2

    公开(公告)日:2007-02-20

    申请号:US10223953

    申请日:2002-08-19

    IPC分类号: G06F17/30 G06F15/16 G06F17/00

    摘要: A computer program product provides accurate statistics in real time. These statistics can be used to determine if a table space in a database management system (DBMS) requires maintenance operations such as reorganization, back up, fresh access path statistics, and/or larger disk space allocation. The DBMS maintains a set of values that provide indications of whether that operation is due on that object. The indicators are asynchronously externalized in dedicated database tables either periodically in user-specified intervals or at some predefined event such as stopping the database. When the user performs a database administration operation, the database management system resets the associated indicators, and reports objects that are in an exception state based on the indicators collected as described for each operation.

    摘要翻译: 计算机程序产品实时提供准确的统计数据。 这些统计信息可用于确定数据库管理系统(DBMS)中的表空间是否需要维护操作,例如重组,备份,新建访问路径统计信息和/或更大的磁盘空间分配。 DBMS维护一组值,提供该操作是否在该对象上的指示。 这些指示器在专用数据库表中以用户指定的间隔或某些预定义事件(例如停止数据库)周期性地异步外部化。 当用户执行数据库管理操作时,数据库管理系统将重置相关联的指示符,并根据为每个操作所述收集的指示器报告处于异常状态的对象。

    Automatic maintenance of a set of indexes with different currency characteristics in a database management system

    公开(公告)号:US10452629B2

    公开(公告)日:2019-10-22

    申请号:US13082174

    申请日:2011-04-07

    IPC分类号: G06F16/22

    摘要: Methods and apparatus, including computer program products, for maintaining a set of indexes in a database management system (DBMS) having at least one table. A current, stale or deferred status is defined for at least a part of the indexes, resulting in at least a part of a set of current, stale, or deferred indexes in the DBMS. Current indexes are maintained by refreshing a current index synchronously with a table change relating to the current index. Stale indexes are maintained by refreshing a stale index continuously and asynchronously to table modifications of tables relating to the stale index based on log information relating to the modifications. Deferred indexes are maintained by building a deferred index in response to a query to a table relating to the deferred index, thereby bringing the deferred index in accordance with the current query time status to the table relating to the deferred index.

    Database Backup and Restore with Integrated Index Reorganization
    10.
    发明申请
    Database Backup and Restore with Integrated Index Reorganization 有权
    数据库备份和还原与整合索引重组

    公开(公告)号:US20120221523A1

    公开(公告)日:2012-08-30

    申请号:US13465381

    申请日:2012-05-07

    IPC分类号: G06F17/30

    摘要: According to an embodiment of the present invention, a method for reorganizing a source index tree of a database table resulting in a target index tree of the database table is provided. A backup process reads source leaf pages of the source index tree in a logical order defined by a sequence of index keys. The logical order can be different from a physical order of the source leaf pages defined by a sequence of respective storage locations. The backup process constructs target leaf pages of the target index tree maintaining the logical order. A restore process constructs target non-leaf pages of the target index tree based on the distribution of the index keys among the constructed leaf pages and stores the target leaf and non-leaf pages.

    摘要翻译: 根据本发明的实施例,提供了一种用于重组数据库表的源索引树的方法,其导致数据库表的目标索引树。 备份过程按照索引键序列定义的逻辑顺序读取源索引树的源页面页面。 逻辑顺序可以不同于由各个存储位置的序列定义的源叶子页的物理顺序。 备份过程构建维护逻辑顺序的目标索引树的目标叶页面。 恢复过程基于构建的叶子页面中的索引关键字的分布来构建目标索引树的目标非叶子页面,并存储目标叶子和非叶子页面。