Transaction consistent copy-on-write database
    1.
    发明授权
    Transaction consistent copy-on-write database 有权
    事务一致的写时复制数据库

    公开(公告)号:US07395278B2

    公开(公告)日:2008-07-01

    申请号:US10611774

    申请日:2003-06-30

    IPC分类号: G06F12/00 G06F9/34

    摘要: A database view of a database is created which provides a transaction-consistent view of an existing database at a previous time. Each database view contains all the information needed to, along with the primary database, determine the contents of the primary database at a previous time. The database view consists of a side file corresponding to each data file in the primary database. The side files contain a copy of all data from the corresponding data file which has been changed since the database view was created. Sparse files may be used for the side files in order to conserve space. Page table data is kept in order to allow a quick determination as to whether the page from the primary database has been modified and the old version stored in the database view side file.

    摘要翻译: 创建数据库的数据库视图,该数据库视图在以前的时间提供了现有数据库的事务一致视图。 每个数据库视图包含与主数据库一起确定先前时间的主数据库的内容所需的所有信息。 数据库视图包含与主数据库中每个数据文件对应的副文件。 副文件包含自创建数据库视图以来已更改的相应数据文件的所有数据的副本。 为了节省空间,稀疏文件可能用于侧面文件。 保留页表数据以便快速确定来自​​主数据库的页面是否已被修改,并且旧版本存储在数据库视图侧文件中。

    Synchronization with derived metadata
    3.
    发明授权
    Synchronization with derived metadata 有权
    与派生元数据同步

    公开(公告)号:US07610317B2

    公开(公告)日:2009-10-27

    申请号:US11063424

    申请日:2005-02-22

    IPC分类号: G06F17/30

    摘要: A system and method for synchronizing a database comprising raw data and metadata derived from the raw data, but when the metadata has not yet been updated. The raw data and the metadata are first synchronized, with the raw data having been assigned a version number. After synchronization, any stale metadata will be updated and assigned the same version number as the raw data.

    摘要翻译: 一种用于使包含原始数据和从原始数据导出的元数据的数据库同步的系统和方法,但是当元数据尚未被更新时。 原始数据和元数据首先被同步,原始数据被分配了版本号。 同步后,任何陈旧的元数据将被更新,并分配与原始数据相同的版本号。

    System and method for identifying and storing changes made to a table
    5.
    发明授权
    System and method for identifying and storing changes made to a table 有权
    用于识别和存储对表进行更改的系统和方法

    公开(公告)号:US07333992B2

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

    申请号:US10445095

    申请日:2003-05-22

    IPC分类号: G06F7/30

    摘要: A base table is scanned with a delete marker and an insert marker. The delete marker identifies a last change committed to the base table as part of a transaction prior to execution of a statement, and the insert marker identifies a last change committed to base table as part of the transaction during execution of the statement. The results of the delete marker scan are filtered with deletions stored in a delta table, and a delete table is populated with the filtered rows. The results of the insert scan are filtered with insertions stored in the delta table, and an insert table is populated with the filtered rows.

    摘要翻译: 使用删除标记和插入标记扫描基表。 删除标记在执行语句之前标识作为事务的一部分提交给基表的最后一个更改,并且在执行语句期间,插入标记将提交给基表的最后一个更改标识为事务的一部分。 使用存储在增量表中的删除过滤删除标记扫描的结果,并使用已过滤的行填充删除表。 使用存储在增量表中的插入过滤插入扫描的结果,并使用已过滤的行填充插入表。

    Systems and methods for synchronization of items without snapshots
    7.
    发明授权
    Systems and methods for synchronization of items without snapshots 有权
    没有快照的项目同步的系统和方法

    公开(公告)号:US07457826B2

    公开(公告)日:2008-11-25

    申请号:US11025165

    申请日:2004-12-20

    IPC分类号: G06F17/30

    摘要: Various embodiments of the present invention are directed to systems and methods for synchronizing mixed elements (MEs) comprising structure data and unstructured filestreams between peer computer systems in a hardware/software interface system environment that does not permit snapshotting of large unstructured ME filestreams during synchronization. For several such embodiments, the method comprises synchronizing the ME in two steps, one for snapshotting the structured data component of the ME (as well as the cv of the filestream but not the filestream itself) and one for locking and transmitting the filestream to the receiving sync peer if and only if, after being locked, it is determined that the filestream is unchanged from the time of the ME data component snapshot.

    摘要翻译: 本发明的各种实施例涉及用于在硬件/软件接口系统环境中的对等计算机系统之间同步混合元件(ME)的系统和方法,该硬件/软件接口系统环境不允许在同步期间对大型非结构化ME滤波器进行快照。 对于若干这样的实施例,该方法包括以两个步骤同步ME,一个用于快照ME的结构化数据组件(以及该文件流本身的cv,而不是该子串本身),一个用于锁定和传送该子串至 接收到同步对等体,如果且仅当锁定后,从ME数据组件快照的时间确定文件流不变。

    Identifying appropriate undo during a forward pass through a log
    8.
    发明授权
    Identifying appropriate undo during a forward pass through a log 有权
    在向前传递日志期间识别适当的撤消数据

    公开(公告)号:US07036044B1

    公开(公告)日:2006-04-25

    申请号:US10295131

    申请日:2002-11-15

    IPC分类号: G06F11/00

    CPC分类号: G06F11/1474 G06F11/1471

    摘要: The location of appropriate undo data necessary for reversing an effect of an operation performed at a computer system is identified during a forward pass through a log. A cycle count can be used to determine if appropriate undo data is stored in an object or is stored in auxiliary storage. If appropriate undo data is stored in an object and the undo data would be potentially lost by processing a redo log entry to modify the contents of the object, the appropriate undo data is copied to auxiliary storage. In some embodiments, a secondary computer system receives log entries from a primary computer system. The secondary computer system can identify undo data necessary to reverse an effect of an operation performed at the secondary computer system from received log entries. Identified undo data can be copied auxiliary storage at the secondary computer system.

    摘要翻译: 在向前传递日志期间识别用于反转在计算机系统执行的操作的效果所需的适当的撤销数据的位置。 可以使用循环计数来确定适当的撤消数据是存储在对象中还是存储在辅助存储器中。 如果适当的撤消数据存储在对象中,并且通过处理重做日志条目来修改对象的内容可能会丢失撤消数据,则将相应的撤消数据复制到辅助存储。 在一些实施例中,辅助计算机系统从主计算机系统接收日志条目。 辅助计算机系统可以识别从接收的日志条目反转在次计算机系统执行的操作的影响所需的撤销数据。 识别的撤消数据可以复制到辅助计算机系统的辅助存储器。

    Linked data structure integrity verification system which verifies actual node information with expected node information stored in a table
    9.
    发明授权
    Linked data structure integrity verification system which verifies actual node information with expected node information stored in a table 失效
    链接的数据结构完整性验证系统,其使用存储在表中的预期节点信息来验证实际节点信息

    公开(公告)号:US06185569B2

    公开(公告)日:2001-02-06

    申请号:US09106727

    申请日:1998-06-29

    IPC分类号: G06F1730

    摘要: A linked data structure verification system to verify the integrity of at least one linked data structure simultaneously by way of a verification setup phase and an integrity verification phase. Individual nodes are retrieved from a memory device and examined seriatim in optimal memory device location order. Nodes are retrieved and examined in optimal memory device location order for maximum memory device retrieval performance. Expected and/or actual node information about nodes in a given linked data structure are temporarily stored as records in an integrity verification table for only as much time as is necessary to verify any part of the node information prior to excising one or more unnecessary records from the integrity verification table.

    摘要翻译: 一种链接的数据结构验证系统,其通过验证设置阶段和完整性验证阶段同时验证至少一个链接的数据结构的完整性。 从存储设备检索单个节点,并以最佳存储器设备位置顺序进行检查。 以最佳存储器件位置顺序检索和检查节点,以获得最大的存储器件检索性能。 将关于给定链接数据结构中的节点的预期和/或实际节点信息作为记录临时存储在完整性验证表中,只需要在将一个或多个不必要记录从一个或多个不必要记录中删除之前验证节点信息的任何部分所需的时间 完整性验证表。

    Type definition language for defining content-index from a rich structured WinFS data type
    10.
    发明授权
    Type definition language for defining content-index from a rich structured WinFS data type 有权
    用于从丰富的结构化WinFS数据类型定义content-index的类型定义语言

    公开(公告)号:US07590654B2

    公开(公告)日:2009-09-15

    申请号:US11480721

    申请日:2006-06-30

    IPC分类号: G06F17/30

    摘要: An XML based type-definition language for declaring content-index for WinFS Types is provided. Content-index declarations can be specified for the Item type as well as it's sub-entities like Fragments, etc across Item type hierarchies. The properties of WinFS types in the schema are marked for content-indexing by the schema designer. Installing the content-index definitions includes parsing content-index definitions in the schema, generation of appropriate SQL statements for data extraction and storing the SQL statements.

    摘要翻译: 提供了一种用于为WinFS类型声明content-index的基于XML的类型定义语言。 可以为Item类型指定Content-index声明,以及跨类型层次结构的子实体,如Fragments等。 模式中的WinFS类型的属性由模式设计器标记为内容索引。 安装内容索引定义包括解析模式中的内容索引定义,生成用于数据提取和存储SQL语句的适当SQL语句。