BASE USER DEFINED FUNCTIONS
    3.
    发明申请

    公开(公告)号:US20180046659A1

    公开(公告)日:2018-02-15

    申请号:US15555634

    申请日:2015-03-20

    CPC classification number: G06F16/2291 G06F16/245

    Abstract: Methods, devices, and techniques for base user defined functions in a database management system are discussed herein. For example, in one aspect, a query request is received from a computer device. The query request may include a query operator representing a specialized user defined function (SUDF). The SUDF may then be executed. Executing the SUDF may include executing a base operation of a base user defined function (BUDF). The base operation may interact with an application programming interface (API) of the query engine to obtain a tuple stored in the database. Executing the SUDF may further include executing a specialized operation that processes the tuple according to an analytics function. The specialized operation may generate a result. Then, a query result may be returned to the computer device. The query result can include the result.

    ACCESSING ELECTRONIC DATABASES
    4.
    发明申请

    公开(公告)号:US20180011905A1

    公开(公告)日:2018-01-11

    申请号:US15202636

    申请日:2016-07-06

    CPC classification number: G06F16/24554 G06F16/21 G06F16/2433

    Abstract: Examples disclosed herein relate to accessing electronic databases. Some examples disclosed herein may include partitioning a computation task into subtasks. A processing node of a computation engine may generate a database query for retrieving an electronic data segment associated with at least one of the subtasks from a database. The database query may include pre-processing instructions for a database management system (DBMS) associated with the database to pre-process the electronic data segment before providing the electronic data segment to the processing node. The pre-processing instructions may include at least one of: filtering, projection, join, aggregation, count, and user-defined instructions. The generated query may be provided to the DBMS.

    PARALLEL TRANSFERS OF ELECTRONIC DATA
    5.
    发明申请

    公开(公告)号:US20180011886A1

    公开(公告)日:2018-01-11

    申请号:US15203451

    申请日:2016-07-06

    CPC classification number: G06F16/2282 G06F16/2365 G06F16/2379

    Abstract: Examples disclosed herein relate to parallel transfers of electronic data. Some examples disclosed herein may include executing, by a processing node of a computation engine, a computation task among a plurality of computation tasks generated by the computation engine for transferring an electronic data table to a target table. The computation task, when executed by the processing node, may cause the processing node to transfer a segment of the electronic data table to a staging table, update a task status table upon completing the transfer of the segment to the staging table, in response to determining that the plurality of computation tasks have completed, update a last committer table with a task identifier associated with the computation task, and in response to determining that the last committer table includes the task identifier associated with the computation task, transfer the staging table to the target table.

    Accessing electronic databases
    6.
    发明授权

    公开(公告)号:US10909119B2

    公开(公告)日:2021-02-02

    申请号:US15202636

    申请日:2016-07-06

    Abstract: Examples disclosed herein relate to accessing electronic databases. Some examples disclosed herein may include partitioning a computation task into subtasks. A processing node of a computation engine may generate a database query for retrieving an electronic data segment associated with at least one of the subtasks from a database. The database query may include pre-processing instructions for a database management system (DBMS) associated with the database to pre-process the electronic data segment before providing the electronic data segment to the processing node. The pre-processing instructions may include at least one of: filtering, projection, join, aggregation, count, and user-defined instructions. The generated query may be provided to the DBMS.

    QUERIES BASED ON RANGES OF HASH VALUES
    7.
    发明申请

    公开(公告)号:US20180268030A1

    公开(公告)日:2018-09-20

    申请号:US15762586

    申请日:2015-09-25

    Abstract: A system includes a database client, and a distributed database comprising database nodes. The distributed database may receive a database query from the client, determine that the query comprises a range of hash values of a table partition stored by a node of the distributed database, and determine that the range of hash values is not stored by other nodes of the distributed database. Responsive to determining that the range of hash values of the query is stored by the node and not by the other nodes, the database may generate an optimized distributed execution plan that includes the node that stores the range of hash values and excludes the nodes that do not include the range of hash values.

Patent Agency Ranking