Method and system for locating a workforce

Abstract

The present invention generally relates to a computer-implemented method and system that helps a user or any other person to organization that needs to choose or allocate resources between or among geographical areas on the basis of key demographic variables. More specifically, the present invention uses computer automated SQL statements to extract, integrate, and index disparate data associated with at least one database over a Network. Non-limiting examples of disparate data may include statistical data essential to quantifying various industry and occupation variables that is mined from federal and/or private databases and maintained on a private database. Common geographical areas may link the disparate data, which is returned to the user as viewable raw data and/or index values. A user may then compare disparate data essential to quantifying and qualifying industry and occupation variables on an “apples to apples” basis.

1 . A computer-implemented method for extracting, integrating, and creating index and/or percentile values of disparate data from one or more tables in a database, the method comprising:
 a.) receiving user selections relating to industries and occupations that form a structured language query;   b.) the structured language query of step a.) being presented to a database having tables with disparate statistical data relating to industries and occupations;   c.) having a structured language query extract the disparate statistical data of step b.) from the database corresponding to the user's selections of step a.);   d.) having a structured language query within the database convert some, or all, of the extracted statistical data of step c.) into index or percentile values; and   e.) having a structured language query return the statistical data and/or the converted statistical data of step d.) to the user as integrated data, index values, percentile values, and/or any combinations thereof.   
     
     
         2 . The user of  claim 1 , wherein the user comprises a business, the media, or any other person or organization that needs to choose or allocate resources between or among geographical areas. 
     
     
         3 . The method of  claim 1 , wherein user selections are accessed over a Network at a computer server by web based applications, wherein user selections indicate at least one cell within at least one column and/or row of at least one database table having statistical data relating to industries and occupations within the database. 
     
     
         4 . The method of  claim 1 , wherein user selections are accessed from a permanent or temporary computer file located on the user's computer, wherein user selections indicate at least one cell within at least one column and/or row of at least one database table having statistical data relating to industries and occupations within the database. 
     
     
         5 . The method of  claim 1 , wherein the user selections comprises occupational categories and/or occupational subcategories, various industry categories and/or industry subcategories, query variables for the same, and/or any combinations thereof. 
     
     
         6 . The query variables of  claim 5 , wherein said query variables comprise the size of a metropolitan area, the number and types of minorities within an occupation, occupation employment within a geographic area, occupation unemployment within a geographic area, occupation wage within a geographic area, standard of living within a geographic area, industry unemployment within a geographic area, industry employment within a geographic area, total occupation employment within a geographic area, total occupation unemployment within a geographic area, total industry employment within a geographic area, total industry unemployment within a geographic area, job creation within a geographic area, new hires within a geographic area, separations within a geographic area, turnover rate within a geographic area, average wages within a geographic area, cost of living within a geographic area, average wage inverse within a geographic area, industry unemployment within a geographic area, unemployment average within a geographic area, industry workforce within a geographic area, percentage of minorities within a geographic area, gender make up within a geographic area, the percent of industry employment in the given occupation, the percent of establishments reporting the given occupation in the given industry, the mean hourly industry and/or occupation wage, the mean annual industry and/or occupation wage, the percent relative standard error for the mean wage, employment percent relative error, and/or any combinations thereof. 
     
     
         7 . The query variables of  claim 6 , wherein all statistical data associated with each query variable is returned, displayed, or stored on the user's computer as raw data, an index value, or a percetinle value. 
     
     
         8 . The geographic area of  claim 6 , wherein the geographic area is a Metropolitan Statistical Area as defined by the United States Office of Management and Budget. 
     
     
         9 . The method of  claim 1 , wherein the U.S. Census Bureau and the U.S. Bureau of Labor and Statistics define the industry and occupation categories and subcategories thereof, or are harmonized to correspond to those categories or subcategories. 
     
     
         10 . The database of  claim 1 , wherein said database is a private database housed on a computer server and accepts query languages comprising MS SQL/ASP.NET, MS Access/Visual Basic, MySQL/Coldfusion (CFML), HSQL/JSP (J2EE), PostgreSQL/Perl, MS SQL/Foxpro, Oracle/ASP.NET. 
     
     
         11 . The structured language query of  claim 1 , wherein the structured language query is in the form of an SQL query statement. 
     
     
         12 . The disparate data of  claim 1 , wherein the disparate data comprises statistical data essential to quantifying and/or qualifying various industry and occupation query variables as acquired by the U.S. Bureau of Labor Statistics, the U.S. Census Bureau, the Council for Community, and the Economic Research. 
     
     
         13 . The disparate data of  claim 1 , wherein the disparate data is initially mined over a Network from tables located within databases maintained by the U.S. Bureau of Labor Statistics, the U.S. Census Bureau, or Council for Community and Economic Research and extracted into tables on a private database. 
     
     
         14 . The method of  claim 1 , wherein the user subjectively ranks the importance of the integrated data, index data, or percentile data returned to the users according to their business needs. 
     
     
         15 . A system for extracting, integrating, and indexing disparate data from one or more tables in a database, the system comprising:
 a user computer having web-based applications or permanent files located on the user's computer, capable of selecting options related to occupations, industries, and query variables for the same; and   a server computer or a file within the user's computer capable of reading options selected from the user's computer over a Network or within the user's computer and generating a structured language query to parse a relational database having statistical data relating to occupation, industry, and query variables of the same.   
     
     
         16 . The system of  claim 15 , wherein the server computer presents a series of graphical menus relating to occupation and industry variables to the user's computer over a Network via a graphical user interface. 
     
     
         17 . The system of  claim 15 , wherein the server computer has at least one send/receive module capable of generating and/or reading a structured language query concerning statistical data associated with industries and occupations and presenting said query to the relational database. 
     
     
         18 . The system of  claim 15 , wherein the relational database has at least one send/receive module capable of generating and/or reading a structured language query concerning statistical data associated with industries and occupations as presented by the server computer. 
     
     
         19 . The system of  claim 15 , wherein the relational database has a send/receive module for searching tables having statistical data associated with industries and occupations within the database and returning that data to the send/receive module associated with communicating to the send/receive module of the computer server. 
     
     
         20 . The method of  claim 1 , wherein integrated data, index values, percentile values and/or any combinations thereof is presented to the user as estimated data for each occupation in each industry for each MSA.