ENFORCEMENT OF QUERY RULES BASED ON POWER FOR ACCESS TO DATA IN A DATABASE SYSTEM

    公开(公告)号:US20240338370A1

    公开(公告)日:2024-10-10

    申请号:US18743289

    申请日:2024-06-14

    摘要: A query processing system is operable to determine a set of query rules that includes a minimum result set size rule. A query is received from a requesting entity. A size of a result set of the query is determined. Compliance data is determined based on determining whether the size of the result set complies with the minimum result set size rule and based on power utilization. When the compliance data indicates the size of the result set complies with the minimum result set size rule, a query result for the query is generated based on the result set, and the query result is generated to the requesting entity. When the compliance data indicates the size of the result set does not comply with the minimum result set size rule: transmission of the query result to the requesting entity is foregone.

    REBUILDING PORTIONS OF VIRTUAL SEGMENTS BASED ON POWER

    公开(公告)号:US20240330305A1

    公开(公告)日:2024-10-03

    申请号:US18743262

    申请日:2024-06-14

    IPC分类号: G06F16/2455 G06Q50/04

    摘要: A database system operates by: identifying at least two data portions in a first segment for rebuilding, wherein the at least two data portions is a proper subset of a plurality of sequential data portions; generating a locally rebuilt set of rows for the at least two data portions based on power consumption and: determining at least two corresponding data portions of at least one other segment in the segment group required to rebuild the at least two data portions; retrieving the at least two corresponding data portions of the at least one other segment from storage; and utilizing the retrieved at least two corresponding data portions to rebuild the at least two data portions based on the redundancy coding scheme.

    PROCESSING MULTI-COLUMN STREAMS DURING QUERY EXECUTION VIA A DATABASE SYSTEM

    公开(公告)号:US20230418827A1

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

    申请号:US18322688

    申请日:2023-05-24

    摘要: A database system is operable to determine a query operator execution flow that includes a plurality of operators for execution of a corresponding query against a database having a schema that includes a plurality of columns. The query operator execution flow is executed in conjunction with executing the corresponding query against the database based on generating a first plurality of data blocks of a multi-column data stream as first output of a first operator of the plurality of operators, where each data block of the multi-column data stream includes column values for each of the plurality of columns. Executing the query operator execution flow is further based on processing the multi-column data stream as input of a second operator of the plurality of operators serially after the first operator to generate a second plurality of data blocks as second output of the second operator.

    Level-based queries in a database system and methods for use therewith

    公开(公告)号:US11853364B2

    公开(公告)日:2023-12-26

    申请号:US17340553

    申请日:2021-06-07

    IPC分类号: G06F16/903 G06F16/9038

    CPC分类号: G06F16/90335 G06F16/9038

    摘要: A method for execution by a node of a computing device includes: determining level assignment data indicating assignment to a subset of levels of a plurality of levels of a query execution plan, wherein the plurality of levels includes a lowest level, at least one inner level, and a highest level; determining a query for execution; determining a query discriminator number corresponding to the query; determining to process the query at one of the plurality of levels based on determining the one of the plurality of levels is included in the subset of levels; generating query resultant data by facilitating execution of at least one query operator of the query in accordance with the one of the plurality of levels; selecting one of a plurality of possible parent nodes in a sequentially higher one of the plurality of levels based on the query discriminator number; and sending the query resultant data to the one of the plurality of possible parent nodes for processing.