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.

Cigarette smoking and risk of epithelial ovarian cancer (Australia)

Objectives: We studied the association between cigarette smoking and ovarian cancer in a population-based case-control study. Methods: A total of 794 women with histologically confirmed epithelial ovarian cancer who were aged 18-79 years and resident in one of three Australian states were interviewed, together with 855 controls aged 18-79 years selected at random from the electoral roll from the same states. Information was obtained about cigarette smoking and other factors including age, parity, oral contraceptive use, and reproductive factors. We estimated the relative risk of ovarian cancer associated with cigarette smoking, accounting for histologic type, using multivariable logistic regression to adjust for confounding factors. Results: Women who had ever smoked cigarettes were more likely to develop ovarian cancer than women who had never smoked (adjusted odds ratio (OR) = 1.5; 95% confidence interval (CI) = 1.2-1.9). Risk was greater for ovarian cancers of borderline malignancy (OR = 2.4; 95% CI = 1.4-4.1) than for invasive tumors (OR = 1.7; 95% CI = 1.2-2.4) and the histologic subtype most strongly associated overall was the mucinous subtype among both current smokers (OR = 3.2; 95% CI = 1.8-5.7) and past smokers (OR = 2.3; 95% CI = 1.3-3.9). Conclusions: These data extend recent findings and suggest that cigarette smoking is a risk factor for ovarian cancer, especially mucinous and borderline mucinous types. From a public health viewpoint, this is one of the few reports of a potentially avoidable risk factor for ovarian cancer.

Genetic covariance among measures of information processing speed, working memory, and IQ

The genetic relationship between lower (information processing speed), intermediate (working memory), and higher levels (complex cognitive processes as indexed by IQ) of mental ability was studied in a classical twin design comprising 166 monozygotic and 190 dizygotic twin pairs. Processing speed was measured by a choice reaction time (RT) task (2-, 4-, and 8-choice), working memory by a visual-spatial delayed response task, and IQ by the Multidimensional Aptitude Battery. Multivariate analysis, adjusted for test-retest reliability, showed the presence of a genetic factor influencing all variables and a genetic factor influencing 4- and 8-choice RTs, working memory, and IQ. There were also genetic factors specific to 8-choice RT, working memory, and IQ. The results confirmed a strong relationship between choice RT and IQ (phenotypic correlations: -0.31 to -0.53 in females, -0.32 to -0.56 in males; genotypic correlations: -0.45 to -0.70) and a weaker but significant association between working memory and IQ (phenotypic: 0.26 in females, 0.13 in males; genotypic: 0.34). A significant part of the genetic variance (43%) in IQ was not related to either choice RT or delayed response performance, and may represent higher order cognitive processes.

Category-theoretic fibration as an abstraction mechanism in information systems

This paper examines the problem of establishing a formal relationship of abstraction and refinement between abstract enterprise models and the concrete information systems which implement them. It introduces and justifies a number of reasonableness requirements, which turn out to justify the use of category theoretic concepts, particularly fibrations, to precisely specify a semantics for enterprise models which enables them to be considered as abstractions of the conceptual models from which the implementing information systems are built. The category-theoretic concepts are developed towards the problem of testing whether a system satisfies the fibration axioms, and are applied to case studies to demonstrate their practicability.

Free-radical bulk polymerization of styrene: ESR and near-infrared spectroscopic study of the entire conversion range

The free radical polymerization of styrene in bulk was monitored by ESR and FT near-infrared spectroscopy at 70°C for a series of concentrations of the initiator, dimethyl 2,2′-azobis(isobutyrate). In order to obtain detailed kinetic information over the intire conversion range, and the gel effect range in particular, conversion and free radical concentration data points were accumulated with exceptionally short time intervals. The polystyrene radical concentration ([St•]) went through a sharp maximum at the gel effect, a feature that has hitherto escaped observation due to the rapid concentration changes in the gel effect range relative to the data point time intervals of previous studies. Temperature measurements throughout the polymerization were employed to calculate that a temperature increase was not the cause of the [St•] maximum, which thus appeares to be a genuine feature of the gel effect of this system under isothermal conditions. The propagation rate constant (kp) as a function of monomer conversion exhibited a marked dependence on initiator concentration at high monomer conversion; the sharp decrease in kp with increasing conversion was shifted to higher conversions with increasing initiator concentration.

Diet, lifestyle and the risk of Type 2 Diabetes Mellitus in women

Background Previous studies have examined individual dietary and lifestyle factors in relation to type 2 diabetes, but the combined effects of these factors are largely unknown. Methods We followed 84,941 female nurses from 1980 to 1996; these women were free of diagnosed cardiovascular disease, diabetes, and cancer at base line. Information about their diet and lifestyle was updated periodically. A low-risk group was defined according to a combination of five variables: a body-mass index (the weight in kilograms divided by the square of the height in meters) of less than 25; a diet high in cereal fiber and polyunsaturated fat and low in trans fat and glycemic load (which reflects the effect of diet on the blood glucose level); engagement in moderate-to-vigorous physical activity for at least half an hour per day; no current smoking; and the consumption of an average of at least half a drink of an alcoholic beverage per day. Results During 16 years of follow-up, we documented 3300 new cases of type 2 diabetes. Overweight or obesity was the single most important predictor of diabetes. Lack of exercise, a poor diet, current smoking, and abstinence from alcohol use were all associated with a significantly increased risk of diabetes, even after adjustment for the body-mass index. As compared with the rest of the cohort, women in the low-risk group (3.4 percent of the women) had a relative risk of diabetes of 0.09 (95 percent confidence interval, 0.05 to 0.17). A total of 91 percent of the cases of diabetes in this cohort (95 percent confidence interval, 83 to 95 percent) could be attributed to habits and forms of behavior that did not conform to the low-risk pattern. Conclusions Our findings support the hypothesis that the majority of cases of type 2 diabetes could be prevented by the adoption of a healthier lifestyle.

Dietary fat intake and risk of type 2 diabetes in women

Background: The long-term relations between specific types of dietary fat and risk of type 2 diabetes remain unclear. Objective: Our objective was to examine the relations between dietary fat intakes and the risk of type 2 diabetes. Design: We prospectively followed 84204 women aged 34–59 y with no diabetes, cardiovascular disease, or cancer in 1980. Detailed dietary information was assessed at baseline and updated in 1984, 1986, and 1990 by using validated questionnaires. Relative risks of type 2 diabetes were obtained from pooled logistic models adjusted for nondietary and dietary covariates. Results: During 14 y of follow-up, 2507 incident cases of type 2 diabetes were documented. Total fat intake, compared with equivalent energy intake from carbohydrates, was not associated with risk of type 2 diabetes; for a 5% increase in total energy from fat, the relative risk (RR) was 0.98 (95% CI: 0.94, 1.02). Intakes of saturated or monounsaturated fatty acids were also not significantly associated with the risk of diabetes. However, for a 5% increase in energy from polyunsaturated fat, the RR was 0.63 (0.53, 0.76; P < 0.0001) and for a 2% increase in energy from trans fatty acids the RR was 1.39 (1.15, 1.67; P = 0.0006). We estimated that replacing 2% of energy from trans fatty acids isoenergetically with polyunsaturated fat would lead to a 40% lower risk (RR: 0.60; 95% CI: 0.48, 0.75). Conclusions: These data suggest that total fat and saturated and monounsaturated fatty acid intakes are not associated with risk of type 2 diabetes in women, but that trans fatty acids increase and polyunsaturated fatty acids reduce risk. Substituting nonhydrogenated polyunsaturated fatty acids for trans fatty acids would likely reduce the risk of type 2 diabetes substantially.

The preparation of reach to grasp movements in adults with Down syndrome

The aim of this study was to determine the extent to which adults with Down syndrome (DS) are able to utilise advance information to prepare reach to grasp movements. The study comprised ten adults with DS; ten children matched to an individual in the group with DS on the basis of their intellectual ability, and twelve adult controls. The participants used their right hand to reach out and grasp illuminated perspex blocks. Four target blocks were positioned on a table surface, two to each side of the midsagittal plane. In the complete precue condition, participants were provided with information specifying the location of the target. In the partial precue condition, participants were given advance information indicating the location of the object relative to the midsagittal plane (left or right). In the null condition, advance information concerning the position of the target object was entirely ambiguous. It was found that both reaction times and movement times were greater for the participants with DS than for the adults without DS. The reaction times exhibited by individuals with DS in the complete precue condition were lower than those observed in the null condition, indicating that they had utilised advance information to prepare their movements. In the group with DS, when advance information specified only the location of the target object relative to the midline, reaction times were equivalent to those obtained when ambiguous information was given. In contrast, the adults without DS exhibited reaction times that were lower in both the complete and partial precue conditions when compared to the null condition. The pattern of results exhibited by the children was similar to that of the adults without DS. The movement times exhibited by all groups were not influenced by the precue condition. In summary, our findings indicate that individuals with DS are able to use advance information if it specifies precisely the location of the target object in order to prepare a reach to grasp movement. The group with DS were unable, however, to obtain the normal advantage of advance information specifying only one dimension of the movement goal (i.e., the position of an object relative to the body midline). (C) 2001 Elsevier Science B.V. All rights reserved.

Haptic information stabilizes and destabilizes coordination dynamics

Goal-directed, coordinated movements in humans emerge from a variety of constraints that range from 'high-level' cognitive strategies based oil perception of the task to 'low-level' neuromuscular-skeletal factors such as differential contributions to coordination from flexor and extensor muscles. There has been a tendency in the literature to dichotomize these sources of constraint, favouring one or the other rather than recognizing and understanding their mutual interplay. In this experiment, subjects were required to coordinate rhythmic flexion and extension movements with an auditory metronome, the rate of which was systematically increased. When subjects started in extension on the beat of the metronome, there was a small tendency to switch to flexion at higher rates, but not vice versa. When subjects: were asked to contact a physical stop, the location of which was either coincident with or counterphase to the auditor) stimulus, two effects occurred. When haptic contact was coincident with sound, coordination was stabilized for both flexion and extension. When haptic contact was counterphase to the metronome, coordination was actually destabilized, with transitions occurring from both extension to flexion on the beat and from flexion to extension on the beat. These results reveal the complementary nature of strategic and neuromuscular factors in sensorimotor coordination. They also suggest the presence of a multimodal neural integration process-which is parametrizable by rate and context - in which intentional movement, touch and sound are bound into a single, coherent unit.

Development and implementation of the population Fisher information matrix for the evaluation of population pharmacokinetic designs.

In population pharmacokinetic studies, the precision of parameter estimates is dependent on the population design. Methods based on the Fisher information matrix have been developed and extended to population studies to evaluate and optimize designs. In this paper we propose simple programming tools to evaluate population pharmacokinetic designs. This involved the development of an expression for the Fisher information matrix for nonlinear mixed-effects models, including estimation of the variance of the residual error. We implemented this expression as a generic function for two software applications: S-PLUS and MATLAB. The evaluation of population designs based on two pharmacokinetic examples from the literature is shown to illustrate the efficiency and the simplicity of this theoretic approach. Although no optimization method of the design is provided, these functions can be used to select and compare population designs among a large set of possible designs, avoiding a lot of simulations.

Fitting a mixture model to three-mode three-way data with missing information

When the data consist of certain attributes measured on the same set of items in different situations, they would be described as a three-mode three-way array. A mixture likelihood approach can be implemented to cluster the items (i.e., one of the modes) on the basis of both of the other modes simultaneously (i.e,, the attributes measured in different situations). In this paper, it is shown that this approach can be extended to handle three-mode three-way arrays where some of the data values are missing at random in the sense of Little and Rubin (1987). The methodology is illustrated by clustering the genotypes in a three-way soybean data set where various attributes were measured on genotypes grown in several environments.

Long-term outcomes of genetic counseling in women at increased risk of developing hereditary breast cancer Information,

This multicenter study evaluated the impact of genetic counseling in 218 women at risk of developing hereditary breast cancer. Women were assessed prior to counseling and 12-month post-counseling using self-administered, mailed questionnaires. Compared to baseline, breast cancer genetics knowledge was increased significantly at follow-up. and greater increases in knowledge were associated with educational level. Breast cancer anxiety decreased significantly from baseline to follow-up, and these decreases were associated with improvements in perceived risk. A significant decrease in clinical breast examination was observed at the 12-month follow-up. Findings suggest that women with a family history of breast cancer benefit from attending familial cancer clinics as it leads to increases in breast cancer genetics knowledge and decreases in breast cancer anxiety. The lowered rates of clinical breast examination indicate that the content of genetic counseling may need to be reviewed to ensure that women receive and take away the right message. (C) 2001 Elsevier Science Ireland Ltd. All rights reserved.