Title
Component-based end-user database design for ecologists
Abstract
To solve today's ecological problems, scientists need well documented, validated, and coherent data archives. Historically, however, ecologists have collected and stored data idiosyncratically, making data integration even among close collaborators difficult. Further, effective ecology data warehouses and subsequent data mining require that individual databases be accurately described with metadata against which the data themselves have been validated. Using database technology would make documenting data sets for archiving, integration, and data mining easier, but few ecologists have expertise to use database technology and they cannot afford to hire programmers. In this paper, we identify the benefits that would accrue from ecologists' use of modern information technology and the obstacles that prevent that use. We describe our prototype, the Canopy DataBank, through which we aim to enable individual ecologists in the forest canopy research community to be their own database programmers. The key feature that makes this possible is domain-specific database components, which we call templates. We also show how additional tools that reuse these components, such as for visualization, could provide gains in productivity and motivate the use of new technology. Finally, we suggest ways in which communities might share database components and how components might be used to foster easier data integration to solve new ecological problems.
Year
DOI
Venue
2007
10.1007/s10844-006-0028-6
J. Intell. Inf. Syst.
Keywords
Field
DocType
Ecosystem informatics,End-user programming,Domain-specific data structures,Spatial databases,Scientific visualization
Data warehouse,Data science,Data integration,Data mining,Metadata,End user,Information technology,Computer science,Reuse,Database design,Scientific visualization
Journal
Volume
Issue
ISSN
29
1
0925-9902
Citations 
PageRank 
References 
11
0.88
16
Authors
7
Name
Order
Citations
PageRank
Judith Bayard Cushing1193106.22
Nalini Nadkarni2132.41
Michael Finch3110.88
Anne Fiala4111.21
Emerson R. Murphy-hill5128474.35
Lois M. L. Delcambre6992420.78
David Maier756391666.90