SELECTING BETWEEN HYDRATION-BASED SCANNING AND STATELESS SCALE-OUT SCANNING TO IMPROVE QUERY PERFORMANCE

    公开(公告)号:US20230195726A1

    公开(公告)日:2023-06-22

    申请号:US18171245

    申请日:2023-02-17

    CPC classification number: G06F16/24537 G06F16/24539 G06F16/24542

    Abstract: When a query is received by a stateful data processing service, the service determines, for each table scan (and associated operations) of a query, whether to select the table scan for execution by a stateless data processing service. The selected table scans are sent to the stateless data processing service for execution, and results are received by the stateful data processing service. The stateful data processing service may also execute other table scans of the query locally, against a local data cache. If the data is not present in the local data cache, then the stateful data processing service will copy the table data into the local data cache before executing the table scan. A query result based on the remote and/or local table scans may then be returned to the client.

    Selecting between hydration-based scanning and stateless scale-out scanning to improve query performance

    公开(公告)号:US12197437B2

    公开(公告)日:2025-01-14

    申请号:US18171245

    申请日:2023-02-17

    Abstract: When a query is received by a stateful data processing service, the service determines, for each table scan (and associated operations) of a query, whether to select the table scan for execution by a stateless data processing service. The selected table scans are sent to the stateless data processing service for execution, and results are received by the stateful data processing service. The stateful data processing service may also execute other table scans of the query locally, against a local data cache. If the data is not present in the local data cache, then the stateful data processing service will copy the table data into the local data cache before executing the table scan. A query result based on the remote and/or local table scans may then be returned to the client.

    Selecting between hydration-based scanning and stateless scale-out scanning to improve query performance

    公开(公告)号:US11593367B1

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

    申请号:US17489532

    申请日:2021-09-29

    Abstract: When a query is received by a stateful data processing service, the service determines, for each table scan (and associated operations) of a query, whether to select the table scan for execution by a stateless data processing service. The selected table scans are sent to the stateless data processing service for execution, and results are received by the stateful data processing service. The stateful data processing service may also execute other table scans of the query locally, against a local data cache. If the data is not present in the local data cache, then the stateful data processing service will copy the table data into the local data cache before executing the table scan. A query result based on the remote and/or local table scans may then be returned to the client.

Patent Agency Ranking