Database - summary
Dr. Gerald Stinger Guala
stinger at FAIRCHILDGARDEN.ORG
Wed Jan 16 17:13:25 CST 2002
You will see several other systems that i have tested listed at:
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
Gerald "Stinger" Guala, Ph.D.
Keeper of the Herbarium
Fairchild Tropical Garden Research Center
11935 Old Cutler Rd.
Coral Gables, FL 33156-4299
From: Taxacom Discussion List [mailto:TAXACOM at USOBI.ORG]On Behalf Of
Sent: Wednesday, January 16, 2002 2:29 PM
To: TAXACOM at USOBI.ORG
Subject: Database - summary
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.
l,intro_right recommend only 60.000 objects for their Access-based database
Recommended (used by listmembers) software packages are:
Database engine: OpenInsight
Single user licence: more than 4000 Br. Pounds (module system)
Very good support (Kerry Walter); extensive software
Database engine: KE Texpress
Very good support (Doug Belford); extensive software; KE Emu is expensive
Database engine: ?
Single user licence: 950 Euro
Very good support (Paul Schreilechner); focus on mapping (with ArcView),
GIS - primarily not designed for herbaria or bot. gardens!
Database engine: FoxPro
Very good support (Denis Filer); BRAHMS is free
*Multi MIMSY 2000*
Database engine: Oracle 8i
Stand-alone copy: 10000 USD
Extensive software; Willoughby Ass. offers interesting additional software
to Multi MIMSY!
Database engine: SQL Server version 7
Single user licence: 275 Aust. Dollars
Database engine: Access 2000
Specify is free
Nobody mentioned the German Systax! This was a great surprise for me.
Database engine: Oracle
For those, who are looking for a database too, it's worth to open:
Best wishes and
PS: I couldn't make a decision up to now.
Mag. Dr. Roland K. Eberwein
Carinthian Botanic Center
Tel.: ++43 (0)463 598983 11
Fax: ++43 (0)463 598983 14
E-Mail: roland.eberwein at landesmuseum-ktn.at
More information about the Taxacom