QUERY PROCESSING USING HORIZONTAL PARTIAL COVERING JOIN INDEX
    21.
    发明申请
    QUERY PROCESSING USING HORIZONTAL PARTIAL COVERING JOIN INDEX 审中-公开
    查询处理使用水平部分覆盖加入索引

    公开(公告)号:US20100036799A1

    公开(公告)日:2010-02-11

    申请号:US12186173

    申请日:2008-08-05

    IPC分类号: G06F17/30

    CPC分类号: G06F16/24544

    摘要: A computer implemented system and method includes obtaining a query referring to rows in a relational database. A sparse index of the database that has a set of rows that is a subset of the rows referred to in the query is obtained. Rows referred to in the query that are not in the sparse index are then obtained and a union of such rows and the rows of the sparse index is performed to obtain a complete row set for processing the query.

    摘要翻译: 计算机实现的系统和方法包括获取参考关系数据库中的行的查询。 获取具有一组行的数据库的稀疏索引,该行是查询中引用的行的子集。 然后获取查询中引用的不在稀疏索引中的行,并执行这些行和稀疏索引的行的并集,以获取用于处理查询的完整行集。