Small table: multitenancy for lots of small tables on a cloud database

A system for partitioning a native table in a database comprising one or more computing devices configured to:

• receive a first query directed to a logical table from an application on a client device, wherein the logical table is not recognized by the database;
• translate the first query into a second query in which the logical table is mapped into a portion of a native table recognized by the database using an entry corresponding to the application and the logical table in a mapping data structure;
• retrieve data from the portion of the native table using the second query;
• and
• return the data to the client in a response, wherein the response is configured to appear responsive to the first query directed to the logical table.

A computer program product for partitioning a native table in a database, comprising at least one computer-readable medium having computer instructions stored therein which are operable to cause a computer device to:

• receive a first query directed to a logical table from an application on a client device, wherein the logical table is not recognized by the database;
• translate the first query into a second query in which the logical table is mapped into a portion of a native table recognized by the database using an entry corresponding to the application and the logical table in a mapping data structure;
• retrieve data from the portion of the native table using the second query;
• and
• return the data to the client in a response, wherein the response is configured to appear responsive to the first query directed to the logical table.