Database - summary

[Dr. Gerald Stinger Guala]

Roland,

You will see several other systems that i have tested listed at:
http://www.virtualherbarium.org/vh/othersystems.html


As for the assertion that you should not use Access for large databases,
this is pure propaganda that was once true but is now outdated and
unfortunately maintained by Oracle and its affectionados. I have one
database with 180,000 records in it that runs fine in Access2000. The limit
is around 2 gigabytes for the size of the mdb file. That would be 3.6
million records in my herbarium database. Then you can export to SQL
automatically - unlike a lot of MS software, it actually works, I've tried
it.

Stinger


Gerald "Stinger" Guala, Ph.D.
Keeper of the Herbarium
Fairchild Tropical Garden Research Center
11935 Old Cutler Rd.
Coral Gables, FL 33156-4299

www.virtualherbarium.org

-----Original Message-----
From: Taxacom Discussion List [mailto:TAXACOM at USOBI.ORG]On Behalf Of
Roland Eberwein
Sent: Wednesday, January 16, 2002 2:29 PM
To: TAXACOM at USOBI.ORG
Subject: Database - summary


Dear Listmembers,

several weeks ago, I posted a call for help: I'm looking for a suitable
database to manage a herbarium and a botanical garden.
I got a lot of  tips, support and informative discussions - CORDIAL THANKS
TO ALL !!
Now I want to share the results:

Many listmembers are working with self-developed databases using MS Access,
dBase, Filemaker Pro or Paradox. I don't want to develop an own database
because I'm a single fighter in "my" herbarium. If I go mad, it would be
difficult to update or convert the database. A "professional" database is
more secure: you get support, updates and if the company goes bankrupt,
others are affected too and the way out can be easier found by teamwork.
MS Access is the most popular database software (be careful, Access should
not be used for larger databases. For example, Willoughby Ass.
http://www.willo.com/cgi/content.cgi?main.html,snap.html,intro_left,snap.htm
l,intro_right recommend only 60.000 objects for their Access-based database
SNAP!)

Recommended (used by listmembers) software packages are:

*BG-Base*
Database engine: OpenInsight
http://www.rbge.org.uk/bg-base
Single user licence: more than 4000 Br. Pounds (module system)
Very good support (Kerry Walter); extensive software

*KE Emu*
Database engine: KE Texpress
http://www.kesoftware.com
Very good support (Doug Belford); extensive software; KE Emu is expensive

*Bio Office*
Database engine: ?
http://www.biogis.at
Single user licence: 950 Euro
Very good support (Paul Schreilechner); focus on mapping (with ArcView),
GIS - primarily not designed for herbaria or bot. gardens!

*BRAHMS*
Database engine: FoxPro
http://www.brahms.co.uk
Very good support (Denis Filer); BRAHMS is free

*Multi MIMSY 2000*
Database engine: Oracle 8i
http://www.mda.org.uk/mmimsy.htm
http://www.willo.com
Stand-alone copy: 10000 USD
Extensive software; Willoughby Ass. offers interesting additional software
to Multi MIMSY!

*BioLink*
Database engine: SQL Server version 7
http://www.ento.csiro.au/biolink/index.html
Single user licence: 275 Aust. Dollars

*Specify*
Database engine: Access 2000
http://usobi.org/specify
Specify is free

Nobody mentioned the German Systax! This was a great surprise for me.

*Systax*
Database engine: Oracle
http://www.biologie.uni-ulm.de/systax/index.html

For those, who are looking for a database too, it's worth to open:
http://www.bgbm.org/TDWG/acc/software.htm

Best wishes and
good luck!
Roland

PS: I couldn't make a decision up to now.

*********************************************************
Mag. Dr. Roland K. Eberwein
Carinthian Botanic Center
Prof.-Dr.-Kahler-Platz 1
A-9020 Klagenfurt
Austria
Tel.: ++43 (0)463 598983 11
Fax: ++43 (0)463 598983 14
E-Mail: roland.eberwein at landesmuseum-ktn.at