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.

Back, chest and abdominal pain: How good are spinal signs at identifying musculoskeletal causes of back, chest or abdominal pain?

Background: Spinal signs found in association with atypical chest and abdominal pain may suggest the pain is referred from the thoracic spine. However, the prevalence of such signs in these conditions has rarely been compared with that in those without pain. In this study, the prevalence of spinal signs and dysfunction in patients with back, chest and abdominal pain is compared with that in pain free controls. The aim of the study is to determine the significance of spinal findings in patients with such pain. Methods: A general practitioner blinded to the patients' histories performed a cervical and thoracic spinal examination on general practice patients with back, chest and/or abdominal pain and on controls without pain. Thoracic intervertebral dysfunction was diagnosed on the basis of movement and palpation findings. Results: Seventy three study patients plus 24 controls, were examined. For cervical spinal signs, pain in the back, chest and/or abdomen was associated with pain with active movements and overpressure at end range and with loss of movement range. For thoracic spinal signs, this association held for pain with active movements and overpressure, but not with loss of movement range. The prevalence of thoracic intervertebral dysfunction was 25.0% in controls, 65.5% with chest/abdominal pain, 72.0% with back pain and 79.0% with back pain with chest/abdominal pain. This prevalence was higher with chest pain than with abdominal pain. Conclusions: The results show an association, but not a causal link between thoracic intervertebral dysfunction and atypical chest/abdominal pain. A spinal examination should be performed routinely assessing these conditions. The minimum examination for the detection of intervertebral dysfunction is testing for pain with spinal movements and palpation for tenderness. The interpretation of positive signs requires knowledge of their prevalence in pain free controls and in patients with visceral disease

Unprecedented oxidation of a biologically active aroylhydrazone chelator catalysed by iron(III): serendipitous identification of diacylhydrazine ligands with high iron chelation efficacy

Ligands of the 2-pyridylcarbaldehyde isonicotinoylhydrazone class show high iron (Fe) sequestering efficacy and have potential as agents for the treatment of Fe overload disease. We have investigated the mechanisms responsible for their high activity. X-ray crystallography studies show that the tridentate chelate 2-pyridylcarbaldehyde isonicotinoylhydrazone undergoes an unexpected oxidation to isonicotinoyl(picolinoyl)hydrazine when complexed with Fe-III. In contrast, in the absence of Fel the parent hydrazone is not oxidized in aerobic aqueous solution. To examine whether the diacylhydrazine could be responsible for the biological effects of 2-pyridylcarbaldehyde isonicotinoylhydrazone, their Fe chelation efficacy was compared. In contrast to its parent hydrazone, the diacylhydrazine showed little Fe chelation activity. Potentiometric titrations suggested that this might be because the diacylhydrazine was charged at physiological pH, hindering its access across membranes to intracellular Fe pools. In contrast, the Fe complex of this diacylhydrazine was charge neutral, which may allow facile movement through membranes. These data allow a model of Fe chelation for this compound to be proposed: the parent aroylhydrazone diffuses through cell membranes to bind Fe and is subsequently oxidized to the diacylhydrazine complex which then diffuses from the cell. Other diacylhydrazine analogues that were charge neutral at physiological pH demonstrated high Fe chelation efficacy. Thus, for this class of ligands, the charge of the chelator appears to be an important factor for determining their ability to access intracellular Fe. The results of this study are significant for understanding the biological activity of 2-pyridylcarbaldehyde isonicotinoylhydrazone and for the design of novel diacylhydrazine chelators for clinical use.

Valproic acid has temporal variability in urinary clearance of metabolites

The reasons for the intra- and interindividual variability in the clearance of valproic acid (VPA) have not been completely characterized. The aim of this study was to examine day-night changes in the clearance of 3-oxo-valproate (3-oxo-VPA), 4-hydroxy-valproate (4-OH-VPA), and valproic acid glucuronides under steady state. Six diurnally active healthy male volunteers ingested 200 mg sodium valproate 12 hourly, at 0800 and 2000, for 28 days. On the last study day, two sequential 12-h urine samples were collected commencing at 2000 the evening before. Plasma samples were obtained at the end of each collection. Following alkaline hydrolysis, urine was analyzed for concentrations of VPA, 3-oxo-VPA, and 4-OH-VPA. A separate aliquot was assayed for creatinine (CR). The plasma concentrations of VPA, 3-oxo-VPA, 2-en-VPA, and CR were determined. The analysis of VPA and its metabolites was performed by CC-MS. There was an increase in plasma 3-oxo-VPA concentration at 0800, sampling as compared to 2000 sampling (p < .05). The urinary excretion of 3-oxo-VPA and VPA glucuronides were decreased between 2000 and 0800, compared to between 0800, and 2000, by 30% and 50% respectively (p < .05). These results indicate a nocturnal decrease in renal clearance of 3-oxo-VPA rather than a decrease in the beta -oxidation of VPA at night. These differences were not explained by differences between the sampling periods in CR excretion. These results indicate the importance of collecting samples of 24-h duration when studying metabolic profiles of VPA.

Perceived constraints and social support for active leisure among mothers with young children

Evidence suggests that women who are mothers of young children have lower levels of physical activity than women of similar age who do not have children (Brown, Lee, Mishra, & Bauman, 2000). The purposes of this study were to explore the factors that constrain mothers of young children from being more physically active, and the relationship between physical activity and levels of social support available to the women. The empirical basis for this examination was provided through a study of activity levels and barriers to physical activity experienced by a sample of 543 mothers of young children from differing socioeconomic backgrounds. The data indicate that: (a) more than two-thirds of the mothers were inadequately active in their leisure time for health benefit; (b) while the vast majority of mothers expressed a desire to be more active, they were inhibited in their ability to act out their leisure preferences by a combination of structural (e.g., lack of time, money, energy) and ideological influences (e.g., sense of commitment to others); (c) access to social support (from partners, family, and friends) was seen to place some women in a better position than others to negotiate constraints that inhibit leisure participation; and (d) within groups of varying socioeconomic status (SES) there was wide variation in the amount of time spent each week in active leisure.

Solution structures by H-1 NMR of the novel cyclic trypsin inhibitor SFTI-1 from sunflower seeds and an acyclic permutant

SFTI-1 is a recently discovered cyclic peptide trypsin inhibitor from sunflower seeds comprising 14 amino acid residues. It is the most potent known Bowman-Birk inhibitor and the only naturally occurring cyclic one. The solution structure of SFTI-1 has been determined by H-1-NMR spectroscopy and compared with a synthetic acyclic permutant. The solution structures of both are remarkably similar. The lowest energy structures from each family of 20 structures of cyclic and acyclic SFTI-1 have an rmsd over the backbone and heavy atoms of 0.29 Angstrom and 0.66 Angstrom, respectively. The structures consist of two short antiparallel beta -strands joined by an extended loop containing the active site at one end. Cyclic SFTI-1 also has a hairpin turn completing the cycle. Both molecules contain particularly stable arrangements of cross-linking hydrogen bonds between the beta -strands and a single disulfide bridge, making them rigid and well defined in solution. These stable arrangements allow both the cyclic and acyclic variants of SFTI-1 to inhibit trypsin with very high potencies (0.5 nM and 12.1 nM, respectively). The cyclic nature of SFTI-1 appears to have evolved to provide higher trypsin inhibition as well as higher stability. The solution structures are similar to the crystal structure of the cyclic inhibitor in complex with trypsin. The lack of a major conformational change upon binding suggests that the structure of SFTI-1 is rigid and already pre-organized for maximal binding due to minimization of entropic losses compared to a more flexible ligand. These properties make SFTI-1 an ideal platform for the design of small peptidic pharmaceuticals or pesticides. (C) 2001 Academic Press.