Unstructured data editing through category comparison

• US 20070106686A1
• Filed: 10/25/2006
• Published: 05/10/2007
• Est. Priority Date: 10/25/2005
• Status: Abandoned Application

• Current Assignee: Inmon Data Systems
• Original Assignee: Inmon Data Systems Incorporated
• Inventors: Inmon, William, Shank, James
• Application Number:
  US11/586,898
• Publication Number:
  US 20070106686A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/30 of unstructured textual data document management systems G06F16/93

Abstract

Embodiments of the present invention include methods for editing and scanning unstructured data and text by using one or more external categories of data for the purpose of finding words and phrases in the unstructured environment which correspond to words and phrases in the external category. External categories of data are words and phrases that relate to the external category. External categories can be made for practically any subject. When a match (“hit”) is found, an output record is written to a table or a file. The output record may include the document name, the word that was a hit, and the external category. The process of using external categories of data is done either directly or indirectly to unstructured data.

Claims

1. A method of processing unstructured data comprising:

specifying a first plurality of words or phrases corresponding to a category;

accessing unstructured data comprising a second plurality of words or phrases;

comparing the unstructured data against each of the specified words or phrases;

associating at least a portion of the unstructured data with the category if one or more of the specified words or phrases matches at least one word or phrase in the portion of the unstructured data; and

generating a structured data output.

2. The method of claim 1 wherein the structured data output comprises an identification of an unstructured document, a matching word or phrase, and a name of the category.

3. The method of claim 1 wherein the structured data output comprises at least a portion of the unstructured data, at least one matching word or phrase in the unstructured data and the category.

4. The method of claim 1 wherein the structured data output is a structured record.

5. The method of claim 1 wherein the structured data output is generated in a list.

6. The method of claim 1 wherein the structured data output is generated in a database.

7. The method of claim 1 wherein the structured data output is generated in a table.

8. The method of claim 1 further comprising reading the unstructured data into a file, and accessing the unstructured data from the file.

9. The method of claim 1 further comprising reading the unstructured data directly from the unstructured data source.

10. The method of claim 1 wherein the unstructured data comprises a plurality of emails.

11. The method of claim 1 wherein the unstructured data comprises a plurality of spreadsheets.

12. The method of claim 1 wherein the unstructured data comprises plurality of transcribed telephone conversations.

13. The method of claim 1 wherein the unstructured data comprises one or more electronic files comprising a plurality of words or phrases.

14. The method of claim 1 wherein the unstructured data comprises textual data.

15. The method of claim 1 wherein the category comprises accounting.

16. The method of claim 1 wherein the category comprises finance.

17. The method of claim 1 wherein the category comprises sales.

18. The method of claim 1 wherein the category comprises Sarbanes Oxley.

19. The method of claim 1 wherein the category comprises manufacturing.

20. The method of claim 1 wherein the category comprises marketing.

21. The method of claim 1 wherein the category comprises human resources.

22. The method of claim 1 wherein the category is generated from the unstructured data.

23. The method of claim 1 wherein the category is an external category.

24. The method of claim 1 wherein the category comprises a name and a plurality of associated words or phrases.

25. A method of processing unstructured data comprising:

specifying one or more categories, each category comprising a first plurality of words or phrases;

reading unstructured data comprising a second plurality of words or phrases;

comparing the unstructured data against the words or phrases in each category;

associating at least a portion of the unstructured data with at least one category if one or more words or phrases in the at least one category matches at least one word or phrase in the portion of the unstructured data; and

generating a structured data output.

26. The method of claim 25 wherein the structured data output comprises an identification of an unstructured document, a matching word or phrase, and a name of the category.

27. The method of claim 25 wherein the structured data output comprises at least a portion of the unstructured data, at least one matching word or phrase in the unstructured data and the category.

28. The method of claim 25 wherein the structured data output is a structured record.

29. The method of claim 25 wherein the structured data output is generated in a list.

30. The method of claim 25 wherein the structured data output is generated in a database.

31. The method of claim 25 wherein the structured data output is generated in a table.

32. The method of claim 25 further comprising reading the unstructured data into a file, and accessing the unstructured data from the file.

33. The method of claim 25 further comprising reading the unstructured data directly from the unstructured data source.

34. The method of claim 25 wherein the unstructured data comprises a plurality of emails.

35. The method of claim 25 wherein the unstructured data comprises a plurality of spreadsheets.

36. The method of claim 25 wherein the unstructured data comprises a plurality of transcribed telephone conversations.

37. The method of claim 25 wherein the unstructured data comprises one or more electronic files comprising a plurality of words or phrases.

38. The method of claim 25 wherein the unstructured data comprises textual data.

39. The method of claim 25 wherein the category comprises accounting.

40. The method of claim 25 wherein the category comprises finance.

41. The method of claim 25 wherein the category comprises sales.

42. The method of claim 25 wherein the category comprises Sarbanes Oxley.

43. The method of claim 25 wherein the category comprises manufacturing.

44. The method of claim 25 wherein the category comprises marketing.

45. The method of claim 25 wherein the category comprises human resources.

46. The method of claim 25 wherein the category is generated from the unstructured data.

47. The method of claim 25 wherein the category is an external category.

48. The method of claim 25 wherein the category comprises a name and a plurality of associated words or phrases.

49. A computer implemented system for processing unstructured data comprising:

means for specifying a first plurality of words or phrases corresponding to a category;

means for accessing unstructured data comprising a second plurality of words or phrases;

means for comparing the unstructured data against each of the specified words or phrases;

means for associating at least a portion of the unstructured data with the category if one or more of the specified words or phrases matches at least one word or phrase in the portion of the unstructured data; and

means for generating a structured data output.