Efficient multiple aggregation distinct processing

    公开(公告)号:US10747763B2

    公开(公告)日:2020-08-18

    申请号:US15152333

    申请日:2016-05-11

    IPC分类号: G06F16/2453

    摘要: A computer program product provides efficient multiple aggregation distinct processing. The computer program product including a computer readable storage medium having program instructions embodied therewith. The program instructions are executable by a processor to cause the processor to convert a query with multiple aggregation distincts into a two-stage group-by process using a nest operator. The two-stage group-by process including further program instructions to cause the processor to: perform a first stage group-by process including the nest operator taking a single input row, and concatenating a grouping key with a measure value for each aggregation distinct that forms multiple inputs to a single group-by table, and perform a second stage group-by process including the nest operator bringing together entries for each original group.

    TRACKING DATA AVAILABILITY USING HEARTBEATS
    6.
    发明申请

    公开(公告)号:US20200050697A1

    公开(公告)日:2020-02-13

    申请号:US16057560

    申请日:2018-08-07

    IPC分类号: G06F17/30

    摘要: One embodiment provides for a method to track replication state and providing quorum visible retrievals. The method includes assigning, by a writer node performing write operations, a sequence number. The sequence number is replicated with a write operation to other replica nodes in an asynchronous fashion thru a first network channel. On a second network channel, a state of a local system is communicated by sending a latest sequence number available that has been hardened to the other replica nodes. A query is obtained by a reader node, and a sequence number limit is selected. Results up to the sequence number limit are returned.

    Data shuffling in a non-uniform memory access device

    公开(公告)号:US10521128B2

    公开(公告)日:2019-12-31

    申请号:US15828473

    申请日:2017-12-01

    摘要: A method of orchestrated shuffling of data in a non-uniform memory access device that includes a plurality of processing nodes connected by interconnects. The method includes running an application on a plurality of threads executing on the plurality of processing nodes. Data to be shuffled is identified from source threads running on source processing nodes among the processing nodes to target threads executing on target processing nodes among the processing nodes. The method further includes generating a plan for orchestrating the shuffling of the data among the all of the memory devices associated with the threads and for simultaneously transmitting data over different interconnects to a plurality of different target processing nodes from a plurality of different source processing nodes. The data is shuffled among all of the memory devices based on the plan. Shifting the data-shifting table includes rotating a first ring with respect to a second ring.

    Technology to reduce cost of concatenation for hash array

    公开(公告)号:US10430408B2

    公开(公告)日:2019-10-01

    申请号:US14864427

    申请日:2015-09-24

    摘要: A first table has more than one key column, and a hash array is built for the table, which includes computing hash indices for respective rows of the first table based on more than one key column. Building the hash array also includes writing in the hash array for each row at a respective location in the hash array, wherein each location is indicated by each row's respective hash index computed from the more than one key column. The hash array is probed responsive to the second table. In the building of the hash array for the first table, the writing in the hash array for each row at a respective location in the hash array writes only one of the key columns as a single key field in the hash array for each row.