Click here to receive your FREE subscription to Campus Technology
Features
Harvard University: An Anthill of Activity Spurs Versatile Database
11/26/2002
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.
Recommended Reading
- Fixed-Mobile Convergence: Dartmouth Beefs Up Cell Coverage, Cuts Costs
Problems with cell phone coverage aren't uncommon on college campuses. There are two main reasons: The beefy structure of historic buildings can block cellular reception within walls, and, on more remote campuses outside cities, signal coverage can be light.
- Thompson Rivers U Deploys Unified Digital Campus for ERP
Thompson Rivers University (TRU) in British Columbia has selected SunGard Higher Education's Banner Unified Digital Campus (UDC) to integrate its ERP systems.
- DV Kitchen Web Video Publishing System Released
DVcreators.net has released DV Kitchen, a new video encoding and publishing application for Mac OS X designed specifically for creating materials to be posted on the Web.
- NEC Debuts 4 Education Projectors
NEC this week debuted four new projectors targeted toward education applications, along with a new MultiSync LCD display. The new NP-series projectors are entry-level models started at $899 but are designed to provide high light output, support for closed captioning, and built-in networking capabilities.
- Security Researchers Uncover Spring Framework Vulnerability
Software frameworks are enjoying enormous popularity these days among a range of developers. It's popularity well earned; frameworks provide powerful tools for building more flexible and less error-prone applications. They generally enhance developer productivity with out-of-the-box functionality. And they can free developers to focus on features instead of common coding tasks.
- 3PAR Server Arrays Integrate Fat-to-Thin Processing
Utility storage provider 3PAR has announced the release of the 3PAR InServ T400 and T800 Storage Servers. The new hardware is built on the company's third-generation InSpire architecture, featuring the 3PAR Gen3 ASIC with integrated fat-to-thin processing.
