TABLE-PER-PARTITION
    2.
    发明申请
    TABLE-PER-PARTITION 审中-公开

    公开(公告)号:US20180322127A1

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

    申请号:US15586119

    申请日:2017-05-03

    申请人: ServiceNow, Inc.

    IPC分类号: G06F17/30

    摘要: The present approach improves the query performance of a database in a manner that is transparent to a user. In one aspect, this approach creates separate partition tables that are not directly accessible to a user of the database. A client-facing aspect of the database is a logical model which may correspond to a single, main table with which the user interacts. Thus, queries or operations may be generated on the client side in the context of the logical model. A database or query layer can then, transparent to the user, translate the user generated requests into query language that addresses the proper partitions to generate a result set or otherwise perform a database operation.

    DATA PROCESSING WITH STREAMING DATA
    3.
    发明申请

    公开(公告)号:US20180307731A1

    公开(公告)日:2018-10-25

    申请号:US15946128

    申请日:2018-04-05

    发明人: Wei Xiao

    IPC分类号: G06F17/30 G06F17/16

    摘要: A data streaming environment provides a summary of streaming data from a sensor that is an Internet of things device. An input interface receives the streaming data. A processor is communicatively coupled to the input interface for processing the streaming data. The processed streaming data includes, but is not limited to, a plurality of records and variables that describe a characteristic of a physical object. A computer-readable medium has instructions stored thereon that, when executed by the processor, cause the processor to execute a correlation update application with the received streaming data to provide a correlation between two variables of the streaming data. The non-transitory computer-readable medium further stores sum and bin data for the correlation update application to compute the correlation. The output interface provides the processed streaming data to be visually presented in one or more data graphs on a display device.

    Record level data security
    4.
    发明授权

    公开(公告)号:US09965644B2

    公开(公告)日:2018-05-08

    申请号:US15702690

    申请日:2017-09-12

    IPC分类号: G06F17/30 G06F21/62

    摘要: A database security system protects a data table at both the column level and the individual data record level. Access to data records within the data table is governed by categories assigned to data records, by user roles assigned to users, and by a set of security access tables. A first access table maps data record identifiers to data record categories, data record protection schemes, and corresponding scheme keys. A second access table maps user roles to data record categories. A third access table maps column identifiers to column protection schemes and corresponding scheme keys. A fourth access table maps user roles to column identifiers. If a user requests access to a data record, the security access tables are queried using the data record identifier, the associated column identifier, and the user roles associated with the user to determine if the user can access the requested data record.

    IDENTIFICATION OF COMMON ATTRIBUTES IN MULTIPLE DATASETS

    公开(公告)号:US20170371949A1

    公开(公告)日:2017-12-28

    申请号:US15189220

    申请日:2016-06-22

    申请人: SAP SE

    发明人: Yann Le Biannic

    IPC分类号: G06F17/30

    摘要: A system comprises reception of a dataset comprising at least one dataset attribute and one or more instances of each dataset attribute, determination of a similarity value between instances of each pair of one of the at least one dataset attribute and one of a plurality of stored attributes, determination of an intersection between instances of each pair of one of the at least one dataset attribute and one of the stored attributes having a similarity greater than a threshold, and generation of metadata associating a dataset attribute with a semantic entity with which a stored attribute having a similarity to the dataset attribute greater than the threshold is associated.