公开(公告)号：US20240028250A1

公开(公告)日：2024-01-25

申请号：US17870712

申请日：2022-07-21

Applicant: SAP SE

Inventor： Hari Venkatesh Subramanian ,  Florian Roll ,  Joerg Franke ,  Joerg Weller ,  Dimitrij Raev ,  Stefan Kraus

IPC: G06F3/06 ,  G06F16/25

CPC classification number: G06F3/0655 ,  G06F16/258 ,  G06F3/061 ,  G06F3/0683

Abstract: Techniques and solutions are provided for updating or augmenting consolidated data that is produced using base data. The consolidated data can include data that is aggregated by various grouping criteria. After a set of consolidated data is determined, the base data may change, one or more rules used to calculate the consolidated data may change, or it may be desired to see data that is more granular than that included in the consolidated data. After consolidated data is provided to a user, a user issues a data augmentation request. The data augmentation request causes the base data, which may have been updated, to be processed to provide updated data, where the processing includes grouping operations used in producing the consolidated data. The updated data is provided to a client in response to the data augmentation request.

公开(公告)号：US20240028594A1

公开(公告)日：2024-01-25

申请号：US17870888

申请日：2022-07-22

Applicant: SAP SE

Inventor： Joerg Weller ,  Helmut Holthoff ,  Dimitrij Raev ,  Julian Frank ,  Hari Venkatesh Subramanian

IPC: G06F16/2455 ,  G06F16/22

CPC classification number: G06F16/2456 ,  G06F16/2272

Abstract: Techniques and solutions are provided for improving query execution. Data models can be complex, which is often reflected in queries against such data models. The present disclosure provides a query refactoring technique where a complex query, such as a query expressed as a single select statement, can be formulated as a series of less complex queries. The workload of a database can be reduced by combining results of the less complex queries outside of the database. The present disclosure provides a framework for implementing these techniques, where the framework includes a virtual cube, a calculation engine, and one or more operations, which can all be implemented as classes in a programming language, and where a generic class or interface can help guide users in developing subclasses that provide a reformulation or refactoring of a complex query.

公开(公告)号：US12229143B2

公开(公告)日：2025-02-18

申请号：US17870888

申请日：2022-07-22

Applicant: SAP SE

Inventor： Joerg Weller ,  Helmut Holthoff ,  Dimitrij Raev ,  Julian Frank ,  Hari Venkatesh Subramanian

IPC: G06F16/22 ,  G06F16/2455

Abstract: Techniques and solutions are provided for improving query execution. Data models can be complex, which is often reflected in queries against such data models. The present disclosure provides a query refactoring technique where a complex query, such as a query expressed as a single select statement, can be formulated as a series of less complex queries. The workload of a database can be reduced by combining results of the less complex queries outside of the database. The present disclosure provides a framework for implementing these techniques, where the framework includes a virtual cube, a calculation engine, and one or more operations, which can all be implemented as classes in a programming language, and where a generic class or interface can help guide users in developing subclasses that provide a reformulation or refactoring of a complex query.

公开(公告)号：US12001710B2

公开(公告)日：2024-06-04

申请号：US17870712

申请日：2022-07-21

Applicant: SAP SE

Inventor： Hari Venkatesh Subramanian ,  Florian Roll ,  Joerg Franke ,  Joerg Weller ,  Dimitrij Raev ,  Stefan Kraus

IPC: G06F3/06 ,  G06F16/25

CPC classification number: G06F3/0655 ,  G06F3/061 ,  G06F3/0683 ,  G06F16/258

Abstract: Techniques and solutions are provided for updating or augmenting consolidated data that is produced using base data. The consolidated data can include data that is aggregated by various grouping criteria. After a set of consolidated data is determined, the base data may change, one or more rules used to calculate the consolidated data may change, or it may be desired to see data that is more granular than that included in the consolidated data. After consolidated data is provided to a user, a user issues a data augmentation request. The data augmentation request causes the base data, which may have been updated, to be processed to provide updated data, where the processing includes grouping operations used in producing the consolidated data. The updated data is provided to a client in response to the data augmentation request.