[BioSQL-l] ModBioSQL release 0.12

[Hegedus, Tamas .]

Dear All,
Dear Hilmar,

during my work I had to use UniProt in an RDBMS. Cause of performance problems I had to realize my system without BioSQL.

I collected my scripts and experiments into a package called Modular BioSQL which has different features:
-- Modular RDB realization of different biological databases allows fine-tuning with increased performance. 
-- Storing result sets in RDBMS allows more accurate, more comfortable analysis using SQL. 

-- User interaction with the RDBMS (installation, loading up and querying data) does not need programming skills. 
-- Light weight RDB interaction with analysis packages (only EMBOSS is implemented). 
-- Optimalized loading of flat files into the RDBMS. 
-- Using 'fixed value arrays' (*_ref tables) results in both smaller data size (smaller than the flat file) and smaller index -- size increasing the performance (theoretically both the uploading and querying performance). 
-- Relatively easily extendable to implement and handle databases other than the currently realized.

You may think I suggest Modular BioSQL as a replacement of BioSQL. I do not think so!
For details, please visit my web site, and please send comments and suggestions:
http://www.biomembrane.hu/~hegedus/modbiosql/


Best regards,
Tamas

--
Tamas Hegedus, Research Fellow | phone: 480-301-6041
Mayo Clinic Scottsdale         | fax:   480-301-7017
13000 E. Shea Blvd             | mailto:hegedus.tamas at mayo.edu
Scottsdale, AZ, 85259          | http://www.biomembrane.hu/~hegedus