Evaluating rules applied to data

• US 9,984,059 B2
• Filed: 09/25/2014
• Issued: 05/29/2018
• Est. Priority Date: 09/27/2013
• Status: Active Grant

• Current Assignee: Ab Initio Technology LLC (Ab Initio Software Corporation)
• Original Assignee: Ab Initio Technology LLC (Ab Initio Software Corporation)
• Inventors: Studer, Scott, Phillimore, David, Weisman, Amit
• Primary Examiner(s): TAPP, AMELIA L
• Application Number:
  US14/495,951
• Publication Number:
  US 20150095752A1
• Time in Patent Office: 1,342 Days
• CPC Class Codes: G06F 16/24564 Applying rules; Deductive queries
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence
• CPC Class Codes: G06F 3/04895 Guidance during keyboard input operation, e.g. prompting
• CPC Class Codes: G06F 40/174 Form filling; Merging
• CPC Class Codes: G06F 40/177 of tables; using ruled lines
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Specifying rules for processing data included in fields of elements of a dataset includes rendering user interface elements associated with a respective condition. The user interface elements include: first subsets of user interface elements, at least some of which are associated with an input value derived from at least one field, and second subsets of user interface elements, each configured to receive user input associated with a respective condition. Conditions are applied to at least a first element of the dataset based on user input received from at least some of the user interface elements, in response to receiving user input for a first user interface element associated with a first field. Instructions are generated for applying one or more selected conditions associated with fewer than all of the user interface elements, the selected conditions including at least a condition associated with the first user interface element.

Claims

1. An apparatus for specifying one or more rules for processing data included in one or more fields of each element of a plurality of elements of a dataset, the apparatus including:

a user interface module configured to render a plurality of user interface elements associated with a respective condition, the user interface elements including

one or more first subsets of the user interface elements, at least some subsets of the one or more first subsets associated with an input value derived from at least one field of an element of the plurality of elements of the dataset, and

multiple second subsets of the user interface elements, each user interface element of one or more of the multiple second subsets configured to receive user input associated with a respective condition; and

a processing module, including at least one processor, configured to apply conditions to at least a first element of the dataset based on user input received from at least some of the user interface elements, in response to receiving user input for a first user interface element associated with a first field, where applying the conditions includes

compiling a selected portion of a specification of the rules to generate instructions for applying one or more selected conditions associated with fewer than all of the user interface elements, the selected conditions including at least a condition associated with the first user interface element, and

executing the generated instructions and providing feedback associated with a result based on applying the condition associated with the first user interface element to data included in the first field of the first element.

2. The apparatus of claim 1, wherein

the user interface elements are included in cells arranged in a grid having a first axis and a second axis,

the one or more first subsets of the user interface elements are included in respective subsets of the cells extending in a direction along the first axis of the grid, and

the multiple second subsets of the user interface elements are included in respective subsets of the cells extending in a direction along the second axis of the grid.

3. The apparatus of claim 2, wherein the processing module is further configured to:

generate a specification of an evaluation order for conditions associated with different cells; and

execute the generated instructions for applying the selected conditions according to the specification of the evaluation order, and provide feedback associated with results in response to applying the selected conditions to data included in one or more fields of the first element according to the specification of the evaluation order.

4. The apparatus of claim 3, wherein the specification of the evaluation order includes a state transition diagram that includes states representing different conditions and includes transitions among the states that define an order in which the conditions are allowed to be applied.

5. The apparatus of claim 2, wherein applying the conditions further includes:

storing the generated instructions; and

executing the stored generated instructions to apply the condition associated with the first user interface element to data included in the first field of a second element.

6. The apparatus of claim 2, wherein applying the conditions further includes:

storing the result based on applying the condition associated with the first user interface element to data included in the first field of the first element; and

retrieving the stored result in response to applying the condition associated with the first user interface element to data included in the first field of a second element that is the same as data included in the first field of the first element.

7. The apparatus of claim 2, wherein the one or more subsets of the cells extending in a direction along the first axis are columns of cells.

8. The apparatus of claim 2, wherein the multiple subsets of the cells extending in a direction along the second axis are rows of cells.

9. The apparatus of claim 2, wherein the result of applying the condition to the data included in the first field of the element includes a pass/fail result.

10. The apparatus of claim 9, wherein the providing feedback includes applying shading to the first user interface element if the result is a fail result.

11. The apparatus of claim 2, wherein applying the conditions further includes providing feedback associated with applying conditions associated with one or more cells to data included in multiple elements of the dataset.

12. The apparatus of claim 2, wherein the processing module is further configured to validate a syntax of a condition.

13. The apparatus of claim 12, wherein the at least some cells associated with a field and a validation rule provide feedback associated with the result of the validation of the syntax of the condition.

14. The apparatus of claim 1, wherein the dataset includes one or more tables of a database and the elements of the dataset include database records.

15. The apparatus of claim 1, wherein generating instructions for applying one or more conditions associated with fewer than all of the user interface elements includes generating instructions for applying selected conditions associated with respective user interface elements, the selected conditions consisting of a condition associated with the first user interface element and one or more additional conditions selected based on information specifying potential dependencies between different conditions.

16. The apparatus of claim 1, wherein the processing module is further configured to provide an output of evaluating a first set of existing instructions as part of the execution of the generated instructions, where the first set of existing instructions are for applying at least one condition other than the selected conditions, and the at least one condition depends on the condition associated with the first user interface element.

17. The apparatus of claim 16, wherein the processing module is further configured to re-execute a second set of existing instructions based on the result of executing the generated instructions.

18. A computing system for specifying one or more rules for processing data included in one or more fields of each element of a plurality of elements of a dataset, the computing system including:

means for rendering a plurality of user interface elements associated with a respective condition, the user interface elements including

one or more first subsets of the user interface elements, at least some subsets of the one or more first subsets associated with an input value derived from at least one field of an element of the plurality of elements of the dataset, and

multiple second subsets of the user interface elements, each user interface element of one or more of the multiple second subsets configured to receive user input associated with a respective condition; and

means for applying conditions to at least a first element of the dataset based on user input received from at least some of the user interface elements, in response to receiving user input for a first user interface element associated with a first field, where applying the conditions includes

compiling a selected portion of a specification of the rules to generate instructions for applying one or more selected conditions associated with fewer than all of the user interface elements, the selected conditions including at least a condition associated with the first user interface element, and

executing the generated instructions and providing feedback associated with a result based on applying the condition associated with the first user interface element to data included in the first field of the first element.

19. A method for specifying one or more rules for processing data included in one or more fields of each element of a plurality of elements of a dataset, the method including:

rendering a plurality of user interface elements associated with a respective condition, the user interface elements including

one or more first subsets of the user interface elements, at least some subsets of the one or more first subsets associated with an input value derived from at least one field of an element of the plurality of elements of the dataset, and

multiple second subsets of the user interface elements, each user interface element of one or more of the multiple second subsets configured to receive user input associated with a respective condition; and

applying conditions to at least a first element of the dataset based on user input received from at least some of the user interface elements, in response to receiving user input for a first user interface element associated with a first field, where applying the conditions includes

compiling a selected portion of a specification of the rules to generate instructions for applying one or more selected conditions associated with fewer than all of the user interface elements, the selected conditions including at least a condition associated with the first user interface element, and

executing the generated instructions and providing feedback associated with a result based on applying the condition associated with the first user interface element to data included in the first field of the first element.

20. The method of claim 19, wherein

the user interface elements are included in cells arranged in a grid having a first axis and a second axis,

the one or more first subsets of the user interface elements are included in respective subsets of the cells extending in a direction along the first axis of the grid, and

the multiple second subsets of the user interface elements are included in respective subsets of the cells extending in a direction along the second axis of the grid.

21. The method of claim 20, further including:

generating a specification of an evaluation order for conditions associated with different cells; and

executing the generated instructions for applying the selected conditions according to the specification of the evaluation order, and providing feedback associated with results in response to applying the selected conditions to data included in one or more fields of the first element according to the specification of the evaluation order.

22. The method of claim 21, wherein the specification of the evaluation order includes a state transition diagram that includes states representing different conditions and includes transitions among the states that define an order in which the conditions are allowed to be applied.

23. The method of claim 20, wherein applying the conditions further includes:

storing the generated instructions; and

executing the stored generated instructions to apply the condition associated with the first user interface element to data included in the first field of a second element.

24. The method of claim 20, wherein applying the conditions further includes:

storing the result based on applying the condition associated with the first user interface element to data included in the first field of the first element; and

retrieving the stored result in response to applying the condition associated with the first user interface element to data included in the first field of a second element that is the same as data included in the first field of the first element.

25. The method of claim 20, wherein the result of applying the condition to the data included in the first field of the element includes a pass/fail result.

26. The method of claim 25, wherein the providing feedback includes applying shading to the first user interface element if the result is a fail result.

27. The method of claim 20, wherein applying the conditions further includes providing feedback associated with applying conditions associated with one or more cells to data included in multiple elements of the dataset.

28. The method of claim 20, further including validating a syntax of a condition.

29. The method of claim 28, wherein the at least some cells associated with a field and a validation rule provide feedback associated with the result of the validation of the syntax of the condition.

30. The method of claim 19, wherein generating instructions for applying one or more conditions associated with fewer than all of the user interface elements includes generating instructions for applying selected conditions associated with respective user interface elements, the selected conditions consisting of a condition associated with the first user interface element and one or more additional conditions selected based on information specifying potential dependencies between different conditions.

31. The method of claim 19, further including providing an output of evaluating a first set of existing instructions as part of the execution of the generated instructions, where the first set of existing instructions are for applying at least one condition other than the selected conditions, and the at least one condition depends on the condition associated with the first user interface element.

32. The method of claim 31, further including re-executing a second set of existing instructions based on the result of executing the generated instructions.

33. Software stored in a non-transitory form on a computer-readable medium, for specifying one or more rules for processing data included in one or more fields of each element of a plurality of elements of a dataset, the software including instructions for causing a computing system to:

render a plurality of user interface elements associated with a respective condition, the user interface elements including

one or more first subsets of the user interface elements, at least some subsets of the one or more first subsets associated with an input value derived from at least one field of an element of the plurality of elements of the dataset, and

multiple second subsets of the user interface elements, each user interface element of one or more of the multiple second subsets configured to receive user input associated with a respective condition; and

apply conditions to at least a first element of the dataset based on user input received from at least some of the user interface elements, in response to receiving user input for a first user interface element associated with a first field, where applying the conditions includes

compiling a selected portion of a specification of the rules to generate instructions for applying one or more selected conditions associated with fewer than all of the user interface elements, the selected conditions including at least a condition associated with the first user interface element, and

executing the generated instructions and providing feedback associated with a result based on applying the condition associated with the first user interface element to data included in the first field of the first element.

34. The software of claim 33, wherein

the user interface elements are included in cells arranged in a grid having a first axis and a second axis,

the one or more first subsets of the user interface elements are included in respective subsets of the cells extending in a direction along the first axis of the grid, and

the multiple second subsets of the user interface elements are included in respective subsets of the cells extending in a direction along the second axis of the grid.

35. The software of claim 34, further including instructions for causing the computing system to:

generate a specification of an evaluation order for conditions associated with different cells; and

execute the generated instructions for applying the selected conditions according to the specification of the evaluation order, and provide feedback associated with results in response to applying the selected conditions to data included in one or more fields of the first element according to the specification of the evaluation order.

36. The software of claim 35, wherein the specification of the evaluation order includes a state transition diagram that includes states representing different conditions and includes transitions among the states that define an order in which the conditions are allowed to be applied.

37. The software of claim 34, wherein applying the conditions further includes:

storing the generated instructions; and

executing the stored generated instructions to apply the condition associated with the first user interface element to data included in the first field of a second element.

38. The software of claim 34, wherein applying the conditions further includes:

storing the result based on applying the condition associated with the first user interface element to data included in the first field of the first element; and

retrieving the stored result in response to applying the condition associated with the first user interface element to data included in the first field of a second element that is the same as data included in the first field of the first element.

39. The software of claim 34, wherein the result of applying the condition to the data included in the first field of the element includes a pass/fail result.

40. The software of claim 39, wherein the providing feedback includes applying shading to the first user interface element if the result is a fail result.

41. The software of claim 34, wherein applying the conditions further includes providing feedback associated with applying conditions associated with one or more cells to data included in multiple elements of the dataset.

42. The software of claim 34, further including instructions for causing the computing system to validate a syntax of a condition.

43. The software of claim 42, wherein the at least some cells associated with a field and a validation rule provide feedback associated with the result of the validation of the syntax of the condition.

44. The software of claim 33, wherein generating instructions for applying one or more conditions associated with fewer than all of the user interface elements includes generating instructions for applying selected conditions associated with respective user interface elements, the selected conditions consisting of a condition associated with the first user interface element and one or more additional conditions selected based on information specifying potential dependencies between different conditions.

45. The software of claim 33, further including instructions for causing the computing system to provide an output of evaluating a first set of existing instructions as part of the execution of the generated instructions, where the first set of existing instructions are for applying at least one condition other than the selected conditions, and the at least one condition depends on the condition associated with the first user interface element.

46. The software of claim 45, further including instructions for causing the computing system to re-execute a second set of existing instructions based on the result of executing the generated instructions.