I had made a MediaWiki extension capable of storing the data. Some of you might have seen it or else you can have a look at it here
http://202.164.53.122/~albertcoder/mediawiki-1.22.6/index.php/Special:Material For this extension I have made my own database design for simplicity and better understanding of the extension-structure. But now I wish to you the database design which has been worked upon in the previous years. Studying it critically, I have come to notice that it has redundancies and it needs normalization. I am confused as I could not understand the purpose of using "table_materialID" and "materialID" in "traits" table. Can you see any difference between the columns pointed in [0] ? You can see the whole database structure in [1]. Else for more clarity you can import the sql file from [2]. [0] http://awesomescreenshot.com/08b2yhm7a8 [1] http://awesomescreenshot.com/09a2yhktde [2] http://202.164.53.122/~albertcoder/brlcad/material/db.sql -- Thanks Albert www.coderalbert.wordpress.com " Eat Sleep Conquer Repeat " ------------------------------------------------------------------------------ HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions Find What Matters Most in Your Big Data with HPCC Systems Open Source. Fast. Scalable. Simple. Ideal for Dirty Data. Leverages Graph Analysis for Fast Processing & Easy Data Exploration http://p.sf.net/sfu/hpccsystems _______________________________________________ BRL-CAD Developer mailing list brlcad-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/brlcad-devel
