Servicing database requests using derivations of canonicalized tables
Servicing database requests using derivations of 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 that the canonical version of the requested table is derivable using a canonicalized table in the canonical table repository; and in response to determining that the canonical version of the requested table is derivable using the canonicalized table in the canonical table repository: transforming the canonicalized table in the canonical table repository based on the received request for the table, including deriving a portion of the requested table using the canonicalized table in the canonical table repository; and providing, to the client computing system, the transformed canonicalized table.
1. A method of servicing database requests using derivations of canonicalized tables, the method comprising:
receiving, from a client computing system, a request for a table from a database;
determining, based on a determination that the requested table includes at least one calculation column, that a canonical version of the requested table is derivable using a canonicalized table in a canonical table repository;
transforming the canonicalized table into the requested table by deriving a column of the requested table using a column of the canonicalized table as input; and
providing, to the client computing system, the transformed canonicalized table.
2. The method of claim 1 , wherein determining that the canonical version of the requested table is derivable using the canonicalized table in the canonical table repository comprises determining that the canonical version of the requested table does not match any canonicalized table in the canonical table repository.
3. The method of claim 1 , wherein determining that the canonical version of the requested table is derivable using the canonicalized table in the canonical table repository comprises determining that the canonical version of the requested table is derivable using at least two canonicalized tables in the canonical table repository.
4. The method of claim 1 , wherein determining that the canonical version of the requested table is derivable using the canonicalized table in the canonical table repository comprises determining that at least one column of the requested table is calculable using at least one column of the canonicalized table in the canonical table repository.
5. The method of claim 1 , wherein deriving the column of the requested table using the column of the canonicalized table as input comprises populating at least one column of the requested table with calculation results using at least one column of the canonicalized table in the canonical table repository.
6. The method of claim 1 , wherein transforming the canonicalized table into the requested table comprises one selected from a group consisting of repositioning at least one column and repositioning at least one row in the canonicalized table.
7. The method of claim 1 , wherein providing, to the client computing system, the transformed canonicalized table bypasses retrieving the requested table from the database.
8. An apparatus for servicing database requests using derivations of canonicalized tables, 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, from a client computing system, a request for a table from a database;
determining that a canonical version of the requested table is derivable using a canonicalized table in a canonical table repository;
transforming the canonicalized table into the requested table by deriving a column of the requested table using a column of the canonicalized table as input; and
providing, to the client computing system, the transformed canonicalized table.
9. The apparatus of claim 8 , wherein determining that the canonical version of the requested table is derivable using the canonicalized table in the canonical table repository comprises determining that the canonical version of the requested table does not match any canonicalized table in the canonical table repository.
10. The apparatus of claim 8 , wherein determining that the canonical version of the requested table is derivable using the canonicalized table in the canonical table repository comprises determining that the canonical version of the requested table is derivable using at least two canonicalized tables in the canonical table repository.
11. The apparatus of claim 8 , wherein determining that the canonical version of the requested table is derivable using the canonicalized table in the canonical table repository comprises determining that at least one column of the requested table is calculable using at least one column of the canonicalized table in the canonical table repository.
12. The apparatus of claim 8 , wherein deriving the column of the requested table using the column of the canonicalized table as input comprises populating at least one column of the requested table with calculation results using at least one column of the canonicalized table in the canonical table repository.
13. The apparatus of claim 8 , wherein transforming the canonicalized table into the requested table comprises one selected from a group consisting of repositioning at least one column and repositioning at least one row in the canonicalized table.
14. The apparatus of claim 8 , wherein providing, to the client computing system, the transformed canonicalized table bypasses retrieving the requested table from the database.
15. A computer program product for servicing database requests using derivations of canonicalized tables, the computer program product comprising a computer readable medium comprising computer program instructions that, when executed, cause a computer to carry out the steps of:
receiving, from a client computing system, a request for a table from a database;
determining that a canonical version of the requested table is derivable using a canonicalized table in a canonical table repository;
transforming the canonicalized table into the requested table by deriving a column of the requested table using a column of the canonicalized table as input; and
providing, to the client computing system, the transformed canonicalized table.
16. The computer program product of claim 15 , wherein determining that the canonical version of the requested table is derivable using the canonicalized table in the canonical table repository comprises determining that the canonical version of the requested table does not match any canonicalized table in the canonical table repository.
17. The computer program product of claim 15 , wherein determining that the canonical version of the requested table is derivable using the canonicalized table in the canonical table repository comprises determining that the canonical version of the requested table is derivable using at least two canonicalized tables in the canonical table repository.
18. The computer program product of claim 15 , wherein determining that the canonical version of the requested table is derivable using the canonicalized table in the canonical table repository comprises determining that at least one column of the requested table is calculable using at least one column of the canonicalized table in the canonical table repository.
19. The computer program product of claim 15 , wherein deriving the column of the requested table using the column of the canonicalized table as input comprises populating at least one column of the requested table with calculation results using at least one column of the canonicalized table in the canonical table repository.
20. The computer program product of claim 15 , wherein transforming the canonicalized table into the requested table comprises one selected from a group consisting of repositioning at least one column and repositioning at least one row in the canonicalized table.