IP Library Granted Patent US 8,200,784
Granted Patent B2
US 8,200,784 · App. 12/547,962 · Granted Jun 12, 2012

Method and computer system for unstructured data integration through graphical interface

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,200,784
App. No.
12/547,962
Granted
Jun 12, 2012
Kind
B2
Abstract

Embodiments disclosed herein provide a system and method for transferring data between an unstructured data source and a structured destination. In one embodiment, graphical representations of a unstructured data source and a structured destination are presented to a user via a graphical user interface of a computer. Using the graphical user interface, the user can draw lines between the graphical representations to indicate how data from the unstructured data source should be associated with and transferred to the structured destination. The graphical representation of the unstructured data source may be generated using data extracted from a web based document. This data extraction can be done recursively and at least partially in parallel with retrieving files associated with hyperlinks within the web based document.

Claims (64)

1. A method of transferring data between an unstructured data source document and a structured destination document, comprising:

displaying a graphical representation of the unstructured data source document and a graphical representation of the structured destination document to a user via a graphical user interface of a client computer, wherein the unstructured data source document resides at or is downloaded from a server computer and wherein the structured destination document resides at the client computer;

enabling the user to draw, via the graphical user interface of the computer, one or more lines between at least a portion of the graphical representation of the unstructured data source document and at least a portion of the graphical representation of the structured destination document, wherein each of the one or more lines has a first end point and a second end point, wherein the first end point points to a branch representing a level within the unstructured data source document, and wherein the second end point points to a node representing a locale within the structured destination document;

associating the level within the unstructured data source document with the locale within the structured destination document based upon the one or more lines drawn by the user to connect the branch representing the level within the unstructured data source document and the node representing the locale within the structured destination document utilizing the graphical user interface of the computer; and

transferring data from the level within the unstructured data source document to the locale within the structured destination document.

2. The method according to claim 1 , further comprising performing one or more transformations on the data as it is being transferred from the level within the unstructured data source document to the locale within the structured destination document.

3. The method according to claim 1 , further comprising:

preprocessing an input received at the client computer; and

determining whether the input is a string, a file name, a Universal Resource Locator (URL), or a file.

4. The method according to claim 3 , wherein the input is a string, further comprising:

extracting contents from the string; and

generating the graphical representation of the unstructured data source document based on the contents extracted from the string.

5. The method according to claim 3 , wherein the input is a file name or a URL, further comprising:

accessing a document associated with the file name or the URL;

extracting contents from the document; and

generating the graphical representation of the unstructured data source document based on the contents extracted from the document.

6. The method according to claim 5 , further comprising storing the file name or the URL.

7. The method according to claim 6 , wherein the document is a web based document containing one or more hyperlinks, further comprising:

resolving the one or more hyperlinks within the web based document;

retrieving one or more files corresponding to the one or more hyperlinks; and

recursively extracting data from each of the one or more files.

8. The method according to claim 7 , wherein the recursively extracting data step begins before the retrieving step is completed.

9. A non-transitory computer-readable storage medium storing computer instructions translatable by one or more processors to perform a method of transferring data between an unstructured data source document and a structured destination document, the method comprising:

displaying a graphical representation of the unstructured data source document and a graphical representation of the structured destination document to a user via a graphical user interface of a client computer, wherein the unstructured data source document resides at or is downloaded from a server computer and wherein the structured destination document resides at the client computer;

enabling the user to draw, via the graphical user interface of the computer, one or more lines between at least a portion of the graphical representation of the unstructured data source document and at least a portion of the graphical representation of the structured destination document, wherein each of the one or more lines has a first end point and a second end point, wherein the first end point points to a branch representing a level within the unstructured data source document, and wherein the second end point points to a node representing a locale within the structured destination document;

associating the level within the unstructured data source document with the locale within the structured destination document based upon the one or more lines drawn by the user to connect the branch representing the level within the unstructured data source document and the node representing the locale within the structured destination document utilizing the graphical user interface of the computer; and

transferring data from the level within the unstructured data source document to the locale within the structured destination document.

10. The non-transitory computer-readable storage medium of claim 9 , wherein the computer instructions are further translatable by the one or more processors to perform one or more transformations on the data as it is being transferred from the level within the unstructured data source document to the locale within the structured destination document.

11. The non-transitory computer-readable storage medium of claim 9 , wherein the computer instructions are further translatable by the one or more processors to:

preprocess an input received at the client computer; and

determine whether the input is a string, a file name, a Universal Resource Locator (URL), or a file.

12. The non-transitory computer-readable storage medium of claim 11 , wherein the computer instructions are further translatable by the one or more processors to:

extract contents from the string; and

generate the graphical representation of the unstructured data source document based on the contents extracted from the string.

13. The non-transitory computer-readable storage medium of claim 11 , wherein the computer instructions are further translatable by the one or more processors to:

store the file name or the URL;

access a document associated with the file name or the URL;

extract contents from the document; and

generate the graphical representation of the unstructured data source document based on the contents extracted from the document.

14. The non-transitory computer-readable storage medium of claim 13 , wherein the document is a web based document containing one or more hyperlinks and wherein the computer instructions are further translatable by the one or more processors to:

resolve the one or more hyperlinks within the web based document;

retrieve one or more files corresponding to the one or more hyperlinks; and

recursively extract data from each of the one or more files.

15. The non-transitory computer-readable storage medium of claim 14 , wherein the computer instructions are further translatable by the one or more processors to perform at least partially in parallel retrieving the one or more files corresponding to the one or more hyperlinks and recursively extracting the data from each of the one or more files.

16. A system for transferring data between an unstructured data source document and a structured destination document, comprising:

a computer having:

a graphical user interface;

one or more processors; and

one or more non-transitory computer-readable storage media storing computer instructions translatable by the one or more processors to:

display a graphical representation of the unstructured data source document and a graphical representation of the structured destination document to a user via the graphical user interface of the computer;

enable the user to draw, via the graphical user interface of the computer, one or more lines between at least a portion of the graphical representation of the unstructured data source document and at least a portion of the graphical representation of the structured destination document, wherein each of the one or more lines has a first end point and a second end point, wherein the first end point points to a branch representing a level within the unstructured data source document, and wherein the second end point points to a node representing a locale within the structured destination document;

associate the level within the unstructured data source document with the locale within the structured destination document based upon the one or more lines drawn by the user to connect the branch representing the level within the unstructured data source document and the node representing the locale within the structured destination document utilizing the graphical user interface of the computer; and

transfer data from the level within the unstructured data source document to the locale within the structured destination document.

17. The system of claim 16 , wherein the computer instructions are further translatable by the one or more processors to perform one or more transformations on the data as it is being transferred from the level within the unstructured data source document to the locale within the structured destination document.

18. The system of claim 16 , wherein the computer instructions are further translatable by the one or more processors to:

preprocess an input received at the computer; and

determine whether the input is a string, a file, a file name, or a Universal Resource Locator (URL).

19. The system of claim 18 , wherein the computer instructions are further translatable by the one or more processors to:

extract contents from the string, the file, or a document associated with the file name or the URL; and

generate the graphical representation of the unstructured data source document based on the extracted contents.

20. The system of claim 19 , wherein the document is a web based document containing one or more hyperlinks and wherein the computer instructions are further translatable by the one or more processors to:

resolve the one or more hyperlinks within the web based document;

retrieve one or more files corresponding to the one or more hyperlinks; and

recursively extract data from each of the one or more files.

Assignments (10)
CERTIFICATE OF CONTINUANCE Recorded Sep 13, 2016
From: OP IP SUB, LLC
To: IP OT SUB ULC
Reel/Frame 040019/0500 →
CERTIFICATE OF AMALGAMATION Recorded Sep 13, 2016
From: IP OT SUB ULC
To: OPEN TEXT SA ULC
Reel/Frame 040019/0578 →
IP BUSINESS SALE AGREEMENT Recorded Sep 13, 2016
From: OPEN TEXT S.A.
To: OT IP SUB, LLC
Reel/Frame 040019/0627 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 19, 2011
From: VIGNETTE PARTNERSHIP, LP
To: OPEN TEXT S.A.
Reel/Frame 027483/0205 →
CERTIFICATE OF CONVERSION Recorded Oct 14, 2011
From: VIGNETTE OPERATING, LLC
To: VIGNETTE PARTNERSHIP, LP
Reel/Frame 027066/0773 →
CERTIFICATE OF CONVERSION Recorded Oct 13, 2011
From: VIGNETTE CORPORATION
To: VIGNETTE OPERATING, LLC
Reel/Frame 027091/0009 →
MERGER Recorded Oct 12, 2011
From: VIGNETTE SOFTWARE, LLC
To: VIGNETTE CORPORATION
Reel/Frame 027077/0423 →
INTELLECTUAL PROPERTY PURCHASE AGREEMENT Recorded Jan 14, 2010
From: VIGNETTE LLC (96%)
To: VIGNETTE SOFTWARE LLC
Reel/Frame 023792/0470 →
INTELLECTUAL PROPERTY PURCHASE AGREEMENT Recorded Jan 11, 2010
From: VIGNETTE CORPORATION (4%)
To: VIGNETTE SOFTWARE LLC
Reel/Frame 023768/0708 →
INTELLECTUAL PROPERTY PURCHASE AGREEMENT Recorded Jan 11, 2010
From: VIGNETTE CORPORATION (96%)
To: VIGNETTE LLC
Reel/Frame 024006/0001 →