DYNAMICALLY SELECTING AMONG LEARNED AND NON-LEARNED INDEXES FOR DATA ACCESS

    公开(公告)号:US20220245116A1

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

    申请号:US17727886

    申请日:2022-04-25

    申请人: Nasdaq, Inc.

    摘要: The described technology relates to systems and techniques for accessing a database by dynamically choosing an index from a plurality of indexes that includes at least one learned index and at least one non-learned index. The availability of learned and non-learned indexes for accessing the same database provides for flexibility in accessing the database, and the dynamic selection between learned indexes and non-learned indexes provide for choosing the index based on the underlying data in the database and the characteristics of the query. Certain example embodiments provide a learned model that accepts a set of features associated with the query as input, and outputs a set of evaluated weights for respective features, which are then processed according to a set of rules to predict the most efficient index to be used.

    DYNAMICALLY SELECTING AMONG LEARNED AND NON-LEARNED INDEXES FOR DATA ACCESS

    公开(公告)号:US20230350866A1

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

    申请号:US18218278

    申请日:2023-07-05

    申请人: Nasdaq, Inc.

    摘要: The described technology relates to systems and techniques for accessing a database by dynamically choosing an index from a plurality of indexes that includes at least one learned index and at least one non-learned index. The availability of learned and non-learned indexes for accessing the same database provides for flexibility in accessing the database, and the dynamic selection between learned indexes and non-learned indexes provide for choosing the index based on the underlying data in the database and the characteristics of the query. Certain example embodiments provide a learned model that accepts a set of features associated with the query as input, and outputs a set of evaluated weights for respective features, which are then processed according to a set of rules to predict the most efficient index to be used.