Concurrent calculation of resource qualification and availability using text search

• US 9,165,011 B2
• Filed: 09/30/2011
• Issued: 10/20/2015
• Est. Priority Date: 09/30/2011
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Wang, Tianyi, Salgar, Vivek, Watson, Darryl L.
• Primary Examiner(s): Le, Miranda
• Application Number:
  US13/251,038
• Publication Number:
  US 20130086054A1
• Time in Patent Office: 1,481 Days
• Field of Search: 707/725, 707/722, 707/723
• US Class Current: 1/1
• CPC Class Codes: G06F 16/1767 Concurrency control, e.g. optimistic or pessimistic approaches

Abstract

A system, for concurrent calculation of resource qualifications (e.g., skills, educational degree, etc) and availability (e.g., availability to work on a project) using text search. The method commences by initiating a flow for requesting resources, the resource request comprising a qualification requirement indication and a time period requirement indication. The method further comprises retrieving candidate resource documents in a manner so as to calculate an overall match score that is based not only on qualifications, but also on availability. The scoring uses a recoded candidate resource document that comprises qualification attributes as well as time period availability to form an overall match score. The recoding can be performed in an administrative flow (e.g., a batch process, and/or a periodically executed update process), and the administrative flow creates recoded candidate resource document that are suited for use with a text search engine capable of processing an extensible markup language document.

Claims

1. A computer implemented method for concurrent calculation of resource qualification and availability using text search, the method comprising:

receiving, at a server, a resource request, the resource request comprising at least a qualification requirement indication and a time period requirement indication, wherein the time period requirement indication indicates a period of availability needed for the resource request;

retrieving, from a first portion of a resource repository, a plurality of matching candidate resource records, at least two of the matching candidate resource records matching at least a portion of the qualification requirement indication of the resource request and the at least two of the matching candidate resource records matching at least a portion of the time period requirement indication of the resource request;

recoding at least two of the matching candidate resource records to form at least two recoded candidate resource documents;

storing the recoded candidate resource documents in a second portion of the resource repository;

converting the resource request into a text query, wherein the text query scores the recoded candidate resource documents using both availability and qualification corresponding to the recoded candidate resource documents;

retrieving, in response to the text query, from at least the second portion of the resource repository, at least one recoded candidate resource document, the recoded candidate resource document matching at least a portion of the qualification requirement indication and the recoded candidate resource document matching at least a portion of the time period requirement indication;

scoring the recoded candidate resource document using the qualification requirement indication and the time period requirement indication to form an overall match score, wherein the overall match score is formed by concurrently calculating a qualification match score and an availability match score for the recoded candidate resource document, wherein the overall match score is calculated prior to assigning one or more resources to the resource request; and

assigning one or more resources based at least in part on the overall match score.

2. The method of claim 1, wherein the recoding is performed in a batch process.

3. The method of claim 1, wherein the recoded candidate resource documents are recoded into an extensible markup language (XML) document.

4. The method of claim 3, wherein the extensible markup language (XML) document comprises a qualifications possessed portion and a timeframes of availability portion.

5. The method of claim 1, wherein the overall match score is calculated by a formula

[(qualification match score)+(availability match score)]/2=overall match score.

6. The method of claim 5, wherein the availability match score is compared to an availability match score threshold.

7. A computer system for concurrent calculation of resource qualification and availability using text search comprising:

a computer processor to execute a set of program code instructions; and

a memory to hold the program code instructions in which the program code instructions comprise program code

to perform receiving a resource request, the resource request comprising at least a qualification requirement indication and a time period requirement indication, wherein the time period requirement indication indicates a period of availability needed for the resource request;

to perform retrieving, from a first portion of a resource repository, a plurality of matching candidate resource records, at least two of the matching candidate resource records matching at least a portion of the qualification requirement indication of the resource request and the at least two of the matching candidate resource records matching at least a portion of the time period requirement indication of the resource request;

to perform recoding at least two of the matching candidate resource records to form at least two recoded candidate resource documents;

to perform storing the recoded candidate resource documents in a second portion of the resource repository;

to perform converting the resource request into a text query, wherein the text query scores the recoded candidate resource documents using both availability and qualification corresponding to the recoded candidate resource documents;

to perform retrieving, in response to the text query, from at least the second portion of the resource repository, at least one recoded candidate resource document, the recoded candidate resource document matching at least a portion of the qualification requirement indication and the recoded candidate resource document matching at least a portion of the time period requirement indication; and

to perform scoring the recoded candidate resource document using the qualification requirement indication and the time period requirement indication to form an overall match score, wherein the overall match score is formed by concurrently calculating a qualification match score and an availability match score for the recoded candidate resource document, wherein the overall match score is calculated prior to assigning one or more resources to the resource request; and

to perform assigning one or more resources based at least in part on the overall match score.

8. The computer system of claim 7, wherein the recoding is performed in a batch process.

9. The computer system of claim 7, wherein the recoded candidate resource documents are recoded into an extensible markup language (XML) document.

10. The computer system of claim 9, wherein the extensible markup language (XML) document comprises a qualifications possessed portion and a timeframes of availability portion.

11. The computer system of claim 7, wherein the overall match score is calculated by a formula

[(qualification match score)+(availability match score)]/2=overall match score.

12. The computer system of claim 11, wherein the availability match score is compared to an availability match score threshold.

13. A computer program product embodied in a non-transitory computer readable medium, the computer readable medium having stored thereon a sequence of instructions which, when executed by a processor causes the processor to execute a method to perform concurrent calculation of resource qualification and availability using text search, the method comprising:

receiving, at a server, a resource request, the resource request comprising at least a qualification requirement indication and a time period requirement indication, wherein the time period requirement indication indicates a period of availability needed for the resource request;

retrieving, from a first portion of a resource repository, a plurality of matching candidate resource records, at least two of the matching candidate resource records matching at least a portion of the qualification requirement indication of the resource request and the at least two of the matching candidate resource records matching at least a portion of the time period requirement indication of the resource request;

recoding at least two of the matching candidate resource records to form at least two recoded candidate resource documents;

storing the recoded candidate resource documents in a second portion of the resource repository;

converting the resource request into a text query, wherein the text query scores the recoded candidate resource documents using both availability and qualification corresponding to the recoded candidate resource documents;

retrieving, in response to the text query, from at least the second portion of the resource repository, at least one recoded candidate resource document, the recoded candidate resource document matching at least a portion of the qualification requirement indication and the recoded candidate resource document matching at least a portion of the time period requirement indication; and

scoring the recoded candidate resource document using the qualification requirement indication and the time period requirement indication to form an overall match score wherein the overall match score is formed by concurrently calculating a qualification match score and an availability match score for the recoded candidate resource document, wherein the overall match score is calculated prior to assigning one or more resources to the resource request; and

assigning one or more resources based at least in part on the overall match score.

14. The computer program product of claim 13, wherein the recoding is performed in a batch process.

15. The computer program product of claim 13, wherein the recoded candidate resource documents are recoded into an extensible markup language (XML) document.

16. The computer program product of claim 15, wherein the extensible markup language (XML) document comprises a qualifications possessed portion and a timeframes of availability portion.

17. The computer program product of claim 13, wherein the overall match score is calculated by a formula

[(qualification match score)+(availability match score)]/2=overall match score.