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.

On the direct product of two weak uniquely completable partial latin squares

In this note we show by counter-example that the direct product of two weak uniquely completable partial latin squares is not necessarily a uniquely completable partial latin square. This counter-example rejects a conjecture by Gower (see [3]) on the direct product of two uniquely completable partial latin squares.

On the intersection problem for 1-factorizations and near 1-factorizations of K-v

The number of 1-factors (near 1-factors) that mu 1-factorizations (near 1-factorizations) of the complete graph K-v, v even (v odd), can have in common, is studied. The problem is completely settled for mu = 2 and mu = 3.

On the Oberwolfach problem with two similar length cycles

For all in greater than or equal to 3, the Oberwolfach problem is solved for the case where the 2-factors consist of two cycles of lengths in and m + 1, and for the case where the 2-factors consist of two cycles of lengths m and m + 2.

Effects of short- and long-term exposure to c-AMP and c-GMP on the noradrenaline transporter

The effects of short- and long-term exposure of cells to elevated cyclic adenosine monophosphate (c-AMP), using dibutyryl-c-AMP, 8-bromo-c-AMP, cholera toxin or forskolin, or cyclic guanosine monophosphate (c-GMP), using dibutyryl-c-GMP or 8-bromo-c-GMP, on the activity and expression of the noradrenaline transporter (NAT) were examined. Short- or long-term c-GMP elevation had no effects on H-3-noradrenaline uptake by rat PC12 phaeochromocytoma cells or human SK-N-SH-SY5Y neuroblastoma cells. Short-term c-AMP elevation (for 17 min experiment duration) caused a decrease in H-3-noradrenaline uptake by PC12 cells, but had no effects on SK-N-SH-SY5Y cells or COS-7 cells transfected with human or rat NAT cDNA. c-AMP did not affect H-3-nisoxetine binding to PC12 cells. Long-term (24 h) exposure to elevated c-AMP levels caused a decrease in H-3-noradrenaline uptake and NAT mRNA in PC12 cells, but had no effects on SK-N-SH-SY5Y cells and caused a small increase in H-3-noradrenaline uptake in COS-7 cells heterologously expressing rat or human NAT. Hence, c-AMP, but not c-GMP, causes a cell type-dependent reduction in NAT activity after short-term exposure and a reduction in NAT expression after long-term exposure. (C) 2001 Elsevier Science Ltd. All rights reserved.

Increasing the response rate to a mailed questionnaire by including more stamps on the return envelope: A cotwin control study

Twins taking part in two unrelated studies were sent a questionnaire together with a self-addressed envelope that either carried one or multiple (up to 5) stamps to the same value. The unprompted proportion of questionnaires returned (before commencement of telephone reminder calls) was increased from 62% to 71% in one study, and from 43% to 52% in the other study (test for common odds ratio in studies, p = 0.04).

New perspectives on the role of aldosterone excess in cardiovascular disease

1. Evidence from recent experimental and clinical studies suggests that excessive circulating levels of aldosterone can bring about adverse cardiovascular sequelae independent of the effects on blood pressure. Examples of these sequelae are the development of myocardial and vascular fibrosis in uninephrectomized, salt-loaded rats infused with mineralocorticoids and, in humans, an association of aldosterone with left ventricular hypertrophy, impaired diastolic and systolic function, salt and water retention causing aggravation of congestion in patients with established congestive cardiac failure (CCF), reduced vascular compliance and an increased risk of arrhythmias (resulting from intracardiac fibrosis, hypokalaemia, hypomagnesaemia, reduced baroreceptor sensitivity and potentiation of catecholamine effects). 2. These sequelae of aldosterone excess may contribute to the pathogenesis and worsen the prognosis of CCF and hypertension. 3. The heart and blood vessels may be capable of extra-adrenal aldosterone biosynthesis, raising the possibility that aldosterone may have paracrine or autocrine (and not just endocrine) effects on cardiovascular tissues. 4. The high prevalence of CCF, which is associated with secondary aldosteronism, and primary aldosteronism (PAL; recently recognized to be a much more common cause of hypertension than was previously thought) argue for an important role for aldosterone excess as a cause of cardiovascular injury. 5. The recognition of non-blood pressure-dependent adverse sequelae of aldosterone excess raises the question as to whether normotensive individuals with PAL, who have been detected as a result of genetic or biochemical screening among families with inherited forms of PAL, are at excess risk of cardiovascular events. 6. Provided that patients are carefully investigated in order to permit the appropriate selection of specific surgical (laparoscopic adrenalectomy for PAL that lateralizes on adrenal venous sampling) or medical (treatment with aldosterone antagonist medications) management and safety considerations for the use of aldosterone antagonists are kept in mind, the appreciation of a widening role for aldosterone in cardiovascular disease should provide a substantially better outlook for many patients with CCF and hypertension.

Tormopsolus attenuatus n. sp (Digenea : Acanthocolpidae) from Seriola hippos (Perciformes : Carangidae), Western Australia, with some observations on the relationships in the genus

A new acanthocolpid, Tormopsolus attenuatus n. sp., is described from the carangid Seriola hippos from waters off the coast of SW Australia. A cladistic analysis of the genus using 31 morphological and metrical characters indicates that the closest species is T. asiatica Parukhin, 1976 status amend. (previously T. orientalis asiatica). T. attenuatus differs from T. asiatica in its smaller overall dimensions, more attenuated outline, relatively shorter post-testicular region, vitelline interruption at the level of the ovary, papillae on the oral sucker and, possibly, much longer genital atrium. Other similar species, T. orientalis Yamaguti, 1934 and T. medius Reimer, 1983, differ in having interruptions of the vitelline fields at the level of both testes and at the level of the ovary.

Ultracentrifugal studies of the effect of molecular crowding by trimethylamine N-oxide on the self-association of muscle glycogen phosphorylase b

The suitability of sedimentation equilibrium for characterizing the self-association of muscle glycogen phosphorylase b has been reappraised. Whereas sedimentation equilibrium distributions for phosphorylase b in 40 mM Hepes buffer (pH 6.8) supplemented with 1 mM AMP signify a lack of chemical equilibrium attainment, those in buffer supplemented additionally with potassium sulfate conform with the requirements of a dimerizing system in chemical as we:ll as sedimentation equilibrium. Because the rate of attainment of chemical equilibrium under the former conditions is sufficiently slow to allow resolution of the dimeric and tetrameric enzyme species by sedimentation velocity, this procedure has been used to examine the effects of thermodynamic nonideality arising from molecular crowding try trimethylamine N-oxide on the self-association behaviour of phosphorylase b. In those terms the marginally enhanced extent of phosphorylase b self-association observed in the presence of high concentrations of the cosolute is taken to imply that the effects of thermodynamic nonideality on the dimer-tetramer equilibrium are being countered by those displacing the T reversible arrow R isomerization equilibrium for dimer towards the smaller, nonassociating T state. Because the R state is the enzymically active form, an inhibitory effect is the predicted consequence of molecular crowding by high concentrations of unrelated solutes. Thermodynamic nonideality thus provides an alternative explanation for the inhibitory effects of high concentrations of glycerol, sucrose and ethylene glycol on phosphorylase b activity, phenomena that have been attributed to extremely weak interaction of these cryoprotectants with the T state of the enzyme.

On the relation between the conditional moment closure and unsteady flamelets

We consider the relation between the conditional moment closure (CMC) and the unsteady flamelet model (FM). The CMC equations were originally constructed as global equations, while FM was derived asymptotically for a thin reaction zone. The recent tendency is to use FM-type equations as global equations. We investigate the possible consequences and suggest a new version of FM: coordinate-invariant FM (CIFM). Unlike FM, CIFM complies with conditional properties of the exact transport equations which are used effectively in CMC. We analyse the assumptions needed to obtain another global version of FM: representative interactive flamelets (RIF), from original FM and demonstrate that, in homogeneous turbulence, one of these assumptions is equivalent to the main CMC hypothesis.