System and method for interactively entering data into a database

[0001] This application is a continuation of U.S. application Ser. No. 09/456,930, filed Dec. 7, 1999 now abandon, which is a continuation-in-part of U.S. Application Ser. No. 09/019,948, filed Feb. 6, 1998, now U.S. Pat. No. 5,999,939, which claims the benefit of U.S. Provisional Application No. 60/068,404, filed Dec. 21, 1997.

[0002] The present invention relates to data processing systems for entering information into and accessing information from large structured databases and in particular to those systems which allow multiple independent users to enter information from nonuniformly formatted documents/files and to interact with the system to assure the accuracy of the database entries.

[0003] The use of databases for storing data records which can be readily searched is well known. A typical application of large structured databases would be a system for matching jobs and applicants. When used in conjunction with a search engine, a program that can search for matches between inquiry data and data stored within the database, such a system significantly reduces the manual efforts required to match the needs of employers (job providers) and applicants (job seekers). In order to enter applicant data into the database, source documents/files (typically, nonuniformly formatted resume) can be used. Since the format of text data contained within a resume is typically not standardized, text data extraction software is used to retrieve data for entry into the database. Typical of such data extraction software is that described in U.S. Pat. Nos. 5,164,899 and 5,197,004.

[0004] The present invention is directed to a system for facilitating the accurate transfer of information from a source data stream, e.g., a document/file, to a highly structured database and more particularly to such systems capable of accepting nonuniformly formatted documents, e.g., text documents such as resumes, advertisements, and medical records, from a plurality of users via a remote communication interface, e.g., the Internet, and for extracting information therefrom via a procedure which includes user participation to assure the transfer of appropriate entries into the database.

[0005] Embodiments of the present invention provide an interactive path for a user (typically, the author of the source document/file) to interactively modify the extracted information. In a preferred embodiment, this interactive path is provided via the Internet and the extracted information can be altered by editing and/or selectively copying portions of the source document/file to supplement and/or modify the extracted information.

[0006] A preferred system for facilitating the accurate transfer of information from each of a plurality of nonuniformly formatted source data streams into a structured database comprises (1) means for supplying digital data representing each of a plurality of source data streams from a plurality of users, each source data stream containing data corresponding to multiple discernible source data strings, (2) data extraction means for extracting selected ones of the source data strings and generating related target data strings, (3) means for displaying a structured form comprised of multiple fields, each field capable of accommodating a data string and wherein one or more of the fields have the target data strings inserted within, (4) means for enabling each user to modify the target strings inserted within the displayed form corresponding to the source data stream originating from the user before accepting the form, and (5) means for storing data corresponding to the data strings from the form fields into the database.

[0007] In a further aspect of the present invention, the providing means uses a remote communication interface, preferably using the Internet, to supply the source document/file to the data extraction means and, subsequently, to return the form having target data strings within its fields.

[0008] An additional embodiment of the present invention also comprises a means for providing one or more supplemental inquiry forms to a user, receiving data strings in response to the supplemental inquiry forms, and for providing the data strings back to the user along with the target data strings in a structured form.

[0009] In a further aspect of the present invention, the providing means enables a user to submit digital data in the form of an audio stream. Data processing includes the conversion of the audio stream to a text string. The text string is then processed in the same manner as a user submitted source string containing text.

[0010] In an alternative embodiment of the present invention, the providing means uses traditional mail to supply the source document/file to the data extraction means. Alternatively, the data extraction means, structured form generating means, supplemental inquiry form generator, and structured form editing means are supplied to the user's computer as a self executing piece of software.

[0011] The novel features of the invention are set forth with particularity in the appended claims. The invention will be best understood from the following description when read in conjunction with the accompanying drawings.

[0021] The present invention is directed to a system for facilitating the accurate transfer of information from a source data stream, e.g., a document/file, to a highly structured database and more particularly to such systems capable of accepting nonuniformly formatted documents, e.g., text documents such as resumes, from a plurality of users via a remote communication interface, e.g., the Internet, and for extracting information therefrom via a procedure which includes user participation to assure the transfer of appropriate entries into the database.

[0022] In a preferred embodiment of the present invention, the system is used to place nonuniformly formatted advertisements into a structured database. In an additional embodiment of the present invention, the system is used to place nonuniformly formatted medical records into a structured database.

[0023] Embodiments of the present invention provide an interactive path for a user (typically, the author of the source document/file) to interactively modify the extracted information, e.g., according to the source document/file. In a preferred embodiment, this interactive path is provided via the Internet and the extracted information can be altered by editing and/or selectively copying portions of the source document/file to supplement and/or modify the extracted information.

[0024] FIG. 1 comprises a simplified block diagram of a system 10 for entering data from a source data stream 12, e.g., a text document/file such as a resume, into a database 14 and interactively modifying and/or supplementing such entered data. In an exemplary job search environment, the interactive system 10 provides an improved system and method for accurately transferring information from resume source document/file 12, hereinafter referred to as resumes and preferably independently generated by a plurality of applicants 16, to the database 14 where it is accessible (preferably via a search engine as described further below) to one or more employers 18. Resumes are preferably used as the source documents/files 12 in this environment since resumes are a well-accepted tool for providing information from an applicant to an employer and, as such, they typically already exist.

[0025] As shown in FIG. 1, the resume 12 is typically generated via path 20 using a word processor (not shown). Interactions between the applicant 16 and resume 12 typically continue via the word processor until a satisfactory resume 12 is generated and stored as corresponding digital data. However, resumes are generally nonstructured or loosely structured (and nonuniformly formatted between users) text documents that are only intended to be human readable e.g., by the employer 18 and the applicant 16, and are typically not directly useable in the highly structured database 14. Consequently, the resume 12 is supplied via path 21 to a data extractor 22, preferably implemented as text data extraction software (e.g., the DEFT software developed by TRW as part of their InfoWeb™ system), to selectively convert information from the format of the unstructured (or loosely structured) resume 12 to the format of the highly structured database 14. Essentially as shown in FIG. 2 (a portion of the exemplary resume of FIG. 7), the data extractor 22 isolates one or more discernible source data strings, e.g., text data strings 24, within the resume 12 and, according to the content of the source data strings, e.g., 24a-24z, and using the syntax of surrounding keyword data, e.g., text strings 26, determines a correlation between source text strings 24 and data fields 28 that are to be entered into the database 14. For example, the keyword text string 26 (“EXPERIENCE”) identifies the following source text strings 24 as being related to the applicant's job experience due to the syntax of the surrounding text, e.g., the keyword “experience”, the existence of dates, the identification of a company (Inc.), etc.

[0026] As shown in FIG. 3, an exemplary applicant database 14 is comprised of a plurality of fixed length records 30, each corresponding to a different one of a plurality of applicants 16. Each record 30 is comprised of a plurality of data fields 28 having predefined formats and lengths, corresponding to searchable pieces of information.

[0027] Table I shows an exemplary partial list of definitions of the information stored in the data fields 28 of the database 14 of FIG. 3.

[0028]

	TABLE I
	Data Field	Definition
	28j	Most recent job start date
	28k	Most recent job end date
	28l	Most recent job company
	28m	Most recent job title
	28n	Next job start date
	28o	Next job end date
	28p	Next job company
	28q	Next job title

[0029] First, the data extractor 22 extracts source data strings, e.g., text strings 24a-2d, from the resume 12. Optionally, the text format of one or more of the source text strings 24 are then altered by the data extractor 22 to generate target data strings, e.g., text strings 32, of a standardized format. For example, a date text string could be standardized (e.g, Mar. 12, 1993 could be changed to 3/12/93). Otherwise, the stored target text string 32 is essentially identical to the source text string 24. As described further below, each target text string 32 preferably directly corresponds to the data fields 28 in the database 14 (e.g., the target string 32 corresponding to source text string 24a corresponds to 28j) and thus, following the modification/acceptance process described below, target text strings 32 are stored via path 34 into the database 14 (following any conversions required by the format of the database 14 and its fields 28).

[0030] However, due to lack of structure of the resume 12, the data extractor 22 (also referred to as a natural language processor) is susceptible to making an incomplete or erroneous correlations. Accordingly, the present invention provides an interactive path 36 that enables the applicant 16, generally the individual most acquainted with the contents of the resume 12, to modify the target text strings 32 to best correspond to the resume 12 and, thus, enhance the accuracy of the data stored in the database 14.

[0031] FIG. 4 is an expanded block diagram of the system 10 of FIG. 1 showing the data flow which enables each user (i.e., applicant 16 in this exemplary environment) to interact with the information extracted by the data extractor 22 and thus assure the accurate transfer of information from the resume 12 into the structured database 14. The interactive system 10 is preferably comprised of one or more user sites 38 (including a computer 40 operated by the applicant 16) and a database service provider site 42 (generally an automated service) coupled to each other via a remote communication interface 44. In the following discussion, the remote communication interface comprises the Internet 46, the associated hardware and/or software at the user 38 and database service provider 42 sites, typically comprising a modem 48 and a web (Internet) browser 50, and the associated interconnections 52 between (typically phone lines and Internet Service Providers (ISPs)). However, other communication interfaces, e.g., a local area network (LAN) or a direct modem to modem or serial port to serial port connections, are also considered to be alternative remote communication interfaces.

[0032] Preferably, each user site 38 is comprised of the computer 40, e.g., a personal computer, having a display control output 54 that drives a display monitor 56 to generate a displayed output 58 and a data entry device, e.g., a keyboard/mouse 60, that directs operation of the computer 40 via control path 62. In contrast, while the database service provider site 42 may typically also include a monitor and a keyboard/mouse, it only requires a computer 64 that interfaces to the Internet 46.

[0033] Initially, the user 16 at user site 38 generates the source document/file, i.e., resume 12, at step 66 of FIG. 5. As previously discussed, this generation is interactive and proceeds until user 16 is satisfied with the results. However, the resulting resume 12 is generally unstructured relative to the highly structured form of the database 14.

[0034] As a next step, the user 16 requests a first web page form (step 68) via the Internet 46 to begin the process of interactively transferring the resume 12 to the database 14. The first web page form 68 (see FIG. 6A) is stored (see block 70) within computer 64 at the database service provider site 42 and is responsively provided back (see step 72) to the user site 38 via the Internet 46 (commencing STEP ONE) and displayed by the web browser 50 on the monitor 56. The user 16 then preferably provides the existing resume 12 back to the database service provider site 42 via a pasting operation used in conjunction with the web browser 50. In an exemplary Windows 95 environment, the user 16 launches the word processor, e.g., Microsoft Word, that had been used to generate the resume 12. Preferably, the user 16 then selects the entire resume document and copies it to the clipboard. Next, the user 16 pastes the resume 12 from the clipboard into a source data input field 70 of the first web page form 68 using the web browser 50, e.g., Microsoft Internet Explorer. Typically, this pasting removes any word processor formatting information and results in digital data (preferably formatted as ASCII text) representing the resume 12 being stored in the web browser 50. (Alternatively, the word processor formatting information can be extracted by the data extractor 22.) The web browser 50 is then used to send (see step 74) the first web page form 68 (now containing the resume 12) to the database service provider site 42 where the resume 12 is stored in resume storage 74. The data extractor 22 then extracts one or more source text strings 24 according to syntactical rules to establish a correspondence between the source text strings 24 (preferably saved as intermediary target text strings 32) and fields 28 of the database 14.

[0035] Next, STEP TWO of the process commences by the computer 64 at the database service provider site 42 sending a second web page form 78 (see FIG. 6B) at step 80 which is displayed via the web browser 50 on the monitor 56 at the user site 38. In this example, the second web page form 78 is a supplemental inquiry form, that asks the user 16 one or more supplemental questions. In response, the user 16 fills in supplemental fields 82, e.g., by a pull-down field, free text entry, a radio selection, etc. This filled-in form is sent back to the database service provider 42 in step 84 where supplemental text strings 86 are stored in supplemental text storage 88.

[0036] STEP THREE of the process commences by the third web page form generator 90 at the database service provider site 42 generating a third web page form 92 (see FIG. 6C), a structured form having multiple fields 94 each field being capable of accommodating a text string within. Specifically, target text strings 32 (corresponding to source text strings 24) are inserted within fields 94 according to the syntax of the source document/file 12 and the definition (e.g., name, address, city, etc.) of each field 94. Additionally, the supplemental text strings 86 are inserted within the associated fields 94 of form 92. Preferably, the stored resume 12′ from resume storage 74 is also added to the third web page form 92. Finally, the third web page form 92 is sent back in step 96 to the user site 38 where it is displayed by the web browser 50 on monitor 56.

[0037] The user 16 can now use the view the displayed form 92 to determine its accuracy. If the displayed data, including target text strings 32 and supplemental text strings 86, are accurate the user 16 sends back form 92 to the database service provider site 42 where the accepted text strings are extracted in block 98 and stored in database 14. However, as previously discussed, the displayed data is not always accurate. Accordingly, the user 16 can edit data supplied in the third web page form 92 (preferably including using the supplied resume 12) to cause the fields 94 of form 92 to more accurately represent the applicant's resume information. Using features of the web browser 50, the user 16 can in step 100 edit fields 94 and/or paste information from resume 12′ (now part of form 92) to modify the data fields 94. The user in step 102 then sends the modified form 92 back to the database service provider site 42 where accepted text strings 104 from fields 94 are stored in the database 14 in step 98.

[0038] As an example of the modification process, it is noted that field 94n corresponding to the third “Company” under “Experience” has been filled in with the target text string 32 “Los Angeles”. This is inaccurate since the data extractor 22 has apparently missed the company name, i.e., Nordstroms, and instead extracted the city name as the target text string 32. Therefore, the user/applicant 16 can identify this inaccuracy and either (1) edit the field 94n by typing in the correct entry or (2) select the source text string 24′ from the copy 12′ of resume 12 included on the third web page form and paste the proper text (Nordstroms) into field 94n. Accordingly, the user/applicant 16 has been given the opportunity to verify and correct the data before entering it into the database 14, thus assuring the accurate transfer of information into the database 14.

[0039] Once the information has been stored in the database 14, a search engine 106, preferably a software program that executes on the computer 64 at the database service provider site 42, can be used to match inquiries, e.g., from one or more employer sites 108 (preferably via the remote communication interface 44) to look for applicants 16 with specific attributes. For example, since the highly structured database 14 contains fields 28 corresponding to the schools attended by each applicant 16, the search engine 106 can, in response to a request from the employer site 108, search for applicants 16 who graduated from specific schools or any other criteria stored in the fields 28 of the database 14.

[0040] In another embodiment of the current invention, the user 16 at user site 38 generates an audio file to be used as the source file, i.e., resume 12, at step 66 of FIG. 5. The ability to submit an audio file may be particularly helpful to those who have difficulty typing or who prefer to dictate. The user 16 proceeds through the same series of steps as previously described, except that instead of cutting and pasting resume text from some type of word processor into the first web page form 68, the user 16 attaches the audio file via an attachment operation in conjunction with the web browser 50. The user 16 then uses the web browser 50 to send the first web page form 68 (now containing the resume 12 as an audio file) to the database service provider site 42 where the audio file is stored in resume storage 74.

[0041] Once received by the database service provider site 42 a speech to text conversion program is used to convert the audio file attached to first web page form 68 into a text file 12. The text file 12 is also stored in resume storage 74. The text file is then used the same way a user generated text file 12 is used as described above to generate an entry in database 14.

[0042] In another embodiment of the invention (see FIG. 8) the text extractor, supplemental question page generator, structured form generator, and structured form editor is supplied to the user's computer 40 as an applet or other self executing piece of software 69 by the database service provider. A speech to text conversion program may also be supplied to the user's computer 40. The provision of the software 69 may be done through a remote communication interface, such as the Internet. The applet or software 69 may use a web browser as an interface or it may have its own independent user interface.

[0043] Initially, the user 16 at user site 38 generates the source document/file, i.e., resume 12, at step 66 of FIG. 9. As previously discussed, this generation is interactive and proceeds until user 16 is satisfied with the results. In this embodiment however, the resume generation process can either be carried out using another word processor or through the supplied software 69 itself.

[0044] As a next step, the user 16 requests a first web page form and the associated software 69 (step 68) via the Internet 46 to begin the process of interactively transferring the resume 12 to the database 14. The first web page form 68 (see FIG. 6A) and the associated software 69 is stored (see block 70) within computer 64 at the database service provider site 42, and is responsively provided back (see step 72) to the user site 38 via the Internet 46 (commencing STEP ONE), and displayed by the web browser 50 on the monitor 56.

[0045] The user 16 then preferably provides the existing resume 12 into the software 69 either by entering it directly or via a pasting operation used in conjunction with the web browser 50.

[0046] Next, STEP TWO of the process commences by the software on the users computer 40 which generates a second form 78 (see FIG. 6B) at step 80 which is displayed on the monitor 56 at the user site 38. In this example, the second form 78 is a supplemental inquiry form, that asks the user 16 one or more supplemental questions. The number of supplemental questions can vary depending on the contents of the resume 12. In response, the user 16 fills in supplemental fields 82, e.g., by a pull-down field, free text entry, a radio selection, etc. This filled-in form is submitted to the software 69 in step 84 where the supplemental text strings 86 are stored by the software 69 to some type of recordable media as supplemental text storage 88.

[0047] STEP THREE of the process commences by the software 69 on the user's computer 40 generating a third form 92 (see FIG. 6C), a structured form having multiple fields 94, each field being capable of accommodating a text string within. Specifically, target text strings 32 (corresponding to source text strings 24) are inserted within fields 94 according to the syntax of the source document/file 12 and the definition (e.g., name, address, city, etc.) of each field 94. Additionally, the supplemental text strings 86 are inserted within the associated fields 94 of form 92. Preferably, the stored resume 12′ from resume storage 74 is also added to the third form 92. The third web page form 92 is displayed by the web browser 50 on monitor 56.

[0048] The user 16 can now use the software 69 to view the displayed form 92 to determine its accuracy. If the displayed data, including target text strings 32 and supplemental text strings 86 are accurate, the user 16 sends back form 92 using the software to the database service provider site 42 via the Internet, where the accepted text strings are extracted in block 98 and stored in database 14. However, as previously discussed, the displayed data is not always accurate. Accordingly, the user 16 can edit data supplied in the third form 92 (preferably including using the supplied resume 12) to cause the fields 94 of form 92 to more accurately represent the applicant's resume information. Using features of the web browser 50, the user 16 can in step 100 edit fields 94 and/or paste information from resume 12′ (now part of form 92) to modify the data fields 94. The user in step 102 then uses their browser to send the modified form 92 back to the database service provider site 42 using the software where accepted text strings 104 from fields 94 are stored in the database 14 in step 98.

[0049] In another embodiment of the invention the text extractor, structured form generator, supplemental question page generator, and structured form editor is supplied to the user's computer as self executing piece of software 69 by the database service provider. In this embodiment the user would not need to have an Internet connection at all. The user contacts the database service provider using for example e-mail, telephone or traditional mail requesting the software 69. The software 69 is sent to the user on portable storage media through traditional mail and is executable as a stand alone program on the user's computer 40.

[0050] The functionality is similar to the above embodiments except that once the process is complete the user is prompted to save the completed resume 12 to portable storage media. The user then sends the storage media to the database service provider using traditional mail. Once received, the database service provider takes the resume 12 off of the portable storage media and places the resume contents into the database 14.

[0051] Although the present invention has been described in detail with reference only to the presently-preferred embodiments, those of ordinary skill in the art will appreciate that various modifications can be made without departing from the invention. For example, while a job search environment has been primarily described, the present invention can be useful in other environments where the source document is essentially unstructured relative to a highly structured database. Accordingly, the invention is defined by the following claims.