Interface optimizing model based upon database information

摘要

Embodiments relate to interfaces allowing a user to optimize a model which references and manipulates volumes of information present in an underlying database. An interface engine of an application layer, may communicate with the database engine of an underlying database layer, to provide a user with indicia of modeling performance. Thus for every modeling step, an interface engine could display performance indicia such as a number of database rows that are being referenced, and/or an amount of time consumed in retrieving the data from the database. This performance indicia, together with a structure of the model itself, can be processed by the interface engine through a repository of optimization recommendations. Recommendations from the repository may be published to the user, who is free to accept or reject them. Particular embodiments may leverage processing capacity of an in-memory database engine, to analyze database information gathered during modeling.

主权项

1. A computer-implemented method comprising:
providing a modeling engine within an application layer that is in communication with a database of a database layer via a database engine; causing the modeling engine to construct a model referencing the database; causing the modeling engine to execute a step of the model; causing the modeling engine to receive a performance indicia of execution of the step; causing the modeling engine to display the performance indicia on a user interface; and causing the modeling engine to generate an optimization recommendation from the performance indicia, and to provide the optimization recommendation to the user interface; wherein the modeling engine is further configured to receive from the user interface an acceptance of the optimization recommendation, to modify the model based upon the optimization recommendation, and to depict an updated model reflecting the optimization recommendation as a flow of steps represented by shapes arranged in a vertical direction.