-
公开(公告)号: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
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.
-
公开(公告)号:US20210382880A1
公开(公告)日:2021-12-09
申请号:US16891767
申请日:2020-06-03
Applicant: SAP SE
Inventor: Dimitrij Raev
IPC: G06F16/245 , G06F16/248 , G06Q10/10 , G06Q10/06 , G06F17/15
Abstract: In an example embodiment, a specialized in-memory database abstraction component is introduced in a cloud cluster. The in-memory database abstraction component may receive lifecycle commands from a client-facing application and interface with a container service to create an in-memory database resource. When parameters are received by the in-memory database abstraction component from the client-facing application, the in-memory database abstraction component may act to validate the parameters, determine if a service plan is available, and determine whether the parameters meet the service plan requirements. If the service plan requirements are not met, the in-memory database abstraction component translates the parameters for the in-memory database resource.
-
公开(公告)号: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
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.
-
公开(公告)号:US11783205B2
公开(公告)日:2023-10-10
申请号:US16717819
申请日:2019-12-17
Applicant: SAP SE
Inventor: Kefeng Wang , Andreas Seifried , Birgitta Bruegel , Kieran Turley , Dimitrij Raev
Abstract: Data is received that defines a rule mining run including a scope of a search and at least one data source to be searched. In response, the at least one data source is polled to obtain rules responsive to the rule mining run. Each rule can specify one or more actions to take as part of a computer-implemented process when certain conditions are met. A list of rules (i.e., a proposed subset of the obtained rules) can then be generated using at least one machine learning model. The generated list of rule can then be displayed in a graphical user interface. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号:US20210182695A1
公开(公告)日:2021-06-17
申请号:US16717819
申请日:2019-12-17
Applicant: SAP SE
Inventor: Kefeng Wang , Andreas Seifried , Birgitta Bruegel , Kieran Turley , Dimitrij Raev
Abstract: Data is received that defines a rule mining run including a scope of a search and at least one data source to be searched. In response, the at least one data source is polled to obtain rules responsive to the rule mining run. Each rule can specify one or more actions to take as part of a computer-implemented process when certain conditions are met. A list of rules (i.e., a proposed subset of the obtained rules) can then be generated using at least one machine learning model. The generated list of rule can then be displayed in a graphical user interface. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号:US12216646B2
公开(公告)日:2025-02-04
申请号:US18212454
申请日:2023-06-21
Applicant: SAP SE
Inventor: Stefan Kraus , Dimitrij Raev , Waldemar Isajkin , Joerg Franke , Marco Pesarese
IPC: G06F16/242 , G06F16/248 , G06F16/28
Abstract: Techniques and solutions are provided for processing query requests from a software application, such as one having a user interface model, using an analytical data protocol that accesses an analytic query. Often, user interface models access data using transactional data protocols, which can limit analytical actions that can be performed through a user interface, particularly actions altering data presented or a data format as compared with pre-defined analytical objects. A query request associated with a user interface query model is received and converted to be executable using at least one analytical query model object. The request, in an analytical protocol, is submitted to a virtual data model. The query request in the analytical protocol is converted to be used with an analytic query defined in the virtual data model. The converted query request is executed against a data store and query results are returned to a user interface layer.
-
公开(公告)号:US20240427761A1
公开(公告)日:2024-12-26
申请号:US18212454
申请日:2023-06-21
Applicant: SAP SE
Inventor: Stefan Kraus , Dimitrij Raev , Waldemar Isajkin , Joerg Franke , Marco Pesarese
IPC: G06F16/242 , G06F16/248 , G06F16/28
Abstract: Techniques and solutions are provided for processing query requests from a software application, such as one having a user interface model, using an analytical data protocol that accesses an analytic query. Often, user interface models access data using transactional data protocols, which can limit analytical actions that can be performed through a user interface, particularly actions altering data presented or a data format as compared with pre-defined analytical objects. A query request associated with a user interface query model is received and converted to be executable using at least one analytical query model object. The request, in an analytical protocol, is submitted to a virtual data model. The query request in the analytical protocol is converted to be used with an analytic query defined in the virtual data model. The converted query request is executed against a data store and query results are returned to a user interface layer.
-
公开(公告)号:US20210065016A1
公开(公告)日:2021-03-04
申请号:US16552678
申请日:2019-08-27
Applicant: SAP SE
Inventor: Dirk Riemer , Dimitrij Raev , Mikhail Goncharov
Abstract: Technologies are provided for automatically implementing composite data rules, where a composite data rule includes a plurality of data rules. From the plurality of data rules, rule antecedents and rule consequents are used to automatically generate one or more computing artifacts for evaluating data for compliance with a composite data rule. Computing artifacts can include a scope decision table, which includes rule antecedents of association rules in a composite data rule, and a condition decision table, which includes rule consequents of individual data rules in a composite data rule. Scope and condition expressions can be used with the scope decision table and the condition decision table, respectively, to generate a result indicating whether given data is in scope or whether the data item satisfied consequents in an individual data rule of the composite data rule if the composite data rule is in scope for the data.
-
公开(公告)号: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.
-
-
-
-
-
-
-
-
-