Date: Wed, 29 May 2002 15:11:27 -0400 From: Lance M.Westerhoff <lmw188@psu.edu> To: Bill Moran <wmoran@potentialtech.com> Cc: freebsd-questions@FreeBSD.ORG Subject: Re: DB2 on FreeBSD?? Message-ID: <E05EFBFC-7337-11D6-B5D0-00039357F10C@psu.edu> In-Reply-To: <3CF52335.30807@potentialtech.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Wednesday, May 29, 2002, at 02:51 PM, Bill Moran wrote: > <SNIP> > > What about database software? As the databases grow, I expect each of > them to encompass several TB, so I don't think MySQL will work in the > long run (though I could be wrong). Therefore, we are looking at > commercial database solutions. > > Keep in mind, MySQL *is* a commercial database. Contact MySQL AB > directly and inquire about db sizes, etc. The FAQ states that tables > can be up to 8 million Tb ( 2^63 ), so you may be underestimating what > MySQL can do. > http://www.mysql.com/doc/T/a/Table_size.html > > Have you considered PostgreSQL? It's another _extremely_ powerful > open-source database. Agreed. A little more research may be in order here. Do you know if either MySQL or PostgreSQL offer any Object Oriented or Object Relational support (like Oracle)? Biological systems are inherently object oriented and over the coming months I'll be exploring OO DBMS to see what I can see. I have focused exclusively on RDBMS's such as MySQL (the databases are currently fully implemented with MySQL), but OO seems interesting (at least for certain types of applications). > >> From the FreeBSD page, it seems that Linux-Oracle8 will run (I assume >> that 9 will as well??). Does anyone know about DB2 from IBM? Being a >> University, we have a much much better deal with IBM then with >> Oracle. Other ideas? Lastly, what sort of performance hit, if any, >> can we expect with using a Linux-native DBMS with FreeBSD's Linux >> compatibility libraries? > > I can't say for sure with DBMS, but with other Linux software > (Staroffice, Acrobat) I've seen 0 performance hit running under the > FreeBSD Linuxulator. > I also don't have experience with DB2 or Oracle on FreeBSD, so I can't > give any advice there. There's an article in the handbook (I believe) > on getting Oracle running under FreeBSD. > I'll take a look. Thanks! -Lance _____________________ Lance M. Westerhoff PennState Chemistry Graduate Researcher & UNIX Systems Administrator - Merz Computational Biochemistry Research Group Phone: 814-863-7591 Email: lance@mac.com Web: http://merz.chem.psu.edu/~lance/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?E05EFBFC-7337-11D6-B5D0-00039357F10C>