Please use this identifier to cite or link to this item: https://une.intersearch.com.au/unejspui/handle/1959.11/37
Title: SGS Database: use of relational databases to enhance data management for multi-site experiments
Contributor(s): Scott, JM (author); Lord, CJ (author)
Publication Date: 2003
DOI: 10.1071/EA02215
Handle Link: https://hdl.handle.net/1959.11/37
Abstract: Relational databases are increasingly used to manage large and complex experimental datasets. This technology was chosen to create a common database tool for a large multi-site experiment which measured aspects of the sustainability of various regionally focused grazing experiments, as part of the Sustainable Grazing Systems Program. Since the data needs of experiments expanded over time and the number of sites and subsites increased, it was necessary to adopt an evolutionary approach to creating the database. It was important that the database be customised to accommodate the wide range of experiments and the diverse needs of the many scientists involved and yet have complete conformity of structure to permit across-site queries. This paper describes the steps taken in this process and suggests how similar database projects could be implemented more efficiently in the future. As most of the scientists involved were initially new users of relational databases, there were some delays in achieving full adoption of a uniform approach to data handling. The software chosen was a commonly available desktop application which was modified using code developed to allow graphical queries, quality assurance of data, and interfacing with a purpose-built simulation model. A survey of users at the end of the project indicated that there was generally a high degree of satisfaction with the relational database developed, but it also identified areas requiring improvement. The need for developing mechanisms of sharing data and of protecting data for possible future use are briefly discussed.
Publication Type: Journal Article
Source of Publication: Australian Journal of Experimental Agriculture, 43(8), p. 729-743
Publisher: CSIRO Publishing
Place of Publication: Collingwood, Victoria
ISSN: 0816-1089
Field of Research (FOR): 050302 Land Capability and Soil Degradation
Peer Reviewed: Yes
HERDC Category Description: C1 Refereed Article in a Scholarly Journal
Statistics to Oct 2018: Visitors: 51
Views: 56
Downloads: 0
Appears in Collections:Journal Article

Files in This Item:
2 files
File Description SizeFormat 
Show full item record

Page view(s)

44
checked on Feb 8, 2019
Google Media

Google ScholarTM

Check

Altmetric

SCOPUSTM   
Citations

 

Items in Research UNE are protected by copyright, with all rights reserved, unless otherwise indicated.