Bounded query rewriting using views

A computing device, comprising:

• a memory storage comprising instructions;
• and
• one or more processors in communication with the memory storage, wherein the one or more processors execute the instructions to:
• obtain a query and access constraints;
• select a cached view containing results of the query as applied to a dataset stored in a database;
• generate a query rewriting plan by:
• adding a fetch from query operation to the query rewriting plan based on the access constraints when a rewritten query variable can be fetched from a query constant,
• adding a fetch from database operation to the query rewriting plan based on the access constraints when a rewritten query variable can be fetched as a query variable that obtains bounded data from the database, and
• adding an access view operation to the query rewriting plan when a rewritten query variable can be fetched from the cached view;
• execute the query rewriting plan to fetch retrieved data;
• and
• execute the query on the retrieved data to determine updated results to the query without reapplying the query to the dataset.

A non-transitory computer-readable medium storing computer instructions that when executed by one or more processors, cause the one or more processors to:

• obtain a query and access constraints;
• select a cached view containing results of the query as applied to a dataset stored in a database;
• generate a query rewriting plan by:
• adding a fetch from query operation to the query rewriting plan based on the access constraints when a rewritten query variable can be fetched from a query constant,
• adding a fetch from database operation to the query rewriting plan based on the access constraints when a rewritten query variable can be fetched as a query variable that obtains bounded data from the database, and
• adding an access view operation to the query rewriting plan when a rewritten query variable can be fetched from the cached view;
• execute the query rewriting plan to fetch retrieved data;
• and
• execute the query on the retrieved data to determine updated results to the query without reapplying the query to the dataset.