Joining two data tables on a join attribute

    公开(公告)号:US11163769B2

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

    申请号:US16443958

    申请日:2019-06-18

    IPC分类号: G06F16/00 G06F16/2453

    摘要: A computer-implemented method for joining two data tables on a join attribute, where the data tables have at least a first and a second attribute and the second attribute is the join attribute. The method provides a function for associating a computing node to a given record. The function may be used to determine the associated computing node. The records of the two data tables may be distributed to the respective determined computing nodes. The relationship between the values of the first and second attributes may be modelled using a predefined dataset. For each record of the two data tables the values of the first attribute may be re-determined using the corresponding values of the second attribute. The function may be used to re-determine the associated computing node.

    Push down policy enforcement
    3.
    发明授权

    公开(公告)号:US11093642B2

    公开(公告)日:2021-08-17

    申请号:US16238913

    申请日:2019-01-03

    摘要: A method, computer program product, and a system where a processor(s) intercepts a query from a client targeting a database. The processor(s) analyzes the query to determine contextual data relevant to the query and determines, based on a data masking policy, if a portion of results responsive to the intercepted query should be provided to the client as masked data. When the processor(s) determines that the portion of the results should be provided to the client as masked data, the processor(s) determines computing resources managing data comprising the results responsive to the intercepted query. The processor(s) executes the query on the computing resources by obtaining the masked data via coprocessors deployed on the computing resources, where the coprocessors mask the portion of the results. The processor(s) returns query results comprising the portion of the results masked by the coprocessors, to the client.

    INDEXING DATA IN A TABLE BASED ON DATA USAGE STATISTICS

    公开(公告)号:US20210089508A1

    公开(公告)日:2021-03-25

    申请号:US16580533

    申请日:2019-09-24

    摘要: Aspects of the present invention disclose a method for ordering rows of a table based on access statistics. The method includes one or more processors adding a respective tracking mechanism to the attribute of each respective instance of the set of rows of the table of the database. The method further includes adding a tracking mechanism to the respective instances of the set of rows. The method further includes gathering access data of the respective tracking mechanism of the attribute of each respective instance of the set of rows. The method further includes determining each respective instance of an attribute value that corresponds to the access data of the respective tracking mechanism of each respective instance of the set of rows. The method further includes ordering each respective instance of the set of rows of the table based at least in part on the respective instances of the attribute values.

    Optimization of data processing job execution using hash trees

    公开(公告)号:US10922312B2

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

    申请号:US16139472

    申请日:2018-09-24

    摘要: Optimization of job execution includes generating a hash tree for an initial dataset, executing a data processing job against the initial dataset, the job including a set of calculations against data of the records of the initial dataset, generating, based on a modification to the initial dataset to produce a modified dataset, a hash tree for the modified dataset, comparing the hash tree for the initial dataset to the hash tree for the modified dataset, and identifying one or more blocks of the modified dataset that are updated compared to the initial dataset, and re-executing the job against the modified dataset. The re-executing performs only those calculations that use data of the records of the one or more blocks that are updated compared to the initial dataset, and does not perform other calculations that do not use data of the records of the one or more blocks.

    DATABASE WITH SECURITY ROW TABLES
    6.
    发明申请

    公开(公告)号:US20200320210A1

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

    申请号:US16377376

    申请日:2019-04-08

    摘要: A computer-implemented method for processing a query for accessing data in a database with row level security may be provided. The data is organized in rows and columns, and the rows are grouped in storage regions. The method comprises maintaining, as part of a control record for each storage region, a lower access security label, representing a minimal user access right of any of the rows in the storage region, and an upper access security label representing a maximal user access right of any of the rows in the storage region, and upon determining, for a query, whether an access right of a user initiating the query is below the lower access security label of a storage region addressed by the query, skipping the storage region during a read execution of the query.

    Storing data records
    7.
    发明授权

    公开(公告)号:US10318513B2

    公开(公告)日:2019-06-11

    申请号:US15831535

    申请日:2017-12-05

    IPC分类号: G06F17/30 G06F16/22

    摘要: Embodiments of the present invention provide a method, computer program product, and a computer system for storing data records in extents. According to one embodiment a data record comprising an attribute value is received. One or more data records stored in a first extent, are identified, wherein the stored one or more data records in the first extent have at least one attribute value. The attribute value of the received data record is compared to the attribute values of the identified data records stored in the first extent. It is then determined whether to store the received data record in the first extent. Responsive to determining, not to store the received data record in the first extent, the received data record is stored in a second extent. If the first received data record is stored in a second extent, determining, an attribute value information of the second extent.

    EFFICIENT PROCESSING OF DATA EXTENTS
    8.
    发明申请

    公开(公告)号:US20180060386A1

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

    申请号:US15249509

    申请日:2016-08-29

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30448 G06F17/30395

    摘要: The present disclosure relates to a computer-implemented method, computer program product, and computer system, for optimization of query processing a set of data extents on which a table is stored. Attribute value information may be maintained for each data extent. The attribute value information indicate as ranges the minimum and maximum values of an attribute of the entries stored in the respective extent. A first metric of a first data extent of the set may determine splitting the first data extent into sub-extents increases query processing efficiency. A second metric of a second data extent and a third data extent may determine merging the second data extent and the third data extent increases query processing efficiency.

    Determining control flow divergence due to variable value difference

    公开(公告)号:US09117020B2

    公开(公告)日:2015-08-25

    申请号:US14488543

    申请日:2014-09-17

    IPC分类号: G06F9/44 G06F11/36 G06F11/34

    摘要: An embodiment is directed to a method for analyzing a computer program that includes receiving an instruction specifying a first variable of the program. The first variable has a first value at a first location during program execution. The instruction further specifies a second value for the first variable at the first location. The method includes determining that a second location during program execution includes a conditional control flow instruction that includes the first variable. In addition, the method includes evaluating the conditional control flow instruction using the first and second values of the first variable at the second location. It may be determined whether control flow diverges at the second location based on the evaluating of the conditional control flow instruction using the first and second values at the second location.