Method for defining data categories

• US 8,489,608 B2
• Filed: 01/12/2010
• Issued: 07/16/2013
• Est. Priority Date: 01/13/2009
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Dupont, Joel, Ioannou, Andrew, Finnegan, John
• Primary Examiner(s): Lee, Wilson
• Assistant Examiner(s): Le, Jessica N
• Application Number:
  US12/686,319
• Publication Number:
  US 20100179952A1
• Time in Patent Office: 1,281 Days
• Field of Search: None
• US Class Current: 707/740
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence

Abstract

A method for the definition of data categories is described. The method uses logic templates and may be used in database processing. One embodiment of the method comprises: selecting a plurality of attributes from a group of attributes, each attribute describing a possible data item in a set of data; selecting a logic template from a group of logic templates, each logic template comprising a predetermined logic expression containing one or more variables; and assigning one or more selected attributes to each variable within the selected the logic template to produce a logic expression defining the data category. A computer program product and a user interface for achieving this method are also described.

Claims

1. A method for defining categories for a set of data comprising:

selecting, by a computing processor, a plurality of attributes from a group of attributes, each attribute describing a possible data item in the set of data;

selecting, by the computing processor, a logic template from a group of logic templates, each logic template comprising a predetermined logic expression containing one or more variables; and

assigning, by the computing processor, one or more selected attributes to each variable within the selected logic template;

producing, by the computing processor, a logic expression defining the data category based on the assigned one or more selected attributes and predetermined logic expression of the selected logic template; and

validating, by the computing processor, one or more data entries stored in a database based on the data category defined by the produced logic expression.

2. The method of claim 1, wherein the data category comprises a category for time data and/or the plurality of attributes comprise time attributes.

3. The method of claim 1, wherein the predetermined logic expression comprises two or more logic groups of one or more variables linked by a logical operator.

4. The method of claim 3, wherein the assigning of the one or more selected attributes to each variable within the selected the logic template further comprises assigning one or more selected attributes to each logic group.

5. The method of claim 4, further comprising selecting, by the computing processor, a predetermined logic rule for governing the relationship between the attributes in each logic group, said logic rule forming part of the logic expression defining the data category.

6. The method of claim 1, further comprising using, by the computing processor, the data category in database operations.

7. The method of claim 1, further comprising generating, by the computing processor, a natural language statement describing the logic expression defining the data category.

8. The method of claim 1, further comprising adding, editing or removing, by the computing processor, a logic template from the group of logic templates.

9. A system comprising:

a processor; and

a memory coupled with and readable by the processor and having stored therein a sequence of instructions which, when executed by the processor, causes the processor to define categories for a set of data by;

selecting a plurality of attributes from a group of attributes, each attribute describing a possible data item in the set of data;

selecting a logic template from a group of logic templates, each logic template comprising a predetermined logic expression containing one or more variables; and

assigning one or more selected attributes to each variable within the selected logic template;

producing, by the computer system, a logic expression defining the data category based on the assigned one or more selected attributes and predetermined logic expression of the selected logic template; and

validating, by the computer system, one or more data entries stored in a database based on the data category defined by the produced logic expression.

10. The system of claim 9, wherein the data category comprises a category for time data and/or the plurality of attributes comprise time attributes.

11. The system of claim 9, wherein the predetermined logic expression comprises two or more logic groups of one or more variables linked by a logical operator.

12. The system of claim 11, wherein the assigning of the one or more selected attributes to each variable within the selected the logic template further comprises assigning one or more selected attributes to each logic group.

13. The system of claim 12, further comprising selecting a predetermined logic rule for governing the relationship between the attributes in each logic group, said logic rule forming part of the logic expression defining the data category.

14. The system of claim 9, further comprising using the data category in database operations.

15. The system of claim 9, further comprising generating a natural language statement describing the logic expression defining the data category.

16. The system of claim 9, further comprising adding, editing or removing a logic template from the group of logic templates.

17. A computer-readable memory having stored therein a sequence of instructions which, when executed by a processor, causes the processor to define categories for a set of data by:

selecting a plurality of attributes from a group of attributes, each attribute describing a possible data item in the set of data;

selecting a logic template from a group of logic templates, each logic template comprising a predetermined logic expression containing one or more variables; and

assigning one or more selected attributes to each variable within the selected logic template;

producing, by the computer system, a logic expression defining the data category based on the assigned one or more selected attributes and predetermined logic expression of the selected logic template; and

validating, by the computer system, one or more data entries stored in a database based on the data category defined by the produced logic expression.

18. The computer-readable memory of claim 17, wherein the data category comprises a category for time data and/or the plurality of attributes comprise time attributes.

19. The computer-readable memory of claim 17, wherein the predetermined logic expression comprises two or more logic groups of one or more variables linked by a logical operator.

20. The computer-readable memory of claim 19, wherein the assigning of the one or more selected attributes to each variable within the selected the logic template further comprises assigning one or more selected attributes to each logic group.

21. The computer-readable memory of claim 20, further comprising selecting a predetermined logic rule for governing the relationship between the attributes in each logic group, said logic rule forming part of the logic expression defining the data category.

22. The computer-readable memory of claim 17, further comprising using the data category in database operations.

23. The computer-readable memory of claim 17, further comprising generating a natural language statement describing the logic expression defining the data category.

24. The computer-readable memory of claim 17, further comprising adding, editing or removing a logic template from the group of logic templates.