Calculation models using annotations for filter optimization

An article of manufacture comprising:

• computer executable instructions stored on non-transitory computer readable media, which, when executed by at least one data processor, causes the at least one data processor to perform operations comprising:
• receiving a query statement requiring at least one calculated attribute;
• generating a data flow graph comprising a plurality of nodes for executing the query, at least one of the nodes corresponding to the at least one calculated attribute and having at least one level of child nodes, the generating comprising:
• generating, for each of the nodes corresponding to the at least one calculated attribute, at least one filter that is based on an inverse of a calculated expression corresponding to the at least one calculated attribute;
• and
• pushing the generated filters down to a corresponding child node;
• and
• initiating executing of the query using the generated data flow graph.

A method for implementation by one or more data processor forming part of at least one computing system, the method comprising:

• receiving, by at least one data processor, a query statement requiring at least one calculated attribute;
• generating, by at least one data processor, a data flow graph comprising a plurality of nodes for executing the query, at least one of the nodes corresponding to the at least one calculated attribute and having at least one level of child nodes, the generating comprising:
• determining, by at least one data processor for at least one calculated attribute, an inverse of a corresponding calculated expression;
• pushing, by at least one data processor, the inverse of the determined corresponding calculated expression down to a corresponding child node, wherein at least one calculated attributed is replaced with an actual filter value and a new filter on top of the actual filter value is pushed down to the corresponding node;
• initiating, by at least one data processor, executing of the query using the generated data flow graph.