Consistent database recovery across constituent segments
    1.
    发明授权
    Consistent database recovery across constituent segments 有权
    跨组成部分的数据库恢复一致

    公开(公告)号:US08671085B2

    公开(公告)日:2014-03-11

    申请号:US13315363

    申请日:2011-12-09

    IPC分类号: G06F17/00

    CPC分类号: G06F11/1471 G06F17/30289

    摘要: A distributed database transaction coordination manager's outcome store may be unavailable to resolve in-doubt transactions locally, e.g., after an unclean detach, during an outcomes store restore, or during a logical database restore. To facilitate transactional consistency, AGEs and values based on them are used. Some code avoids reformatting any closed physical portion for reuse based on the segment's most recently received minimum of persisted AGEs. Some code commits any in-doubt transactions that appear on an aggregate list and aborts any not on the aggregate list. Some code writes each segment's transaction commit records to persistent storage until the segment's persisted-AGE is not less than a common-restore-AGE, and some code resolves any in-doubt transactions based on a harvested outcomes list. Outcomes may reside in a log or a persisted transactions table. A restore checkpoint may include harvested outcomes. Segments may reside on cloud nodes and/or in a shared nothing database system.

    摘要翻译: 分布式数据库事务协调管理器的结果存储可能不可用于在结果存储恢复期间或在逻辑数据库恢复期间在本地例如在不清洁的分离之后解决无疑的事务。 为了促进事务一致性,使用AGEs和基于它们的值。 一些代码避免重新格式化任何封闭的物理部分,以便根据片段最近接收的持久AGE的最小值进行重新使用。 一些代码提交出现在聚合列表上的任何无疑的事务,并且中止不在聚合列表上的任何事务。 一些代码将每个段的事务提交记录写入永久存储,直到段的持久AGE不小于common-restore-AGE,并且一些代码基于收获的结果列表来解决任何无疑的事务。 成果可能驻留在日志或持久化事务表中。 恢复检查点可能包括收获结果。 分段可能驻留在云节点和/或共享无数据库系统中。

    Consistent Database Recovery Across Constituent Segments
    2.
    发明申请
    Consistent Database Recovery Across Constituent Segments 有权
    跨组成部分的数据库恢复一致

    公开(公告)号:US20130151494A1

    公开(公告)日:2013-06-13

    申请号:US13315363

    申请日:2011-12-09

    IPC分类号: G06F17/30

    CPC分类号: G06F11/1471 G06F17/30289

    摘要: A distributed database transaction coordination manager's outcome store may be unavailable to resolve in-doubt transactions locally, e.g., after an unclean detach, during an outcomes store restore, or during a logical database restore. To facilitate transactional consistency, AGEs and values based on them are used. Some code avoids reformatting any closed physical portion for reuse based on the segment's most recently received minimum of persisted AGEs. Some code commits any in-doubt transactions that appear on an aggregate list and aborts any not on the aggregate list. Some code writes each segment's transaction commit records to persistent storage until the segment's persisted-AGE is not less than a common-restore-AGE, and some code resolves any in-doubt transactions based on a harvested outcomes list. Outcomes may reside in a log or a persisted transactions table. A restore checkpoint may include harvested outcomes. Segments may reside on cloud nodes and/or in a shared nothing database system.

    摘要翻译: 分布式数据库事务协调管理器的结果存储可能不可用于在结果存储恢复期间或在逻辑数据库恢复期间在本地例如在不清洁的分离之后解决无疑的事务。 为了促进事务一致性,使用AGEs和基于它们的值。 一些代码避免重新格式化任何封闭的物理部分,以便根据片段最近接收的持久AGE的最小值进行重新使用。 一些代码提交出现在聚合列表上的任何无疑的事务,并且中止不在聚合列表上的任何事务。 一些代码将每个段的事务提交记录写入永久存储,直到段的持久AGE不小于common-restore-AGE,并且一些代码基于收获的结果列表来解决任何无疑的事务。 成果可能驻留在日志或持久化事务表中。 恢复检查点可能包括收获结果。 分段可能驻留在云节点和/或共享无数据库系统中。

    Remote storage and management of binary object data
    3.
    发明授权
    Remote storage and management of binary object data 有权
    二进制对象数据的远程存储和管理

    公开(公告)号:US08250102B2

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

    申请号:US12048753

    申请日:2008-03-14

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30091 G06F17/30011

    摘要: Embodiments described herein are directed to the accessing remotely stored binary object data in a binary object store. In one embodiment, a computer system receives a request for a portion of binary object data, sends a query to a database server requesting access to the binary object data, and receives a binary object reference. The binary object reference includes binary object identification data and use characteristics specific to the binary object store. The computer system sends a binary object data access request based on the binary object reference to the binary object store using a binary object store interface, and receives the binary object data corresponding to the binary object data access request. The binary object data comprises a portion of data files. The computer system also sends the received binary object data to the user.

    摘要翻译: 本文描述的实施例涉及在二进制对象存储中访问远程存储的二进制对象数据。 在一个实施例中,计算机系统接收对二进制对象数据的一部分的请求,向请求访问二进制对象数据的数据库服务器发送查询,并接收二进制对象引用。 二进制对象引用包括二进制对象标识数据和特定于二进制对象存储的特性。 计算机系统使用二进制对象存储接口将基于二进制对象引用的二进制对象数据访问请求发送到二进制对象存储,并且接收对应于二进制对象数据访问请求的二进制对象数据。 二进制对象数据包括一部分数据文件。 计算机系统还将接收到的二进制对象数据发送给用户。

    REMOTE STORAGE AND MANAGEMENT OF BINARY OBJECT DATA
    4.
    发明申请
    REMOTE STORAGE AND MANAGEMENT OF BINARY OBJECT DATA 有权
    二进制对象数据的远程存储和管理

    公开(公告)号:US20090234880A1

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

    申请号:US12048753

    申请日:2008-03-14

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30091 G06F17/30011

    摘要: Embodiments described herein are directed to the accessing remotely stored binary object data in a binary object store. In one embodiment, a computer system receives a request for a portion of binary object data, sends a query to a database server requesting access to the binary object data, and receives a binary object reference. The binary object reference includes binary object identification data and use characteristics specific to the binary object store. The computer system sends a binary object data access request based on the binary object reference to the binary object store using a binary object store interface, and receives the binary object data corresponding to the binary object data access request. The binary object data comprises a portion of data files. The computer system also sends the received binary object data to the user.

    摘要翻译: 本文描述的实施例涉及在二进制对象存储中访问远程存储的二进制对象数据。 在一个实施例中,计算机系统接收对二进制对象数据的一部分的请求,向请求访问二进制对象数据的数据库服务器发送查询,并接收二进制对象引用。 二进制对象引用包括二进制对象标识数据和特定于二进制对象存储的特性。 计算机系统使用二进制对象存储接口将基于二进制对象引用的二进制对象数据访问请求发送到二进制对象存储,并且接收对应于二进制对象数据访问请求的二进制对象数据。 二进制对象数据包括一部分数据文件。 计算机系统还将接收到的二进制对象数据发送给用户。

    DATA STORAGE INCLUDING STORING OF PAGE IDENTITY AND LOGICAL RELATIONSHIPS BETWEEN PAGES
    5.
    发明申请
    DATA STORAGE INCLUDING STORING OF PAGE IDENTITY AND LOGICAL RELATIONSHIPS BETWEEN PAGES 审中-公开
    数据存储,包括页面标识的存储和页面之间的逻辑关系

    公开(公告)号:US20110153674A1

    公开(公告)日:2011-06-23

    申请号:US12641715

    申请日:2009-12-18

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

    CPC分类号: G06F16/22

    摘要: Methods, systems, and computer-readable media of data storage that include storing page identities of individual pages and logical relationships between pages are disclosed. A particular system includes a plurality of data storage devices. A storage manager is configured to store data as pages at the data storage devices. Each page includes a page payload and a page identity. The storage manager is also configured to store one or more relationships indicating logical order between pages.

    摘要翻译: 公开了数据存储的方法,系统和计算机可读介质,其包括存储页面的页面标识和页面之间的逻辑关系。 特定系统包括多个数据存储设备。 存储管理器被配置为在数据存储设备处将数据存储为页面。 每页包括页面有效载荷和页面标识。 存储管理器还被配置为存储指示页之间的逻辑顺序的一个或多个关系。