Database Queries Enriched in Rules
Embodiments allow complex conditional statements to be considered in formulating database queries. Business rules are modeled based upon ready-to-use abstract structures such as decision trees, decision tables, or formulas. A query to the database is then posed by a user. The query includes a system of rules evaluation activating a built-in processing function provided with a unique identifier of the rule. This function processes the rule, taking the input data set from the context of the application level language (e.g. SQL) in which the database was created. This rule-processing capability may be implemented as a functional mechanism similar to the standard aggregation functions (e.g. SUM, AVG, MAX, MIN), rather than by extending the application level language itself.
1 . A computer-implemented method in a database system comprising:
providing, in a non-transitory computer readable storage medium, a database comprising data organized in rows and columns;
storing a model of a business rule based upon an abstract structure;
the database system receiving a database query comprising a data query and a reference to the business rule;
the database system generating a result for the database query including accessing data in the rows and columns of the database in accordance with the data query and applying the business rule to data accessed from the rows and columns; and
displaying the result to a user in response to the database query.
2 . The computer-implemented method of claim 1 wherein the abstract structure comprises a decision tree.
3 . The computer-implemented method of claim 1 wherein the abstract structure comprises a decision table.
4 . The computer-implemented method of claim 1 wherein the abstract structure comprises a formula expression.
5 . The computer-implemented method of claim 1 wherein applying the business rule comprises reading rule metadata from a rule repository.
6 . The computer-implemented method of claim 1 wherein applying the business rule comprises reading context information from the database query.
7 . A non-transitory computer readable storage medium embodying a computer program for performing a method in a database system, said method comprising:
providing a database comprising data organized in rows and columns;
storing a model of a business rule based upon an abstract structure;
the database system receiving a database query comprising a data query and a reference to the business rule;
the database system generating a result for the database query including accessing data in the rows and columns of the database in accordance with the data query and applying the business rule to data accessed from the rows and columns; and
displaying the result to a user in response to the database query.
8 . The non-transitory computer readable storage medium of claim 7 wherein the abstract structure comprises a decision tree.
9 . The non-transitory computer readable storage medium of claim 7 wherein the abstract structure comprises a decision table.
10 . The non-transitory computer readable storage medium of claim 7 wherein the abstract structure comprises a formula expression.
11 . The non-transitory computer readable storage medium of claim 7 wherein applying the business rule comprises reading a rule metadata from a rule repository.
12 . The non-transitory computer readable storage medium of claim 7 wherein applying the business rule comprises reading context information from the database query.
13 . A computer system comprising:
one or more processors;
a software program, executable on said computer system, the software program configured to:
provide a database created comprising data organized in rows and columns;
storing a model of a business rule based upon an abstract structure;
cause the computer system to receive a database query comprising a data query and a reference to the business rule;
cause the computer system to generate a result for the database query including accessing data in the rows and columns of the database in accordance with the data query and applying the business rule to data accessed from the rows and columns; and
display the result to a user in response to the database query.
14 . The computer system of claim 13 wherein the software program is configured to model the rule based upon the abstract structure comprising a decision tree.
15 . The computer system of claim 13 wherein the software program is configured to model the rule based upon the abstract structure comprising a decision table.
16 . The computer system of claim 13 wherein the software program is configured to model the rule based upon the abstract structure comprising a formula expression.
17 . The computer system of claim 13 wherein the software program is configured to apply the business rule by reading a rule metadata from a rule repository.
18 . The computer system of claim 13 wherein the software program is configured to apply the business rule by reading context information from the database query.