9. A system for testing a component of a database application, the system comprising: a server configured to populate a column in a database with test data that falls within a certain range specified by a user; a query generator configured to specify, as indicated by the user, a desired cardinality constraint suitable for testing the component, the component operating on the system, wherein the component is a software component, wherein the system is a computing device; the query generator further configured to specify, as indicated by the user, a parametric pattern query that includes a parameter, wherein the parametric pattern query is compatible with the database, and wherein the parametric pattern query is configured to restrict cardinality when evaluated against the database; the query generator further configured to select a candidate value; a query evaluation layer configured for evaluating, via the component, the parametric pattern query against the database with the parameter set to the candidate value; the query generator further configured for calculating a cardinality error as a difference between a returned cardinality and the desired cardinality constraint wherein the returned cardinality results from the evaluating; the query generator further configured to adjust the candidate value based on the calculated cardinality error and further configured to then repeat the evaluating the parametric pattern query against the database with the parameter set to the adjusted candidate value and the calculating the cardinality error until the calculated cardinality error is within an allowable limit.
9. A system for testing a component of a database application, the system comprising: a server configured to populate a column in a database with test data that falls within a certain range specified by a user; a query generator configured to specify, as indicated by the user, a desired cardinality constraint suitable for testing the component, the component operating on the system, wherein the component is a software component, wherein the system is a computing device; the query generator further configured to specify, as indicated by the user, a parametric pattern query that includes a parameter, wherein the parametric pattern query is compatible with the database, and wherein the parametric pattern query is configured to restrict cardinality when evaluated against the database; the query generator further configured to select a candidate value; a query evaluation layer configured for evaluating, via the component, the parametric pattern query against the database with the parameter set to the candidate value; the query generator further configured for calculating a cardinality error as a difference between a returned cardinality and the desired cardinality constraint wherein the returned cardinality results from the evaluating; the query generator further configured to adjust the candidate value based on the calculated cardinality error and further configured to then repeat the evaluating the parametric pattern query against the database with the parameter set to the adjusted candidate value and the calculating the cardinality error until the calculated cardinality error is within an allowable limit. 11. The system of claim 9 , further comprising: the query generator further configured to select a second candidate value; the query evaluation layer further configured to evaluate, via the component, the parametric pattern query against the database with a second parameter set to the second candidate value, wherein the parametric pattern query further includes the second parameter; the query generator further configured to adjust the second candidate value in response to the cardinality error not being within the allowable limit; and the query evaluation layer further configured to evaluate, via the component and in response to the cardinality error not being within the allowable limit, the parametric pattern query against the database with the second parameter set to the adjusted second candidate value.