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.

Metastatic lesions in the joint associated with acute inflammatory arthritis after dendritic cell immunotherapy for metastatic melanoma

A 47 year old man undergoing immunotherapy for metastatic melanoma with autologous dendritic cells pulsed with autologous tumour peptide and hepatitis a surface antigen developed acute left ankle arthritis. Gout and acute infection were excluded, and an autoimmune aetiology or occult metastasis were considered. The arthritis initially subsided with indomethacin, but the symptoms recurred 2 months later, and magnetic resonance imaging demonstrated metastatic melanoma of the left talus. Immunohistochemical staining of a cerebral metastatic deposit biopsied 1 week after the onset of arthritis demonstrated T-cell and macrophage infiltration of the tumour. In addition, the patient developed melanoma-specific delayed type hypersensitivity and cytotoxic T-cell responses after vaccination. Thus, the monoarthritis represented an 'appropriate' inflammatory response directed against metastatic melanoma. (C) 2001 Lippincott Williams & Wilkins.

Comparison of differentiated dendritic cell infiltration of autoimmune and osteoarthritis synovial tissue

Objective. Infiltration of rheumatoid arthritis (RA) synovial tissue (ST) by differentiated dendritic cells (DC) is a consistent feature in patients with active disease. However, mononuclear cells (MNC), including DC, may be nonspecifically chemoattracted to inflammatory sites regardless of etiology, Therefore, to evaluate the specificity of ST infiltration by differentiated DC, synovial biopsies from patients with RA, spondylarthropathy (SpA), osteoarthritis (OA), and gout were examined. Methods. Formalin-fixed ST sections were analyzed by double immunohistochemical staining for vascularity and infiltration by differentiated DC, lymphocytes, and macrophages. Results, DC containing nuclear RelB were found in perivascular MNC aggregates from patients with all arthritides studied. Infiltration by differentiated DC was similar in RA and SpA ST, but reduced in OA ST. Differentiated DC were always observed in close association with lymphocytes, and the correlation between these variables suggested that the infiltration of inflammatory sites by DC and lymphocytes was associated. Conclusion, Perivascular infiltration by DC, lymphocytes, and macrophages is nonspecifically related to inflammation, but signals present in RA and SpA ST lead to more intense cellular infiltration and accumulation.

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.