I am a new comer to the entire "stabilized table" factor. I've got a csv file using the contents the following:


Cell,Width(m),Length(m),Spacing(m),VDD(V),VSS(V),Temp,Param,Value,Path,TOOL

pmos_var12,5e-03,5e-03,5e-03,.5,,,delay[s],4.65e-06,/home/user/tests/run2/pspice

pmos_var12,5e-03,5e-03,5e-03,.5,,10,delay[s],6.2e-06,/home/user/tests/run2/pspice

pmos_var12,5e-03,5e-03,5e-03,.5,,25,delay[s],7.46e-06,/home/user/tests/run2/pspice

pmos_var12,5e-03,5e-03,5e-03,.5,,70,delay[s],8.98e-06,/home/user/tests/run2/pspice

pmos_var12,5e-03,5e-03,5e-03,.5,,100,delay[s],9.56e-06,/home/user/tests/run2/pspice

nmos_var12,5e-03,5e-03,5e-03,.5,,,delay[s],4.65e-06,/home/user/tests/run2/pspice

nmos_var12,5e-03,5e-03,5e-03,.5,,10,delay[s],6.2e-06,/home/user/tests/run2/pspice

nmos_var12,5e-03,5e-03,5e-03,.5,,25,delay[s],7.46e-06,/home/user/tests/run2/pspice

nmos_var12,5e-03,5e-03,5e-03,.5,,70,delay[s],8.98e-06,/home/user/tests/run2/pspice

nmos_var12,5e-03,5e-03,5e-03,.5,,100,delay[s],9.56e-06,/home/user/tests/run2/pspice

I have produced these tables to keep the information:


CREATE TABLE `TEST__RUN_MAPPING` (

 `ID` int(11) NOT NULL auto_increment,

 `NAME` varchar(45) NOT NULL,

 `STATUS` varchar(20) NOT NULL,

 `PATH` text NOT NULL,

 `TOOL` varchar(10) NOT NULL,

 `COMMENTS` text NOT NULL,

 PRIMARY KEY  (`ID`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1


CREATE TABLE `TEST__DATA_MAPPING` (

 `ID` int(11) NOT NULL auto_increment,

 `NAME_ID` int(11) NOT NULL,

 `CONDITIONS` int(11) NOT NULL,

 `VALUE` varchar(10) NOT NULL,

 PRIMARY KEY  (`ID`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1


CREATE TABLE `TEST__CONDITION_MAPPING` (

 `ID` int(11) NOT NULL auto_increment,

 `CELL_ID` int(11) NOT NULL,

 `W_ID` int(11) NOT NULL,

 `L_ID` int(11) NOT NULL,

 `SPACE_ID` int(11) NOT NULL,

 `VDD_ID` int(11) NOT NULL,

 `VSS_ID` int(11) NOT NULL,

 `TEMP_ID` int(11) NOT NULL,

 `PARAM_ID` int(11) NOT NULL,

 PRIMARY KEY  (`ID`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

TEST__RUN_MAPPING ID maps to check__DATA_MAPPING Title_ID

TEST__DATA_MAPPING CONDITIONS maps to checkSituationApplying ID

All *ID in TEST_CONDITION_MAPPING map to their personal table to be able to have things unique.

every one of these csv files will differ with what technology utilized in the simulations, and that i monitor this using the Title column in TEST__RUN_MAPPING. Cell, Width(m), Length(m), Spacing(m), VDD(V), VSS(V), and Temp are values which are taken, truly they are exactly the same per technology and so i arranged them together inside a separate table.

Are there more ways in which a far more experienced person could break lower the connection such that it may have optimal reading through occasions? better normalization?

Basically appreciate this structure properly then I wouldn't seperate the circumstances table in the run table. Surely they'd possess a 1-to-1 relationship. So why wouldn't you ask them to in exactly the same table. The circumstances for your paticular run.

Also I'd be cautious about placing a 'TEXT' block in the record. TEXT and Blobs may cause some performance problems. varchar in mysql 5 can go up to 65,000 figures. For pathways you shouldn't require more than 1024 figures. So varchar(1024) ought to be enough for any path.