List:General Discussion« Previous MessageNext Message »
From:ChoiSaehoon Date:March 30 2009 11:38pm
Subject:RE: Data structure for matching for company data
View as plain text  
Thanks for the resource! Arthur.

 

SIC seems to be great for most industries, but not for high-tech industries. (e.g. it
doesn't have Internet or software etc) Still a great tip, though. Thanks again! :)
 


Date: Fri, 27 Mar 2009 19:13:51 -0500
Subject: Re: Data structure for matching for company data
From: fuller.artful@stripped
To: peter.brawley@stripped
CC: saehoony@stripped; mysql@stripped


My esteemed friend, partner and co-author has laid it out perfectly for you. Just follow
the instructions table-wise. 
 
One thing that may not be obvious from Peter's prescription is that you need to enter a
bunch of rows into the industry table first, so that the foreign keys will make sense in
the bridge table. But presumably this is not onerous.
 
Over here we commonly use a table called SIC (standard industry codes) that has
sub-industries etc. Whenever possible I try to use such standards rather than make up a
new one. For example, there is the ISO country codes standard, which provides unique two
and three letter codes for every country. Yes, thanks to politics, envy, revenge instinct
etc. such country codes from time to time require updating, but I choose to stick with the
ISO standards rather than rely on my self-invented one and all attendant hassles whenever
a country commits seppukku.
 
You might consider looking into the SIC code scheme before bothering to invent your own.
You can download this from a number of sources and in a number of formats. Just Google
SIC and you should get there.
 
Hope this helps,
Arthur

_________________________________________________________________
강력해진 보안성, 아웃룩을 닮아 편리해진 기능들로 무장한 Windows
Live Hotmail! 지금 로그인해 보세요!
http://www.hotmail.com
Thread
Data structure for matching for company dataChoiSaehoon27 Mar
  • Re: Data structure for matching for company dataPeter Brawley27 Mar
    • Re: Data structure for matching for company dataArthur Fuller28 Mar
      • RE: Data structure for matching for company dataChoiSaehoon31 Mar
    • RE: Data structure for matching for company dataChoiSaehoon31 Mar
      • Re: Data structure for matching for company dataPeter Brawley31 Mar
        • Re: Data structure for matching for company dataAndy Shellam31 Mar