The effects of information request ambiguity and construct incongruence on query development

This paper examines the effects of information request ambiguity and construct incongruence on end user's ability to develop SQL queries with an interactive relational database query language. In this experiment, ambiguity in information requests adversely affected accuracy and efficiency. Incongruities among the information request, the query syntax, and the data representation adversely affected accuracy, efficiency, and confidence. The results for ambiguity suggest that organizations might elicit better query development if end users were sensitized to the nature of ambiguities that could arise in their business contexts. End users could translate natural language queries into pseudo-SQL that could be examined for precision before the queries were developed. The results for incongruence suggest that better query development might ensue if semantic distances could be reduced by giving users data representations and database views that maximize construct congruence for the kinds of queries in typical domains. (C) 2001 Elsevier Science B.V. All rights reserved.

Matching prescription claims with medication data for nursing home residents: Implications for prescriber feedback, drug utilisation studies and selection of prescription claims database

Medication data retrieved from Australian Repatriation Pharmaceutical Benefits Scheme (RPBS) claims for 44 veterans residing in nursing homes and Pharmaceutical Benefits Scheme (PBS) claims for 898 nursing home residents were compared with medication data from nursing home records to determine the optimal time interval for retrieving claims data and its validity. Optimal matching was achieved using 12 weeks of RPBS claims data, with 60% of medications in the RPBS claims located in nursing home administration records, and 78% of medications administered to nursing home residents identified in RPBS claims. In comparison, 48% of medications administered to nursing home residents could be found in 12 weeks of PBS data, and 56% of medications present in PBS claims could be matched with nursing home administration records. RPBS claims data was superior to PBS, due to the larger number of scheduled items available to veterans and the veteran's file number, which acts as a unique identifier. These findings should be taken into account when using prescription claims data for medication histories, prescriber feedback, drug utilisation, intervention or epidemiological studies. (C) 2001 Elsevier Science Inc. All rights reserved.

Use of the web to provide learning support for a large metabolism and nutrition class

To support student learning in a large Metabolism and Nutrition class, we have introduced a web-based package, using a commercially available program, WebCT. The package was developed at a minimal cost and with limited resources. In addition to downloadable (PDF) versions of lecture Powerpoint presentations, tutorial outlines and a practical class exercise, web-based self-directed learning exercises were included to reinforce and extend lecture material in an active learning environment. The web-site also contained a variety of formative and summative assessment tasks that examined both factual recall and higher order thinking Detailed course information, timetables and a bulletin board were also readily accessible. Student usage of the site was generally high, but varied widely between individual students. Students who achieved a high overall score for the course completed on average three times as many formative assessment items and achieved a higher score for all tests than students who did poorly. Student feedback about the site was very positive with the majority of students reporting that the course material and assessment items that were available were useful to their learning. Administration of the course was also facilitated. (C) 2001 IUBMB. Published by Elsevier Science Ltd. All rights reserved.

Partial automation of database processing of simulation outputs from L-systems models of plant morphogenesis

Models of plant architecture allow us to explore how genotype environment interactions effect the development of plant phenotypes. Such models generate masses of data organised in complex hierarchies. This paper presents a generic system for creating and automatically populating a relational database from data generated by the widely used L-system approach to modelling plant morphogenesis. Techniques from compiler technology are applied to generate attributes (new fields) in the database, to simplify query development for the recursively-structured branching relationship. Use of biological terminology in an interactive query builder contributes towards making the system biologist-friendly. (C) 2002 Elsevier Science Ireland Ltd. All rights reserved.

Prediction of coal ash fusion temperatures with the F*A*C*T thermodynamic computer package

This paper outlines research on the processes taking place within the coal mineral matter at high temperatures and development of the relationship between ash fusion temperatures (AFT) and phase equilibria of the coal ash slags. A new thermodynamic database for the Al-Ca-Fe-O-Si system developed by the author was used in conjunction with the thermodynamic computer package F*A*C*T for these purposes. In addition, high temperature experimental studies were undertaken that involved heat treatment and quenching of the ash cones followed by the analyses using different techniques. The study provided new information on the processes taking place during AFT test and demonstrated the validity of the AFTs predictions with F*A*C*T. Examples of practical applications of the AFT prediction method are given in the paper. The results of this study are important not only for the AFT predictions, but also in general for the application of phase equilibrium science to the characterisation of the coal mineral matter interactions at high temperature. (C) 2002 Elsevier Science Ltd. All rights reserved.

Cross-reactivity of Sydney funnel-web spider antivenom: neutralization of the in vitro toxicity of other Australian funnel-web (Atrax and Hadronyche) spider venoms

Australian funnel-web spiders are recognized as one of the most venomous spiders to humans world-wide. Funnel-web spider antivenom (FWS AV) reverses clinical effects of envenomation from the bite of Atrax robustus and a small number of related Hadronyche species. This study assessed the in vitro efficacy of FWS AV in neutralization of the effects of funnel-web spider venoms, collected from various locations along the eastern seaboard of Australia, in an isolated chick biventer cervicis nerve-muscle preparation. Venoms were separated by SDS-PAGE electrophoresis to compare protein composition and transblotted for Western blotting and incubation with FWS AV. SDS-PAGE of venoms revealed similar low and high molecular weight protein bands. Western blotting with FWS AV showed similar antivenom binding with protein bands in all the venoms tested. Male funnel-web spider venoms (7/7) and female venoms (5110) produced muscle contracture and fasciculation when applied to the nerve-muscle preparation. Venom effects were reversed by subsequent application of FWS AV or prevented by pretreatment of the preparation with antivenom. FWS AV appears to reverse the in vitro toxicity of a number of funnel-web spider venoms from the eastern seaboard of Australia. FWS AV should be effective in the treatment of envenomation from most, if not all, species of Australian funnel-web spiders. (C) 2001 Elsevier Science Ltd. All rights reserved.

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.

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.

Synthesis and characterization of delta-atracotoxin-ar1a, the lethal neurotoxin from venom of the Sydney funnel-web spider (Atrax robustus)

delta-Atracotoxin-Ar1a (delta-ACTX-Ar1a) is the major polypeptide neurotoxin isolated from the venom of the male Sydney funnel-web spider, Atrax robustus. This neurotoxin targets both insect and mammalian voltage-gated sodium channels, where it competes with scorpion alpha-toxins for neurotoxin receptor site-3 to slow sodium-channel inactivation. Progress in characterizing the structure and mechanism of action of this toxin has been hampered by the limited supply of pure toxin from natural sources. In this paper, we describe the first successful chemical synthesis and oxidative refolding of the four-disulfide bond containing delta-ACTX-Ar1a. This synthesis involved solid-phase Boc chemistry using double coupling, followed by oxidative folding of purified peptide using a buffer of 2 M GdnHCl and glutathione/glutathiol in a 1:1 mixture of 2-propanol (pH 8.5). Successful oxidation and refolding was confirmed using both chemical and pharmacological characterization. Ion spray mass spectrometry was employed to confirm the molecular weight. H-1 NMR analysis showed identical chemical shifts for native and synthetic toxins, indicating that the synthetic toxin adopts the native fold. Pharmacological studies employing whole-cell patch clamp recordings from rat dorsal root ganglion neurons confirmed that synthetic delta-ACTX-Ar1a produced a slowing of the sodium current inactivation and hyperpolarizing shifts in the voltage-dependence of activation and inactivation similar to native toxin. Under current clamp conditions, we show for the first time that delta-ACTX-Ar1a produces spontaneous repetitive plateau potentials underlying the clinical symptoms seen during envenomation. This successful oxidative refolding of synthetic delta-ACTX-Ar1a paves the way for future structure-activity studies to determine the toxin pharmacophore.