EFFICIENT INDEXING FOR QUERYING ARRAYS IN DATABASES

    公开(公告)号:US20210357373A1

    公开(公告)日:2021-11-18

    申请号:US15930351

    申请日:2020-05-12

    申请人: Couchbase, Inc.

    摘要: A database system performs queries on fields storing arrays of a database (i.e., array fields) using de-duplication indexes. The system generates de-duplication indexes for array fields. The de-duplication indexes include unique entries for corresponding distinct values stored by the array fields. The system uses the de-duplication indexes to perform efficient queries specifying corresponding array fields. The system may further generate de-duplication indexes corresponding one or more fields storing various types of values. In various embodiments, the system selects an optimal index from various indexes usable to execute a query, such as a de-duplication index and a conventional index.

    Efficient Indexing for Querying Arrays in Databases

    公开(公告)号:US20220391367A1

    公开(公告)日:2022-12-08

    申请号:US17888341

    申请日:2022-08-15

    申请人: Couchbase, Inc.

    摘要: A database system performs queries on fields storing arrays of a database (i.e., array fields) using de-duplication indexes. The system generates de-duplication indexes for array fields. The de-duplication indexes include unique entries for corresponding distinct values stored by the array fields. The system uses the de-duplication indexes to perform efficient queries specifying corresponding array fields. The system may further generate de-duplication indexes corresponding one or more fields storing various types of values. In various embodiments, the system selects an optimal index from various indexes usable to execute a query, such as a de-duplication index and a conventional index.

    Efficient indexing for querying arrays in databases

    公开(公告)号:US11416458B2

    公开(公告)日:2022-08-16

    申请号:US15930351

    申请日:2020-05-12

    申请人: Couchbase, Inc.

    摘要: A database system performs queries on fields storing arrays of a database (i.e., array fields) using de-duplication indexes. The system generates de-duplication indexes for array fields. The de-duplication indexes include unique entries for corresponding distinct values stored by the array fields. The system uses the de-duplication indexes to perform efficient queries specifying corresponding array fields. The system may further generate de-duplication indexes corresponding one or more fields storing various types of values. In various embodiments, the system selects an optimal index from various indexes usable to execute a query, such as a de-duplication index and a conventional index.