Servicing database requests using canonicalized tables
Servicing database requests using canonicalized tables including maintaining a canonical table repository of canonicalized tables, wherein each canonicalized table is a transformed version of a table previously retrieved from a database; receiving, from a client computing system, a request for a table from the database; generating a description of a canonical version of the requested table; determining whether the canonical version of the requested table matches a canonicalized table in the canonical table repository; and if the canonical version of the requested table matches the canonicalized table in the canonical table repository: transforming the matching canonicalized table based on the received request for the table; and providing, to the client computing system, the transformed matching canonicalized table.
1 . A method comprising:
maintaining a canonical table repository of canonicalized tables, wherein each canonicalized table is a transformed version of a table previously retrieved from a cloud-based data warehouse;
receiving, from a client computing system, a request for a table from the cloud-based data warehouse;
determining that a canonical version of the requested table matches at least one canonicalized table within the canonical table repository by determining that the requested table is able to be generated by transforming the matching canonicalized table in the canonical table repository; and
providing, to the client computing system, the matching canonicalized table that is transformed based on the received request for the table.
2 . The method of claim 1 , wherein transforming the matching canonical table comprises reordering at least one column.
3 . The method of claim 1 , wherein receiving, from the client computing system, the request for the table from the cloud-based data warehouse comprises detecting that a user has manipulated a worksheet displayed within a graphical user interface on the client computing system.
4 . The method of claim 1 , wherein providing, to the client computing system, the transformed matching canonicalized table bypasses retrieving the requested table from the cloud-based data warehouse.
5 . The method of claim 1 , wherein the canonicalized tables within the canonical table repository are indexed by worksheet specifications describing each canonicalized table.
6 . The method of claim 1 , wherein determining that the canonical version of the requested table matches the canonicalized table in the canonical table repository storing multiple canonicalized tables comprises comparing a description of the canonical version of the requested table to a description of each canonicalized table in the canonical table repository.
7 . An apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory comprising computer program instructions that, when executed by the computer processor, cause the apparatus to carry out:
maintaining a canonical table repository of canonicalized tables, wherein each canonicalized table is a transformed version of a table previously retrieved from a cloud-based data warehouse;
receiving, from a client computing system, a request for a table from a cloud-based data warehouse;
determining that a canonical version of the requested table matches at least one canonicalized table within the canonical table repository by determining that the requested table is able to be generated by transforming the matching canonicalized table in the canonical table repository; and
providing, to the client computing system, the matching canonicalized table that is transformed based on the received request for the table.
8 . The apparatus of claim 7 , wherein transforming the matching canonical table comprises reordering at least one column.
9 . The apparatus of claim 8 , wherein providing, to the client computing system, the transformed matching canonicalized table bypasses retrieving the requested table from the cloud-based data warehouse.
10 . The apparatus of claim 7 , wherein receiving, from the client computing system, the request for the table from the cloud-based data warehouse comprises detecting that a user has manipulated a worksheet displayed within a graphical user interface on the client computing system.
11 . The apparatus of claim 7 , wherein the canonicalized tables within the canonical table repository are indexed by worksheet specifications describing each canonicalized table.
12 . A computer program product for servicing cloud-based data warehouse requests using canonicalized tables, the computer program product disposed upon a computer readable medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out:
maintaining a canonical table repository of canonicalized tables, wherein each canonicalized table is a transformed version of a table previously retrieved from a cloud-based data warehouse;
receiving, from a client computing system, a request for a table from a cloud-based data warehouse;
determining that a canonical version of the requested table matches at least one canonicalized table within the canonical table repository by determining that the requested table is able to be generated by transforming the matching canonicalized table in the canonical table repository; and
providing, to the client computing system, the matching canonicalized table that is transformed based on the received request for the table.
13 . The computer program product of claim 12 , wherein transforming the matching canonical table comprises reordering at least one column.
14 . The computer program product of claim 12 , wherein receiving, from the client computing system, the request for the table from the cloud-based data warehouse comprises detecting that a user has manipulated a worksheet displayed within a graphical user interface on the client computing system.
15 . The computer program product of claim 12 , wherein providing, to the client computing system, the transformed matching canonicalized table bypasses retrieving the requested table from the cloud-based data warehouse.
16 . The computer program product of claim 12 , wherein the canonicalized tables within the canonical table repository are indexed by worksheet specifications describing each canonicalized table.