Computer system and query processing method

    公开(公告)号:US12056129B2

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

    申请号:US18113154

    申请日:2023-02-23

    Applicant: Hitachi, Ltd.

    CPC classification number: G06F16/2456 G06F11/3433 G06F16/2255

    Abstract: 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.

    TECHNIQUES FOR A CLOUD SCIENTIFIC MACHINE LEARNING PROGRAMMING ENVIRONMENT

    公开(公告)号:US20240241701A1

    公开(公告)日:2024-07-18

    申请号:US18414136

    申请日:2024-01-16

    CPC classification number: G06F8/36 G06F11/3433

    Abstract: Various aspects of the present disclosure relate to techniques for a cloud scientific machine learning programming environment. An apparatus includes at least one memory and at least one processor coupled to the memory and configured to cause the apparatus to receive a request to perform a machine learning task, analyze the machine learning task to determine one or more functions for performing the machine learning task, generate a workflow for the one or more functions of the machine learning task, execute the generated workflow, and provide results of the executed workflow.

Patent Agency Ranking