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.

Apical limit of root canal filling and its relationship with success on endodontic treatment of a mandibular molar: 11-year follow-up

Objective. This article discusses the relationship between apical limit of root canal filling and success on endodontic treatment of a mandibular molar. Study design. A mandibular right first molar with vital pulp was endodontically treated, and 3 years later periapical lesions on mesial and distal roots were detected. The canals were retreated and obturated to the same levels as in the previous treatment. Results. An 8-year radiographic follow-up showed repair of the periapical lesions on both roots. Conclusions. Results suggest that the apical limit of obturation seems to have no influence in the repair of periapical tissues in mandibular molars. (Oral Surg Oral Med Oral Pathol Oral Radiol Endod 2011; 112: e48-e50)

Quantitative 3D profilometry and SEM analysis of the adaptation of root-end filling materials placed under an optical microscope

P>Aim To evaluate by 3D profilometry and scanning electron microscopy (SEM), the marginal adaptation of mineral trioxide aggregate (MTA) and Sealer 26 placed in root-end cavities with direct vision or under an optical microscope. Methodology The root ends of 52 root filled canine teeth were filled with MTA or Sealer 26 under direct vision or optical microscope (n = 13). In each group, eight specimens were analysed by profilometry for measurement of the area and depth of gaps. In the other five specimens, gap area was measured using SEM to verify marginal adaptation and surface characteristic. Data were analysed by parametric (anova and Tukey) and non-parametric (Kruskal-Wallis and Dunn) tests. Results The assessment of the adaptation of both materials to dentine was not influenced by the mode of visualization, which was confirmed by both profilometry and SEM observations. The voids measured with profilometry for Sealer 26 under direct vision were significantly wider and deeper than those for MTA under direct vision (P < 0.05). In SEM, significantly larger gap areas were observed with Sealer 26 (P < 0.05). Conclusion Root-end cavities filled with MTA had smaller gaps and better marginal adaptation than Sealer 26.

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.

Acquired central diabetes insipidus in children: A 12 year Brisbane experience

Objective: To study the clinical, endocrine and radiological features and progress of children presenting with acquired diabetes insipidus (CDI). Methodology: Chart review of children presenting because of CDI to Brisbane paediatric endocrine clinics between 1987 and 1999. Results: Thirty-nine children (female/male ratio 21/18) aged 0.1-15.4 years (mean age 6.7 years) were identified. Aetiologies were head trauma or familial in eight cases (20.5%) each, central nervous system (CNS) tumours in five cases (12.8%), CNS malformations in four cases (10.2%), histiocytosis in three cases (7%) and hypoxia and infection in two cases (5.1%) each. Seven cases (17.9%) remain undiagnosed. Of the 32 (82%) cases with isolated anti-diuretic hormone deficiency at presentation, 24 cases (61.5%) experienced no further endocrine deficit. Additional endocrine deficits occurred mainly in the tumour or undiagnosed groups. On follow-up brain magnetic resonance imaging (MRI) scans in the seven undiagnosed cases, six patients bad mild or no change and one patient had marked improvement of MRI findings. These changes occurred 10-48 months (mean 18 months) after presentation. Conclusions: Children without an aetiological diagnosis for the uncommon condition of acquired CDI require careful follow-up. More intensive investigation at presentation (e.g. estimation of cerebrospinal fluid human chorionic gonadotrophin) promises to lessen the number of such cases. Pituitary stalk biopsies should be reserved for those patients with progressive MRI changes. If these changes do not occur early, our experience suggests that follow-up MRI scans may need to be performed only yearly.

Prediction of mortality using dobutamine echocardiography

OBJECTIVES We sought to find out whether dobutamine echocardiography (DbE) could provide independent prediction of total and cardiac mortality, incremental to clinical and angiographic variables. BACKGROUND Existing outcome studies with DbE have examined composite end points, rather than death, over a relatively short follow-up. METHODS Clinical and stress data were collected in 3,156 patients (age 63 +/- 12 years, 1,801 men) undergoing DbE. Significant stenoses (>50% diameter) were identified in 70% of 1,073 patients undergoing coronary angiography. Total and cardiac mortality were identified over nine years of follow-up (mean 3.8 +/- 1.9). Cox models were used to analyze the effect of ischemia and other variables, independent of other determinants of mortality. RESULTS The dobutamine echocardiogram was abnormal in 1,575 patients (50%). Death occurred in 716 patients (23%), 259 of whom (8%) were thought to have died from cardiac causes. Patients with normal DbE had a total mortality of 8% per year and a cardiac mortality of 1% per year over the first four years of follow-up. Ischemia and the extent of abnormal wall motion were independent predictors of cardiac death, together with age and heart failure. In sequential Cox models, the predictive power of clinical data alone (model chi-square 115) was strengthened by adding the resting left ventricular function (model chi-square 138) and the results of DbE (model chi-square 181). In the subgroup undergoing coronary angiography, the power of the model was increased to a minor degree by the addition of coronary anatomy data. CONCLUSIONS Dobutamine echocardiography is an independent predictor of death, incremental to other data. While a normal dobutamine echocardiogram predicts low risk of cardiac death ton the order of 1% per year), this risk increases with the extent of abnormal wall motion at rest and stress, (J Am Coil Cardiol 2001;37:754-60) (C) 2001 by the American College of Cardiology.

Operative treatment of ankle fractures: A minimum ten-year follow-up

The long-term outcome of 25 patients with bimalleolar fractures of the ankle was assessed ten to fourteen years following their fractures using the Phillips scoring system. All patients had undergone open reduction and anatomical internal fixation (as described in their operative notes in the medical records). 52 % of patients had a good or excellent overall outcome while 24% had a poor overall outcome. This study has the longest follow-up period (10 to 14 years) to date on the outcomes of internal fixation of bimalleolar ankle fractures and demonstrates a higher percentage of poorer outcomes than has been previously described. This trend appears to be predictable as other studies with shorter term follow-up have already established a trend of increasing radiological evidence of post-traumatic arthritis with successively longer-term outcome reports.

Outcomes of transient evoked otoacoustic emission testing in 6-year-old school children: A comparison with pure tone screening and tympanometry

Objectives: (1) To establish test performance measures for Transient Evoked Otoacoustic Emission testing of 6-year-old children in a school setting; (2) To investigate whether Transient Evoked Otoacoustic Emission testing provides a more accurate and effective alternative to a pure tone screening plus tympanometry protocol. Methods: Pure tone screening, tympanometry and transient evoked otoacoustic emission data were collected from 940 subjects (1880 ears), with a mean age of 6.2 years. Subjects were tested in non-sound-treated rooms within 22 schools. Receiver operating characteristics curves along with specificity, sensitivity, accuracy and efficiency values were determined for a variety of transient evoked otoacoustic emission/pure tone screening/tympanometry comparisons. Results: The Transient Evoked Otoacoustic Emission failure rate for the group was 20.3%. The failure rate for pure tone screening was found to be 8.9%, whilst 18.6% of subjects failed a protocol consisting of combined pure tone screening and tympanometry results. In essence, findings from the comparison of overall Transient Evoked Otoacoustic Emission pass/fail with overall pure tone screening pass/fail suggested that use of a modified Rhode Island Hearing Assessment Project criterion would result in a very high probability that a child with a pass result has normal hearing (true negative). However, the hit rate was only moderate. Selection of a signal-to-noise ratio (SNR) criterion set at greater than or equal to 1 dB appeared to provide the best test performance measures for the range of SNR values investigated. Test performance measures generally declined when tympanometry results were included, with the exception of lower false alarm rates and higher positive predictive values. The exclusion of low frequency data from the Transient Evoked Otoacoustic Emission SNR versus pure tone screening analysis resulted in improved performance measures. Conclusions: The present study poses several implications for the clinical implementation of Transient Evoked Otoacoustic Emission screening for entry level school children. Transient Evoked Otoacoustic Emission pass/fail criteria will require revision. The findings of the current investigation offer support to the possible replacement of pure tone screening with Transient Evoked Otoacoustic Emission testing for 6-year-old children. However, they do not suggest the replacement of the pure tone screening plus tympanometry battery. (C) 2001 Elsevier Science Ireland Ltd. All rights reserved.