Utilization of logical fields with conditional constraints in abstract queries

1. A computer implemented method for retrieving data, comprising:

providing a plurality of conditional constraints, wherein each constraint is programmatically generated by execution of a constraint generation routine that performs a constraint generation operation, comprising:

issuing a first query to retrieve distinct values for a first field;

receiving results for the first query, the results comprising the distinct values for the first field;

for each of the distinct values for the first field,

issuing a second query configured to retrieve, for a second field, a result set that satisfies a first condition comprising the first field related to the distinct value by an operator;

determining whether a correlation exists between (i) the respective distinct value of the first field and (ii) a respective result set value of the second field; and

if a correlation exists, defining a conditional constraint for the first field based on the correlation, wherein the conditional constraint specifies the addition of a second condition to a query if the query includes the respective first condition, wherein the second condition includes the second field related to the respective result set value by an operator;

receiving a query;

for each conditional constraint of the plurality of conditional constraints:

determining whether the query satisfies the conditional constraint; and

if the query satisfies the conditional constraint, adding the respective second condition corresponding to the satisfied conditional constraint to the query to produce a modified query;

executing the modified query; and

returning results for the modified query.

2. The computer implemented method of claim 1 , further comprising:

determining whether the modified query satisfies at least one conditional constraint of the plurality of conditional constraints; and

if so, adding the respective second condition corresponding to the at least one conditional constraint to the modified query to produce another modified query.

3. The computer implemented method of claim 1 , wherein the query is an abstract query defined according to logical fields having respective definitions in a data abstraction model, each respective definition comprising a field name, a location parameter indicating a locations of a counterpart physical field and a reference to an access method configured to access the physical field according to the location parameter.

4. The computer implemented method of claim 1 , further comprising, for each of the plurality of conditional constraints:

determining whether the respective correlation is violated by a data entry; and

if the respective correlation is violated, removing the conditional constraint for which the respective correlation is violated.

5. The computer implemented method of claim 1 , wherein the respective second conditions are complex conditions and comprise a plurality of individual conditions related by operators.