[Bioclusters] Re: [Biodevelopers] RDBMS and Bioinformatics

[Michael Maibaum]

On Mar 15, 2004, at 18:18, Dan Bolser wrote:

> On Mon, 15 Mar 2004, Titus Brown wrote:
>
>> -> Hi, I would like to know if RDBMS (Relational Data
>> -> Base Management Systems) is extensively used in
>> -> Bioinformatics Data Bases. If it indeed true, what is
>> -> the most suited RDBMS, Oracle?
>>
>> I believe that NCBI uses SQLserver for some things, and MySQL has
>> been used by several of the public projects (ENSEMBL, for one).
>> I use PostgreSQL because of it's support for an object/relational
>> data model.

A second vote for postgres here, most of the features you could want, 
fast and stable.

>>
>> I don't know of a project using Oracle but there must be some out 
>> there.
>
> MSD

Most of the large EBI databases use Oracle, ArrayExpress is another - 
as is the stuff I'm developing which is partially based on the MSD. 
Oracle is great  - but an absolute nightmare to administrate unless you 
*really* know what you are doing. Postgres is much simpler. MySql is 
even simpler, but at a cost in features.



>
>>
>> I'm not sure what distinguishes one database as being better for
>> bioinformatics as a whole; it depends an awful lot on what you're
>> doing...
>>

absolutely.

mike
-- 
Michael Maibaum
internet: mike at maibaum.org    |    http://mike.maibaum.org
voice:     [m] 07958 604025        |