System and method for parallel retrieval of data from a distributed database
    1.
    发明申请
    System and method for parallel retrieval of data from a distributed database 审中-公开
    用于从分布式数据库并行检索数据的系统和方法

    公开(公告)号:US20090204593A1

    公开(公告)日:2009-08-13

    申请号:US12069486

    申请日:2008-02-11

    IPC分类号: G06F7/06 G06F17/30

    CPC分类号: G06F16/27

    摘要: An improved system and method for parallel retrieval of data from a distributed database is provided. A parallel interface may be provided for use by a cluster of client machine for parallel retrieval of partial results from parallel execution of a database query by a cluster of database servers storing a distributed database. A query interface may be augmented for inputting a database query and specifying the number of instances of parallel retrieval of results from query execution. To do so, a commercial query language may be augmented for sending a query request that may include a parameter specifying the database query and an additional parameter specifying the desired retrieval parallelism. The augmented query interface may return a list of retrieval point addresses for retrieving the partial results assigned to each of the retrieval point addresses from parallel execution of the database query.

    摘要翻译: 提供了一种用于从分布式数据库并行检索数据的改进的系统和方法。 可以提供并行接口以供由客户机集群使用,以通过存储分布式数据库的数据库服务器的并行执行数据库查询来并行检索部分结果。 可以增加用于输入数据库查询并且从查询执行指定结果并行检索的实例的数量的查询接口。 为此,可以增加商业查询语言以发送可以包括指定数据库查询的参数的查询请求以及指定所需检索并行性的附加参数。 增强查询界面可以返回用于从数据库查询的并行执行中检索分配给每个检索点地址的部分结果的检索点地址的列表。

    DECENTRALIZED RECORD EXPIRY
    4.
    发明申请
    DECENTRALIZED RECORD EXPIRY 有权
    分散式记录过期

    公开(公告)号:US20090089313A1

    公开(公告)日:2009-04-02

    申请号:US11863902

    申请日:2007-09-28

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30306

    摘要: A technique is described that reduces the complexity and resource consumption associated with performing record expiry in a distributed database system. In accordance with the technique, a record is checked to see if it has expired only when it has been accessed for a read or a write. If at the time of a read a record is determined to have expired, then it is not served. If at the time of a write a record is determined to have expired, then the write is treated as an insertion of a new record, and steps are taken to treat the insertion consistently with regard to the previous expired version. A background process is used to delete records that have not been written to or actively deleted by a client after expiration.

    摘要翻译: 描述了一种降低与在分布式数据库系统中执行记录到期相关联的复杂性和资源消耗的技术。 根据该技术,检查记录以查看它是否仅在已被访问以进行读取或写入时才过期。 如果在阅读时确定记录已经过期,则不会提供记录。 如果在写入时确定记录已经过期,则写入被视为新记录的插入,并且采取步骤以一致的方式对先前的过期版本进行处理。 使用后台进程来删除客户端到期后尚未写入或主动删除的记录。

    Decentralized record expiry
    5.
    发明授权
    Decentralized record expiry 有权
    权力下放记录到期

    公开(公告)号:US07783607B2

    公开(公告)日:2010-08-24

    申请号:US11863902

    申请日:2007-09-28

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30306

    摘要: A technique is described that reduces the complexity and resource consumption associated with performing record expiry in a distributed database system. In accordance with the technique, a record is checked to see if it has expired only when it has been accessed for a read or a write. If at the time of a read a record is determined to have expired, then it is not served. If at the time of a write a record is determined to have expired, then the write is treated as an insertion of a new record, and steps are taken to treat the insertion consistently with regard to the previous expired version. A background process is used to delete records that have not been written to or actively deleted by a client after expiration.

    摘要翻译: 描述了一种降低与在分布式数据库系统中执行记录到期相关联的复杂性和资源消耗的技术。 根据该技术,检查记录以查看它是否仅在已被访问以进行读取或写入时才过期。 如果在阅读时确定记录已经过期,则不会提供记录。 如果在写入时确定记录已经过期,则写入被视为新记录的插入,并且采取步骤以一致的方式对先前的过期版本进行处理。 使用后台进程来删除客户端到期后尚未写入或主动删除的记录。

    SYSTEM FOR MAINTAINING A DATABASE
    6.
    发明申请
    SYSTEM FOR MAINTAINING A DATABASE 审中-公开
    维护数据库的系统

    公开(公告)号:US20090144333A1

    公开(公告)日:2009-06-04

    申请号:US11948262

    申请日:2007-11-30

    IPC分类号: G06F17/30

    CPC分类号: G06F16/21

    摘要: A system for maintaining a database. The system includes a storage unit for storing many tablets each tablet including multiple records. The tablet controller is configured to maintain the relationship between the tablet and the storage unit. The tablet controller tracks failures to access the storage unit and designates a new storage unit for each tablet based on a storage unit failure. A router is in communication with the tablet controller and configured to distribute messages from clients to the storage units thereby serving as a layer of indirection.

    摘要翻译: 用于维护数据库的系统。 该系统包括用于存储包括多个记录的每个平板电脑的许多片的存储单元。 平板电脑控制器被配置为维持平板电脑和存储单元之间的关系。 平板电脑控制器跟踪访问存储单元的故障,并根据存储单元故障为每个平板电脑指定一个新的存储单元。 路由器与平板电脑控制器通信,并被配置为将消息从客户端分发到存储单元,从而用作间接层。

    SYSTEM FOR STORING DISTRIBUTED HASHTABLES
    7.
    发明申请
    SYSTEM FOR STORING DISTRIBUTED HASHTABLES 审中-公开
    存储分布式可变系统

    公开(公告)号:US20090144220A1

    公开(公告)日:2009-06-04

    申请号:US11948236

    申请日:2007-11-30

    IPC分类号: G06F17/30

    CPC分类号: G06F16/2255

    摘要: A system for storing a distributed hash table. The system includes a storage unit, a tablet controller, a router, and a transaction bank. The storage unit has a plurality of tablets forming a hash table and each of the tablets includes multiple records. The tablet controller maintains a relationship between each tablet and the storage unit. The router hashes a record's key to determine the tablet associated with each record. Further, the router distributes messages from clients to the storage units based on the tablet-storage unit relationship thereby serving as a layer of indirection. The transaction bank propagates updates made in one record to all other replicas of the record.

    摘要翻译: 一种用于存储分布式哈希表的系统。 该系统包括存储单元,平板电脑控制器,路由器和交易银行。 存储单元具有形成散列表的多个片,并且每个片包括多个记录。 平板电脑控制器维持每个平板电脑和存储单元之间的关系。 路由器散列记录的密钥以确定与每个记录相关联的平板电脑。 此外,路由器基于平板电脑存储单元关系将消息从客户端分发到存储单元,从而用作间接层。 交易银行将一条记录中的更新传播到记录的所有其他副本。

    ASYNCHRONOUSLY REPLICATED DATABASE SYSTEM USING DYNAMIC MASTERSHIP
    8.
    发明申请
    ASYNCHRONOUSLY REPLICATED DATABASE SYSTEM USING DYNAMIC MASTERSHIP 审中-公开
    使用动态MASTERSHIP的异步数据库系统

    公开(公告)号:US20090144338A1

    公开(公告)日:2009-06-04

    申请号:US11948221

    申请日:2007-11-30

    IPC分类号: G06F17/30 G06F12/06

    CPC分类号: G06F16/273

    摘要: A system for a distributed database implementing a dynamic mastership strategy. The system includes a multiple data centers, each having a storage unit to store a set of records. Each data center stores its own replica of the set of records and each record includes a field that indicates which data center is assigned to be the master for that record. Since each of the data centers can he geographically distributed, one record may be more efficiently edited with the master being one geographic region while another record, possibly belonging to a different user, may be more efficiently edited with the master being located in another geographic region.

    摘要翻译: 用于分布式数据库的系统,用于实现动态管理策略。 该系统包括多个数据中心,每个数据中心具有存储单元以存储一组记录。 每个数据中心存储其自己的记录集合的副本,并且每个记录包括指示哪个数据中心被分配为该记录的主数据的字段。 由于每个数据中心都可以在地理上分布,所以主机可以更有效地编辑一个记录,主机是一个地理区域,而可能属于不同用户的另一个记录可以被更有效地编辑,主机位于另一个地理区域 。