Declarative rules for optimized access to data

A system, comprising:

• at least one processor;
• and
• a memory communicatively coupled to the at least one processor, the memory storing instructions which, when executed by the at least one processor, cause the at least one processor to perform operations comprising:
• receiving a structured query language (SQL) query, the SQL query associated with at least one database table and at least one first predicate;
• determining whether the SQL query is associated with at least one declarative rule based on the at least one database table and the at least one first predicate;
• in response to determining that the SQL query is associated with at least one declarative rule:
• applying, during optimization of the SQL query, the at least one associated declarative rule, wherein the at least one declarative rule defines a first transformation to the SQL query to be performed during query optimization and wherein the first transformation includes a modification to the first predicate that reduces a search set searched by the SQL query by removing at least one irrelevant search area that has been predetermined to not include data relating to the first predicate and maintaining at least one maintained search area that has been predetermined to include data relating to the first predicate, and wherein the applying includes:
• identifying, in a first declarative rule, a sub query that is configured to query a configuration table to determine the modification to the first predicate;
• automatically executing the sub query to determine the modification to the first predicate;
• and
• generating an updated SQL query based on the applied at least one associated declarative rule, including transforming the SQL query by applying the modification to the first predicate;
• and
• executing the updated SQL query including searching the at least one maintained search area and not searching the at least one irrelevant search area.

One or more computer-readable media storing instructions which, when executed by at least one processor, cause the at least one processor to perform operations comprising:

• receiving a structured query language (SQL) query, the SQL query associated with at least one database table and at least one first predicate;
• determining whether the SQL query is associated with at least one declarative rule based on the at least one database table and the at least one first predicate;
• in response to determining that the SQL query is associated with at least one declarative rule:
• applying, during optimization of the SQL query, the at least one associated declarative rule, wherein the at least one declarative rule defines a first transformation to the SQL query to be performed during query optimization and wherein the first transformation includes a modification to the first predicate that reduces a search set searched by the SQL query by removing at least one irrelevant search area that has been predetermined to not include data relating to the first predicate and maintaining at least one maintained search area that has been predetermined to include data relating to the first predicate, and wherein the applying includes:
• identifying, in a first declarative rule, a sub query that is configured to query a configuration table to determine the modification to the first predicate;
• automatically executing the sub query to determine the modification to the first predicate;
• and
• generating an updated SQL query based on the applied at least one associated declarative rule, including transforming the SQL query by applying the modification to the first predicate;
• and
• executing the updated SQL query including searching the at least one maintained search area and not searching the at least one irrelevant search area.