TaxoDros is a joint project of Dr. Gerhard Bächli
(Zoological Museum) and
the IT Services (U. Bernhard, Dr. A. J. Godknecht)
of the University of Zürich.
TaxoDros was developed out of the need to find another platform for the Drosophila
Taxonomy Database maintained by Dr. Gerhard Bächli since 1975. The initial Drosophila
Database was running on a MVS system using a non-relational database called PIZZA. Data were checked
and prepared for input into PIZZA using a variety of SAS routines.
As the Center for Computing Services shut down the MVS System in October 1999 a new platform
for the database had to be found.
As the database in its MVS form was exclusively accessible and intellegible to Dr. Bächli only,
we decided to port the whole database to a relational database system (MySQL) and make it
accessible to the Drosophila community by writing a Web-Interface to search the data.
TaxoDros is running on a standard x86 server with Linux, Apache, MySQL and PHP (LAMP).
|
|
Database Version Current (January 2024)
- We stopped the versioning of the database and instead give
infomation on the current database:
| Date | Literature | Taxa | Locations |
| January 2024
|
19,762
|
7,258
|
23,786
|
| July 2023
|
19,583
|
7,242
|
23,679
|
| January 2023
|
19,536
|
7,229
|
23,619
|
| June 2022
|
19,429
|
7,182
|
23,230
|
| January 2022
|
19,285
|
7,170
|
23,056
|
| July 2021
|
19,191
|
7,122
|
22,950
|
| January 2021
|
19,003
|
7,113
|
22,813
|
| September 2020
|
18,932
|
7,074
|
22,542
|
| January 2020
|
18,817
|
7,067
|
22,411
|
| July 2019
|
18,565
|
6,986
|
22,158
|
| February 2019
|
18,434
|
6,986
|
21,870
|
| July 2018
|
18,191
|
6,986
|
21,870
|
| February 2019
|
18,434
|
6,986
|
21,870
|
| July 2018
|
18,191
|
6,927
|
21,723
|
| January 2018
|
18,109
|
6,893
|
21,614
|
| July 2017
|
18,031
|
6,855
|
21,847
|
| February 2017
|
17,980
|
6,847
|
21,783
|
| July 2016
|
17,813
|
6,812
|
21,561
|
| April 2016
|
17,720
|
6,750
|
21,483
|
| March 2015
|
17.560
|
6.633
|
21.021
|
| September 2014
|
17.456
|
6.570
|
20.871
|
| January 2014
|
17.446
|
6.568
|
20.846
|
| June 2013
|
17.429
|
6.566
|
20.813
|
| March 2013
|
17.298
|
6.540
|
20.566
|
| October 2012
|
17.263
|
6.523
|
20.524
|
| July 2012
|
17.214
|
6.510
|
20.463
|
| April 2012
|
17.204
|
6.502
|
20.462
|
| December 2011
|
17.158
|
6.477
|
20.420
|
| June 2011
|
17.158
|
6.446
|
20.388
|
| December 2010
|
17.125
|
6.440
|
20.304
|
| June 2010
|
17.080
|
6.428
|
20.278
|
| March 2010
|
17.022
|
6.423
|
20.262
|
| January 2010
|
16.672
|
6.413
|
20.124
|
| October 2009
|
16.591
|
6.391
|
20.051
|
| August 2009
|
16.376
|
6.339
|
19.802
|
| July 2009
|
16.180
|
6.325
|
19.740
|
| April 2009
|
16.163
|
6.325
|
19.752
|
| December 2008
|
16.034
|
6.303
|
19.589
|
| September 2008
|
15.984
|
6.282
|
19.572
|
| May 2008
|
15.514
|
6.211
|
19.421
|
| March 2008
|
15.457
|
6.206
|
19.361
|
| January 2008
|
15.308
|
6.179
|
19.193
|
| June 2007
|
15.185
|
6.161
|
19.048
|
| March 2007
|
15.179
|
6.147
|
18.991
|
| December 2006
|
15.164
|
6.138
|
18.942
|
| August 2006
|
15.026
|
6.111
|
18.842
|
| May 2006
|
14.966
|
6.071
|
18.724
|
| March 2006
|
14.900
|
6.049
|
18.506
|
| Januar 2006
|
15.055
|
5.977
|
18.169
|
| August 2005
|
17.698
|
5.973
|
12.772
|
| January 2005
|
18.062
|
5.951
|
11.224
|
| October 2004
|
18.029
|
5.916
|
11.129
|
| August 2004
|
17.943
|
5.868
|
10.992
|
| April 2004
|
17.916
|
5.833
|
10.881
|
| November 2003
|
17.817
|
5.806
|
10.779
|
| October 2003
|
17.600
|
5.800
|
10.656
|
| September 2003
|
17.460
|
5.795
|
10.581
|
| April 2003
|
17.381
|
5.761
|
10.501
|
Database Version 3.0 (June 2001)
- In Database Version 3.0 further data was added, some corrections
were made and some inconsistencies fixed.
Database Version 2.0 (July 2000)
- The Database Version 2.0 is a greatly enhanced version. Many inconsitencies of
the initial Version 1.0 could be eliminated or corrected and new entries were added.
Database Version 1.0 (October 1999)
- The Database Version 1.0 was the first set of test-data converted from the MVS
flat data files to the MySQL input files using Perl scripts.
Data preparation and integrity checks were still done on the MVS using SAS. Further
checks were added in the Perl scripts that did the conversion of the flat files to
the MySQL input format.
| Contents | Version 3.0 | Version 2.0 | Version 1.0 |
Literature
Taxa
Locations
|
16.907
5.635
9.798
|
16.792
5.612
9.374
|
16.652
5.121
9.154
|
|
|
Interface Version 1.03 (March 2007)
- Correction of a few minor bugs and typos.
Interface Version 1.02 (November 2006)
- Added links to pdf-files for art-books.
- Removed banners with obsolete information.
Interface Version 1.01 (December 2003)
- Added Taxa Lists and some search hints.
- Added hints for searches with Umlaute on reference page.
- Added information that World coordinates are in Degrees.Minutes, not Decimal
- Added lists for Genus/Subgenus, Genus/Subgenus/Group, Genus/Subgenuss/Goup/Complex
on page Classification page.
Interface Version 1.0 (January 2003)
- The interface proved to be stable so we changed the Version from
0.4 beta to 1.0. Further development is momentarily suspended.
Interface Version 0.4 beta (June 2001)
- Due to the workload of a lot of other projects the further
development of the interface had to be suspended for almost a year.
We started programming again at the beginning of June 2001.
- At last added the classification pages.
- Optimized code of many search pages
- Rearranged some tables to better fit the need of the classification pages
- Fixed some minor problems in the interface.
Interface Version 0.3 beta (July 2000) not public
- Most of the tables and search pages were redesigned to take into account
the newly added Taxonomy part of TaxoDros.
- Bugs fixed in searches for locations. Search just found entries with location
data, records without location (just region) were omitted (Oops!).
- Redesigned search page for taxon names to display taxon and to
search for corresponding TaxoDros unique short forms.
- Added necessary explanation for difference of TaxoDros unique short forms
and valid names.
- Added function to send selected citations in different formats (Ovid, Medline,
Complete/Text) by e-mail.
- Changed colors of result pages for better printing.
- Implemented Cascading Style Sheets for better support of Windows browsers.
- Added this history file ;-)
Interface Version 0.2 beta (September 1999)
- 0.2 beta was presented in September, 30, 1999 on the European
Drosophila Congress held at the University of Zürich.
- Supported searches for citations, distribution, taxon names (unique short forms)
and keywords. Literature display in short and detailed form.
Interface Version 0.1 beta (August 1999)
- The initial interface 0.1 beta was only used for a feasability study.
|
