View maintenance rules for an update pipeline of an object-relational mapping (ORM) platform

A data access system for providing data services to an application, comprising:

• a processor;
• and
• a memory bearing instructions that, upon execution by the processor, cause the system at least to:
• receive application data modifications that modify instances of the application, the application data modifications being expressed according to an application schema;
• utilize incremental view maintenance to translate the application data modifications into relational database modifications expressed according to a database schema for updating a database, wherein incremental view maintenance further causes the system at least to:
• generate a dependency graph based on a set of changed materialized entity instances in the incremental view maintenance, wherein a node of the dependency graph represents an operation on a table of the relational database of a set of operations, and an edge in the dependency graph indicates that there is a dependency between two nodes connected by the edge, a dependency indicating that a first operation on the table relies on a result of having already performed a second operation;
• order the set of operations based on the dependency graph;
• and
• apply the set of operations to the database based on the order.

A computer readable storage device bearing instructions for providing data services to an application, that, when executed on a computer, cause the computer to perform functions comprising:

• receiving application data modifications that modify instances of the application, wherein the application data modifications are expressed according to an application schema;
• and
• utilizing incremental view maintenance to translate the application data modifications into relational database modifications expressed according to a database schema for updating a database, utilizing incremental view maintenance comprises:
• generating a dependency graph based on a set of changed materialized entity instances in the incremental view maintenance, wherein a node of the dependency graph represents an operation on a table of the relational database of a set of operations, and an edge in the dependency graph indicates that there is a dependency between two nodes connected by the edge, a dependency indicating that a first operation on the table relies on a result of having already performed a second operation;
• order the set of operations based on the dependency graph;
• and
• ordering the set of operations based on the dependency graph;
• and
• applying at least one view maintenance rule that specifies a view operator, and
• given the application data modifications, produces the relational database modifications.