PROVIDING UNIQUE VIEWS OF DATA BASED ON CHANGES OR RULES

    公开(公告)号:US20170169244A1

    公开(公告)日:2017-06-15

    申请号:US15438453

    申请日:2017-02-21

    IPC分类号: G06F21/62 G06Q50/26 G06F17/30

    摘要: In one embodiment, a method comprises creating and storing, in a revisioning database, one or more data objects; wherein a first plurality of the data objects is associated with a base realm representing data shared across all users of the database; wherein a second plurality of the data objects is associated with one or more child realms, wherein each of the child realms represents data local to a project, wherein each of the users is associated with one or more of the child realms; wherein the revisioning database associates each data object to a realm identifier value and to a version identifier value for a plurality of versions of the data object, wherein each of the versions represents a change to the data object by any of a plurality of users; receiving a request from a first user to view a third plurality of data objects in the revisioning database; selecting, based on the base realm, the particular realm, the version identifier value for the data objects in the third plurality, and one or more rules associated with the particular realm and the first user, data objects in the third plurality that can be viewed by the first user; creating a particular data view that includes only the selected data objects; and providing a display of the particular data view to the first user.

    SQL enhancements simplifying database querying

    公开(公告)号:US09639572B2

    公开(公告)日:2017-05-02

    申请号:US14020610

    申请日:2013-09-06

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30418 G06F17/30604

    摘要: Disclosed are techniques employed alone or in combination, to further enhance a database language and improve conciseness and comprehensiveness of query statements in application code. Embodiments may build upon an initial extension of database language to accommodate concepts of entity-relationship models (ERMs). That initial extension may include entities with structured types, and named associations. One technique modifies SQL to allow the SELECT command to specify element path expressions based upon a relationship (e.g. named associations between ERM elements). Another technique modifies SQL to introduce filter expressions suffixed to associations within path expressions, thus improving adherence to the principle of locality within query statements. Yet another technique allows a shorthand to “factor out” association path prefixes, thereby avoiding lengthy lists of path expressions in order to read several elements from the same nested structure or a same target entity behind a single association. Other techniques simplifying database querying are also disclosed.

    Unit of work based incremental data processing
    5.
    发明授权
    Unit of work based incremental data processing 有权
    基于工作单位的增量数据处理

    公开(公告)号:US09454557B2

    公开(公告)日:2016-09-27

    申请号:US14158964

    申请日:2014-01-20

    IPC分类号: G06F17/30 G06F19/00

    摘要: Systems, methods, and other embodiments associated with a unit of work for incremental data processing are described. In one embodiment, a method includes selecting a unit of work key for a program that processes records in a source table. The unit of work key is selected such that modifications to a record having a certain unit of work key value will not affect the program's processing of records having a different unit of work key value. The selected unit of work key is associated with the program. When a record in the source table is created, modified, or deleted, a unit of work key value is identified for the record and a selected set of records having the identified unit of work key value is provided to the program. Thus, records in the data source that do not have the identified unit of work key values are not provided to the program.

    摘要翻译: 描述了与用于增量数据处理的工作单元相关联的系统,方法和其他实施例。 在一个实施例中,一种方法包括为处理源表中的记录的程序选择工作密钥单位。 选择工作单位,使得对具有特定单位工作键值的记录的修改不会影响程序对具有不同单位工作键值的记录的处理。 所选择的工作单位与程序相关联。 当创建,修改或删除源表中的记录时,为记录识别出工作键值的单位,并且向程序提供具有所识别的工作键值的单位的所选择的一组记录。 因此,数据源中没有已识别的工作单位键值的记录未提供给程序。

    SQL EXTENDED WITH TRANSIENT FIELDS FOR CALCULATION EXPRESSIONS IN ENHANCED DATA MODELS

    公开(公告)号:US20160246858A1

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

    申请号:US15145559

    申请日:2016-05-03

    申请人: SAP SE

    IPC分类号: G06F17/30

    摘要: A database language (e.g. SQL) is extended to define a transient field whose value is derived from data stored in a database. The value of the transient field is calculated by the database engine for consumption as needed by the application layer, for example as part of a particular data model. The value of the transient field may not be materialized as a persistent field in the underlying database table, or may be selectively materialized based upon a heuristic or hint. Certain embodiments may implement the transient field as a basic elaboration on standard SQL utilizing an identifier. Some embodiments may implement the transient field as an entity where SQL has been extended to accommodate concepts of a higher-level Entity Relationship Model (ERM). The use of constants and/or floating values (e.g. a current time) in connection with transient fields, is also disclosed.

    System and method for accessing dimensional databases
    7.
    发明授权
    System and method for accessing dimensional databases 有权
    用于访问维数据库的系统和方法

    公开(公告)号:US09183272B1

    公开(公告)日:2015-11-10

    申请号:US14073822

    申请日:2013-11-06

    IPC分类号: G06F17/00 G06F17/30

    摘要: In one embodiment, a method includes defining a slice of a dimensional database. The slice includes at least one dimension and at least one measurement and is expressable as a table. The method further includes building, in a structured query language (SQL) dialect, a single query that queries the slice and one or more non-dimensional databases. The SQL dialect represents the at least one dimension, the at least one measurement, and data attributes of the one or more non-dimensional databases. In addition, the method includes parsing the single query. The parsing includes generating a dimensional query for the dimensional database and a non-dimensional query for each of the one or more non-dimensional databases. Furthermore, the method includes executing the dimensional query on the dimensional database. Moreover, the method includes, for each non-dimensional database of the one or more non-dimensional databases, executing the non-dimensional query on the non-dimensional database.

    摘要翻译: 在一个实施例中,一种方法包括定义维数据库的切片。 切片包括至少一个维度和至少一个测量值,并且可表示为表格。 该方法还包括以结构化查询语言(SQL)方言构建查询片和一个或多个非维数据库的单个查询。 SQL方言表示一个或多个非维数据库的至少一个维度,至少一个测量值和数据属性。 此外,该方法包括解析单个查询。 解析包括为维度数据库生成维度查询和为一个或多个非维数据库中的每一个生成非维度查询。 此外,该方法包括在维数据库上执行维度查询。 此外,对于一个或多个非维数据库的每个非维数据库,该方法包括在非维数据库上执行无量纲查询。

    Techniques for dynamic cross-filtering
    9.
    发明授权
    Techniques for dynamic cross-filtering 有权
    动态交叉滤波技术

    公开(公告)号:US09037584B2

    公开(公告)日:2015-05-19

    申请号:US14077132

    申请日:2013-11-11

    IPC分类号: G06F3/048 G06F17/30

    摘要: Techniques for dynamic cross-filtering are described. An apparatus may comprise a filter manager component for an application program. The filter manager component is operative to manage cross-filtering operations for the application program. The filter manager component may comprise a filter control module operative to determine a selection state for a filter data element of a first filter component, and a relationship state for the filter data element of the first filter component with a filter data element of a second filter component. The filter manager component may also comprise a filter interface module communicatively coupled to the filter control module. The filter interface module is operative to dynamically display a different visual indicator for the filter data elements based on the selection state and the relationship state, among other filter criteria or filter states. Other embodiments are described and claimed.

    摘要翻译: 描述了用于动态交叉滤波的技术。 装置可以包括用于应用程序的过滤器管理器组件。 过滤器管理器组件用于管理应用程序的交叉过滤操作。 过滤器管理器组件可以包括过滤器控制模块,其操作以确定第一过滤器部件的过滤器数据元素的选择状态,以及用于具有第二过滤器的过滤器数据元素的第一过滤器部件的过滤器数据元素的关系状态 零件。 过滤器管理器组件还可以包括通信地耦合到过滤器控制模块的过滤器接口模块。 过滤器接口模块用于基于选择状态和关系状态以及其他过滤标准或过滤状态来动态地显示用于过滤器数据元素的不同视觉指示符。 描述和要求保护其他实施例。

    System and method of consolidated central user administrative provisioning
    10.
    发明授权
    System and method of consolidated central user administrative provisioning 有权
    综合中央用户管理配置的系统和方法

    公开(公告)号:US08788666B2

    公开(公告)日:2014-07-22

    申请号:US12347839

    申请日:2008-12-31

    摘要: In one embodiment the present invention includes a computer-implemented method of reducing a quantity of business application programming interface (BAPI) calls in a hardware client-server environment. The method includes configuring a centralized provisioning system on a hardware server with access definitions for systems. The method further includes receiving, by the centralized provisioning system, a provisioning request for a user of a client to access the systems. The method further includes determining a collected BAPI call according to the access definitions. The method further includes providing access to the user according to the collected BAPI call.

    摘要翻译: 在一个实施例中,本发明包括一种在硬件客户机 - 服务器环境中减少业务应用编程接口(BAPI)呼叫的数量的计算机实现的方法。 该方法包括在具有系统的访问定义的硬件服务器上配置集中供应系统。 该方法还包括由集中式供应系统接收为客户端的用户访问系统的供应请求。 该方法还包括根据访问定义来确定收集的BAPI呼叫。 该方法还包括根据所收集的BAPI呼叫来提供对用户的访问。