Query refactoring framework
    1.
    发明授权

    公开(公告)号:US12229143B2

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

    申请号:US17870888

    申请日:2022-07-22

    Applicant: SAP SE

    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.

    Dynamic update of consolidated data based on granular data values

    公开(公告)号:US12001710B2

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

    申请号:US17870712

    申请日:2022-07-21

    Applicant: SAP SE

    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.

    MASTER DATA PROFILING
    3.
    发明申请

    公开(公告)号:US20210382880A1

    公开(公告)日:2021-12-09

    申请号:US16891767

    申请日:2020-06-03

    Applicant: SAP SE

    Inventor: Dimitrij Raev

    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.

    DYNAMIC UPDATE OF CONSOLIDATED DATA BASED ON GRANULAR DATA VALUES

    公开(公告)号:US20240028250A1

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

    申请号:US17870712

    申请日:2022-07-21

    Applicant: SAP SE

    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.

    Machine learning-based rule mining algorithm

    公开(公告)号:US11783205B2

    公开(公告)日:2023-10-10

    申请号:US16717819

    申请日:2019-12-17

    Applicant: SAP SE

    CPC classification number: G06N5/025 G06N20/00

    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.

    Machine Learning-Based Rule Mining Algorithm

    公开(公告)号:US20210182695A1

    公开(公告)日:2021-06-17

    申请号:US16717819

    申请日:2019-12-17

    Applicant: SAP SE

    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.

    Data retreival framework and use thereof

    公开(公告)号:US12216646B2

    公开(公告)日:2025-02-04

    申请号:US18212454

    申请日:2023-06-21

    Applicant: SAP SE

    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.

    DATA RETREIVAL FRAMEWORK AND USE THEREOF

    公开(公告)号:US20240427761A1

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

    申请号:US18212454

    申请日:2023-06-21

    Applicant: SAP SE

    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.

    AUTOMATIC GENERATION OF COMPUTING ARTIFACTS FOR DATA ANALYSIS

    公开(公告)号:US20210065016A1

    公开(公告)日:2021-03-04

    申请号:US16552678

    申请日:2019-08-27

    Applicant: SAP SE

    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.

    USER INTERFACE MODELS PROVIDING DYNAMIC ANALYTICAL CAPABILITY

    公开(公告)号:US20240427760A1

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

    申请号:US18212473

    申请日:2023-06-21

    Applicant: SAP SE

    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.

Patent Agency Ranking