Framework for creating database applications

A computer-implemented method for querying records from a database in a SQL database server wherein the query is provided as a flowchart, the flowchart including:

• a start unit at which the flowchart starts;
• one or more value units at which the flowchart ends,
• one or more logic units between the start unit and the value unit, each logic unit:
• representing a logic statement,
• having a true output representing a true result of the logic statement, and
• having a false output representing a false result of the logic statement, and
• paths through the flowchart wherein each path extends:
• from the start unit,
• into one or more of the logic units,
• out of one of the true output and the false output of any logic unit that the path enters, and
• ending at one of the value units,
• the method including the steps of:
• selecting one or more of the value units;
• determining all paths through the flowchart which end at the selected value units;
• for each path ending at the selected value units, generating a path logic statement including:
• the logic statement of the first logic unit along the path after the start unit, and
• the logic statement of each successive logic unit along the path, wherein the logic statement of each successive logic unit is appended to the path logic statement by:
• a logical AND if the successive logic unit is entered from a true output of the prior logic unit along the path, or
• a logical AND NOT if the successive logic unit is entered from a false output of the prior logic unit along the path;
• generating a flowchart logic statement including all generated path logic statements, wherein each path logic statement is separated from any adjacent path logic statements by a logical OR.

A computer-implemented method for realizing conditions of a database application in a SQL database server, the database application being provided as a flowchart including:

• a start unit at which the flowchart starts;
• one or more value units at which the flowchart ends, each value unit defining a condition;
• one or more logic units between the start unit and the value unit, each logic unit:
• representing a logic statement,
• having a true output representing a true condition of the logic statement, and
• having a false output representing a false condition of the logic statement, and
• paths through the flowchart wherein each path extends:
• from the start unit,
• into one or more of the logic units,
• out of one of the true output and the false output of any logic unit that the path enters, and
• ending at one of the value units,
• the method including the steps of:
• obtaining an input;
• determining all paths through the flowchart;
• generating a path logic statement for each path through the flowchart, each path logic statement including:
• the logic statement of the first logic unit along the path after the start unit, and
• the logic statement of each successive logic unit along the path, wherein the logic statement of each successive logic unit is appended to the path logic statement by:
• a logical AND if the successive logic unit is entered from a true output of the prior logic unit along the path, or
• a logical AND NOT if the successive logic unit is entered from a false output of the prior logic unit along the path;
• evaluating the input versus each path logic statement, thereby determining one or more value units resulting from the input;
• and
• returning the conditions of the resulting value units.