公开(公告)号：US20210256028A1

公开(公告)日：2021-08-19

申请号：US16795393

申请日：2020-02-19

Applicant: SAP SE

Inventor： Axel Herbst ,  Knut Manske

IPC: G06F16/2455 ,  G06Q10/06 ,  G06F16/242 ,  G06F16/28

Abstract: In a database environment including a plurality of logical object definitions having relationships defined according to a schema, and logical object instances following the logical object definitions include attribute names and respective attribute values indicating status of an enterprise in an enterprise resource planning system, the method can receive a starting exception definition specifying a first query against the logical object instances and derive a new exception definition based on the starting exception definition and one or more stored, acted-upon exception definition proposals. The first query can include one or more initial situational trigger conditions. The new exception definition can specify a second query against the logical object instances and the second query can include one or more modified situational trigger conditions.

公开(公告)号：US20180173771A1

公开(公告)日：2018-06-21

申请号：US15382286

申请日：2016-12-16

Applicant: SAP SE

Inventor： Ralf Dentzer ,  Axel Herbst

IPC: G06F17/30

CPC classification number: G06F16/2477 ,  G06F16/21 ,  G06F16/221 ,  G06F16/2291

Abstract: A database includes a plurality of partitions with respective partition dates. A query is received for data from a view of the database, the query containing a filtering parameter for retrieval of the data. A definition of the view is analyzed to determine a table of the database that contributes to the view and an aging object associated with the table. A restriction rule associated with the aging object is identified, for example, based on an annotation in the definition of the view. A restriction date for the aging object is determined based on the restriction rule. A partition, from the plurality of partitions, is selected based on the partition date of the partition being equal to or later than the restriction date. The queried data is retrieved from the selected partition according to the filtering parameter and a response to the query is generated based on the retrieved data.

公开(公告)号：US09639538B2

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

申请号：US13930581

申请日：2013-06-28

Applicant: SAP SE

Inventor： Toni Fabijancic ,  Axel Herbst ,  Jan Nolte-Boemelburg ,  Mathias Roeher

IPC: G06F17/30 ,  G06F11/14

CPC classification number: G06F17/30073 ,  G06F11/1451 ,  G06F17/30312

Abstract: Archiving may be integrated into an organization's existing data management systems instead of being configured as a separate system. This integration may occur by adding an archiving table to an existing database of the organization containing data that is to be archived. The archiving table may include multiple records, each record storing a binary large object representing a complete, self-contained archive of the organization's data at a preselected time. Incorporating archiving and archived data into the organization's existing data management systems in this manner may eliminate the need for a dedicated archiving system and may eliminate synchronization and interconnectivity issues with an independent archiving system.

公开(公告)号：US20170039227A1

公开(公告)日：2017-02-09

申请号：US14818992

申请日：2015-08-05

Applicant: SAP SE

Inventor： Axel Herbst ,  Veit Bolik ,  Mathias Roeher

IPC: G06F17/30

CPC classification number: G06F17/30309 ,  G06F17/30336 ,  G06F17/30569

Abstract: Embodiments relate to data archiving utilizing an existing big data platform (e.g., HADOOP) as a cost-effective target infrastructure for storage. Particular embodiments construct a logical structure (hereafter, “vault”) in the big data platform so that a source, type, and context of the data is maintained, and metadata can be added to aid searching for snapshots according to a given time, version, and other considerations. A vaulting process transforms relationally stored data in an object view to allow for object-based retrieval or object-wise operations (such as destruction due to legal data privacy reasons), and provide references to also store unstructured data (e.g., sensor data, documents, streams) as attachments. A legacy archive extractor provides extraction services for existing archives, so that extracted information is stored in the same vault. This allows for cross queries over legacy data and data from other sources, facilitating the application of new analysis techniques by data scientists.

Abstract translation: 实施例涉及利用现有的大数据平台（例如，HADOOP）作为用于存储的成本有效的目标基础设施的数据存档。 特定实施例在大数据平台中构建逻辑结构（以下称为“保险库”），从而维护数据的源，类型和上下文，并且可以添加元数据以帮助根据给定时间版本搜索快照 ，和其他考虑。 存储过程将对象视图中的关系存储数据转换为允许基于对象的检索或对象操作（例如由于合法的数据隐私原因而被破坏），并提供对存储非结构化数据的引用（例如，传感器数据，文档 ，流）作为附件。 遗留归档提取器为现有存档提供提取服务，从而将提取的信息存储在同一个文件库中。 这允许对遗留数据和来自其他来源的数据进行交叉查询，从而有助于数据科学家应用新的分析技术。

公开(公告)号：US10095717B2

公开(公告)日：2018-10-09

申请号：US14818992

申请日：2015-08-05

Applicant: SAP SE

Inventor： Axel Herbst ,  Veit Bolik ,  Mathias Roeher

IPC: G06F17/30

Abstract: Embodiments relate to data archiving utilizing an existing big data platform (e.g., HADOOP) as a cost-effective target infrastructure for storage. Particular embodiments construct a logical structure (hereafter, “vault”) in the big data platform so that a source, type, and context of the data is maintained, and metadata can be added to aid searching for snapshots according to a given time, version, and other considerations. A vaulting process transforms relationally stored data in an object view to allow for object-based retrieval or object-wise operations (such as destruction due to legal data privacy reasons), and provide references to also store unstructured data (e.g., sensor data, documents, streams) as attachments. A legacy archive extractor provides extraction services for existing archives, so that extracted information is stored in the same vault. This allows for cross queries over legacy data and data from other sources, facilitating the application of new analysis techniques by data scientists.

公开(公告)号：US11561982B2

公开(公告)日：2023-01-24

申请号：US16795393

申请日：2020-02-19

Applicant: SAP SE

Inventor： Axel Herbst ,  Knut Manske

IPC: G06F17/00 ,  G06F7/00 ,  G06F16/2455 ,  G06F16/28 ,  G06F16/242 ,  G06Q10/06

Abstract: In a database environment including a plurality of logical object definitions having relationships defined according to a schema, and logical object instances following the logical object definitions include attribute names and respective attribute values indicating status of an enterprise in an enterprise resource planning system, the method can receive a starting exception definition specifying a first query against the logical object instances and derive a new exception definition based on the starting exception definition and one or more stored, acted-upon exception definition proposals. The first query can include one or more initial situational trigger conditions. The new exception definition can specify a second query against the logical object instances and the second query can include one or more modified situational trigger conditions.

公开(公告)号：US10380334B2

公开(公告)日：2019-08-13

申请号：US14934629

申请日：2015-11-06

Applicant: SAP SE

Inventor： Ajalesh P. Gopi ,  Tenzin Choegyen ,  Santosh V ,  Sharath Jois ,  Axel Herbst

IPC: G06F17/30 ,  G06F7/00 ,  G06F21/34 ,  G06F21/62

Abstract: The user of an application may query a data storage system with a request to access a dataset from a database of the system. The system identifies at least one data access rule that is applicable to the dataset, with the at least one data access rule specifying at least one user group authorized to access a restricted portion of the dataset. The system identifies an authorized access group associated with the application user and compares it to the at least one user group authorized to access the restricted portion of the dataset. If the authorized access group associated with the user does not match one of the at least one user group authorized to access the restricted portion of the dataset, the system assembles a modified dataset based on the dataset and the at least one data access rule and transmits the modified dataset to the application.

公开(公告)号：US10346418B2

公开(公告)日：2019-07-09

申请号：US15382286

申请日：2016-12-16

Applicant: SAP SE

Inventor： Ralf Dentzer ,  Axel Herbst

IPC: G06F17/30 ,  G06F16/2458 ,  G06F16/22 ,  G06F16/21

Abstract: A database includes a plurality of partitions with respective partition dates. A query is received for data from a view of the database, the query containing a filtering parameter for retrieval of the data. A definition of the view is analyzed to determine a table of the database that contributes to the view and an aging object associated with the table. A restriction rule associated with the aging object is identified, for example, based on an annotation in the definition of the view. A restriction date for the aging object is determined based on the restriction rule. A partition, from the plurality of partitions, is selected based on the partition date of the partition being equal to or later than the restriction date. The queried data is retrieved from the selected partition according to the filtering parameter and a response to the query is generated based on the retrieved data.

公开(公告)号：US20170132401A1

公开(公告)日：2017-05-11

申请号：US14934629

申请日：2015-11-06

Applicant: SAP SE

Inventor： Ajalesh P. Gopi ,  Tenzin Choegyen ,  Santosh V ,  Sharath Jois ,  Axel Herbst

IPC: G06F21/34 ,  G06F21/62

CPC classification number: G06F21/34 ,  G06F21/6218 ,  G06F21/6227 ,  G06F2221/2141

Abstract: The user of an application may query a data storage system with a request to access a dataset from a database of the system. The system identifies at least one data access rule that is applicable to the dataset, with the at least one data access rule specifying at least one user group authorized to access a restricted portion of the dataset. The system identifies an authorized access group associated with the application user and compares it to the at least one user group authorized to access the restricted portion of the dataset. If the authorized access group associated with the user does not match one of the at least one user group authorized to access the restricted portion of the dataset, the system assembles a modified dataset based on the dataset and the at least one data access rule and transmits the modified dataset to the application.