US 2026/0037510 A1Published application

Dynamic analytical model optimizations

AssigneeSap SE

InventorsDevicharan Vinnakota, Priyanka Kommanapalli, Jaya Gupta

Life of this patent

Estimating the term…

Loading patent…

Abstract

In an example embodiment, a mechanism is provided to dynamically determine optimizations of data model execution at runtime at an engine-by-engine level, meaning that one optimization may be applied to one engine and not others. This mechanism is enabled by also providing a method by which model optimizations are stored and retrieved using a hash representation of each model, allowing past optimizations to be reused. Thus, the next time a similar model is built, optimizations of an earlier model can be reused. A definition store is also used as a basis to create new optimizations dynamically.

Claims20

Dependent claims

A system comprising:

at least one hardware processor;
and
a computer-readable medium storing instructions that, when executed by the at least one hardware processor, cause the at least one hardware processor to perform operations comprising:
receiving a call to a database from a first entity;
identifying a data model to handle the call, the data model identifying a joining of data structures in the database;
using a hash function to generate a hash of the data model;
determining whether the hash of the data model matches a hash stored in an optimization data store;
in response to a determination that the hash of the data model does not match a hash stored in the optimization data store:
identifying a plurality of database engines for processing the data model;
for each of the plurality of database engines, generating a different engine-level optimization based on a predicted volume of data to be used to process the call using the data model and based on type of the first entity, each different engine-level optimization indicating a change in process flow for a corresponding database engine;
and
processing the call using the data model by applying each different engine-level optimization to a corresponding database engine.

9 more elements

A non-transitory machine-readable medium storing instructions which, when executed by one or more processors, cause the one or more processors to perform operations comprising:

accessing historical time series data regarding workload of a first computer service;
receiving a call to a database from a first entity;
identifying a data model to handle the call, the data model identifying a joining of data structures in the database;
using a hash function to generate a hash of the data model;
determining whether the hash of the data model matches a hash stored in an optimization data store;
in response to a determination that the hash of the data model does not match a hash stored in the optimization data store:
identifying a plurality of database engines for processing the data model;
for each of the plurality of database engines, generating a different engine-level optimization based on a predicted volume of data to be used to process the call using the data model and based on type of the first entity, each different engine-level optimization indicating a change in process flow for a corresponding database engine;
and
processing the call using the data model by applying each different engine-level optimization to a corresponding database engine.

7 more elements

Dependencies are inferred from the claim text.