Harvard University: An Anthill of Activity Spurs Versatile Database

Ants—thousands of species, hundreds of thousands of specimens, from all over the world—have been identified and catalogued on the Web by researchers at Harvard University's Museum of Comparative Zoology. Their efforts, which began with an expedition to hunt the vast ant populations of Madagascar, confronted the scientists with the problem of how to chart and organize their discoveries in a simple, accessible but effective way.

"We discovered almost 500 new species of ants in Madagascar, and were overwhelmed with the task of making specimen labels, sending out ant loans to specialists, and keeping track of detailed field records for each species," recalls Harvard entomologist Gary Alpert.

Alpert and his colleagues agreed that the development of an online database would help them with their project, but weren't sure which database application would best fit their needs: one that was relational, expandable, cost-effective, and intuitive. MS Access was considered, but lacked the flexibility needed for online deployment. Other proprietary tools designed especially for scientific use were also examined, but it would take years to tailor the database to fit their requirements. In addition, they didn't want to rely on a team of developers to add or modify tasks, nor pay thousands of dollars in licensing fees. After careful consideration, a decision was made to use the database software application FileMaker Pro from FileMaker Inc.

Alpert's colleague, entomologist and computer expert Dr. Piotr Naskrecki, developed a comprehensive database documenting thousands of specimens of grasshoppers, katydids, and crickets—complete with audio files of their songs—using FileMaker Pro. The application offered the combination of flexibility, Web-capability, and ease of use Dr. Alpert was looking for in a database application. Realizing the similarity of the two projects, museum curators Prof. Brian Farrell and Prof. Edward O. Wilson brought in Dr. Naskrecki to work with Dr. Alpert on the challenge of preparing a similar system for documenting the ants.

The database developed by Alpert contains over 25,000 individual records documenting Madagascar ants. "We now are running digital images of insects and text directly from our microscope onto a database-driven Web site for the world to see," says Alpert. In the field, FileMaker Mobile is being used to record information on handheld computers to eliminate the hassle of paper records. The process has resulted in the database being carefully organized, allowing users to search by species, geographic location, or by many other scientific classifications. In addition to the information gathered out in the field, an ant bibliography has been imported into the database, providing references to the literature that's been published for that particular specimen.

Alpert and his colleagues are able to continuously update and add new specimens without relying on a team of developers. Because of the intuitiveness of FileMaker Pro, they've been able to rapidly input information from the Harvard Museum of Zoology insect collection, and expect to complete the project years ahead of schedule. Using an application that has expanded as the project has expanded, accommodating all their needs, has allowed Dr. Alpert to build an entire infrastructure for ant research.

For more information, contact Dr. Gary Alpert at gary_alpert@harvard.edu.

comments powered by Disqus

Campus Technology News

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.