DATABASE POINT-IN-TIME RESTORE AND AS-OF QUERY
    1.
    发明申请
    DATABASE POINT-IN-TIME RESTORE AND AS-OF QUERY 有权
    DATABASE POINT-IN-TIME RESTORE和AS-OF QUERY

    公开(公告)号:US20130212068A1

    公开(公告)日:2013-08-15

    申请号:US13370125

    申请日:2012-02-09

    CPC classification number: G06F17/30144 G06F17/30088

    Abstract: A database is queried as of any wall-clock time within a retention period, via undo that uses database snapshots and a list of page level modifications. The snapshot is user-identified, automatically generated, or extracted from a backup. The list is maintained in a transaction log by persisting page content before a page is re-used, persisting deleted rows before they are moved, persisting compensation log record undo information, and/or logging a full page. To rewind an entire database, the undo scans the transaction log in reverse LSN order and undoes all page modifications. Undo reverses reallocated pages, table truncation, and/or table deletion, as well as page-level modifications of a schema, metadata values, and/or system tables. An as-of query is handled using as-of page(s) from a sparse page file. If the sparse page file does not already contain the responsive page(s), they are created and added to it.

    Abstract translation: 通过使用数据库快照和页面级修改列表的撤销,在保留期内的任何挂钟时间查询数据库。 快照是用户标识,自动生成或从备份中提取的。 该列表通过在重新使用页面之前持久页面内容来维护事务日志,在删除的行移动之前保留已删除的行,持久化补偿日志记录撤消信息和/或记录完整页面。 要倒退整个数据库,undo以反向LSN顺序扫描事务日志,并撤消所有页面修改。 撤消反转重新分配的页面,表截断和/或表删除,以及模式,元数据值和/或系统表的页面级修改。 使用从稀疏页面文件中的页面处理一个查询。 如果稀疏页面文件尚未包含响应页面,则会创建它们并将其添加到其中。

    Synchronization move support systems and methods
    4.
    发明申请
    Synchronization move support systems and methods 有权
    同步移动支持系统和方法

    公开(公告)号:US20060242443A1

    公开(公告)日:2006-10-26

    申请号:US11112799

    申请日:2005-04-22

    CPC classification number: G06F17/30176

    Abstract: Disclosed are systems and methods pertaining to data synchronization and move handling support. In particular, a move log is maintained that identifies data that has moved in, out, and within a synchronization scope. Furthermore, the log comprises times associated with when data moves in and out of the synchronization scope. Systems and methods can interact easily with the generated and updated move log to facilitate determining data versions and identifying new data that may need to be synchronized.

    Abstract translation: 公开了与数据同步和移动处理支持有关的系统和方法。 特别地,维护移动日志,其标识已移入,移出和在同步范围内的数据。 此外,日志包括当数据移入和移出同步范围时相关联的时间。 系统和方法可以与生成和更新的移动日志轻松交互,以便于确定数据版本并识别可能需要同步的新数据。

    Reorganization of data under continuous workload
    5.
    发明授权
    Reorganization of data under continuous workload 有权
    在连续工作量下重组数据

    公开(公告)号:US09009112B2

    公开(公告)日:2015-04-14

    申请号:US12723696

    申请日:2010-03-15

    CPC classification number: G06F17/30584 G06F17/30174

    Abstract: Architecture that provides the capability to automatically (e.g., dynamically) reorganize (repartition) an existing partition by dividing (splitting) or recombining (merging) logical databases. This reorganization can be performed to logical databases belonging to the same customer, and based on the partitioning of the tables in these databases. This can include not only splitting secondary replicas of a partition or merging secondary replicas of the partition, but also splitting off secondary replicas of the partition to create a new partition and merging two partitions into one partition. Moreover, these operations can occur while the logical databases are accepting workload (online).

    Abstract translation: 提供通过划分(分割)或重组(合并)逻辑数据库来自动(例如,动态地)重新组织(重新分配)现有分区的能力的架构。 可以对属于同一客户的逻辑数据库执行此重组,并且基于这些数据库中的表的分区。 这不仅可以分割分区的次要副本或合并分区的副副本,还可以分割分区的辅助副本,以创建新分区,并将两个分区合并成一个分区。 而且,当逻辑数据库接受工作负载(在线)时,可能会发生这些操作。

    SEAMLESS UPGRADES IN A DISTRIBUTED DATABASE SYSTEM
    6.
    发明申请
    SEAMLESS UPGRADES IN A DISTRIBUTED DATABASE SYSTEM 有权
    分布式数据库系统中的无缝升级

    公开(公告)号:US20120239616A1

    公开(公告)日:2012-09-20

    申请号:US13051967

    申请日:2011-03-18

    CPC classification number: G06F17/30578

    Abstract: Embodiments are directed to providing distributed database service upgrades of database server instances in a computer cluster using multiple database server instances and to monitoring and maintaining a distributed database service during upgrade. In an embodiment, each computer system in a computer cluster instantiates at least two different database server instances on each of the nodes in the cluster. The first database server instances are configured to operate using a current distributed database version and the second instances are configured to operate using a new, updated distributed database service version. The computer system receives an indication that the distributed database service is to be upgraded. Then, based on the received indication, the computer system migrates database replicas from the first database server instances to the second database server instances which operate the new, updated service version, substantially without user-visible downtime.

    Abstract translation: 实施例旨在使用多个数据库服务器实例在计算机集群中提供数据库服务器实例的分布式数据库服务升级,并在升级期间监视和维护分布式数据库服务。 在一个实施例中,计算机集群中的每个计算机系统在群集中的每个节点上实例化至少两个不同的数据库服务器实例。 第一个数据库服务器实例被配置为使用当前分布式数据库版本进行操作,第二个实例被配置为使用新的更新的分布式数据库服务版本进行操作。 计算机系统接收到分布式数据库服务将被升级的指示。 然后,基于收到的指示,计算机系统将数据库副本从第一数据库服务器实例迁移到操作新的更新服务版本的第二数据库服务器实例,基本上没有用户可见的停机时间。

    LOGICAL DATA BACKUP AND ROLLBACK USING INCREMENTAL CAPTURE IN A DISTRIBUTED DATABASE
    8.
    发明申请
    LOGICAL DATA BACKUP AND ROLLBACK USING INCREMENTAL CAPTURE IN A DISTRIBUTED DATABASE 有权
    在分布式数据库中使用增量捕获的逻辑数据备份和回滚

    公开(公告)号:US20110191299A1

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

    申请号:US12697302

    申请日:2010-02-01

    CPC classification number: G06F17/30

    Abstract: Architecture that eliminates the need for on-disk full backups of data retaining only changes that have occurred, in a separate table. Thus, the architecture provides for incremental recovery of incremental changes in a relational database (e.g., SQL). The architecture provides improved recovery time and recovery point objectives. By using the incremental capture of changed data (e.g., in an XML format), the capability is provided to capture schema changes, query the incremental change data and efficiently restore user data to an earlier point-in-time state. Changes (e.g., insert, update and delete operations) are tracked (e.g., continuously) by a set of triggers and the incrementally captured changed rows are inserted in a data capture table (a differential change “delta” table) in a human-readable format (e.g., XML). Rollback is also provided.

    Abstract translation: 架构,消除了在单独的表中仅保留已发生的更改的数据的磁盘完全备份的数据。 因此,架构提供了关系数据库(例如,SQL)中增量更改的增量恢复。 该架构提供了改进的恢复时间和恢复点目标。 通过使用改变的数据的增量捕获(例如,以XML格式),提供能力来捕获模式改变,查询增量变化数据并有效地将用户数据恢复到较早的时间点状态。 更改(例如,插入,更新和删除操作)被一组触发器跟踪(例如,连续地),并且增量捕获的改变的行被插入到人类可读的数据捕获表(差分变化“delta”表)中 格式(例如,XML)。 还提供回滚。

    Method and system for tracking of work-item revisions
    9.
    发明申请
    Method and system for tracking of work-item revisions 有权
    跟踪工作项目修订的方法和系统

    公开(公告)号:US20060173879A1

    公开(公告)日:2006-08-03

    申请号:US11039185

    申请日:2005-01-19

    CPC classification number: G06Q10/10 G06Q10/1097

    Abstract: A method for work-item tracking, in a computer system that includes client computers and at least one server maintaining a database, includes defining at least one work item, associating version identifiers with corresponding versions of at least one work item, and storing, in the database, work-item data. The work-item data can include the current version of the work item, one or more prior versions of the work item, and the version identifiers. A computer readable medium is encoded with a program that, when executed, can perform the method for work-item tracking.

    Abstract translation: 一种用于在包括客户端计算机和至少一个维护数据库的服务器的计算机系统中进行工件跟踪的方法包括定义至少一个工作项,将版本标识符与至少一个工作项的对应版本相关联,并将其存储在 数据库,工作项数据。 工作项目数据可以包括工作项目的当前版本,工作项目的一个或多个先前版本以及版本标识符。 计算机可读介质用程序编码,该程序在被执行时可以执行用于工件跟踪的方法。

    Database point-in-time restore and as-of query
    10.
    发明授权
    Database point-in-time restore and as-of query 有权
    数据库时间点恢复和查询

    公开(公告)号:US08527462B1

    公开(公告)日:2013-09-03

    申请号:US13370125

    申请日:2012-02-09

    CPC classification number: G06F17/30144 G06F17/30088

    Abstract: A database is queried as of any wall-clock time within a retention period, via undo that uses database snapshots and a list of page level modifications. The snapshot is user-identified, automatically generated, or extracted from a backup. The list is maintained in a transaction log by persisting page content before a page is re-used, persisting deleted rows before they are moved, persisting compensation log record undo information, and/or logging a full page. To rewind an entire database, the undo scans the transaction log in reverse LSN order and undoes all page modifications. Undo reverses reallocated pages, table truncation, and/or table deletion, as well as page-level modifications of a schema, metadata values, and/or system tables. An as-of query is handled using as-of page(s) from a sparse page file. If the sparse page file does not already contain the responsive page(s), they are created and added to it.

    Abstract translation: 通过使用数据库快照和页面级修改列表的撤销,在保留期内的任何挂钟时间查询数据库。 快照是用户标识,自动生成或从备份中提取的。 该列表通过在重新使用页面之前持久页面内容来维护事务日志,在删除的行移动之前保留已删除的行,持久化补偿日志记录撤销信息和/或记录完整页面。 要倒退整个数据库,undo以反向LSN顺序扫描事务日志,并撤消所有页面修改。 撤消反转重新分配的页面,表截断和/或表删除,以及模式,元数据值和/或系统表的页面级修改。 使用从稀疏页面文件中的页面处理一个查询。 如果稀疏页面文件尚未包含响应页面,则会创建它们并将其添加到其中。

Patent Agency Ranking