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.

Determinants of hepato- and spleno-megaly in Hunan, China: cross-sectional survey data from areas endemic for schistosomiasis

In order to understand the determinants of schistosome-related hepato- and spleno-megaly better, 14 002 subjects aged 3-60 years (59% male; mean age =32 years) were randomly selected from 43 villages, all in Hunan province, China, where schistosomiasis caused by Schistosoma japonicum is endemic. The abdomen of each subject was examined along the mid-sternal (MSL) and mid-clavicular lines, for evidence of current hepato- and/or spleno-megaly, and a questionnaire was used to collect information on the medical history of each individual. Current infections with S. japonicum were detected by stool examination. Almost all (99.8%) of the subjects were ethnically Han by descent and most (77%) were engaged in farming. Although schistosomiasis appeared common (42% of the subjects claiming to have had the disease), only 45% of the subjects said they had received anti-schistosomiasis drugs. Overall, 1982 (14%) of the subjects had S. japonicum infections (as revealed by miracidium-hatching tests and/or Katon Katz smears) when examined and 22% had palpable hepatomegaly (i.e. enlargement of at least 3 cm along the MSL), although only 2.5% had any form of detectable splenomegaly (i.e. a Hackett's grade of at least 1). Multiple logistic regression revealed that male subjects, fishermen, farmers, subjects aged greater than or equal to 25 years, subjects with a history of schistosomiasis, and subjects who had had bloody stools in the previous 2 weeks were all at relatively high risk of hepato- and/or spleno-megaly. In areas moderately endemic for Schistosoma japonicum, occupational exposure and disease history appear to be good predictors of current disease status among older residents. These results reconfirm those reported earlier in the same region.

Matching prescription claims with medication data for nursing home residents: Implications for prescriber feedback, drug utilisation studies and selection of prescription claims database

Medication data retrieved from Australian Repatriation Pharmaceutical Benefits Scheme (RPBS) claims for 44 veterans residing in nursing homes and Pharmaceutical Benefits Scheme (PBS) claims for 898 nursing home residents were compared with medication data from nursing home records to determine the optimal time interval for retrieving claims data and its validity. Optimal matching was achieved using 12 weeks of RPBS claims data, with 60% of medications in the RPBS claims located in nursing home administration records, and 78% of medications administered to nursing home residents identified in RPBS claims. In comparison, 48% of medications administered to nursing home residents could be found in 12 weeks of PBS data, and 56% of medications present in PBS claims could be matched with nursing home administration records. RPBS claims data was superior to PBS, due to the larger number of scheduled items available to veterans and the veteran's file number, which acts as a unique identifier. These findings should be taken into account when using prescription claims data for medication histories, prescriber feedback, drug utilisation, intervention or epidemiological studies. (C) 2001 Elsevier Science Inc. All rights reserved.

Comparing physical activity questionnaires for youth: Seasonal vs annual format

Background: In large cohort studies of older children, self-report is the only practical way to assess physical activity. Assessing usual activity over the entire year is desirable, but children and adolescents may overestimate activities with high seasonal variability. Use of questionnaires in which individuals report each activity by season may improve accuracy. Methods: A total of 6782 girls and 5110 boys, aged 9–14 years in 1996, completed self-administered activity questionnaires in 1996 and in 1997. In 1996, participants reported the average time spent in each of 17 activities during the previous 12 months; in 1997, we also asked for the average time spent in the previous year, but within each of the four seasons. Results: Girls reported a median of 12.8 hours/week total activity in 1996 and 10.4 hours/week in 1997. For boys, the estimates were 15.5 hours/week and 13.4 hours/week, respectively. Girls and boys within 1-year age strata (e.g., comparison of 10-year olds in 1996 with 10-year olds in 1997) reported an average of 3.7 and 3.1 fewer hours per week, respectively, on the 1997 seasonal format versus the 1996 annual format questionnaire. In longitudinal analyses, the difference between the annual and the seasonal estimates was greater if participants did the activity in fewer seasons in 1997. Conclusions: In comparison to an annual format questionnaire, a seasonal format questionnaire may improve accuracy of self-report of physical activity by reducing over-reporting of activities in which pre-adolescents and adolescents engage in fewer seasons.

Exploratory spatial data analysis techniques for examining urban crime

Regional planners, policy makers and policing agencies all recognize the importance of better understanding the dynamics of crime. Theoretical and application-oriented approaches which provide insights into why and where crimes take place are much sought after. Geographic information systems and spatial analysis techniques, in particular, are proving to be essential or studying criminal activity. However, the capabilities of these quantitative methods continue to evolve. This paper explores the use of geographic information systems and spatial analysis approaches for examining crime occurrence in Brisbane, Australia. The analysis highlights novel capabilities for the analysis of crime in urban regions.

Who does not gain weight? Prevalence and predictors of weight maintenance in young women

OBJECTIVE: To investigate the prevalence and predictors of weight maintenance over time in a large sample of young Australian women. DESIGN: This population study examined baseline and 4y follow-up data from the cohort of young women participating in the Australian Longitudinal Study on Women's Health. SUBJECTS: A total of 8726 young women aged 18 - 23y at baseline. MEASURES: Height, weight and body mass index (BMI); physical activity; time spent sitting; selected eating behaviours (eg dieting, disordered eating, takeaway food consumption); cigarette smoking, alcohol consumption; parity; and socio-demographic characteristics. RESULTS: Only 44% of the women reported their BMI at follow-up to be within 5% of their baseline BMI (maintainers); 41% had gained weight and 15% had lost weight. Weight maintainers were more likely to be in managerial or professional occupations; to have never married; to be currently studying; and not to be mothers. Controlling for sociodemographic factors, weight maintainers were more likely to be in a healthy weight range at baseline, and to report that they spent less time sitting, and consumed less takeaway food, than women who gained weight. CONCLUSIONS: Fewer than half the young women in this community sample maintained their weight over this 4y period in their early twenties. Findings of widespread weight gain, particularly among those already overweight, suggest that early adulthood, which is a time of significant life changes for many women, may be an important time for implementing strategies to promote maintenance of healthy weight. Strategies which encourage decreased sitting time and less takeaway food consumption may be effective for encouraging weight maintenance at this life stage.

Valerian does not appear to reduce symptoms for patients with chronic insomnia in general practice using a series of randomised n-of-I trials

Objectives: To investigate the effectiveness of valerian for the management of chronic insomnia in general practice. Design: Valerian versus placebo in a series of n-of-1 trials, in Queensland, Australia. Results: Of 42 enrolled patients, 24 (57%) had sufficient data for inclusion into the n-of-1 analysis. Response to valerian was fair for 23 (96%) participants evaluating their 'energy level in the previous day' but poor or modest for all 24 (100%) participants' response to 'total sleep time' and for 23 (96%) participants' response to 'number of night awakenings' and 'morning refreshment'. As a group, the proportion of treatment successes ranged from 0.35 (95% CI 0.23, 0.47) to 0.55 (95% CI 0.43, 0.67) for the six elicited outcome sleep variables. There was no significant difference in the number (P = 0.06), distribution (P = 1.00) or severity (P = 0.46) of side effects between valerian and placebo treatments. Conclusions: Valerian was not shown to be appreciably better than placebo in promoting sleep or sleep-related factors for any individual patient or for all patients as a group. (C) 2003 Elsevier Ltd. All rights reserved.

Data-driven fuzzy analysis in quantitative mineral resource assessment

The integration of geo-information from multiple sources and of diverse nature in developing mineral favourability indexes (MFIs) is a well-known problem in mineral exploration and mineral resource assessment. Fuzzy set theory provides a convenient framework to combine and analyse qualitative and quantitative data independently of their source or characteristics. A novel, data-driven formulation for calculating MFIs based on fuzzy analysis is developed in this paper. Different geo-variables are considered fuzzy sets and their appropriate membership functions are defined and modelled. A new weighted average-type aggregation operator is then introduced to generate a new fuzzy set representing mineral favourability. The membership grades of the new fuzzy set are considered as the MFI. The weights for the aggregation operation combine the individual membership functions of the geo-variables, and are derived using information from training areas and L, regression. The technique is demonstrated in a case study of skarn tin deposits and is used to integrate geological, geochemical and magnetic data. The study area covers a total of 22.5 km(2) and is divided into 349 cells, which include nine control cells. Nine geo-variables are considered in this study. Depending on the nature of the various geo-variables, four different types of membership functions are used to model the fuzzy membership of the geo-variables involved. (C) 2002 Elsevier Science Ltd. All rights reserved.

Nonfatal heroin overdoses in Queensland, Australia: an analysis of ambulance data

In the past decade, the utilization of ambulance data to inform the prevalence of nonfatal heroin overdose has increased. These data can assist public health policymakers, law enforcement agencies, and health providers in planning and allocating resources. This study examined the 672 ambulance attendances at nonfatal heroin overdoses in Queensland, Australia, in 2000. Gender distribution showed a typical 70/30 male-to-female ratio. An equal number of persons with nonfatal heroin overdose were between 15 and 24 years of age and 25 and 34 years of age. Police were present in only 1 of 6 cases, and 28.1% of patients reported using drugs alone. Ambulance data are proving to be a valuable population-based resource for describing the incidence and characteristics of nonfatal heroin overdose episodes. Future studies could focus on the differences between nonfatal heroin overdose and fatal heroin overdose samples.

Ex ante evaluations of alternate data structures for end user queries: Theory and experimental test

The data structure of an information system can significantly impact the ability of end users to efficiently and effectively retrieve the information they need. This research develops a methodology for evaluating, ex ante, the relative desirability of alternative data structures for end user queries. This research theorizes that the data structure that yields the lowest weighted average complexity for a representative sample of information requests is the most desirable data structure for end user queries. The theory was tested in an experiment that compared queries from two different relational database schemas. As theorized, end users querying the data structure associated with the less complex queries performed better Complexity was measured using three different Halstead metrics. Each of the three metrics provided excellent predictions of end user performance. This research supplies strong evidence that organizations can use complexity metrics to evaluate, ex ante, the desirability of alternate data structures. Organizations can use these evaluations to enhance the efficient and effective retrieval of information by creating data structures that minimize end user query complexity.

'Slippage' is not a dirty word: Considering the usefulness of Giddens' notion of knowledgeability in understanding the possibilities for teacher education

The attempt to understand the relationship between messages intended and messages received has been an enduring issue in teacher education. For the past three decades researchers have made forays into understanding this enduring issue, and in the process have drawn on various explanatory frameworks, one of them being socialisation. In this paper we work with Giddens' structuration theory as well as his concept of knowledgeability as analytical frameworks for understanding the relationship between messages intended (by the teacher educator) and messages received (by the student-teachers). Our discussion is informed by the findings of a study that investigated student-teachers' interpretations of the pedagogical process of a physical education teacher education course. Data generated from conversations with, and observations of, the student-teachers indicated that there was considerable “slippage” between the teacher educator's critical pedagogy inspired intentions and what was understood by the student-teachers.

The design and implementation of a repository for the management of spatial data integrity constraints

This paper reviews the key features of an environment to support domain users in spatial information system (SIS) development. It presents a full design and prototype implementation of a repository system for the storage and management of metadata, focusing on a subset of spatial data integrity constraint classes. The system is designed to support spatial system development and customization by users within the domain that the system will operate.