Interface optimizing model based upon database information
View Patent ↗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.
2. A method as in claim 1 wherein the performance indicia is selected from a time to execute the step, a number of database rows accessed by the step, and a computing power consumed by the step.
3. A method as in claim 1 wherein the modeling engine is further configured to generate an optimization value from the performance indicia, and to provide the optimization value to the user interface.
4. A method as in claim 1 wherein the application layer is situated in a same device with the database layer.
5. A method as in claim 1 wherein the database comprises an in memory database, and the modeling engine leverages a computational power of the database engine.
6. A non-transitory computer readable storage medium embodying a computer program for performing a method, said 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;
causing the modeling engine to generate an optimization recommendation from the performance indicia; and
causing the modeling engine 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.
7. A non-transitory computer readable storage medium as in claim 6 wherein the performance indicia is selected from a time to execute the step, a number of database rows accessed by the step, and a computing power consumed by the step.
8. A non-transitory computer readable storage medium as in claim 6 wherein the modeling engine is further configured to generate an optimization value from the performance indicia, and to provide the optimization value to the user interface.
9. A non-transitory computer readable storage medium as in claim 6 wherein the application layer is situated in a same device with the database layer.
10. A non-transitory computer readable storage medium as in claim 6 wherein the database comprises an in memory database, and the modeling engine leverages a computational power of the database engine.
11. A computer system comprising:
one or more processors;
a software program, executable on said computer system, the software program configured to:
provide a modeling engine within an application layer that is in communication with a database of a database layer via a database engine;
cause the modeling engine to construct a model referencing the database;
cause the modeling engine to execute a step of the model;
cause the modeling engine to receive a performance indicia of execution of the step;
cause the modeling engine to display the performance indicia on a user interface;
cause the modeling engine to generate an optimization recommendation from the performance indicia; and
cause the modeling engine 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.
12. A computer system as in claim 11 wherein the performance indicia is selected from a time to execute the step, a number of database rows accessed by the step, and a computing power consumed by the step.
13. A computer system as in claim 11 wherein the modeling engine is further configured to generate an optimization value from the performance indicia, and to provide the optimization value to the user interface.
14. A computer system as in claim 11 wherein the application layer is situated in a same device with the database layer.