Techniques for pre-assignment validation of data managed by a data processing system

A system for enforcing valid data assignments in a data processing system configured to process data that is updated by user devices and/or computerized processes, the data processing system storing the data using data entities and instances thereof, the data entities including a first data entity and the instances include a first data entity instance of the first data entity the system comprising:

• at least one computer hardware processor;
• and
• at least one non-transitory computer-readable storage medium storing an assignment validation module, the assignment validation module comprising a rule selection component, a query generation component, and a query execution component;
• wherein the at least one computer hardware processor is programmed to execute the assignment validation module to perform:
• receiving, by the assignment validation module, a request to assign a value to a first attribute in the first data entity instance, wherein:
• the first data entity comprises a plurality of attributes including the first attribute and a second attribute that stores a reference to a second data entity instance;
• the first data entity is associated with a first validation rule for the first attribute;
• the first validation rule determines validity of a value of the first attribute based on both the first attribute value and a second attribute value stored in the second data entity instance referenced by the second attribute;
• generating, from the first validation rule using the query generation component, a SQL query that, when executed against a datastore of the data processing system, returns values that meet the first validation rule, the generating comprising:
• obtaining, from the second data entity instance and via the reference stored by the second attribute, the second attribute value;
• and
• generating the SQL query using the first validation rule and the second attribute value obtained from the second data entity instance;
• executing, using the query execution component, the generated SQL query against the datastore of the data processing system to obtain, as a result of executing the generated SQL query, one or more valid values for the first attribute that would each meet the first validation rule if assigned to the first attribute;
• and
• assigning a value to the first attribute in the first data entity instance at least in part by:
• providing, through an interface, output indicating the one or more valid values for the first attribute obtained as a result of executing the generated SQL query;
• receiving, through the interface, input indicating a selection of at least one of the one or more valid values for the first attribute;
• and
• persisting, in the datastore of the data processing system, the selected at least one valid value as the value of the first attribute.

At least one non-transitory computer-readable storage medium storing instructions that, when executed by at least one computer hardware processor, cause the at least one computer hardware processor to perform a method of enforcing valid data assignments in a data processing system configured to process data that is updated by user devices and/or computerized processes, the data processing system storing the data using data entities and instances thereof, the data entities including a first data entity and the instances including a first data entity instance of the first data entity, the method comprising:

• receiving, by the data processing system, a request to assign a value to a first attribute in the first data entity instance, wherein:
• the first data entity comprises a plurality of attributes including the first attribute and a second attribute that stores a reference to a second data entity instance;
• the first data entity is associated with a first validation rule for the first attribute;
• and
• the first validation rule determines validity of a value of the first attribute based on both the first attribute value and a second attribute value stored in the second data entity instance referenced by the second attribute;
• generating, from the first validation rule, a SQL query that, when executed against a datastore of the data processing system, returns values that meet the first validation rule, the generating comprising:
• obtaining, from the second data entity instance and via the reference stored by the second attribute, the second attribute value;
• and
• generating the SQL query using the first validation rule and the second attribute value obtained from the second data entity instance;
• executing the generated SQL query against the datastore of the data processing system to obtain, as a result of executing the generated SQL query, one or more valid values for the first attribute that would each meet the first validation rule if assigned to the first attribute;
• and
• assigning a value to the first attribute in the first data entity instance at least in part by:
• providing, through an interface, output indicating the one or more valid values for the first attribute obtained as a result of executing the generated SQL query;
• receiving, through the interface, input indicating a selection of at least one of the one or more valid values for the first attribute;
• and
• persisting, in the datastore of the data processing system, the selected at least one valid value as the value of the first attribute.