Table-per-partition

A method for managing a database, comprising:

• receiving a query from a user as client code, wherein the client code references a logical model of a database presented as a single table to the user;
• resolving the client code to a structure query language (SQL) script referencing one or more partition tables that are inaccessible to the user;
• wherein the resolution of the client code to the SQL script is transparent to the user;
• in response to the SQL script, identifying one or more partition tables referenced by the SQL script from a plurality of partition tables;
• performing one or more of a create, read, update, or delete operation on the one or more partition tables based on the SQL script;
• providing a query confirmation or query result to a user upon completion of the operation.

Non-transitory, tangible, and computer-readable medium storing instructions thereon that, when executed, are configured to cause one or more processors to:

• receive a query from a user as client code, wherein the client code references a logical model of a database presented as a single table to the user;
• resolve the client code to a structure query language (SQL) script referencing one or more partition tables that are inaccessible to the user;
• wherein the resolution of the client code to the SQL script is transparent to the user;
• in response to the SQL script, identify one or more partition tables referenced by the SQL script from a plurality of partition tables;
• perform one or more of a create, read, update, or delete operation on the one or more partition tables based on the SQL script;
• and
• provide a query confirmation or query result to a user upon completion of the operation.