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.

The structures of Langmuir-Blodgett films of fatty acids and their salts

Recent advances in several experimental techniques have enabled detailed structural information to be obtained for floating (Langmuir) monolayers and Langmuir-Blodgett films. These techniques are described briefly and their application to the study of films of fatty acids and their salts is discussed. Floating monolayers on aqueous subphases have been shown to possess a complex polymorphism with phases whose structures may be compared to those of smectic mesophases. However, only those phases that exist at high surface pressures are normally used in Langmuir-Blodgett (LB) deposition. In single LB monolayers of fatty acids and fatty acid salts the acyl chains are in the all-cans conformation with their long axes normal to the substrate. The in-plane molecular packing is hexagonal with long-range bond orientational order and short-range positional order: known as the hexatic-B structure. This structure is found irrespective of the phase of the parent floating monolayer. The structures of multilayer LB films are similar to the structures of their bulk crystals, consisting of stacked bilayer lamellae. Each lamella is formed from two monolayers of fatty acid molecules or ions arranged head to head and held together by hydrogen bonding between pairs of acids or ionic bonding through the divalent cations. With acids the acyl chains are tilted with respect to the substrate normal and have a monoclinic structure, whereas the salts with divalent cations may have the chains normal to the substrate or tilted. The in-plane structures are usually centred rectangular with the chains in the trans conformation and packed in a herringbone pattern, Multilayer films of the acids show only a single-step order-disorder transition at the malting point, This temperature tends to rise as the number of layers increases. Complex changes occur when multilayer films of the salts are heated. Disorder of the chains begins at low temperatures but the arrangement of the head groups does not alter until the melting temperature is reached, Slow heating to a temperature just below the melting temperature gives, with some salts, a radical change in phase. The lamellar structure disappears and a new phase consisting of cylindrical rods lying parallel to the substrate surface and stacked in a hexagonal pattern is formed, In each rod the cations are aligned along the central axis surrounded by the disordered acyl chains. (C) 2001 Elsevier Science B,V. All rights reserved.

The equilibrium penetration of monolayers. Is equilibrium really established?

In studying the penetration of water-soluble surfactants into water-insoluble monolayers the main theoretical problem is to find a relationship that would enable the amount of surfactant that has entered the monolayer to be calculated from a set of equilibrium surface pressure-area isotherms. Despite many attempts, no current theory gives satisfactory results when applied to experimental data (Langmuir 14 (1998) 2148). One possible reason is that equilibrium had not been established when the surface pressure-area curves were measured. The three experiments reported here suggest that equilibrium is extremely difficult to establish in such systems when the area is low or the surface pressure is high. The essence of these experiments is to try to reach the same final condition by two different routes. In the first route, the one nearly always used in equilibrium penetration measurements, the surfactant is injected under the expanded monolayer, which is then slowly compressed in steps, with time allowed at each step for a steady surface pressure to be attained. In the second procedure, the monolayer is first compressed to a high surface pressure and the surfactant then injected. A stepped expansion isotherm may then be observed. Surface pressure-area per monolayer molecule isotherms, reflection spectra, and slow neutron reflectivity data all show the same pattern: if the surfactant was allowed to penetrate while the monolayer was in an expanded state, it was not completely removed when the monolayer was compressed; but if the monolayer was in a highly compressed state when exposed to the surfactant little penetration took place until the film was expanded. There thus appear to be very large energy barriers to the ejection of surfactant from a compressed monolayer and to the penetration of surfactant into a compressed monolayer. Although these experiments have some limitations, it now seems likely that at least some of the penetration data used in evaluating the various thermodynamic treatments of equilibrium penetration were not equilibrium data. (C) 2001 Elsevier Science B.V. All rights reserved.

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.