php - Varchar values to numerical classification -


i have database containing 3 tables:

  1. practices - 8 fields
  2. patients - 47 fields
  3. exacerbations - 11 fields

the majority of fields in these tables recorded in varchar format, other fields include integers, doubles , dates.

i have transform data numerically classified data can used statistician extrapolate patterns in data. acheive have convert varchar fields integers represent classification string belongs to, example being 'severity' has following possible string values:

  1. mild
  2. moderate
  3. severe
  4. very severe

this field in patients table has finite list of string values can appear, other fields have endless possibility of string values cannot classified until encountered database (unless implement form of intelligent approach).

for time being trying construct best approach converting each field entries in each of 3 tables numeric values. pseudo code have in head far follows (it's not complete):

 function profiledatabase     each table in database       each field of type varchar        select distinct values , insert classfication table field      end    end   function classifydatabase    each table in database       each field of type varchar        // efficient build insert string place new table      end    end

can suggest best way of performing process efficient giving there in excess of 100 practices, 15,000 patients , 55,000 exacerbations in system. have no need implement in php, build prefer so. pointers how structure great not sure approach best approach.

this process have run every month next 2 years database grows have total of 100,000 patients.

maybe http://dev.mysql.com/doc/refman/5.1/en/procedure-analyse.html overview find out how fields used.


Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more