公开(公告)号：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.

公开(公告)号：US20240427760A1

公开(公告)日：2024-12-26

申请号：US18212473

申请日：2023-06-21

Applicant: SAP SE

Inventor： Stefan Kraus ,  Dimitrij Raev ,  Julian Frank ,  Joerg Franke

IPC: G06F16/242 ,  G06F16/2457 ,  G06F16/248 ,  G06F16/28

Abstract: Techniques and solutions are provided for providing software application functionality allowing users to perform analytical data operations. Software applications typically limit users to interacting with predefined data. Disclosed techniques allow users retrieve new data, or process data in different ways, by accessing lower-level objects, such as analytic queries defined in a virtual data model. An object of a data model defined for a collection of graphical user interfaces can be used to identify an analytical data object providing access to data defined by the data model. A query is executed to retrieve data corresponding to at least a portion of attributes defined in the data model. At least a portion of retrieved data is displayed. User input is received that requests a pivot operation, an operation to add a filter, or to add a multidimensional data element of the analytical data object to the graphical user interface display.

公开(公告)号：US12039348B1

公开(公告)日：2024-07-16

申请号：US18212490

申请日：2023-06-21

Applicant: SAP SE

Inventor： Stefan Kraus ,  Dimitrij Raev ,  Ruixing Yang ,  Julian Frank

IPC: G06F3/0481 ,  G06F9/451

CPC classification number: G06F9/451 ,  G06F3/0481

Abstract: Techniques and solutions are provided to assist users in creating an instance of a model object definition that can be used in generating user interface displays using data accessed using an analytic query. Often, the development of user interface displays, including binding aspects of a display to data, requires significant technical knowledge, and the user interface displays and supporting objects are often hardcoded for particular use scenarios. Disclosed techniques facilitate the creation of user interface displays by allowing users to select particular definitional elements of analytic queries and analytical data objects defined with respect thereto. The definitional elements are stored in an instance of a model object definition. Using disclosed techniques, users can create and modify user interface displays using a low code/no code approach.

公开(公告)号：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.