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.

Assessment of transient gene expression in plant tissues using the green fluorescent protein as a reference

Four different promoters (35S and enhanced 35S of the cauliflower mosaic virus, polyubiquitin of maize and actin1 of rice) were compared in a transient assay using maize leaves and particle bombardment. A gene encoding the jellyfish green fluorescent protein (GFP) driven by the 358 promoter was used as an internal standard to monitor the effectiveness of each bombardment. Normalisation of the transient expression assay using the GFP reference significantly reduced the variability between separate bombardments and allowed for a rapid and accurate evaluation of different promoters in microprojectile-bombarded leaves.

Applications of accurate, high-precision Pb isotope ratio measurement by multi-collector ICP-MS

The isotope composition of Ph is difficult to determine accurately due to the lack of a stable normalisation ratio. Double and triple-spike addition techniques provide one solution and presently yield the most accurate measurements. A number of recent studies have claimed that improved accuracy and precision could also be achieved by multi-collector ICP-MS (MC-ICP-MS) Pb-isotope analysis using the addition of Tl of known isotope composition to Pb samples. In this paper, we verify whether the known isotope composition of Tl can be used for correction of mass discrimination of Pb with an extensive dataset for the NIST standard SRM 981, comparison of MC-ICP-MS with TIMS data, and comparison with three isochrons from different geological environments. When all our NIST SRM 981 data are normalised with one constant Tl-205/Tl-203 of 2.38869, the following averages and reproducibilities were obtained: Pb-207/Pb-206=0.91461+/-18; Pb-208/Ph-206 = 2.1674+/-7; and (PbPh)-Pb-206-Ph-204 = 16.941+/-6. These two sigma standard deviations of the mean correspond to 149, 330, and 374 ppm, respectively. Accuracies relative to triple-spike values are 149, 157, and 52 ppm, respectively, and thus well within uncertainties. The largest component of the uncertainties stems from the Ph data alone and is not caused by differential mass discrimination behaviour of Ph and Tl. In routine operation, variation of sample introduction memory and production of isobaric molecular interferences in the spectrometer's collision cell currently appear to be the ultimate limitation to better reproducibility. Comparative study of five different datasets from actual samples (bullets, international rock standards, carbonates, metamorphic minerals, and sulphide minerals) demonstrates that in most cases geological scatter of the sample exceeds the achieved analytical reproducibility. We observe good agreement between TIMS and MC-ICP-MS data for international rock standards but find that such comparison does not constitute the ultimate. test for the validity of the MC-ICP-MS technique. Two attempted isochrons resulted in geological scatter (in one case small) in excess of analytical reproducibility. However, in one case (leached Great Dyke sulphides) we obtained a true isochron (MSWD = 0.63) age of 2578.3 +/- 0.9 Ma, which is identical to and more precise than a recently published U-Pb zircon age (2579 3 Ma) for a Great Dyke websterite [Earth Planet. Sci. Lett. 180 (2000) 1-12]. Reproducibility of this age by means of an isochron we regard as a robust test of accuracy over a wide dynamic range. We show that reliable and accurate Pb-isotope data can be obtained by careful operation of second-generation MC-ICP magnetic sector mass spectrometers. (C) 2002 Elsevier Science B.V. All rights reserved.

Audit of maternal and fetal outcomes in women treated for glucose intolerance during pregnancy

Objective To determine whether one should aim for glycaemia that is statistically 'normal' or for levels of glycaemia low enough to prevent macrosomia (if such a threshold exists) when glucose intolerance is detected during pregnancy Design An audit of pregnancy outcomes in women with impaired glucose tolerance in pregnancy as compared to a local age-matched reference group with normal glucose tolerance. Results Our study suggests that for most patients, more intensive therapy would not have been justified. Maternal smoking appeared to convey some 'advantages' in terms of neonatal outcomes, with reduction in large-for-gestational-age (LGA) infants and jaundice in babies of impaired glucose tolerance (IGT) mothers. Conclusions These observations demonstrate the importance of considering risk factors other than GTT results in analysing pregnancy outcomes, while emphasising that 'normalisation' of fetal size should not be our only therapeutic endpoint. Our detailed outcome review allows us to reassure patients with GDM that with current treatment protocols, they should have every expectation of a positive pregnancy outcome.

Importance of water for Archaean granitoid petrology: a comparative study of TTG and potassic granitoids from Barberton Mountain Land, South Africa

A new model for Archaean granitoid magmatism is presented which reconciles the most important geochemical similarities and differences between tonalite-trondhjemite-granodiorite (TTG) and potassic granitoids. Trace element abundances reveal a strong arc magmatism signature in all studied granitoids from Barberton Mountain Land. Characteristic features include HFSE depletion as well as distinct enrichment peaks of fluid-sensitive trace elements such as Pb in N-MORB normalisation, clearly indicating that all studied granitoids are derived from refertilised mantle above subduction zones. We envisage hydrous basaltic (s.l.) melts as parental liquids, which underwent extensive fractional crystallisation. Distinctive residual cumulates evolved depending on initial water content. High-H2O melts crystallised garnet/amphibole together with pyroxenes and minor plagioclase, but no olivine. This fractionation path ultimately led to TTG-like melts. Less hydrous basaltic melts also crystallised garnet/amphibole, but the lower compatible element content indicates that olivine was also a liquidus phase. Pronounced negative Eu-anomalies of the granitic melts, correlating with Na, Ca and Al, indicate plagioclase to be of major importance. In the context of our model, the post-Archaean disappearance of TTG and concomitant preponderance of granites (s.l.), therefore, is explained with secular decrease of aqueous fluid transport into subduction zones and/or efficiency of deep fluid release from slabs.

Residential and lifestyle changes for adults with an intellectual disability in Queensland 1960-2001

As we celebrate 50 years of the Schonell Special Education Research Centre it is timely to consider changes that have occurred in the provision of residential services for people with an intellectual disability. Before the 1970s adults and children were cared for in large institutions using a medical model of care. In the mid-1970s a new developmental model based on education and training was implemented in response to the principle of normalisation and issues of social justice. The most dramatic changes have occurred in the last ten years with the decision to close large institutions and relocate residents into ordinary homes in the community. This paper describes changes in lifestyle for adults with an intellectual disability as a result of the move from institutional to community residential service provision. The Challinor Centre in Ipswich, Queensland, Australia provides examples of lifestyle changes that have occurred under different models of service provision during this time. Community living is described with research evidence validating the advantages of this type of service provision for residents with an intellectual disability. Outcomes have been documented through the use of group results and a case study of one individual following deinstitutionalisation describes the benefits of this new model of residential accommodation

Geochemistry of late Archaean stromatolites from Zimbabwe: evidence for microbial life in restricted epicontinental seas

We report comprehensive trace element and Sr-isotope data for microbial carbonates from the Archaean Mushandike limestone, Masvingo Greenstone Belt, Zimbabwe. The stromatolites have very coherent REE + Y patterns and share the essential shale-normalised characteristics of other Archaean marine precipitates (positive La and Gd anomalies, absence of a negative Cc anomaly and a strongly superchondritic Y/Ho ratio). Mixing models constrain the maximum amount of shale contamination to 0.25-1% and calculated detritus-free carbonate REE + Y systematics require precipitation from seawater. In terms of light-REE over heavy-REE depletion, however, the studied samples are very different from all other known Archaean marine precipitates. In shale-normalised plots, the Mushandike samples yield a negative slope. A very restricted, regional input source of the dissolved load is indicated because normalisation with locally occurring tonalite gneiss REE + Y data yields a pattern closely resembling typical shale-normalised Archaean marine chemical sediments. The disappearance of a negative Eu anomaly when patterns are normalised with local tonalite gneiss strengthens this interpretation. Sr-isotope ratios are strongly correlated with trace element contents and ratios, which explains the modest scatter in Sr-isotope ratios as representing (minor) clastic contamination. Importantly, even the least contaminated samples have very radiogenic initial Sr-87/Sr-86 ratios (0.7184) implying Sr input from an ancient high Rb/Sr source, such as the early Archaean gneisses of south-central Zimbabwe. A local ancient (3.5-3.8 Ga) source is also indicated by previously published Pb-isotope datasets for the Mushandike stromatolites. This is entirely compatible with the occurrence of 3.7-3.8 Ga zircons in quartzites and metapelites from comparably old greenstone belts within less than 150 km of the studied locality. Comparison of the Pb-isotope ratios of the Mushandike stromatolites with 2.7 and 2.6 Ga old stromatolites from the neighbouring, Belingwe Greenstone Belt demonstrates differences in initial isotope composition that relate to the extent of exchange with the open ocean. The development of numerous basins on old continental crust, with water masses variably restricted from the open ocean. suggests a lack of strong vertical topography on this late Archaean craton. (C) 2004 Elsevier B.V. All rights reserved.

A new estimate for the composition of weathered young upper continental crust from alluvial sediments, Queensland, Australia

We present new major element, trace element and Nd-isotope data for 30 alluvial sediments collected from 25 rivers in Queensland, E Australia. Samples were chosen to represent drainage from the region's most important lithologies, including Tertiary intraplate volcanic rocks, a Cretaceous igneous province (and sedimentary rocks derived thereof) as well as Proterozoic blocks. In most chemical and isotopic aspects, the alluvial sediments represent binary or ternary mixing relationships, with absolute abundances implied to reflect the proportion of lithologies in the catchments. When averaged, the studied sediments differ from other proxies of upper continental crust (UCC) mainly in their relative middle rare earth element enrichment (including an elevated Sm/Nd ratio), higher relative Eu abundance and higher Nb/Ta ratio. These features are inherited from eroded Tertiary intraplate basalts, which commonly form topographic highs in the studied region. Despite the high degree of weathering strong to excellent coherence between similarly incompatible elements is found for all samples. From this coherence, we suggest revisions of the following upper crustal element ratios: Y/Ho = 26.2, Yb/Tm = 6.37, Th/W = 7.14, Th/Tl = 24 and Zr/Hf = 36.9. Lithium, Rb, Cs and Be contents do not seem depleted relative to UCC, which may reflect paucity of K-feldspar in the eroded catchments. Nickel, Cr, Pb, Cu and Zn concentrations are elevated in polluted rivers surrounding the state capital. River sediments in the Proterozoic Georgetown Inlier are elevated in Pb, Cu and Zn but this could be a natural phenomenon reflecting abundant sulphide mineralisation in the area. Except for relative Sr concentrations, which broadly anticorrelate with mean annual rainfall in catchments, there is no obvious relationship between the extent of weathering and climate types, which range from and to tropical. The most likely explanation for this observation is that the weathering profiles in many catchments are several Myr old, established during the much wetter Miocene period. The studied sediment compositions (excluding those from the Proterozoic catchments) are used to propose a new trace element normalisation termed MUQ (MUd from Queensland), which serves as an alternative to UCC proxies derived from sedimentary rocks. Copyright (C) 2005 Elsevier Ltd

Recommendations and guidelines for the performance of accurate heat transfer measurements in rapid forming processes

The published requirements for accurate measurement of heat transfer at the interface between two bodies have been reviewed. A strategy for reliable measurement has been established, based on the depth of the temperature sensors in the medium, on the inverse method parameters and on the time response of the sensors. Sources of both deterministic and stochastic errors have been investigated and a method to evaluate them has been proposed, with the help of a normalisation technique. The key normalisation variables are the duration of the heat input and the maximum heat flux density. An example of application of this technique in the field of high pressure die casting is demonstrated. The normalisation study, coupled with previous determination of the heat input duration, makes it possible to determine the optimum location for the sensors, along with an acceptable sampling rate and the thermocouples critical response-time (as well as eventual filter characteristics). Results from the gauge are used to assess the suitability of the initial design choices. In particular the unavoidable response time of the thermocouples is estimated by comparison with the normalised simulation. (c) 2006 Elsevier Ltd. All rights reserved.