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.

Determinants of hepato- and spleno-megaly in Hunan, China: cross-sectional survey data from areas endemic for schistosomiasis

In order to understand the determinants of schistosome-related hepato- and spleno-megaly better, 14 002 subjects aged 3-60 years (59% male; mean age =32 years) were randomly selected from 43 villages, all in Hunan province, China, where schistosomiasis caused by Schistosoma japonicum is endemic. The abdomen of each subject was examined along the mid-sternal (MSL) and mid-clavicular lines, for evidence of current hepato- and/or spleno-megaly, and a questionnaire was used to collect information on the medical history of each individual. Current infections with S. japonicum were detected by stool examination. Almost all (99.8%) of the subjects were ethnically Han by descent and most (77%) were engaged in farming. Although schistosomiasis appeared common (42% of the subjects claiming to have had the disease), only 45% of the subjects said they had received anti-schistosomiasis drugs. Overall, 1982 (14%) of the subjects had S. japonicum infections (as revealed by miracidium-hatching tests and/or Katon Katz smears) when examined and 22% had palpable hepatomegaly (i.e. enlargement of at least 3 cm along the MSL), although only 2.5% had any form of detectable splenomegaly (i.e. a Hackett's grade of at least 1). Multiple logistic regression revealed that male subjects, fishermen, farmers, subjects aged greater than or equal to 25 years, subjects with a history of schistosomiasis, and subjects who had had bloody stools in the previous 2 weeks were all at relatively high risk of hepato- and/or spleno-megaly. In areas moderately endemic for Schistosoma japonicum, occupational exposure and disease history appear to be good predictors of current disease status among older residents. These results reconfirm those reported earlier in the same region.

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.

Geographic variation of notified Ross River virus infections in Queensland, Australia, 1985-1996

The spatial and temporal variations of Ross River virus infections reported in Queensland, Australia, between 1985 and 1996 were studied by using the Geographic Information System. The notified cases of Ross River virus infection came from 489 localities between 1985 and 1988, 805 between 1989 and 1992, and 1,157 between 1993 and 1996 (X (2)((df = 2)) = 680.9; P < 0.001). There was a marked increase in the number of localities where the cases were reported by 65 percent for the period of 1989-1992 and 137 percent for 1993-1996, compared with that for 1985-1988. The geographic distribution of the notified Ross River virus cases has expanded in Queensland over recent years. As Ross River virus disease has impacted considerably on tourism and industry, as well as on residents of affected areas, more research is required to explore the causes of the geographic expansion of the notified Ross River virus infections.

Being breastfed in infancy and breast cancer incidence in adult life: Results from the two Nurses' Health studies

Events during perinatal and early life may influence the incidence of breast cancer in adult life, and some case-control studies suggest that having been breastfed may reduce breast cancer risk. The authors studied this association among premenopausal and postmenopausal women by using data from the two Nurses' Health Studies, the Nurses' Health Study (using data from 1992 to 1996) and the Nurses' Health Study II (using data from 1991 to 1997). A history of being breastfed was self-reported by the study participants. During a total of 695,655 person-years, 1,073 cases of invasive breast cancer were diagnosed. The authors did not observe any important overall association between having been breastfed and the development of breast cancer later in life among premenopausal women (covariate-adjusted relative risk = 0.97, 95% confidence interval (CI): 0.78, 1.20) or postmenopausal women (covariate-adjusted relative risk = 1.12, 95% CI: 0.92, 1.37). No significant trend was observed with increasing duration of breastfeeding. The authors also used data on breastfeeding retrospectively collected from 2,103 mothers of participants of the two Nurses' Health Studies. With the mothers' reports, the covariate-adjusted odds ratio of breast cancer was 1.11 (95% CI: 0.88, 1.39) for women who were breastfed compared with those who were not. Data from these two large cohorts do not support the hypothesis that being breastfed confers protection against subsequent breast cancer.

Neurology of ciguatera

Ciguatera is a widespread ichthyosarcotoxaemia with dramatic and clinically important neurological features. This severe form of fish poisoning may present with either acute or chronic intoxication syndromes and constitutes a global health problem. Ciguatera poisoning is little known in temperate countries as a potentially global problem associated with human ingestion of large carnivorous fish that harbour the bioaccumulated ciguatoxins of the photosynthetic dinoflagellate Gambierdiscus toxicus. This neurotoxin is stored in the viscera of fish that have eaten the dinoflagellate and concentrated it upwards throughout the food chain towards progressively larger species, including humans. Ciguatoxin accumulates in all fish tissues, especially the liver and viscera, of at risk species. Both Pacific (P-CTX-1) and Caribbean (C-CTX-1) ciguatoxins are heat stable polyether toxins and pose a health risk at concentrations above 0.1 ppb. The presenting signs of ciguatera are primarily neurotoxic in more than 80% of cases. Such include the pathognomonic features of postingestion paraesthesiae, dysaesthesiae, and heightened nociperception. Other sensory abnormalities include the subjective features of metallic taste, pruritis, arthralgia, myalgia, and dental pain. Cerebellar dysfunction, sometimes diphasic, and weakness due to both neuropathy and polymyositis may be encountered. Autonomic dysfunction leads to hypotension, bradycardia, and hypersalivation in severe cases. Ciguatoxins are potent, lipophilic sodium channel activator toxins which bind to the voltage sensitive (site 5) sodium channel on the cell membranes of all excitable tissues. Treatment depends on early diagnosis and the early administration of intravenous mannitol. The early identification of the neurological features in sentinel patients has the potential to reduce the number of secondary cases in cluster outbreaks.

Forced emigration, favourable outcomes

The discipline of public health and preventive medicine in Australia and New Zealand had its genesis in the advocacy of 18th and 19th century military pioneers. Military (Royal Navy and British Army) surgeons were posted to Australia as part of their non-discretionary duty. Civilian doctors emigrated variously for adventure, escapism and gold fever. One group, a particularly influential group disproportionate to their numbers, came in one sense as forced emigrants because of chronic respiratory disease in general, and tuberculosis in particular. Tuberculosis was an occupational hazard of 19th century medical and surgical practice throughout western Europe. This paper analyses six examples of such emigration which had, perhaps unforeseen at the time, significant results in the advancement of public health. Such emigration was in one sense voluntary, but in another was forced upon the victims in their quest for personal survival. In Australia, such medical individuals became leading advocates and successful catalysts for change in such diverse fields as social welfare, public health, the preventive aspects of medical practice, child health, nutrition and medical education. A number of such public health pioneers today have no physical memorials; but their influence is to be seen in the ethos of medical practice in Australia and New Zealand today. Their memory is further perpetuated in the names of Australian native wildflowers and trees that symbolise not only a healthy environment but the longterm investment, accrued with interest, of the institution of public health measures for which their advocacy achieved much success.

Step size control for efficient discrete element simulation

The step size determines the accuracy of a discrete element simulation. The position and velocity updating calculation uses a pre-calculated table and hence the control of step size can not use the integration formulas for step size control. A step size control scheme for use with the table driven velocity and position calculation uses the difference between the calculation result from one big step and that from two small steps. This variable time step size method chooses the suitable time step size for each particle at each step automatically according to the conditions. Simulation using fixed time step method is compared with that of using variable time step method. The difference in computation time for the same accuracy using a variable step size (compared to the fixed step) depends on the particular problem. For a simple test case the times are roughly similar. However, the variable step size gives the required accuracy on the first run. A fixed step size may require several runs to check the simulation accuracy or a conservative step size that results in longer run times. (C) 2001 Elsevier Science Ltd. All rights reserved.

An evaluation of a suburban railway pedestrian crossing safety programme

This study evaluated a programme of educational and environmental (access prevention) interventions designed to reduce the incidence of illegal and unsafe crossing of the rail corridor at a suburban station in Auckland, New Zealand. Immediately after the programme of interventions, the proportion of those crossing the rail corridor by walking across the tracks directly rather than using the nearby overbridge had decreased substantially. Three months later, the decrease was even greater. However, the educational and environmental interventions were introduced simultaneously so that the effects of each could not be separated, nor could other unmeasured factors be ruled out. Anonymous surveys administered immediately before and 3 months after the interventions indicated that while awareness of the illegality of walking across the tracks had increased slightly, perception of risk had not changed. This suggests that the educational interventions may have had less effect than the access prevention measures. (C) 2001 Elsevier Science Ltd. All rights reserved.

Extraction and purification of the zwitterions cylindrospermopsin and deoxycylindrospermopsin from Cylindrospermopsis raciborskii

The hepatotoxin cylindrospermopsin (CYN) has been isolated from the cyanobacterium Cylindrospermopsis raciborskii (C. raci.). Efforts to study this toxin have been hampered by the time-consuming requirement to extract it from cultures of the organism. It is usually extracted from lyophilized cells collected from a laboratory culture. Our preliminary work suggested far more of the toxin is available in solution in the culture media than in the cells collected. We have therefore investigated the use of commercially available solid phase extraction sorbents to extract CYN from culture media in which C. raci. has been grown. A range of reverse phase and ion-exchange sorbents were tested across a range of pHs for their ability to retain CYN without success. Subsequently, graphitized carbon cartridges were found to retain CYN strongly. Elution with 5% formic acid in methanol allowed the CYN to be regained for final purification by HPLC. Deoxy-CYN, an analog of CYN can also be extracted using this procedure. (C) 2001 John Wiley & Sons, Inc.