Late materialization of queried data in database cache

    公开(公告)号:US12130814B2

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

    申请号:US17522504

    申请日:2021-11-09

    申请人: Google LLC

    IPC分类号: G06F16/2453 G06F16/2455

    摘要: Aspects of the disclosure are directed to late materialization of attributes in response to queries to a database implementing a database cache. Queried data is materialized in temporary memory before the data is projected as part of generating a result to the query. Instead of materializing all of the attributes referenced in a query before executing the query, a database management system materializes attributes as “late” as possible—when the operation needing the attributes is executed. The operation needing the attributes can be performed sooner, as opposed to materializing all referenced attributes are materialized before executing the query.

    Systems and methods for using machine learning for managing application incidents

    公开(公告)号:US12067502B1

    公开(公告)日:2024-08-20

    申请号:US18154962

    申请日:2023-01-16

    摘要: Disclosed herein are systems and methods for using machine learning for managing application incidents. An embodiment takes the form of a method that includes receiving extracted data pertaining to one or more applications. Model-input data is generated from the extracted data. Model-output data is generated at least in part by processing the generated model-input data with one or more machine-learning models trained to make one or more application-incident predictions. Based at least in part on the model-output data, an application-incident-likely determination is made that a likelihood of an occurrence of an application incident exceeds an application-incident-likelihood threshold, where the application incident corresponds to a given application of the one or more applications. Responsive to making the application-incident-likely determination, one or more alerts of the likelihood of the occurrence of the application incident are output.

    System and Methods for Invoking Pattern Matching to Query Tabular Data Collections

    公开(公告)号:US20240273103A1

    公开(公告)日:2024-08-15

    申请号:US18440694

    申请日:2024-02-13

    申请人: Michael Seul

    发明人: Michael Seul

    摘要: Disclosed is a method for querying by pattern matching a relational data store, including a collection of records having a preset number of attributes, wherein the representation of the content of a structured or unstructured data source also encodes the structure of the data source, and including these steps:



    providing at least one query comprising at least a find- and a where-clause, wherein the where-clause comprises one or more query patterns, and the find-clause specifies a subset of attributes optionally including aliases thereof; executing the query by:

    applying predicates in the one or more query patterns to identify a subset of matching or non-matching records;
    forming the intersection of the two or more subsets of records for two or more patterns;
    in accordance with the find-clause, selecting specified attributes and applying any aliases; and

    thereby identifying the subset of records satisfying constraints expressed in the query patterns.

    Computer system and query processing method

    公开(公告)号:US12056129B2

    公开(公告)日:2024-08-06

    申请号:US18113154

    申请日:2023-02-23

    申请人: Hitachi, Ltd.

    摘要: The processing load for joining a plurality of tables by hash join is reduced for a computer system in which the CPU of a node creates a partial bloom filter that manages a first table hash value of a joining key of a row corresponding to a query in an assigned row of a build table. An integrated bloom filter is created from a plurality of partial bloom filters, and a second table hash value of the joining key of the row corresponding to the condition of the query among the rows of a probe table is calculated. The row of the probe table is transmitted to the node containing a row of the build table of the join hash value for that row when the integrated bloom filter includes an identical first table hash value, and an integrated joined table is created and returned to the query request source.