Optimizing software applications
Techniques for optimizing a software application include receiving, at a local computing system, a query from an application for data stored on a database table, the query including a context defined by a name of the database table; comparing the context of the query to a context of a predefined query scenario; based on the context of the query matching the context of the predefined query scenario, retrieving data stored on a secondary database replicated from data stored on a main database; and passing the retrieved data from the secondary database to the application.
1. A method performed with a computing system for optimizing a performance of an enterprise application, the method comprising:
receiving, at the local computing system that comprises an enterprise computing system, from a remote computing system that executes a hosted application, one or more configuration tables defining a predefined query scenario for querying and retrieving data from the hosted application for data stored on a database table;
replicating a database table from a main database to a secondary database, the main database comprising updated data relative to data contained in the database table of the secondary database, the secondary database comprising an in-memory database and the main database comprising a magnetic memory;
receiving, at the local computing system, a query from the enterprise application for data stored on the database table, the query comprising a query return time and a context;
comparing the context of the query to a context of the predefined query scenario, the context of the query comprising at least one of a database table name, a scenario application name, or a scenario job name;
based on the context of the query matching the context of the predefined query scenario, retrieving data stored on the secondary database replicated from data stored on the main database; and
passing the retrieved data from the secondary database to the enterprise application.
2. The method of claim 1 , wherein the predefined query scenario comprises a scenario table name, and comparing the context of the query to a context of a predefined query scenario comprises comparing the name of the database table to the scenario table name.
3. The method of claim 1 , wherein the predefined query scenario further comprises a scenario application name, and comparing the context of the query to a context of a predefined query scenario further comprises:
comparing a name of the application to the scenario application name.
4. The method of claim 1 , wherein the predefined query scenario further comprises a scenario job name, and comparing the context of the query to a context of a predefined query scenario further comprises:
comparing a name of a background job to the scenario job name.
5. The method of claim 1 , further comprising:
receiving, at the local computing system, a second query from the application for data stored on a database table, the second query comprising a second context defined by a name of the database table;
comparing the second context of the query to the context of the predefined query scenario;
based on the second context of the second query not matching the context of the predefined query scenario, retrieving the data from the main database; and
passing the retrieved data from the main database to the application.
6. The method of claim 5 , wherein the data is retrieved, in response to the second query, from the main database through a primary connection, and the data is retrieved, in response to the query, from the secondary database through a secondary connection.
7. A non-transitory computer storage medium encoded with a computer program, the program comprising instructions that when executed by one or more computers cause the one or more computers to perform operations comprising:
receiving, at the local computing system that comprises an enterprise computing system from a remote computing system that executes a hosted application, one or more configuration tables defining a predefined query scenario for querying and retrieving data from the hosted application for data stored on a database table;
replicating a database table from a main database to a secondary database, the main database comprising updated data relative to data contained in the database table of the secondary database, the secondary database comprising an in-memory and the main database comprising a magnetic memory;
receiving, at the local computing system, a query from the enterprise application for data stored on the database table, the query comprising a query return time and a context;
comparing the context of the query to a context of the predefined query scenario, the context of the query comprising at least one of a database table name, a scenario application name or a scenario job name;
based on the context of the query matching the context of the predefined query scenario, retrieving data stored on the secondary database replicated from data stored on the main database; and
passing the retrieved data from the secondary database to the enterprise application.
8. The computer storage medium of claim 7 , wherein the operations further comprise:
receiving, at the local computing system, the predefined query scenario from a remote computing system.
9. The computer storage medium of claim 7 , wherein the predefined query scenario comprises a scenario table name, and comparing the context of the query to a context of a predefined query scenario comprises comparing the name of the database table to the scenario table name.
10. The computer storage medium of claim 7 , wherein the predefined query scenario further comprises a scenario application name, and comparing the context of the query to a context of a predefined query scenario further comprises:
comparing a name of the application to the scenario application name.
11. The computer storage medium of claim 7 , wherein the predefined query scenario further comprises a scenario job name, and comparing the context of the query to a context of a predefined query scenario further comprises:
comparing a name of a background job to the scenario job name.
12. The computer storage medium of any claim 7 , wherein the secondary database comprises an in-memory database that comprises volatile RAM memory, and the main database comprises magnetic memory.
13. The computer storage medium of claim 7 , wherein the operations further comprise:
receiving a second query from the application for data stored on a database table, the second query comprising a second context defined by a name of the database table;
comparing the second context of the query to the context of the predefined query scenario;
based on the second context of the second query not matching the context of the predefined query scenario, retrieving the data from the main database; and
passing the retrieved data from the main database to the application.
14. The computer storage medium of claim 13 , wherein the data is retrieved, in response to the second query, from the main database through a primary connection, and the data is retrieved, in response to the query, from the secondary database through a secondary connection.
15. A system of one or more computers configured to perform operations comprising:
receiving, at the local computing system that comprises an enterprise computing system from a remote computing system that executes a hosted application, one or more configuration tables defining a predefined query scenario for querying and retrieving data from the hosted application for data stored on a database table;
replicating a database table from a main database to a secondary database, the main database comprising updated data relative to data contained in the database table of the secondary database, the secondary database comprising an in-memory database and the main database comprising a magnetic memory;
receiving, at the local computing system, a query from the enterprise application for data stored on the database table, the query comprising a query return time and a context;
comparing the context of the query to a context of the predefined query scenario, the context of the query comprising at least one of a database table name, a scenario application name or a scenario job name;
based on the context of the query matching the context of the predefined query scenario, retrieving data stored on the secondary database replicated from data stored on the main database; and
passing the retrieved data from the secondary database to the enterprise application.
16. The system of claim 15 , wherein the operations further comprise:
receiving, at the local computing system, the predefined query scenario from a remote computing system.
17. The system of claim 15 , wherein the predefined query scenario comprises a scenario table name, and comparing the context of the query to a context of a predefined query scenario comprises comparing the name of the database table to the scenario table name.
18. The system of claim 15 , wherein the predefined query scenario further comprises a scenario application name, and comparing the context of the query to a context of a predefined query scenario further comprises:
comparing a name of the application to the scenario application name.
19. The system of claim 15 , wherein the predefined query scenario further comprises a scenario job name, and comparing the context of the query to a context of a predefined query scenario further comprises:
comparing a name of a background job to the scenario job name.
20. The system of claim 15 , wherein the secondary database comprises an in-memory database that comprises volatile RAM memory, and the main database comprises magnetic memory.
21. The system of claim 15 , wherein the operations further comprise:
receiving a second query from the application for data stored on a database table, the second query comprising a second context defined by a name of the database table;
comparing the second context of the query to the context of the predefined query scenario;
based on the second context of the second query not matching the context of the predefined query scenario, retrieving the data from the main database; and
passing the retrieved data from the main database to the application.
22. The system of claim 21 , wherein the data is retrieved, in response to the second query, from the main database through a primary connection, and the data is retrieved, in response to the query, from the secondary database through a secondary connection.