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.

The effects of normalisation on the ability of business end-users to detect data anomalies: An experimental evaluation

With the proliferation of relational database programs for PC's and other platforms, many business end-users are creating, maintaining, and querying their own databases. More importantly, business end-users use the output of these queries as the basis for operational, tactical, and strategic decisions. Inaccurate data reduce the expected quality of these decisions. Implementing various input validation controls, including higher levels of normalisation, can reduce the number of data anomalies entering the databases. Even in well-maintained databases, however, data anomalies will still accumulate. To improve the quality of data, databases can be queried periodically to locate and correct anomalies. This paper reports the results of two experiments that investigated the effects of different data structures on business end-users' abilities to detect data anomalies in a relational database. The results demonstrate that both unnormalised and higher levels of normalisation lower the effectiveness and efficiency of queries relative to the first normal form. First normal form databases appear to provide the most effective and efficient data structure for business end-users formulating queries to detect data anomalies.

Tactics at the interface: Australian Aboriginal and Torres Strait Islander health managers

Over the past thirty years in Australia, there has been a recognition of the need for increasing Aboriginal and Torres Strait Islander participation in the management of their health services as part of the strategy to improve the poor health of Australia's indigenous peoples. The proliferation of Aboriginal Community-Controlled Health Services and the vigorous advocacy of groups such as the National Aboriginal Community Controlled Health Organisation have significantly contributed to this recognition. This, combined with additional management opportunities in government service, has drawn attention to difficulties in recruiting and retaining appropriately experienced Aboriginal and Torres Strait Islander managers, particularly in the northern states of Australia. (C) 2001 Elsevier Science Ltd. All rights reserved.

The young women's network: A case study in community development

While young women have been found to be at additional risk for psychological morbidity after a breast cancer diagnosis, their specific needs in relation to support are not well described. A community development approach was utilized to develop the Young Women's Network, a peer support programme for young women who have been diagnosed with breast cancer that addresses their specific psychological and social needs, Central to this approach was the key role of the target group in both the definition of the problem and the generation of the solutions. This article describes the steps involved in developing this programme and guidelines for health professionals and community members who may wish to replicate either the Young Women's Network or this particular approach to programme development. Copyright (C), 2001 John Wiley & Sons, Ltd.

Injury and alcohol: a hospital emergency department study

A pilot survey was undertaken of injury presentations to a public hospital emergency department to determine patterns of alcohol use in this population. Of the 402 injury presentations in the study period, a total of 236 injury cases were interviewed, of whom 45% (n=107) and 29% (n=69) had consumed alcohol 24 and 6 hours prior to injury. Mean age for all injury presentations was 35.1 years, and 32.6 years for alcohol injury cases. For both injury groups, males were significantly younger than females. Recent alcohol ingestion was three times more common among male than female injury presentations, but with females drinking at significantly lower levels. Of males who had consumed alcohol 6 hours prior to injury, nearly 70% were drinking at NHMRC harmful levels and 61% had drunk more than eight standard drinks. Overall, alcohol-involved injury cases commonly occurred among low-income, single males around 30 years of age who were regular heavy drinkers who were drinking heavily in licensed premises prior to their injury, and who sustained injury through intentional harm. In addition, one in five of the alcohol-involved injury cases were aged 15-18 years, i.e. below the legal age of purchase. The high proportion of hazardous and harmful drinkers among those who had consumed alcohol within the last 6 hours, and the injury sample overall, highlights the need for further research to explore the relationship between the occurrence of injury and the drinking patterns and environments associated with injury. Further research is also required to assess the efficacy of early and brief interventions for alcohol and drug use within the emergency ward setting. This information would enable appropriate public health interventions to be initiated.

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.

Mosquito isolates of Ross River virus from Cairns, Queensland, Australia

During 1996-1998 60,619 mosquitoes were collected around Cairns, Australia and processed for Alphavirus isolation. Thirty-three isolates of Ross River (RR) virus were made from 9 species, Aedes imprimens, Aedes kochi, Aedes notoscriptus, Aedes vigilax, Culex annulirostris, Culex gelidus, Mansonia septempunctata, Verrallina (formerly Aedes) carmenti, and Verrallina lineatus. Attempts to isolate RR virus from 121 Aedes aegypti were unsuccessful. Twenty six (79%) of the isolates came from within 1 km of a colony of spectacled flying-foxes, Pteropus conspicillatus. The minimum infection rate for these mosquitoes was 1.0 compared with 0.2 per 1,000 for mosquitoes trapped at all other sites. Ross River virus has not previously been isolated from Ae. imprimens, Cx. gelidus, Ma. septempunctata, Ve. carmenti, or Ve. lineatus. This is also the first isolation of an arbovirus from Cx. gelidus in Australia. In conclusion, the vector status of Ve. carmenti, Ae. aegypti and Mn. septempunctata warrants further study. This study also provides evidence that P. conspicillatus may be a reservoir host.