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.

Research output of Australian general practice: A comparison with medicine, surgery and public health

Objectives: To compare the productivity of Australian general practice in terms of research publications with the productivity of other medical disciplines. Design: A survey of Australian general practice, medicine, surgery and public health publications carried out by manual searching of specific journals and an electronic search of the US National Library of Medicine's PubMed database. Main outcome measures: The number of original research publications by Australian general practitioners, physicians, surgeons and public health physicians during 1999; the relative publication rate of Australian general practice, medicine, surgery and public health over the period 1990-1999. Results: Of original research articles published in 1999, GPs authored 65% (17/26) in Australian Family Physician and 3% (3/90) in the Medical Journal of Australia; physicians published 4% and 37%, respectively. The electronic search identified 54 research articles relating to Australian general practice published in 1999 in 21 different journals, only two of which were primary care journals. Over the period 1990-1999, there was a publication rate of one general practice [discipline] article per 1000 GPs in practice per year. Corresponding rates for medicine, surgery and public health were 105/1000, 61/1000 and 148/1000, respectively. Conclusions: There is considerable disparity between the level of research output of general practice and that of the disciplines of medicine, surgery and public health. If we are to have effective general practice research, we urgently need to develop research skills, a supportive infrastructure and a culture that nurtures research.

On the direct product of two weak uniquely completable partial latin squares

In this note we show by counter-example that the direct product of two weak uniquely completable partial latin squares is not necessarily a uniquely completable partial latin square. This counter-example rejects a conjecture by Gower (see [3]) on the direct product of two uniquely completable partial latin squares.

On the Oberwolfach problem with two similar length cycles

For all in greater than or equal to 3, the Oberwolfach problem is solved for the case where the 2-factors consist of two cycles of lengths in and m + 1, and for the case where the 2-factors consist of two cycles of lengths m and m + 2.

Underuse of beta-blockers following myocardial infarction: a tale of two cities

Aims: To measure factors associated with underuse of beta-blocker therapy after myocardial infarction (MI). Methods: The Newcastle and Perth collaborating centres of the World Health Organization (WHO) MONICA project (to MONItor trends and determinants of Cardiovascular disease) systematically evaluated all patients admitted to hospital in their respective regions with possible MI. A total of 1766 patients in Newcastle and 4503 patients in Perth, discharged from hospital after confirmed MI from 1985 to 1993, were studied, Rates of beta-blocker use before and after hospital discharge were evaluated and correlates of beta-blocker use determined. Results: Beta-blocker use was similar in Newcastle and Perth before MI (21% of patients in each centre). During hospital admission, beta-blocker therapy was initiated nearly twice as frequently in Perth compared with Newcastle (66 vs 36%, respectively) and more patients were discharged from hospital on beta-blockers in Perth (68%) than in Newcastle (45%). The main factors associated with underuse of beta-blockers in multivariate analysis were geographical centre (odds ratio (OR) for Newcastle compared with Perth 0.3 95% confidence interval (CI) 0.3-0.3), a history of previous MI (OR 0.6, 95% CI 0.5-0.7), admission to hospital in earlier years (OR 0.4, 95% CI 0.3-0.4 for years 1985-87 compared with years 1991-93), diabetes (OR 0.6, 95% CI 0.5-0.8) and the concomitant use of diuretics (OR 0.5, 95% CI 0.4-0.6) and calcium antagonists (OR 0.6, 95% CI 0.5-0.8). Conclusions: Underuse of beta-blockers after MI was strongly related to hospital prescribing patterns and not to community use of beta-blockers. Underuse occurred in patients with diabetes and in patients with left ventricular dysfunction, patients who stand to benefit most from beta-blocker use following MI.

An architectonic comparison of the ventrobasal complex of two Megachiropteran and one Microchiropteran bat: implications for the evolution of Chiroptera

The architectonic features of the thalamic ventrobasal complex (Vb) of two species of Megachiropteran (Grey-headed flying fox, Pteropus poliocephalus, and the Eastern tube-nosed bat, Nyctimene robinsoni) are compared with those of a Microchiropteran (Australian ghost bat, Macroderma gigas). The somatosensory system was chosen for comparison as it represents a sensory system that has undergone analogous modifications in both Chiropteran lineages (the evolution of the wing). The components of Vb were examined as there are taxon-specific features in this region of the brain. Within the Megachiropteran Vb, four subnuclei were recognized: the ventral posterior medial (VPM), the ventral posterior lateral (VPL), the ventral posterior inferior (VPI), and the basal ventral medial (VMb). In the ghost bat only VPM and VPL were identified with certainty. No VPI was evident in the ghost bat, however a putative VMb was observed. Vb of the ghost bat also lacked the arcuate lamina, which distinguishes VPM from VPL in the Megachiropterans and many other mammals. These taxon-specific differences lend support to the proposal that the order Chiroptera has a diphyletic origin.

A description of Lecithocladium invasor n.sp (Digenea : Hemiuridae) and the pathology associated with two species of Hemiuridae in acanthurid fish

Lecithocladium invasor n.sp. is described from the oesophagus of Naso annulatus, N. tuberosus and N. vlamingii on the Great Barrier Reef, Australia. The worms penetrate the oesophageal mucosa and induce chronic transmural nodular granulomas, which expand the full thickness of the oesophageal wall and protrude both into the oesophageal lumen and from the serosal surface. We observed two major types of lesions: large ulcerated, active granulomas, consisting of a central cavity containing a single or multiple live worms; and many smaller chronic fibrous submucosal nodules. Small, identifiable but attenuated, worms and degenerate worm fragments were identified within some chronic nodules. Co-infection of the posterior oesophagus of the same Naso species with Lecithocladium chingi was common. L. chingi is redescribed from N. annulatus, N. brevirostris, N. tuberosus and A vlamingii. Unlike L. invasor n.sp., L. chingi was not associated with significant lesions. The different pathenogenicity of the two species in acanthurid fish is discussed.

Models involving two inverse Weibull distributions

In this paper, we look at three models (mixture, competing risk and multiplicative) involving two inverse Weibull distributions. We study the shapes of the density and failure-rate functions and discuss graphical methods to determine if a given data set can be modelled by one of these models. (C) 2001 Elsevier Science Ltd. All rights reserved.

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.

A study of the vacuum gamma-radiolysis of two aromatic polyimide fluoropolymers containing phenylphosphine oxide

The vacuum gamma -radiolysis of two fluorinated polyimides containing phenylphosphine oxide units, TOR-RC and TOR-RC ODPA, have been studied at 77 K and 300 K. The phenyl phosphine oxide units provide protection of the polymers towards oxidation by oxygen atoms and the bulky fluoromethyl groups reduce the colouration of the polymers by limiting donor-acceptor complex formation through the aromatic units. At 77 K the radicals formed were identified to be a mixture of neutral radicals (60%) and anion radicals. At 300 K only neutral radicals were found. The G-values for radical formation were found to be 0.50 and 0.42 at 77 K and 0.051 and 0.052 at 300 K for TOR-RC and TOR-RC ODPA, respectively. Little change was observed in the visible spectra of the polyimides following vacuum radiolysis at 300 K up to a dose of 3.3 MGy, and the polymers were shown to undergo net cross linking with a gel dose of 0.45 MGy.