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.

Considerations in the design of a mixed-method cluster evaluation of a community programme for 'at-risk' young people

This article discusses the design of a comprehensive evaluation of a community development programme for young people 'at-risk' of self-harming behaviour. It outlines considerations in the design of the evaluation and focuses on the complexities and difficulties associated with the evaluation of a community development programme. The challenge was to fulfil the needs of the funding body for a broad, outcome-focused evaluation while remaining close enough to the programme to accurately represent its activities and potential effects at a community level. Specifically, the strengths and limitations of a mixed-method evaluation plan are discussed with recommendations for future evaluation practice.

An evaluation of the changes in malocclusion index scores over a 25-year period

Background: The measured values of specific traits of occlusion may be subject to significant change due to growth and maturation of the dentofacial structures. Some traits may show improvement while others may show deterioration. Rarely is there an opportunity to examine a sample of occlusions 25 years after the acquisition of the original set of records. This study examines the changes in traits of occlusion in a sample of 46 subjects who were originally examined between 1971-1973 and for whom records were again obtained in 1998. Methods: The 46 patients were a sub-group of a previously selected randomised school-based sample and study models obtained in 1971-1973 were still available. New models for each patient were obtained in 1998. Of the 46 subjects, only eight had received orthodontic treatment. Results: Assessments of the changes in specific traits were made using the methods proposed in the Harry L Draker, California Modification (HLD Cal Mod) index. This simple index was chosen because the main component traits were well defined and, when analysed separately, reflected changes with time. The total index score gave a broad indication of the global changes in the individual's occlusion. The five basic traits of the HLD index include overjet, overbite, openbite, mandibular protrusion and labio-lingual spread. Three additional traits (ectopic eruption, anterior crowding and posterior crossbite) are used in the HLD Cal Mod index. These traits provided a useful reflection of occlusal changes with time. Measurements were made with reference to specifications and the details outlined in the HLD Cal Mod protocol. The results revealed an increase in total index scores over time with a significant increase in lower labio-lingual spread associated with an increased score in anterior crowding. Overjet and overbite, however, displayed a significant decrease with time. Conclusions: These findings are in keeping with previous studies and highlight the importance of time as a significant issue in the assessment of occlusion.

Congenital lactic acidosis: Evaluation of the properties of the A199T natural variant of human pyruvate dehydrogenase E1 alpha by in vitro mutation

One cause of congenital lactic acidosis is a mutation in the E1 alpha -subunit of the pyruvate dehydrogenase multienzyme complex. Little is known about the consequences of these mutations at the enzymatic level. Here we study the A199T mutation by expressing the protein in Escherichia coil. The specific activity is 25% of normal and the K-m for pyruvate is elevated by 10-fold. Inhibitors of lactate dehydrogenase might be a useful therapy for patients with such mutations. (C) 2001 Academic Press.

Beyond sex and cooking: Health education for individuals with intellectual disability

Issues of health education programming for people with intellectual disability are discussed. As environments in which such individuals live become more inclusive, and they are encouraged to make their own choices, the issue of whether current health education is sufficient to enable them to make healthy life choices is considered. More attention should be focused on programs in schools and the community to fulfill this need. Three aspects of health education programming are considered: physical activity, general health knowledge, and social supports for health. Continuity of information is viewed as important in policy development as well as in interprofessional coordination and cooperation to assure that these individuals are not further handicapped by poor health.

An evaluation approach for a new paradigm - health care integration

This paper explores an approach to the implementation and evaluation of integrated health service delivery. It identifies the key issues involved in integration evaluation, provides a framework for assessment and identifies areas for the development of new tools and measures. A proactive role for evaluators in responding to health service reform is advocated.

Drug use evaluation of ipratropium bromide at two tertiary referral hospitals in Brisbane.

Objective: To assess the appropriateness of ipratropium bromide prescribing in two tertiary referral hospitals. Method: Criteria for optimal use were developed based on current literature and modified after consultation with respiratory physicians and clinical pharmacists. A prospective review of prescribing was performed over a 2-month period to assess conformity to these criteria. Results: Information was collected from 84 patients; 5% were receiving inhalers and 96% nebuliser therapy (one patient used both). 77% of patients (n = 65) had a principal diagnosis of chronic obstructive pulmonary disease, 14% (n = 12) asthma and 8% (n = 7) had neither diagnosis. 75% of patients were using ipratropium outside the guidelines. The major areas where the guidelines were not met were a lack of therapeutic justification, use of inappropriate doses, and use of an inappropriate delivery device. Feedback and educational interventions were designed and delivered based on the data obtained. Conclusions: There was widespread use of ipratropium outside the developed guidelines. Interventions in specific areas could lead to significant improvements in the use of this high cost drug

Adolescents' perceptions of social status: Development and evaluation of a new indicator

Objective. Eliminating health disparities, including those that are a result of socioeconomic status (SES), is one of the overarching goals of Healthy People 2010. This article reports on the development of a new, adolescent-specific measure of subjective social status (SSS) and on initial exploratory analyses of the relationship of SSS to adolescents' physical and psychological health. Methods. A cross-sectional study of 10 843 adolescents and a subsample of 166 paired adolescent/mother dyads who participated in the Growing Up Today Study was conducted. The newly developed MacArthur Scale of Subjective Social Status (10-point scale) was used to measure SSS. Paternal education was the measure of SES. Indicators of psychological and physical health included depressive symptoms and obesity, respectively. Linear regression analyses determined the association of SSS to depressive symptoms, and logistic regression determined the association of SSS to overweight and obesity, controlling for sociodemographic factors and SES. Results. Mean society ladder ranking, a subjective measure of SES, was 7.2 ± 1.3. Mean community ladder ranking, a measure of perceived placement in the school community, was 7.6 ± 1.7. Reliability of the instrument was excellent: the intraclass correlation coefficient was 0.73 for the society ladder and 0.79 for the community ladder. Adolescents had higher society ladder rankings than their mothers (µteen = 7.2 ± 1.3 vs µmom = 6.8 ± 1.2; P = .002). Older adolescents' perceptions of familial placement in society were more closely correlated with maternal subjective perceptions of placement than those of younger adolescents (Spearman's rhoteens

An evaluation of a suburban railway pedestrian crossing safety programme

This study evaluated a programme of educational and environmental (access prevention) interventions designed to reduce the incidence of illegal and unsafe crossing of the rail corridor at a suburban station in Auckland, New Zealand. Immediately after the programme of interventions, the proportion of those crossing the rail corridor by walking across the tracks directly rather than using the nearby overbridge had decreased substantially. Three months later, the decrease was even greater. However, the educational and environmental interventions were introduced simultaneously so that the effects of each could not be separated, nor could other unmeasured factors be ruled out. Anonymous surveys administered immediately before and 3 months after the interventions indicated that while awareness of the illegality of walking across the tracks had increased slightly, perception of risk had not changed. This suggests that the educational interventions may have had less effect than the access prevention measures. (C) 2001 Elsevier Science Ltd. All rights reserved.

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.

Analysis of the gate capacitance measurement technique and its application for the evaluation of hot-carrier degradation in submicrometer MOSFETs

The use of gate-to-drain capacitance (C-gd) measurement as a tool to characterize hot-carrier-induced charge centers in submicron n- and p-MOSFET's has been reviewed and demonstrated. By analyzing the change in C-gd measured at room and cryogenic temperature before and after high gate-to-drain transverse field (high field) and maximum substrate current (I-bmax) stress, it is concluded that the degradation was found to be mostly due to trapping of majority carriers and generation of interface states. These interface states were found to be acceptor states at top half of band gap for n-MOSFETs and donor states at bottom half of band gap for p-MOSFETs. In general, hot electrons are more likely to be trapped in gate oxide as compared to hot holes while the presence of hot holes generates more interface states. Also, we have demonstrated a new method for extracting the spatial distribution of oxide trapped charge, Q(ot), through gate-to-substrate capacitance (C-gb) measurement. This method is simple to implement and does not require additional information from simulation or detailed knowledge of the device's structure. (C) 2001 Elsevier Science Ltd. All rights reserved.