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.

Body size and ovarian cancer: case-control study and systematic review (Australia)

Objective: Although increased body mass is an established risk factor for a variety of cancers, its relation with cancer of the ovary is unclear. We therefore investigated the association between measures of body mass index (BMI) and ovarian cancer risk. Methods: Data from an Australian case-control study of 775 ovarian cancer cases and 846 controls were used to examine the association with BMI. We have also summarized the results from a number of other studies that have examined this association. Results: There was a significant increased risk of ovarian cancer with increasing BMI, with women in the top 15% of the BMI range having an odds ratio (OR) of 1.9 (95% confidence interval (CI), 1.3-2.6) compared with those in the middle 30%. Stratifying by physical activity showed a stronger effect among inactive women (OR = 3.0, 95% CI 1.3-6.9). The overall effect was consistent with the findings of most prior population-based case-control studies, while cohort studies reported positive effects closer to the null. Hospital-based studies gave variable results. Conclusions: Taken together, the evidence is in favor of a small to moderate positive relation between high BMI and occurrence of ovarian cancer.

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.

Integrating high and moderate spatial resolution image data to estimate forest age structure

The collection of spatial information to quantify changes to the state and condition of the environment is a fundamental component of conservation or sustainable utilization of tropical and subtropical forests, Age is an important structural attribute of old-growth forests influencing biological diversity in Australia eucalypt forests. Aerial photograph interpretation has traditionally been used for mapping the age and structure of forest stands. However this method is subjective and is not able to accurately capture fine to landscape scale variation necessary for ecological studies. Identification and mapping of fine to landscape scale vegetative structural attributes will allow the compilation of information associated with Montreal Process indicators lb and ld, which seek to determine linkages between age structure and the diversity and abundance of forest fauna populations. This project integrated measurements of structural attributes derived from a canopy-height elevation model with results from a geometrical-optical/spectral mixture analysis model to map forest age structure at a landscape scale. The availability of multiple-scale data allows the transfer of high-resolution attributes to landscape scale monitoring. Multispectral image data were obtained from a DMSV (Digital Multi-Spectral Video) sensor over St Mary's State Forest in Southeast Queensland, Australia. Local scene variance levels for different forest tapes calculated from the DMSV data were used to optimize the tree density and canopy size output in a geometric-optical model applied to a Landsat Thematic Mapper (TU) data set. Airborne laser scanner data obtained over the project area were used to calibrate a digital filter to extract tree heights from a digital elevation model that was derived from scanned colour stereopairs. The modelled estimates of tree height, crown size, and tree density were used to produce a decision-tree classification of forest successional stage at a landscape scale. The results obtained (72% accuracy), were limited in validation, but demonstrate potential for using the multi-scale methodology to provide spatial information for forestry policy objectives (ie., monitoring forest age structure).

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.

A comparison between three and five factor models of Pakistani personality data

The Eysenck Personality Questionnaire-Revised (EPQ-R), the Eysenck Personality Profiler Short Version (EPP-S), and the Big Five Inventory (BFI-V4a) were administered to 135 postgraduate students of business in Pakistan. Whilst Extraversion and Neuroticism scales from the three questionnaires were highly correlated, it was found that Agreeableness was most highly correlated with Psychoticism in the EPQ-R and Conscientiousness was most highly correlated with Psychoticism in the EPP-S. Principal component analyses with varimax rotation were carried out. The analyses generally suggested that the five factor model rather than the three-factor model was more robust and better for interpretation of all the higher order scales of the EPQ-R, EPP-S, and BFI-V4a in the Pakistani data. Results show that the superiority of the five factor solution results from the inclusion of a broader variety of personality scales in the input data, whereas Eysenck's three factor solution seems to be best when a less complete but possibly more important set of variables are input. (C) 2001 Elsevier Science Ltd. All rights reserved.

Relating body mass index to figural stimuli: population-based normative data for Caucasians

OBJECTIVE: To establish body mass index (BMI) norms for standard figural stimuli using a large Caucasian population-based sample. In addition, we sought to determine the effectiveness of the figural stimuli to identify individuals as obese or thin. DESIGN: All Caucasian twins born in Virginia between 1915 and 1971 were identified by public birth record. In addition, 3347 individual twins responded to a letter published in the newsletter of the American Association of Retired Persons (AARP). All adult twins (aged 18 and over) from both of these sources and their family members were mailed a 16 page 'Health and Lifestyle' questionnaire. SUBJECTS: BMI and silhouette data were available on 16 728 females and 11 366 males ranging in age from 18- 100. MEASUREMENTS: Self-report information on height-weight, current body size, desired body size and a discrepancy score using standard figural stimuli. RESULTS: Gender- and age-specific norms are presented linking BMI to each of the figural stimuli. Additional norms for desired body size and discrepancy scores are also presented. Receiver operating curves (ROC) indicate that the figural stimuli are effective in classifying individuals as obese or thin. CONCLUSIONS: With the establishment of these norms, the silhouettes used in standard body image assessment can now be linked to BMI. Differences were observed between women and men in terms of desired body size and discrepancy scores, with women preferring smaller sizes. The figural stimuli are a robust technique for classifying individuals as obese or thin.

Facies architecture of the CRP-3 drillhole, Victoria Land Basin, Antarctica

The Cenozoic Victoria Land Basin (VLB) stratigraphic section penetrated by CRP-3 is mostly of Early Oligocene age. It contains an array of lithofacies comprising fine-grained mudrocks, interlaminated and interbedded mudrocks/sandstones, mud-rich and mud-poor sandstones, conglomerates and diametites that are together interpreted as the products of shallow marine to possibly non-marine environments of deposition, affected by the periodic advance and retreat of tidewater glaciers. This lithofacies assemblage can be readily rationalised using the facies scheme designed originally for CRP-2/2A, and published previously. The uppermost 330 metres below sea floor (mbsf) shows a cyclical arrangement of lithofacies also similar to that recognised throughout CRP-2/2A, and interpreted to reflect cyclical variations in relative sea-level driven by ice volume fluctuations ("Motif A"). Between 330 and 480 mbsf, a series of less clearly cyclical units, generally fining-upward but nonetheless incorporating a significant subset of the facies assemblage, has been identified and noted in the Initial Report as "Motif B. Below 480 mbsf, the section is arranged into a repetitive succession of fining-upward units, each of which comprises dolerite clast conglomerate at the base passing upward into relatively thick intervals of sandstones. The cycles present down 480 mbsf are defined as sequences, each interpreted to record cyclical variation of relative sea-level. The thickness distribution of sequences in CRP-3 provides some insights into the geological variables controlling sediment accumulation in the Early Oligocene section. The uppermost part of the section in CRP-3 comprises two or three thick, complete sequences that show a broadly symmetrical arrangement of lithofacies (similar to Sequences 9-11 in CRP-2/2A). This suggests a period of relatively rapid tectonic subsidence, which allowed preservation of the complete facies cycle. Below Sequence 3, however, is a considerable interval of thin, incomplete and erosionally truncated sequences (4-23), which incorporates both the remainder of Motif A sequences and all Motif B sequences recognised. The thinner and more truncated sequences suggest sediment accumulation under conditions of reduced accommodation, and given the lack of evidence for glacial conditions (see Powell et al., this volume) tends to argue for a period of reduced tectonic subsidence. The section below 480 mbsf consists of a series of fining-upward, conglomerate to sandstone intervals which cannot be readily interpreted in terms of relative sea-level change. A relatively mudrock-rich interval above the basal conglomerate/breccia (782-762 mbsf) may record initial flooding of the basin during early rift subsidence. The lithostratigraphy summarised above has been linked to seismic reflection data using depth conversion techniques (Henrys et al., this volume). The three uppermost reflectors ("o", "p" and "q") correlate to the package of thick sequences 1-3, and several deeper reflectors can also be correlated to sequence boundaries. The package of thick Sequences 1-3 shows a sheet-like cross-sectional geometry on seismic reflection lines, unlike the similar package recognised in CRP-2/2A.

Laser-derived particle size data from CRP-3, Victoria Land Basin, Antarctica: Implications for sequence and seismic stratigraphy

Seven hundred and nineteen samples from throughout the Cainozoic section in CRP-3 were analysed by a Malvern Mastersizer laser particle analyser, in order to derive a stratigraphic distribution of grain-size parameters downhole. Entropy analysis of these data (using the method of Woolfe and Michibayashi, 1995) allowed recognition of four groups of samples, each group characterised by a distinctive grain-size distribution. Group 1, which shows a multi-modal distribution, corresponds to mudrocks, interbedded mudrock/sandstone facies, muddy sandstones and diamictites. Group 2, with a sand-grade mode but showing wide dispersion of particle size, corresponds to muddy sandstones, a few cleaner sandstones and some conglomerates. Group 3 and Group 4 are also sand-dominated, with better grain-size sorting, and correspond to clean, well-washed sandstones of varying mean grain-size (medium and fine modes, respectively). The downhole disappearance of Group 1, and dominance of Groups 3 and 4 reflect a concomitant change from mudrock- and diamictite-rich lithology to a section dominated by clean, well-washed sandstones with minor conglomerates. Progressive downhole increases in percentage sand and principal mode also reflect these changes. Significant shifts in grain-size parameters and entropy group membership were noted across sequence boundaries and seismic reflectors, as recognised in others studies.

Being breastfed in infancy and breast cancer incidence in adult life: Results from the two Nurses' Health studies

Events during perinatal and early life may influence the incidence of breast cancer in adult life, and some case-control studies suggest that having been breastfed may reduce breast cancer risk. The authors studied this association among premenopausal and postmenopausal women by using data from the two Nurses' Health Studies, the Nurses' Health Study (using data from 1992 to 1996) and the Nurses' Health Study II (using data from 1991 to 1997). A history of being breastfed was self-reported by the study participants. During a total of 695,655 person-years, 1,073 cases of invasive breast cancer were diagnosed. The authors did not observe any important overall association between having been breastfed and the development of breast cancer later in life among premenopausal women (covariate-adjusted relative risk = 0.97, 95% confidence interval (CI): 0.78, 1.20) or postmenopausal women (covariate-adjusted relative risk = 1.12, 95% CI: 0.92, 1.37). No significant trend was observed with increasing duration of breastfeeding. The authors also used data on breastfeeding retrospectively collected from 2,103 mothers of participants of the two Nurses' Health Studies. With the mothers' reports, the covariate-adjusted odds ratio of breast cancer was 1.11 (95% CI: 0.88, 1.39) for women who were breastfed compared with those who were not. Data from these two large cohorts do not support the hypothesis that being breastfed confers protection against subsequent breast cancer.

Diagnostic performance of Antineutrophil Cytoplasmic Antibody tests for Idiopathic Vasculitides: Metaanalysis with a focus on antimyeloperoxidase antibodies

Objective. The diagnostic value of tests for antimyeloperoxidase antibodies (anti-MPO) for systemic vasculitis is less established than that for cytoplasmic antineutrophil cytoplasmic antibody (cANCA)/antiproteinase 3 antibodies (anti-PR3). Controversy exists regarding the optimal utilization of indirect immunofluorescence (IIF) ANCA testing versus antigen-specific ANCA testing. To summarize the pertinent data, we conducted a metaanalysis examining the diagnostic value of ANCA testing systems that include assays for anti-MPO. Methods. We performed a structured Medline search and reference list review. Target articles in the search strategy were those reporting the diagnostic value of immunoassays for anti-MPO for the spectrum of systemic necrotizing vasculitides that includes Wegener's granulomatosis, microscopic polyangiitis, the Churg-Strauss syndrome, and isolated pauci-immune necrotizing or crescentic glomerulonephritis, regardless of other types of ANCA tests. Inclusion criteria required specification of a consecutive or random patient selection method and the use of acceptable criteria for the diagnosis of vasculitis exclusive of ANCA test results. Weighted pooled summary estimates of sensitivity and specificity were calculated for anti-MPO alone, anti-MPO + perinuclear ANCA (pANCA), and anti-MPO/pANCA + anti-PR3/cANCA. Results. Of 457 articles reviewed, only 7 met the selection criteria. Summary estimates of sensitivity and specificity (against disease controls only) of assays for anti-MPO for the diagnosis of systemic necrotizing vasculitides were 37.1% (confidence interval 26.6% to 47.6%) and 96.3% (CI 94.1% to 98.5%), respectively. When the pANCA pattern by IIF was combined with anti-MPO testing, the specificity improved to 99.4%, with a lower sensitivity, 31.5%. The combined ANCA testing system (anti-PR3/cANCA + anti-MPO/pANCA) increased the sensitivity to 85.5% with a specificity of 98.6%. Conclusion. These results suggest that while anti-MPO is relatively specific for the diagnosis of systemic vasculitis, the combination system of immunoassays for anti-MPO and IIF for pANCA is highly specific and both tests should be used together given the high diagnostic precision required for these conditions. Because patients with ANCA associated vasculitis have either anti-MPO with pANCA or anti-PR3 with cANCA, and rarely both, a combined ANCA testing system including anti-PR3/cANCA and anti-MPO/pANCA is recommended to optimize the diagnostic performance of ANCA testing. (J Rheumatol 2001;28:1584-90)

Population pharmacokinetics of perhexiline from very sparse, routine monitoring data

Using NONMEM, the population pharmacokinetics of perhexiline were studied in 88 patients (34 F, 54 M) who were being treated for refractory angina. Their mean +/- SD (range) age was 75 +/- 9.9 years (46-92), and the length of perhexiline treatment was 56 +/- 77 weeks (0.3-416). The sampling time after a dose was 14.1 +/- 21.4 hours (0.5-200), and the perhexiline plasma concentrations were 0.39 +/- 0.32 mg/L (0.03-1.56). A one-compartment model with first-order absorption was fitted to the data using the first-order (FO) approximation. The best model contained 2 subpopulations (obtained via the $MIXTURE subroutine) of 77 subjects (subgroup A) and 11 subjects (subgroup B) that had typical values for clearance (CL/F) of 21.8 L/h and 2.06 L/h, respectively. The volumes of distribution (V/F) were 1470 L and 260 L, respectively, which suggested a reduction in presystemic metabolism in subgroup B. The interindividual variability (CV%) was modeled logarithmically and for CL/F ranged from 69.1% (subgroup A) to 86.3% (subgroup B). The interindividual variability in V/F was 111%. The residual variability unexplained by the population model was 28.2%. These results confirm and extend the existing pharmacokinetic data on perhexiline, especially the bimodal distribution of CL/F manifested via an inherited deficiency in hepatic and extrahepatic CYP2D6 activity.

Coffee and alcohol consumption and the risk of pancreatic cancer in two prospective United States cohorts

Although most prospective cohort studies do not support an association between coffee consumption and pancreatic cancer, the findings for alcohol are inconsistent. Recently, a large prospective cohort study of women reported statistically significant elevations in risk of pancreatic cancer for both coffee and alcoholic beverage consumption. We obtained data on coffee, alcohol, and other dietary factors using semiquantitative food frequency questionnaires administered at baseline (1986 in the Health Professionals Follow-Up Study and 1980 in the Nurses’ Health Study) and in subsequent follow-up questionnaires. Data on other risk factors for pancreatic cancer, including cigarette smoking, were also available. Individuals with a history of cancer at study initiation were excluded from all of the analyses. During the 1,907,222 person-years of follow-up, 288 incident cases of pancreatic cancer were diagnosed. The data were analyzed separately for each cohort, and results were pooled to compute overall relative risks (RR). Neither coffee nor alcohol intakes were associated with an increased risk of pancreatic cancer in either cohort or after pooling the results (pooled RR, 0.62; 95% confidence interval, 0.27–1.43, for >3 cups of coffee/day versus none; and pooled RR, 1.00; 95% confidence interval, 0.57–1.76, for >=30 grams of alcohol/day versus none). The associations did not change with analyses examining different latency periods for coffee and alcohol. Similarly, no statistically significant associations were observed for intakes of tea, decaffeinated coffee, total caffeine, or alcoholic beverages. Data from these two large cohorts do not support any overall association between coffee intake or alcohol intake and risk of pancreatic cancer.