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 comprising:
receiving, from a client computing system, a request for a database table from a database;
determining that a canonicalized version of the database table does not exist in a canonical table repository;
in response to the determining, retrieving the database table from the database;
converting the database table from the database into a canonicalized version of the database table based on a canonical conversion policy, including moving at least one row in the database table to generate the canonicalized version of the database table; and
storing the canonicalized version of the database table in the canonical table repository.
2. The method of claim 1 , further comprising providing, to the client computing system, the database table from the database.
3. The method of claim 1 , wherein converting the database table from the database into a canonicalized version of the database table based on a canonical conversion policy comprises resorting columns of the database table from the database.
4. The method of claim 1 , wherein converting the database table from the database into a canonicalized version of the database table based on a canonical conversion policy comprises resorting rows of the database table from the database.
5. The method of claim 1 , wherein converting the database table from the database into a canonicalized version of the database table based on a canonical conversion policy comprises removing row labels of the database table from the database.
6. The method of claim 1 , wherein converting the database table from the database into a canonicalized version of the database table based on a canonical conversion policy comprises removing column labels of the database table from the database.
7. The method of claim 1 , wherein converting the database table from the database into a canonicalized version of the database table based on a canonical conversion policy comprises reordering at least one column of the database table from the database.
8. The method of claim 1 , wherein the canonical conversion policy dictates that recent tables retrieved from the database are stored in the canonical table repository.
9. The method of claim 1 , wherein determining that the canonicalized version of the database table does not exist in the canonical table repository comprises determining that the canonical version of the database table does not match any canonicalized table in the canonical table repository.
10. An 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:
receiving, from a client computing system, a request for a database table from a database;
determining that a canonicalized version of the database table does not exist in a canonical table repository;
converting the database table from the database into a canonicalized version of the database table based on a canonical conversion policy, including moving at least one row in the database table to generate the canonicalized version of the database table; and
storing the canonicalized version of the database table in the canonical table repository.
11. The apparatus of claim 10 , wherein the computer program instructions further cause the apparatus to carry out providing, to the client computing system, the database table from the database.
12. The apparatus of claim 10 , wherein converting the database table from the database into a canonicalized version of the database table based on a canonical conversion policy comprises resorting columns of the database table from the database.
13. The apparatus of claim 10 , wherein converting the database table from the database into a canonicalized version of the database table based on a canonical conversion policy comprises resorting rows of the database table from the database.
14. The apparatus of claim 10 , wherein converting the database table from the database into a canonicalized version of the database table based on a canonical conversion policy comprises removing row labels of the database table from the database.
15. The apparatus of claim 10 , wherein converting the database table from the database into a canonicalized version of the database table based on a canonical conversion policy comprises removing column labels of the database table from the database.
16. The apparatus of claim 10 , wherein converting the database table from the database into a canonicalized version of the database table based on a canonical conversion policy comprises reordering at least one column of the database table from the database.
17. The apparatus of claim 10 , wherein the canonical conversion policy dictates that recent tables retrieved from the database are stored in the canonical table repository.
18. A computer program product comprising a computer readable storage medium comprising computer program instructions that, when executed, cause a computer to carry out:
receiving, from a client computing system, a request for a database table from a database;
determining that a canonicalized version of the database table does not exist in a canonical table repository;
in response to the determining, retrieving the database table from the database;
converting the database table from the database into a canonicalized version of the database table based on a canonical conversion policy, including moving at least one row in the database table to generate the canonicalized version of the database table; and
storing the canonicalized version of the database table in the canonical table repository.