Evaluating rules applied to data

Patent metadata

Field	Value
Publication number	US-9984059-B2
Application number	US-201414495951-A
Country	US
Kind code	B2
Filing date	Sep 25, 2014
Priority date	Sep 27, 2013
Publication date	May 29, 2018
Grant date	May 29, 2018

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.

First claim

What is claimed is:

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
execu

Assignees

• Ab Initio Technology Llc

Inventors

• Studer Scott
• Phillimore David
• Weisman Amit

Classifications

• G06F40/177

  of tables; using ruled lines · CPC title

• G06F40/174

  Form filling; Merging · CPC title

• G06F40/18 Primary

  of spreadsheets (form-filling G06F40/174) · CPC title

• G06F3/04842

  Selection of displayed objects or displayed text elements (G06F3/0482 takes precedence) · CPC title

• G06F3/04895 Primary

  Guidance during keyboard input operation, e.g. prompting · CPC title