公开(公告)号：US20110191299A1

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

申请号：US12697302

申请日：2010-02-01

申请人： Hanh Huynh Huu ,  Zhongwei Wu ,  Oliver N. Seeliger ,  Shankar Pal ,  Christian Rober ,  Bruno H.M. Denuit ,  Lev Novik ,  Nigel R. Ellis ,  Tomas Talius

发明人： Hanh Huynh Huu ,  Zhongwei Wu ,  Oliver N. Seeliger ,  Shankar Pal ,  Christian Rober ,  Bruno H.M. Denuit ,  Lev Novik ,  Nigel R. Ellis ,  Tomas Talius

IPC分类号： G06F17/30

CPC分类号： G06F17/30

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

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

公开(公告)号：US20110178984A1

公开(公告)日：2011-07-21

申请号：US12688921

申请日：2010-01-18

申请人： Tomas Talius ,  Bruno H.M. Denuit

发明人： Tomas Talius ,  Bruno H.M. Denuit

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

CPC分类号： G06F11/2097 ,  G06F11/2094 ,  G06F16/27

摘要： Database management architecture for recovering from failures by building additional replicas and catching up replicas after a failure. A replica includes both the schema and the associated data. Modifications are captured, as performed by a primary replica (after the modifications have been performed), and sent asynchronously to secondary replicas. Acknowledgement by a quorum of the replicas (e.g., primary, secondaries) at transaction commit time is then awaited, and desired to be obtained. The logging of changes for recovery from failures is implemented, as well as online copying (e.g., accepting modifications during the copy) of the data when replica catch-up is not possible. Modifications can be sent asynchronously to the secondary replicas and in parallel.

摘要翻译： 数据库管理架构，用于通过构建其他副本并在故障后捕获副本来从故障中恢复。 副本包括模式和关联的数据。 捕获修改，主要副本执行（修改完成后），并异步发送到辅助副本。 然后等待在交易提交时间由复制品（例如主要，次要）的法定人数确认，并希望获得。 在复制追踪不可能的情况下，实施从故障恢复的更改记录以及在线复制（例如，在复制期间接受修改）。 可以将修改异步发送到辅助副本并行。

公开(公告)号：US20110225122A1

公开(公告)日：2011-09-15

申请号：US12723696

申请日：2010-03-15

申请人： Bruno H.M. Denuit ,  Tomas Talius

发明人： Bruno H.M. Denuit ,  Tomas Talius

IPC分类号： G06F17/30

CPC分类号： G06F17/30584 ,  G06F17/30174

摘要： 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).

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

公开(公告)号：US20100281018A1

公开(公告)日：2010-11-04

申请号：US12836993

申请日：2010-07-15

申请人： Bruno H.M. Denuit ,  Stefano Stefani

发明人： Bruno H.M. Denuit ,  Stefano Stefani

IPC分类号： G06F17/30

CPC分类号： G06F17/30436 ,  G06F17/30463

摘要： Pursuant to receipt of a data modification command or statement, such as an Update command, it is determined which fields in a data structure, such as a UDT, computed column, indexed view, or index, for example, will be changed as a result of the command. Only those fields that are affected by the command will be changed. Thus, changes are propagated to only to those dependent data structures whose content is being modified. Tree representations are used to facilitate the determination as to whether a subfield in a hierarchy is changed.

摘要翻译： 根据接收到诸如更新命令的数据修改命令或语句，确定例如UDT，计算列，索引视图或索引等数据结构中的哪些字段将被改变，结果 的命令。 只有那些受命令影响的字段才会被更改。 因此，更改仅传播到内容正被修改的那些依赖数据结构。 树表示用于方便确定层次结构中的子域是否改变。