Cognitive style factors affecting database query performance

As end-user computing becomes more pervasive, an organization's success increasingly depends on the ability of end-users, usually in managerial positions, to extract appropriate data from both internal and external sources. Many of these data sources include or are derived from the organization's accounting information systems. Managerial end-users with different personal characteristics and approaches are likely to compose queries of differing levels of accuracy when searching the data contained within these accounting information systems. This research investigates how cognitive style elements of personality influence managerial end-user performance in database querying tasks. A laboratory experiment was conducted in which participants generated queries to retrieve information from an accounting information system to satisfy typical information requirements. The experiment investigated the influence of personality on the accuracy of queries of varying degrees of complexity. Relying on the Myers–Briggs personality instrument, results show that perceiving individuals (as opposed to judging individuals) who rely on intuition (as opposed to sensing) composed queries more accurately. As expected, query complexity and academic performance also explain the success of data extraction tasks.

Introducing OTseeker (Occupational Therapy Systematic Evaluation of Evidence): A new evidence database for occupational therapists

OTseeker (Occupational Therapy Systematic Evaluation of Evidence) is a new resource for occupational therapists that has been designed with the principle aim of increasing access to research to support clinical decisions. It contains abstracts of systematic reviews and quality ratings of randomized controlled trials (RCTs) relevant to occupational therapy. It is available, free of charge, at www.otseeker.com. This paper describes the OTseeker database and provides an example of how it may support occupational therapy practice.

Effect of organic amendments and solarisation on Fusarium wilt in susceptible banana plantlets, transplanted into naturally infested soil

Despite extensive research since pathogenicity was first established in 1919, no cultural or chemical control strategy has proven effective against Fusarium wilt of bananas. The efficacy of cultural control is attributed to the suppression of pathogen activity. Yet, amending naturally infested soil with aged chicken manure has been shown to enhance disease severity, without any change in the activity of the pathogen Fusarium oxysporum f. sp. cubense (Foc) in the soil. In this study, the effect of amending soil with composted sawdust, and of solarising soil, was compared with the effect of amending soil with chicken manure. Bioassays comparing the activity of Foc in the soil with the extent of invasion of banana pseudostem tissue by Foc were used to investigate why strategies targetting pathogen survival have not proven successful in controlling this disease. The enhancement of Foc invasion of the banana plantlets was reproduced with the addition of chicken manure to the naturally infested soil. However, changes in the activity of Foc in the soil were not associated with changes in the frequency of invasion of the plantlets. Invasion of banana pseudostems in the sawdust and solarisation treatments was not significantly different from invasion in the respective control treatments, despite a reduction in the activity of Foc in the sawdust-amended soil and an enhancement in the solarised soil. Moreover, the increase in Foc activity in the solarised soil recorded during the bioassays occurred despite the effectiveness of solarisation in reducing the survival of Foc in pre-colonised banana root tips buried in the soil. Changes in the frequency of invasion were associated with changes in the availability of mineral nitrogen, particularly ammonium N. These results suggest that the physiological response of banana cultivars to ammonium N may be associated with their susceptibility to Fusarium wilt. Accordingly, cultural strategies for controlling Panama disease will only be effective if they enhance the ability of the host to resist invasion.

Database technologies for l-system simulations in virtual plant applications on bioinformatics

One of the most important advantages of database systems is that the underlying mathematics is rich enough to specify very complex operations with a small number of statements in the database language. This research covers an aspect of biological informatics that is the marriage of information technology and biology, involving the study of real-world phenomena using virtual plants derived from L-systems simulation. L-systems were introduced by Aristid Lindenmayer as a mathematical model of multicellular organisms. Not much consideration has been given to the problem of persistent storage for these simulations. Current procedures for querying data generated by L-systems for scientific experiments, simulations and measurements are also inadequate. To address these problems the research in this paper presents a generic process for data-modeling tools (L-DBM) between L-systems and database systems. This paper shows how L-system productions can be generically and automatically represented in database schemas and how a database can be populated from the L-system strings. This paper further describes the idea of pre-computing recursive structures in the data into derived attributes using compiler generation. A method to allow a correspondence between biologists' terms and compiler-generated terms in a biologist computing environment is supplied. Once the L-DBM gets any specific L-systems productions and its declarations, it can generate the specific schema for both simple correspondence terminology and also complex recursive structure data attributes and relationships.

eMelanoBase: An online locus-specific variant database for familial melanoma

A proportion of melanoma,prone individuals in both familial and non,familial contexts has been shown to carry inactivating mutations in either CDKN2A or, rarely, CDK4. CDKN2A is a complex locus that encodes two unrelated proteins from alternately spliced transcripts that are read in different frames. The alpha transcript (exons 1a, 2, and 3) produces the p16INK4A cyclin-dependent kinase inhibitor, while the beta transcript (exons 1beta and 2) is translated as p14ARF, a stabilizing factor of p53 levels through binding to MDM2. Mutations in exon 2 can impair both polypeptides and insertions and deletions in exons 1alpha, 1beta, and 2, which can theoretically generate p16INK4A,p14ARF fusion proteins. No online database currently takes into account all the consequences of these genotypes, a situation compounded by some problematic previous annotations of CDKN2A related sequences and descriptions of their mutations. As an initiative of the international Melanoma Genetics Consortium, we have therefore established a database of germline variants observed in all loci implicated in familial melanoma susceptibility. Such a comprehensive, publicly accessible database is an essential foundation for research on melanoma susceptibility and its clinical application. Our database serves two types of data as defined by HUGO. The core dataset includes the nucleotide variants on the genomic and transcript levels, amino acid variants, and citation. The ancillary dataset includes keyword description of events at the transcription and translation levels and epidemiological data. The application that handles users' queries was designed in the model,view. controller architecture and was implemented in Java. The object-relational database schema was deduced using functional dependency analysis. We hereby present our first functional prototype of eMelanoBase. The service is accessible via the URL www.wmi.usyd.e, du.au:8080/melanoma.html.

Composition and quality of harvest residues and soil organic matter under windrow residue management in young hoop pine plantations as revealed by solid-state C-13 NMR spectroscopy

Solid-state C-13 nuclear magnetic resonance (NMR) with cross-polarisation (CP) and magic-angle-spinning (MAS) was used to: (a) examine the changes in carbon (C) composition of windrowed harvest residues during the first 3 years of hoop pine plantations in subtropical Australia; (b) assess the impacts of windrowed harvest residues on soil organic matter (SOM) composition and quality in the 0-10 cm soil layer. Harvest residues were collected from 0-, 1-, 2- and 3-year-old windrows of ca. 2.5 m width (15 m apart for 0-, 1- and 2-year-old sites and 10 m apart for 3-year-old site). Soils from the 0 to 10 cm soil layer were collected from the 1-, 2- and 3-year-old sites. The 13C NMR spectra of the harvest residues indicated the presence of lignin in the hoop pine wood, foliage and newly incorporated organic matter (NIOM). Condensed tannin structures were found in the decay-resistant bark, small wood and foliage, but were absent in other residue components and SOM. The NMR spectra of small wood samples contained condensed tannin structures because the outer layer of bark was not removed. NIOM showed a shift from foliage-like structures (celluloses) to lignin-type structures, indicating an incorporation of woody residues from the decomposing harvest residues. Suberins were also present in the small wood, foliage and bark. The 13C CP NMR spectra of SOM indicated that in areas where windrows were present, SOM did not show compositional changes. However, an increase in SOM quality under the windrows in the second year after their formation as characterised by the alkyl C/O-alkyl C (A/O-A) ratio was mainly due to inputs from the decomposition of the labile, readily available components of the windrowed harvest residues. (C) 2002 Published by Elsevier Science B.V.

How does residue management impact soil organic matter composition and quality under Eucalyptus globulus plantations in southwestern Australia?

This study investigated the influence of harvest residue management practices on soil organic matter (SOM) composition and quality from two second-rotation Eucalyptus globulus plantations in southwestern Australia, using solid-state 13C nuclear magnetic resonance (NMR) spectroscopy with cross-polarisation and magic-angle-spinning (CPMAS). Soil samples (0–5 cm) were collected every 12 months for 5 years from two sites that had contrasting soil types and fertility. Harvest residue management treatments established at both sites were (a) no harvest residues; and (b) double harvest residues. The use of 13C CPMAS and DD NMR spectroscopy enabled the successful non-destructive detection of SOM quality changes in the two E. globulus plantations. Relative intensities of 13C CPMAS NMR spectral regions were similar at both sites, and for both harvest residue treatments, indicating that SOM composition was also similar. Dipolar dephasing (DD) NMR spectra revealed resonances in SOM assigned to lignin and tannin structures, with larger resonances in the carbonyl and alkyl C regions that were indicative of cuticular material, enabling detection of changes in SOM quality. Retention of double harvest residues on the soil surface increased the soil quality compared with removal of all harvest residues at both sites as indicated by the NMR aromaticities, but this was most noticeable at Manjimup, which had greater initial soil fertility.

Nitrogen cycling in degraded Leucaena leucocephala-Brachiaria decumbens pastures on an acid infertile soil in south-east Queensland, Australia

A grazing trial was conducted to quantify N cycling in degraded Leucaena leucocephala (leucaena)-Brachiaria decumbens (signal grass) pastures grown on an acid, infertile, podzolic soil in south-east Queensland. Nitrogen accumulation and cycling in leucaena-signal grass pastures were evaluated for 9 weeks until all of the leucaena on offer (mean 600 kg edible dry matter (EDM)/ha, 28% of total pasture EDM) was consumed. Nitrogen pools in the grass, leucaena, soil, cattle liveweight, faeces and urine were estimated. The podzolic soil (pH 4.8-5.9) was found to be deficient in P, Ca and K. Leucaena leaf tissues contained deficient levels of N, P and Ca. Grass tissues were deficient in N and P. Grazing was found to cycle 65% of N on offer in pasture herbage. However, due to the effect of the plant nutrient imbalances described above, biological N fixation by leucaena contributed only 15 kg/ha N to the pasture system over the 9-month regrowth period, of which 13 kg/ha N was cycled. Cattle retained 1.8 kg/ha N (8% of total N consumed) in body tissue and the remainder was excreted in dung and urine in approximately equal proportions. Mineral soil N concentrations did not change significantly (-3.5 kg/ha N) over the trial period. The ramifications of grazing and fertiliser management strategies, and implications for pasture rundown and sustainability are discussed.

Nitrate retention under sugarcane in wet tropical Queensland deep soil profiles

Nitrate leaching below the crop root-zone in variable charge soils may be adsorbed at anion exchange sites, thereby temporarily reducing the risk of contamination of water bodies. The objectives of this study were (i) to investigate whether nitrate adsorption, accumulation, and retention in the Johnstone River Catchment of Far North Queensland wet tropics is widespread; (ii) to assess the capacity of soil in the Johnstone River Catchment to retain nitrate; and (iii) to deduce the consequences of nitrate adsorption/desorption on contamination of water bodies. Soil cores ranging from 8 to 12.5 m depth were taken from 28 sites across the catchment, representing 9 Ferrosol soil types under sugarcane (Saccharum officinarum-S) cultivation for at least 50 years and from rainforest. The cores were segmented at 0.5-m depth increments and subsamples were analysed for nitrate-N, cation and anion exchange capacities, pH, exchangeable cations (Ca, Mg, K, Na), soil organic C, electrical conductivity, sulfate-S, and chloride. Nitrate-N concentration under sugarcane ranged from 0 to 72.5 mg/kg, compared with 0 to 0.31 mg/kg under rainforest, both Pin Gin soils. The average N load in 1-12 m depth across 19 highly oxidic profiles of the Pin Gin soil series was 1550 kg/ha, compared with 185 kg/ha under 8 non-Pin Gin soils and 11 kg/ha in rainforest on a Pin Gin soil. Most of the nitrate retention was observed at depth of 2-12 m, particularly at 4-10 m, indicating that the accumulation was well below the crop root-zone. The average maximum potential nitrate retention capacity was 10.8 t/ha for the Pin Gin and 4.7 t/ha for the non-Pin Gin soil. Compared with the current N load, the soils still possess a large capacity to adsorb and retain nitrate in profiles. Retention of large quantities of the leached nitrate deep in most of the profiles has reduced the risk of contamination of water bodies. However, computations show that substantial quantities of the nitrate leached below the root-zone were not adsorbed and remain unaccounted for. This unaccounted nitrate might have entered both on- and off-site water bodies and/or have been denitrified.

Effects of soil water availability on water use efficiency of Eucalyptus cloeziana and Eucalyptus argophloia plants

Effects of soil water availability on transpiration efficiency (WUET), instantaneous water use efficiency (WUEi) and carbon isotope composition (delta(13)C) were investigated in 7-month-old plants of humid coastal (Gympie) and dry inland ( Hungry Hills) provenances of Eucalyptus cloeziana F. Muell. and in a dry inland provenance of E. argophloia Blakely (Chinchilla), supplied with 100 (W-100), 70 (W-70) and 50% (W-50) of their water requirements. At W-100, WUET of the three provenances were not significantly different but as available soil moisture decreased, E. argophloia produced greater biomass and demonstrated significantly higher WUET than either E. cloeziana provenance. Midday WUEi was not significantly affected by watering regime within each provenance but was lowest in E. argophloia. A decrease in soil water availability caused a consistent increase in delta(13)C values in all three provenances; however, delta(13)C values of E. argophloia in all three water regimes were significantly lower than those of E. cloeziana provenances, which did not differ significantly from each other. For all three provenances, delta(13)C was not correlated with WUEi but height and root collar diameter were negatively correlated to delta(13)C. There was little evidence of differences in delta(13)C, WUET and WUEi between E. cloeziana provenances but clear differences between E. cloeziana and E. argophloia. The high WUET, low WUEi and low delta(13)C for E. argophloia may have implications in the selection of Eucalyptus provenances for commercial forestry in low-rainfall regions.

A technique to assess small-scale heterogeneity of chemical properties in soil aggregates

A new method is presented which allows the separation of the soil aggregate exterior from the aggregate core. The method employs a combination of aggregate freezing with rapid separation of aggregate exteriors using ultrasonic energy. The factors influencing the thickness of the removed aggregate surface layer include water content of the aggregate prior to freezing, temperature difference between that of the frozen aggregate and that of the liquid it is submerged in during sonification, sonification time and energy, and the type of the immersion liquid. The success of the method and the thickness of the removed aggregate surface were examined using barium ( Ba2+) as a tracer. Barium ( as BaCl2) is rapidly absorbed by soil and is present at only very low levels in natural soils. Surface layers of 0.2 - 0.4 cm thickness were successfully removed from aggregates of 1 - 4 cm diameter. Two examples are given from soils in northern NSW to demonstrate the occurrence of small- scale heterogeneity in soil chemical properties. Compared with the surface fraction, a 4 - 7% higher calcium concentration was found in the core fraction of a clay loam soil ( Dermosol). Conversely, on a cracking clay soil ( Vertosol), atrazine concentration was around 15 times greater in the aggregate surface fractions compared with core fractions. Compared with the traditional estimation of soil chemical properties on homogenised bulk soil samples, it is suggested that separate analysis of aggregate surface and core fractions could provide useful additional information on the relationships between soil properties and environmental responses.