Generating edited input tables for low-latency presentation
Generating edited input tables for low-latency presentation including receiving, by the workbook manager on an intermediary computing system from a first workbook client on a first client computing system, a request for an input table on the cloud-based data warehouse; generating, by the workbook manager, a database statement to retrieve the input table from the cloud-based data warehouse, wherein generating the database statement comprises: determining that a cache on the intermediary computing system includes an uncommitted input table edit; and inserting the uncommitted input table edit into the database statement; retrieving, by the workbook manager, query results from the cloud-based data warehouse using the database statement, wherein the query results comprise the input table and the uncommitted input table edit; and providing, by the workbook manager, the query results to the first workbook client on the first client computing system.
1. A method for generating edited input tables for low-latency presentation, the method comprising:
receiving, by a workbook manager on an intermediary computing system from a first workbook client on a first client computing system, a request for an input table on a cloud-based data warehouse, wherein the intermediary computing system and the cloud-based data warehouse are separate and distinct systems;
generating, by the workbook manager, a database statement to retrieve the input table from the cloud-based data warehouse, wherein generating the database statement comprises:
determining that a cache on the intermediary computing system includes an uncommitted input table edit; and
inserting the uncommitted input table edit into the database statement configured to retrieve the input table from the cloud-based data warehouse;
retrieving, by the workbook manager, query results from the cloud-based data warehouse using the database statement, wherein the query results comprise the input table and the uncommitted input table edit; and
providing, by the workbook manager, the query results to the first workbook client on the first client computing system.
2. The method of claim 1 , further comprising:
receiving, from a second workbook client on a second client computing system, an input table edit targeting the input table on the cloud-based data warehouse; and
storing the input table edit in the cache as the uncommitted input table edit.
3. The method of claim 2 , further comprising instructing the cloud-based data warehouse to apply the input table edit to the input table.
4. The method of claim 1 , further comprising:
receiving, from the cloud-based data warehouse, an acknowledgement that the uncommitted input table edit has been committed to the input table; and
removing the uncommitted input table edit from the cache.
5. The method of claim 1 , wherein generating the database statement to retrieve the input table from the cloud-based data warehouse comprises compiling the database statement using the request for the input table.
6. The method of claim 1 , wherein inserting the uncommitted input table edit into the database statement comprises generating a portion of the database statement that edits the input table according to the uncommitted input table edit.
7. The method of claim 1 , wherein the generated database statement instructs the cloud-based data warehouse to combine the uncommitted input table edit with the input table from the cloud-based data warehouse.
8. The method of claim 1 , wherein the request for the input table is a request for a portion of the input table, and wherein determining that the cache on the intermediary computing system includes the uncommitted input table edit comprises determining that the uncommitted input table edit is within the requested portion of the input table.
9. The method of claim 1 , wherein the intermediary computing system is between the first client computing system and the cloud-based data warehouse.
10. The method of claim 1 , wherein the database statement is a structured query language statement.
11. An apparatus for generating edited input tables for low-latency presentation, the apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out the steps of:
receiving, by a workbook manager on an intermediary computing system from a first workbook client on a first client computing system, a request for an input table on a cloud-based data warehouse, wherein the intermediary computing system and the cloud-based data warehouse are separate and distinct systems;
generating, by the workbook manager, a database statement to retrieve the input table from the cloud-based data warehouse, wherein generating the database statement comprises:
determining that a cache on the intermediary computing system includes an uncommitted input table edit; and
inserting the uncommitted input table edit into the database statement configured to retrieve the input table from the cloud-based data warehouse;
retrieving, by the workbook manager, query results from the cloud-based data warehouse using the database statement, wherein the query results comprise the input table and the uncommitted input table edit; and
providing, by the workbook manager, the query results to the first workbook client on the first client computing system.
12. The apparatus of claim 11 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
receiving, from a second workbook client on a second client computing system, an input table edit targeting the input table on the cloud-based data warehouse; and
storing the input table edit in the cache as the uncommitted input table edit.
13. The apparatus of claim 12 , wherein the computer program instructions further cause the apparatus to carry out the step of instructing the cloud-based data warehouse to apply the input table edit to the input table.
14. The apparatus of claim 11 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
receiving, from the cloud-based data warehouse, an acknowledgement that the uncommitted input table edit has been committed to the input table; and
removing the uncommitted input table edit from the cache.
15. The apparatus of claim 11 , wherein generating the database statement to retrieve the input table from the cloud-based data warehouse comprises compiling the database statement using the request for the input table.
16. The apparatus of claim 11 , wherein inserting the uncommitted input table edit into the database statement comprises generating a portion of the database statement that edits the input table according to the uncommitted input table edit.
17. The apparatus of claim 11 , wherein the generated database statement instructs the cloud-based data warehouse to combine the uncommitted input table edit with the input table from the cloud-based data warehouse.
18. The apparatus of claim 11 , wherein the request for the input table is a request for a portion of the input table, and wherein determining that the cache on the intermediary computing system includes the uncommitted input table edit comprises determining that the uncommitted input table edit is within the requested portion of the input table.
19. The apparatus of claim 11 , wherein the intermediary computing system is between the first client computing system and the cloud-based data warehouse.
20. A computer program product for generating edited input tables for low-latency presentation, the computer program product disposed upon a computer readable storage medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of:
receiving, by a workbook manager on an intermediary computing system from a first workbook client on a first client computing system, a request for an input table on a cloud-based data warehouse, wherein the intermediary computing system and the cloud-based data warehouse are separate and distinct systems;
generating, by the workbook manager, a database statement to retrieve the input table from the cloud-based data warehouse, wherein generating the database statement comprises:
determining that a cache on the intermediary computing system includes an uncommitted input table edit; and
inserting the uncommitted input table edit into the database statement configured to retrieve the input table from the cloud-based data warehouse;
retrieving, by the workbook manager, query results from the cloud-based data warehouse using the database statement, wherein the query results comprise the input table and the uncommitted input table edit; and
providing, by the workbook manager, the query results to the first workbook client on the first client computing system.