Graphic representations of data relationships

    公开(公告)号:US09910901B2

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

    申请号:US15378322

    申请日:2016-12-14

    IPC分类号: G06F17/00 G06F17/30

    摘要: Presenting a diagram indicating relationships among data items stored in a data management system includes: receiving a request that identifies a first data item stored in the data management system from a user interface; retrieving stored configuration information that includes a plurality of selection specifications for selecting data items in the data management system that are related to a given data item of a predetermined type, where each selection specification is associated with a different respective predetermined type; querying the data management system to identify a set of one or more data items according to a selection specification from the configuration information that is associated with a type of the first data item; for each of multiple returned data items in the identified set, querying the data management system to determine whether additional data items are identified according to a selection specification from the configuration information that is associated with a type of the returned data item; generating a diagram indicating relationships among data items identified using the configuration information; and presenting the generated diagram over the user interface.

    PATTERN-BASED QUERY RESULT ENHANCEMENT
    3.
    发明申请

    公开(公告)号:US20170329818A1

    公开(公告)日:2017-11-16

    申请号:US15155136

    申请日:2016-05-16

    申请人: SAP SE

    IPC分类号: G06F17/30

    摘要: A system includes reception of a first query, the first query comprising at least one of one or more dimensions and one or more measures, identification, in response to reception of the first query, of a first stored query set associated with the first query, the first stored query set comprising a plurality of queries, determination, in response to identification of the first stored query set, of a first plurality of result sets, each of the first plurality of result sets comprising a respective result set of the first query and each query of the plurality of queries, and presentation of a visualization of each of the first plurality of result sets.

    Record level data security
    4.
    发明授权

    公开(公告)号:US09792454B2

    公开(公告)日:2017-10-17

    申请号:US14993949

    申请日:2016-01-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.

    GRAPHIC REPRESENTATIONS OF DATA RELATIONSHIPS

    公开(公告)号:US20170091345A1

    公开(公告)日:2017-03-30

    申请号:US15378322

    申请日:2016-12-14

    IPC分类号: G06F17/30

    摘要: Presenting a diagram indicating relationships among data items stored in a data management system includes: receiving a request that identifies a first data item stored in the data management system from a user interface; retrieving stored configuration information that includes a plurality of selection specifications for selecting data items in the data management system that are related to a given data item of a predetermined type, where each selection specification is associated with a different respective predetermined type; querying the data management system to identify a set of one or more data items according to a selection specification from the configuration information that is associated with a type of the first data item; for each of multiple returned data items in the identified set, querying the data management system to determine whether additional data items are identified according to a selection specification from the configuration information that is associated with a type of the returned data item; generating a diagram indicating relationships among data items identified using the configuration information; and presenting the generated diagram over the user interface.

    ADAPTIVE QUERY PROCESSOR FOR QUERY SYSTEMS WITH LIMITED CAPABILITIES

    公开(公告)号:US20170083551A1

    公开(公告)日:2017-03-23

    申请号:US15367544

    申请日:2016-12-02

    发明人: Stephen M. COHOON

    IPC分类号: G06F17/30

    摘要: A query processor determines if an initial query results in a query system having a search engine coupled to a database to identify a limited maximum number of records deliverable by the query system. This limitation is indicative of an incomplete result because records are includable in the query may not be included in the result. In response the query processor generates a plurality of queries that cause the query system to generate results that identify less than the maximum number. The results of the plurality of queries are combined as a response to the initial query. Duplicate records caused by any overlap in the plurality of queries may be eliminated from the combination. Determining a median value of a query range that causes the query system to deliver the maximum number of records may be utilized in the generation of the plurality of queries.