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.

Introducing ethnomethodological analysis to the field of music education

In recent years qualitative research methods have been adopted within in the field of music education and have received widespread acceptance. However, the theoretical framework provided by ethnomethodology (Garfinkel, 1974, in R. Turner, Ethnomethodology , Penguin, Middlesex, UK) and the tools of conversational analysis (Sacks, 1992, Lectures on Conversation , edited by Gail Jefferson, Blackwell, Oxford, UK) have, to this point, been overlooked by researchers in the field of music education. In this paper I argue that the application of ethnomethodological and conversation analytical approaches in the field of research in music education can provide fresh insights into the work of music teachers and how this work is accomplished in institutional settings. Here I demonstrate how a conversation analytical perspective drawing on an ethnomethodological framework might be used to investigate transcripts of audio-recorded interview talk. This type of analysis can illuminate aspects of members' roles in relation to, and perceptions about music education in school settings that might be overlooked in other types of analysis. A conversation analytical approach to the examination of talk-in-interaction explicates in fine-grained detail how members orient to matters at hand in the context of research settings, as well as revealing features of the cultural world of music teaching. Further application of the approach to research problems in other school settings, I argue, will inform the field of music education in ways yet to be realised.

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.