Re: [Bioclusters] Re: RDBMS and Bioinformatics
Michael Maibaum <[email protected]>
| Newsgroups | gmane.science.biology.informatics.devel |
|---|---|
| Message-ID | <[email protected]> |
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: [email protected] | http://mike.maibaum.org voice: [m] 07958 604025 |