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.

Selective down-regulation of the astrocyte glutamate transporters GLT-1 and GLAST within the medial thalamus in experimental wernicke's encephalopathy

Although earlier studies on thiamine deficiency have reported increases in extracellular glutamate concentration in the thalamus, a vulnerable region of the brain in this disorder, the mechanism by which this occurs has remained unresolved. Treatment with pyrithiamine, a central thiamine antagonist, resulted in a 71 and 55% decrease in protein levels of the astrocyte glutamate transporters GLT-1 and GLAST, respectively, by immunoblotting in the medial thalamus of day 14 symptomatic rats at loss of righting reflexes. These changes occurred prior to the onset of convulsions and pannecrosis. Loss of both GLT-1 and GLAST transporter sites was also confirmed in this region of the thalamus at the symptomatic stage using immunohistochemical methods. In contrast, no change in either transporter protein was detected in the non-vulnerable frontal parietal cortex. These effects are selective; protein levels of the astrocyte GABA transporter GAT-3 were unaffected in the medial thalamus. In addition, astrocyte-specific glial fibrillary acidic protein (GFAP) content was unchanged in this brain region, suggesting that astrocytes are spared in this disorder. Loss of GLT-1 or GLAST protein was not observed on day 12 of treatment, indicating that down-regulation of these transporters occurs within 48 h prior to loss of righting reflexes. Finally, GLT-1 content was positively correlated with levels of the neurofilament protein alpha -internexin, suggesting that early neuronal drop-out may contribute to the down-regulation of this glutamate transporter and subsequent pannecrosis. A selective, focal loss of GLT-1 and GLAST transporter proteins provides a rational explanation for the increase in interstitial glutamate levels, and may play a major role in the selective vulnerability of thalamic structures to thiamine deficiency-induced cell death.

A potential role for the analytical ultracentrifuge in the experimental measurement of protein valence

A method is described whereby sedimentation velocity is combined with equilibrium dialysis to determine the net charge (valence) of a protein by using chromate as an indicator ion for assessing the extent of the Donnan redistribution of small ions. The procedure has been used in experiments on bovine serum albumin under slightly alkaline conditions (pH 8.0, I 0.05) to illustrate its application to a system in which the indicator ion and protein both bear net negative charge and on lysozyme under slightly acidic conditions (pH 5.0, I 0.10) to illustrate the situation where chromate is a counterion. (C) 2001 Elsevier Science.

Experimental infections of pigs with Japanese encephalitis virus and closely related Australian flaviviruses

The flavivirus Japanese encephalitis (JE) virus has recently emerged in the Australasian region. To investigate the involvement of infections with related enzootic flaviviruses, namely Murray Valley encephalitis (MVE) virus and Kunjin (KUN) virus, on immunity of pigs to JE virus and to provide a basis for interpretation of serologic data, experimental infections were conducted with combinations of these viruses. Antibody responses to primary and secondary infections were evaluated using panels of monoclonal antibody-based blocking enzyme-link-ed immuno-sorbent assays and microtiter scrum neutralization tests (mSNTs). Identification of the primary infecting virus was possible only using the mSNTs. Following challenge, unequivocal diagnosis was impossible due to variation in immune responses between animals and broadened and/or anamnestic responses. Viremia for JE virus was readily detected in pigs following primary infection, but was not detected following prior exposure to MVE or KUN viruses. Boosted levels of existing cross-neutralizing antibodies to JE virus suggested a role for this response in suppressing JE viremia.

Experimental susceptibility of some reef fish species to Benedenia lutjani (Monogenea : Capsalidae), a parasite of Lutjanus carponotatus (Pisces : Lutjanidae)

The susceptibility of species of lutjanid, lethrinid and serranid fish to infection by either larval or post-larval (juvenile and adult) specimens of the capsalid monogenean Benedenia lutjani Whittington and Kearn (1993) was examined experimentally. Four species of lutjanids became infected when exposed to larvae of B. lutjani, but three species of lethrinids and four species of serranids were not susceptible to larvae under the same conditions. Variability in the intensity of infection by larvae occurred within and between lutjanid species. Few post-larval specimens of B. lutjani transferred between individuals of the specific host Lutjanus carponotatus (Richardson 1842) in 60-l aquaria and none transferred between specimens of L. carponotatus in a 7,500-l concrete tank. These results indicate that transfer of post-larval B. lutjani between individuals of the specific host is unlikely to occur in the wild. Other lutjanid species did not become infected when exposed to specimens of L. carponotatus infected heavily by post-larval B. lutjani, but two lethrinid species were susceptible to infection under the same conditions. These data indicate that different factors may mediate host-specificity for larval and post-larval B. lutjani.

Irradiation-induced oral candidiasis in an experimental murine model

The aim of this experiment was to establish a mouse model of irradiation-induced oral candidiasis and to explore the cellular populations and mechanisms by which the infection is cleared from the oral mucosa. BALB/c mice received irradiation to the head and neck equivalent to 800 Rad using a Cobalt 60 gamma source. Both irradiated and non-irradiated mice were infected orally with 1 X 10(8) Candida albicans yeasts. Compared with untreated controls, irradiated animals developed a more severe infection of longer duration, with hyphae penetrating the oral mucosa. Monoclonal antibody depletion of CD4(+) but not CD8(+) T cells from the systemic circulation prolonged the infection in irradiated mice, but not in controls. Supernatants of submandibular and superficial cervical lymph node cultures from irradiated animals demonstrated significantly higher titers of interleukin-12, but similar levels of interferon-gamma compared with controls. Screening for cytokine production by an RNase protection assay detected only macrophage migration inhibition factor in irradiated and non-irradiated oral tissues from day 8 onwards. The results of this study demonstrate a requirement for CD4(+) T cells in the recovery from oral candidiasis induced by head and neck irradiation in mice, and are consistent with a role for Th-1-type cytokines in host resistance.

Do generalized visual training programmes for sport really work? An experimental investigation

We assessed the effectiveness of two generalized visual training programmes in enhancing visual and motor performance for racquet sports. Forty young participants were assigned equally to groups undertaking visual training using Revien and Gabor's Sports Vision programme (Group 1), visual training using Revien's Eyerobics (Group 2), a placebo condition involving reading (Group 3) and a control condition involving physical practice only (Group 4). Measures of basic visual function and of sport-specific motor performance were obtained from all participants before and immediately after a 4-week training period. Significant pre- to post-training differences were evident on some of the measures; however, these were not group-dependent. Contrary to the claims made by proponents of generalized visual training, we found no evidence that the visual training programmes led to improvements in either vision or motor performance above and beyond those resulting simply from test familiarity.

Coupled experimental and thermodynamic study of the Zn-Fe-Si-O system

Experimental and thermodynamic modeling studies have been carried out on the Zn-Fe-Si-O system. This research is part of a wider program to characterize zinc/lead industrial slags and sinters in the PbO-ZnO-SiO2-CaO-FeO-Fe2O3 system. Experimental investigations involve high-temperature equilibration and quenching techniques followed by electron probe X-ray microanalysis (EPMA). Liquidus temperatures and solid solubilities of the crystalline phases were measured in the temperature range from 1200 °C to 1450 °C (1473 to 1723 K) in the zinc ferrite, zincite, willemite, and tridymite primary-phase fields in the Zn-Fe-Si-O system in air. These equilibrium data for the Zn-Fe-Si-O system in air, combined with previously reported data for this system, were used to obtain an optimized self-consistent set of parameters of thermodynamic models for all phases.