Deep filter propagation using explicit dependency and equivalency declarations in a data model

A system comprising:

• memory storing databases and data models associated with the databases;
• and
• one or more processors performing operations, using the memory, the operations including:
• receiving, over a computer network and at design time of a data model, dependencies and equivalences for data elements in the data model;
• storing, in persistent storage with the data model, the dependencies and equivalences;
• receiving, over the computer network, a request to be executed to obtain results from a database associated with the data model;
• and
• generating, using the received request and using the dependencies and equivalences, an optimized query, wherein the optimized query is optimized relative to the received request.

A non-transitory computer-readable media encoded with a computer program, the program comprising instructions that when executed by one or more computers cause the one or more computers to perform operations comprising:

• receiving, over a computer network and at design time of a data model, dependencies and equivalences for data elements in the data model;
• storing, in persistent storage with the data model, the dependencies and equivalences;
• receiving, over the computer network, a request to be executed to obtain results from a database associated with the data model;
• and
• generating, using the received request and using the dependencies and equivalences, an optimized query, wherein the optimized query is optimized relative to the received request.