BUSINESS RULES

• US 20120209800A1
• Filed: 02/11/2011
• Published: 08/16/2012
• Est. Priority Date: 02/11/2011
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Nayak, Tapas Kumar, Shankar, Sai, Bollapragada, Ravi, Agrawal, Sharad, Nadiminti, RaghuRam
• Application Number:
  US13/025,161
• Publication Number:
  US 20120209800A1
• Time in Patent Office: Days
• US Class Current: 706/47
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

Aspects of the subject matter described herein relate to business rules. In aspects, an interface is described that allows a user to enter, update, and delete business rules. Once entered, the business rules may be validated and translated into other forms including a form that is executable by a computer system.

Claims

1. A method implemented at least in part by a computer, the method comprising:

via a user interface of the computer, receiving input that defines a business rule;

translating the business rule into an expression tree; and

providing the expression tree to an execution engine for executing the business rule.

2. The method of claim 1, wherein receiving input that defines a business rule comprises receiving input into cells of a spreadsheet, the input defining one or more conditions and one or more actions of the business rule.

3. The method of claim 1, wherein receiving input that defines a business rule comprises receiving a formula in a cell of a spreadsheet, the formula defining the business rule by including one or more conditions and one or more actions associated with the one or more conditions.

4. The method of claim 1, wherein receiving input that defines a business rule comprises receiving input in a decision table of the user interface.

5. The method of claim 4, wherein translating the business rule into an expression tree comprises translating the decision table into a single spreadsheet formula prior to translating the formula into the expression tree.

6. The method of claim 1, further comprising validating the business rule prior to providing the expression tree to the execution engine.

7. The method of claim 6, wherein validating the business rule includes one or more of determining if the business rule is syntactically correct, determining whether fields of a decision table include permissible values, determining if each rule within a rule set that includes the business rule is deterministic, determining if there are gaps in conditions of the rule set, and determining if conditions and assignments of the business rule are made on similar types.

8. In a computing environment, a system, comprising:

a business rule input manager operable to receive input regarding a business rule and to update a data structure that represents the business rule with one or more conditions and one or more actions as indicated by the input;

a translator operable to create an expression tree derived from the data structure, the expression tree encoding any conditions included in the business rule; and

an execution engine operable to use the expression tree to execute the business rule.

9. The system of claim 8, wherein the business rule input manager comprises a plug-in for a spreadsheet, the business rule input manager being operable receiving the input from the spreadsheet.

10. The system of claim 8, wherein the business rule input manager is operable to display user interface elements including at least an open rule set element, a create rule set element, a create decision table element, a delete decision table element, an add row element, a delete row element, and a validate element.

11. The system of claim 8, wherein the business rule input manager is operable to receive input regarding a business rule by being operable to receive the input via a decision table.

12. The system of claim 8, wherein the business rule input manager is operable to receive input regarding a business rule by being operable to receive the input via a formula that defines the business rule.

13. The system of claim 8, wherein the translator being operable to create an expression tree derived from the data structure comprises the translator being operable to create a formula that encodes the business rule and to create the expression tree from the formula.

14. The system of claim 13, wherein the formula comprises a spreadsheet formula.

15. The system of claim 8, wherein the translator being operable to create an expression tree from a data structure comprises the translator being operable to create the expression tree from a decision table by translating each row in the decision table into a single rule of a rule set.

16. The system of claim 15, wherein the translator being operable to translate a row in the decision table to a single rule of the rule set comprises the translator being operable to translate each condition column of the row into a corresponding single expression and to logically AND expressions created therefrom together to form a composite expression.

17. The system of claim 15, wherein the translator being operable to translate a row in the decision table to a single rule of the rule set comprises the translator being operable to translate each action column of the row into a corresponding action expression.

18. In a computer system, a graphical interface, comprising:

a graphical interface element operable to receive input into a decision table representing a rule set;

a graphical interface element operable to receive input indicative of a command to add a row to the decision table;

a graphical interface element operable to receive input indicative of a command to validate the rule set; and

a graphical interface element operable to receive input indicative of a command to translate the decision table into a form executable by the computer system.

19. The graphical interface of claim 18, further comprising:

a graphical interface element operable to receive a command to open the rule set from a repository; and

a graphical interface element operable to indicate a command to publish the rule set to the repository.

20. The graphical interface of claim 18, further comprising a graphical interface element operable to receive input indicative of a command to translate the decision table into a single formula.