Title
Data exchange between distributed spectral databases
Abstract
Spectral databases constitute one of the components of a complete observing system, storing in situ spectroscopic measurements plus associated metadata and providing data for the validation, calibration, and simulation of imaging spectrometer products. Such databases may be employed by physically or organisationally separate entities. Consequently, methods for data exchange between distributed spectral databases are required, allowing the transfer of defined subsets of spectral data including their full metadata context from a source to a target system. The data exchange comprises generic approaches to the sequential steps of ordered table row export, relational storage in XML files, and nonconflicting import into the target database. The SPECCHIO spectral database system was used as a test bed for the data exchange between databases of identical schemata and according import/export functionality has been added to the SPECCHIO application. Import and export speeds were assessed using test cases of different metadata space densities, a score for the density with which associated metadata are detailed, and the potential utility as a quantitative rating for quality. Future spectral databases should allow the exchange between heterogeneous systems, ideally implementing a common subset of metadata parameters and thus supporting the long-term usability and data sharing between research partners.
Year
DOI
Venue
2011
10.1016/j.cageo.2010.12.009
Computers & Geosciences
Keywords
Field
DocType
specchio spectral database system,spectral data,different metadata space density,metadata parameter,export functionality,complete observing system,associated metadata,relational database,full metadata context,xml,spectral database,spectral databases,spectroradiometer,future spectral databases,data exchange,test bed,database system,imaging spectrometer
Data mining,Metadata,Metadata repository,Data exchange,XML,Relational database,Data element,Computer science,Data sharing,Data dictionary,Database
Journal
Volume
Issue
ISSN
37
7
Computers and Geosciences
Citations 
PageRank 
References 
5
0.70
29
Authors
4
Name
Order
Citations
PageRank
A. Hueni1303.25
T Malthus250.70
M. Kneubuehler350.70
M SCHAEPMAN48310.25