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
- Moodle Gets SCORM Improvements, Security Fixes
New versions of Moodle have been released, bringing the most recent stable build to 1.9.3. The latest round of updates includes a number of bug fixes and security enhancements, as well as improvements to the SCORM module.
- Free 'Morro' Antivirus To Replace Microsoft OneCare
Microsoft is rolling out a free antivirus software program for consumers that will compete with products made by Symantec and McAfee. Code-named "Morro," the AV app is expected to be available by the end of 2009.
- Microsoft Demos New SQL Server Features at PASS
Microsoft Wednesday previewed the ability to centrally manage applications and resources in the planned upgrade of SQL Server, code-named "Kilimanjaro."
- Microsoft Unveils Exchange and SharePoint as Services
Microsoft exec Stephen Elop on Monday announced two hosted solutions from Microsoft--Exchange Online and SharePoint Online--which are now available to organizations of all sizes in the United States. The software, paid for by annual subscriptions, is hosted on Microsoft's servers and supported by Microsoft's channel partners.
- 6 Ways Not To Become Rote Using Instructional Technology
There are, in my experience, six strategies to consider with any use of technology that will guard against rote use of technology and facilitate critical analysis of teaching and learning effectiveness. In this article, I'll share with you the checklist I work with and encourage others to work with in learning about and using new technology.
- Bringing Student Web "Stuff" to Campus Enterprise Systems
How can an institution incorporate Web 2.0 learning opportunities for students, and evidence of learning from those opportunities, into existing campus technologies and processes? PlugJam is providing part of the answer.
