TaxoDros     Drosophila


Compiled by
Gerhard Bächli

The database on Taxonomy of Drosophilidae

 

TaxoDros History

Date: 07-18-2017 06:35

TaxoDros | Database | Web Interface |

TaxoDros

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

Database Version Current (July 2017)

  • We stopped the versioning of the database and instead give infomation on the current database:

    DateLiteratureTaxaLocations
    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.

ContentsVersion 3.0Version 2.0Version 1.0
Literature
Taxa
Locations
16.907
5.635
9.798
16.792
5.612
9.374
16.652
5.121
9.154

 

 

Web Interface

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.
 

Home | Biodiversity | References | Descriptions | Classification |

 

top

last update: 07-18-17 06:35