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.

Genetic covariance among measures of information processing speed, working memory, and IQ

The genetic relationship between lower (information processing speed), intermediate (working memory), and higher levels (complex cognitive processes as indexed by IQ) of mental ability was studied in a classical twin design comprising 166 monozygotic and 190 dizygotic twin pairs. Processing speed was measured by a choice reaction time (RT) task (2-, 4-, and 8-choice), working memory by a visual-spatial delayed response task, and IQ by the Multidimensional Aptitude Battery. Multivariate analysis, adjusted for test-retest reliability, showed the presence of a genetic factor influencing all variables and a genetic factor influencing 4- and 8-choice RTs, working memory, and IQ. There were also genetic factors specific to 8-choice RT, working memory, and IQ. The results confirmed a strong relationship between choice RT and IQ (phenotypic correlations: -0.31 to -0.53 in females, -0.32 to -0.56 in males; genotypic correlations: -0.45 to -0.70) and a weaker but significant association between working memory and IQ (phenotypic: 0.26 in females, 0.13 in males; genotypic: 0.34). A significant part of the genetic variance (43%) in IQ was not related to either choice RT or delayed response performance, and may represent higher order cognitive processes.

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

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.

Evaluation of liquid Bacillus thuringiensis var. israelensis products for control of Australian Aedes arbovirus vectors

Laboratory bioassay studies were conducted in southeast Queensland, Australia,: on the efficacy of Teknar (R), VectoBac (R) 12AS, and Cybate (R) (active ingredient: 1,200 international toxic units Bacillus thuringiensis var, israelensis [Bti]) against 3rd instars of the arbovirus vectors Aedes aegypti. Ae. notoscriptus, Ae. vigilax, and Ae. camptorhynchus. Probit analyses were then used to determine LD,, (median lethal dose), LD95, and lethal dose ratios (LDR). Aedes aegypti and Ae. notoscriptus, both container-habitat species, tolerated the highest Bti concentrations compared with saltmarsh Ae. vigilax and Ae. camptorhynchus. For example, the LDR for Ae. vigilax versus Ae. notoscriptus exposed to Cybate was 0.14 (95% confidence limit [CL] 0.03-0.61). Similarly, the Cybate LDR for Ae. camptorhynchus versus Ae. notoscriptus was 0.22 (95% CL 0.07-0.70). Teknar produced similar results with an LDR of 0.21 (95% CL 0.04-1.10) for Aedes vigilax versus Aedes notoscriptus. Differences in product efficacy were found when tested against the 2 container-breeding species. Cybate was less effective than Teknar with LDRs of 1.55 (95% CL 0.65-3.67) and 1.87 (95% CL 0.68-5.15) for Aedes aegypti and Ae. notoscriptus, respectively. The significant differences in susceptibility between mosquito species and varying efficacy between products highlight the importance of evaluating concentration-response data prior to contracting with distributors of mosquito control products. This information is crucial to resistance management strategies.

Treatment outcome in individuals with chronic pain: is the Pain Stages of Change Questionnaire (PSOCQ) a useful tool? Jenny StrongCorresponding Author Contact Information, E-mail The Corresponding Author, a, Kym Westburya, Glen Smithb, Ian McKenziec and William Ryan

The efficacy of psychological treatments emphasising a self-management approach to chronic pain has been demonstrated by substantial empirical research. Nevertheless, high drop-out and relapse rates and low or unsuccessful engagement in self-management pain rehabilitation programs have prompted the suggestion that people vary in their readiness to adopt a self-management approach to their pain. The Pain Stages of Change Questionnaire (PSOCQ) was developed to assess a patient's readiness to adopt a self-management approach to their chronic pain. Preliminary evidence has supported the PSOCQ's psychometric properties. The current study was designed to further examine the psychometric properties of the PSOCQ, including its reliability, factorial structure and predictive validity. A total of 107 patients with an average age of 36.2 years (SD = 10.63) attending a multi-disciplinary pain management program completed the PSOCQ, the Pain Self-Efficacy Questionnaire (PSEQ) and the West Haven-Yale Multidimensional Pain Inventory (WHYMPI) pre-admission and at discharge from the program. Initial data analysis found inadequate internal consistencies of the precontemplation and action scales of the PSOCQ and a high correlation (r = 0.66, P < 0.01) between the action and maintenance scales. Principal component analysis supported a two-factor structure: 'Contemplation' and 'Engagement'. Subsequent analyses revealed that the PSEQ was a better predictor of treatment outcome than the PSOCQ scales. Discussion centres upon the utility of the PSOCQ in a clinical pain setting in light of the above findings, and a need for further research. (C) 2002 International Association for the Study of Pain. Published by Elsevier Science B.V. All rights reserved.

Mapping intertidal habitats and an evaluation of their conservation status in Queensland, Australia

The goal of biodiversity conservation has been described as the conservation of diversity at three levels: ecosystem, species and genetic diversity. Developing a representative system of marine protected areas (MPAs) is considered an effective way to achieve this goal in the marine environment. In the absence of detailed information relating to biological distributions there has been increasing use of biodiversity surrogates to determine MPA priorities at regional levels. The development of biodiversity surrogates at fine scales (i.e. habitats) will have an increasingly important role in the identification of sites that will contribute to a representative system of MPAs. This is because it will increase the likelihood that the system will adequately achieve biodiversity objectives by ensuring protection of a greater range of habitats and species. This article provides an explanation of an intertidal shoreline habitat surrogate used to describe 24,216km of Queensland's coastline. The protective status of intertidal habitats was evaluated to assist with designing a representative system of intertidal MPAs. (C) 2002 Elsevier Science Ltd. All rights reserved.

Evaluation of an internet-based physical activity intervention: A preliminary investigation

The Internet has the potential for delivering innovative, interactive physical activity (PA) interventions to large numbers of people. This study was designed to test the efficacy. of ant Internet intervention that consisted of a Web site plus 12 weekly e-mail tip sheets, compared with a waiting list control group. The Internet intervention was theory based and emphasized clear, graphical presentation of PA information. Sixty-five (30 intervention and 35 control) sedentary adult employees of several large hospitals (9 men and 56 women) were randomly assigned to 1 of the 2 study arms. Of the 65 participants, 57 completed the 1-month follow-up, and 52 completed the 3-month follow-up. At both 1 and 3 months, those in the intervention group were significantly more likely to have progressed, in stage of motivational readiness for PA than participants in the control group: 1 month, chi(2)(1, N = 52) = 4.05, p

As relações sons e letras e letras e sons em livros didáticos de alfabetização (PNLD 2010) : limitações e desafios ao encontro de uma abordagem discursiva de linguagem

Este estudo teve como foco inicial de investigação o modo como livros didáticos de alfabetização propõem o estudo das relações entre sons e letras e letras e sons, e como essa dimensão se articula (ou não) a uma concepção de alfabetização que toma o texto como unidade de ensino. Caracteriza-se como uma pesquisa de cunho documental, trazendo para estudo produções acadêmico-científicas acerca da temática de investigação, tendências teóricas no estudo da alfabetização, o processo histórico da política de avaliação de livros didáticos no Brasil, o Guia de livros didáticos – PNLD 2010 – letramento e alfabetização – língua portuguesa – 2009 e duas coleções de livros didáticos de alfabetização, quais sejam: A Escola é Nossa – Letramento e Alfabetização Linguística; e Porta Aberta – Letramento e Alfabetização Linguística, avaliadas e selecionadas pelo Programa Nacional do Livro Didático (PNLD), na edição de 2009, para o ano letivo de 2010. Assume a hipótese de que a proposta de trabalho com as relações sons e letras e letras e sons trazida pelos livros didáticos de alfabetização, no contexto do letramento, por não tomar o texto como unidade de ensino, acaba por criar obstáculos para a própria compreensão dessas relações pelos estudantes. Toma como princípios teóricos e metodológicos a abordagem bakhtiniana de linguagem, bem como a concepção de alfabetização que baliza este estudo (GONTIJO; SCHWARTZ, 2009). Conclui que, ao não trazer os textos (gêneros discursivos) como enunciados, indiferentes à alternância dos sujeitos do discurso, os livros analisados, não obstante as poucas diferenças existentes entre um e outro, que se referem mais especificamente a informações que tangem à linguística, vão ao encontro de uma concepção de linguagem como um sistema de normas que devem ser anteriormente internalizadas pelo estudante para que este possa proceder à leitura e à escrita. Tratam, pois, a língua materna como uma língua estrangeira ou morta, como se esta fosse estática, permanecendo imune à evolução histórica. O estudo corroborou a hipótese de investigação, uma vez que, desconsiderando e/ou desconhecendo o aspecto dialógico do enunciado, os livros analisados minimizam a possibilidade da instauração de uma abordagem discursiva de linguagem, o que incide no tratamento das relações sons e letras e letras e sons que acabam por apresentarem-se dicotomizadas do texto e seu contexto discursivo e, dessa forma, sua reflexão e sistematização pelos estudantes distancia-se de um estudo dessas relações no bojo dos aspectos sócio-históricos, ideológicos, linguísticos, estilísticos, dentre outros que perpassam seu ensino. Logo, por não propiciarem um tratamento discursivo da linguagem, pouco contribuem para um tratamento “linguístico” adequado, acabando por criar obstáculos para a compreensão dessas relações pelos estudantes. Entende que conhecimentos linguísticos, principalmente referentes às variedades linguísticas e dialetais, tornam-se importantes quando da abordagem dessas relações, entretanto, estes por si sós não garantem sua apropriação. Ressalta o necessário conhecimento por parte dos professores (e autores) acerca da abordagem linguística tomada pelo livro didático de alfabetização e o resgate da autoria docente diante do ensino da língua materna, instaurando um processo autoral-dialógico da produção de conhecimentos junto aos estudantes.

Use of performance information by local politicians: a field study in the Portuguese context.

This paper seeks to investigate the use of performance information by politicians and whether the institutional reforms on performance management (PM) have been operationalized by local politicians. Differences on the policy field and the organizational context have been analyzed. Our goal is contribute to knowledge on PM in the political sphere and understand the different responses of politicians to government change initiatives (mainly coercive pressures). Our findings show that local politicians support the notion that greater attention should be devoted to the use of performance information on the evaluation process. Nevertheless they are very skeptic in relation to effective execution of government reforms. There is an internal culture where agencies are embedded, strongly influenced by the high degree of politicisation among senior managers, that lead politicians to be more concerned about personal opinions and informal performance information rather than to use more sophisticated information (output and outcome measures). The institutional approach helps us to identify political responses to institutional pressures and understand the reasons for a reduced use in the Portuguese context.

Access to information: assessment of the use of automated interaction technologies in call centers

With the purpose of at lowering costs and reendering the demanded information available to users with no access to the internet, service companies have adopted automated interaction technologies in their call centers, which may or may not meet the expectations of users. Based on different areas of knowledge (man-machine interaction, consumer behavior and use of IT) 13 propositions are raised and a research is carried out in three parts: focus group, field study with users and interviews with experts. Eleven automated service characteristics which support the explanation for user satisfaction are listed, a preferences model is proposed and evidence in favor or against each of the 13 propositions is brought in. With balance scorecard concepts, a managerial assessment model is proposed for the use of automated call center technology. In future works, the propositions may become verifiable hypotheses through conclusive empirical research.

Ambivalent implications of health care information systems: a study in the Brazilian public health care system

This article evaluates social implications of the "SIGA" Health Care Information System (HIS) in a public health care organization in the city of São Paulo. The evaluation was performed by means of an in-depth case study with patients and staff of a public health care organization, using qualitative and quantitative data. On the one hand, the system had consequences perceived as positive such as improved convenience and democratization of specialized treatment for patients and improvements in work organization. On the other hand, negative outcomes were reported, like difficulties faced by employees due to little familiarity with IT and an increase in the time needed to schedule appointments. Results show the ambiguity of the implications of HIS in developing countries, emphasizing the need for a more nuanced view of the evaluation of failures and successes and the importance of social contextual factors.

Fungi, bacteria and pollens seasonally quantified at 3 basic schools in Lisbon: evaluation of ventilation need

Nowadays, most individuals spend about 80% of their time indoor and, consequently, the exposure to the indoor environment becomes more relevant than to the outdoor one. Children spend most of their time at home and at school and evaluations of their indoor environment are important for the time-weighted exposure. Due to their airways still in development, children are a sensitive group with higher risk than adults. Larger impact in health and educational performance of children demand indoor air quality studies of schools. The aim of this study was to assess the children exposure to bioaerosols. A methodology based upon passive sampling was applied to evaluate fungi, bacteria and pollens; its procedures and applicability was optimized. An indoor air study by passive sampling represents an easier and cheaper method when comparing with the use of automatic active samplers. Furthermore, it is possible to achieve important quality information without interfering in the classroom activities. The study was conducted in three schools, representative of different environments in the Lisbon urban area, at three different periods of the year to obtain a seasonal variation, to estimate the variability through the city and to understand the underneath causes. Fungi and bacteria were collected indoor and outdoor of the classrooms to determine the indoor/outdoor ratios and to assess the level of outdoor contamination upon the indoor environment. The children's exposure to pollen grains inside the classrooms was also assessed.

Evaluation of dog population in an urban area of Southeastern Brazil

Planning control programs, for diseases such as rabies requires information on the size and structure of the dog and cat population. In order to evaluate the dog population of the urban area of Araçatuba city, S. Paulo State, Brazil, a survey was conducted using a questionnaire to interview members of households. Eighty-eight districts were visited (37,778 houses) and the interview was possible at 77.93% of these. Human population size evaluated was 113,157 inhabitants. Houses that owned animals represented 55.2%, 26,926 of the animals concerned were dogs and 5,755 were cats. Of the dogs, 56.64% were 1-4 year olds and males represented 56.2% of the total population. Dog: person ratio was estimated at 2.8 dogs to every 10 persons, almost 3 times the ratio hitherto estimated and used in the planning of rabies vaccination campaigns.

Comparative evaluation of underlying causes of death processed by the Automated Classification of Medical Entities and the Underlying Cause of Death Selection Systems

INTRODUCTION: The correct identification of the underlying cause of death and its precise assignment to a code from the International Classification of Diseases are important issues to achieve accurate and universally comparable mortality statistics These factors, among other ones, led to the development of computer software programs in order to automatically identify the underlying cause of death. OBJECTIVE: This work was conceived to compare the underlying causes of death processed respectively by the Automated Classification of Medical Entities (ACME) and the "Sistema de Seleção de Causa Básica de Morte" (SCB) programs. MATERIAL AND METHOD: The comparative evaluation of the underlying causes of death processed respectively by ACME and SCB systems was performed using the input data file for the ACME system that included deaths which occurred in the State of S. Paulo from June to December 1993, totalling 129,104 records of the corresponding death certificates. The differences between underlying causes selected by ACME and SCB systems verified in the month of June, when considered as SCB errors, were used to correct and improve SCB processing logic and its decision tables. RESULTS: The processing of the underlying causes of death by the ACME and SCB systems resulted in 3,278 differences, that were analysed and ascribed to lack of answer to dialogue boxes during processing, to deaths due to human immunodeficiency virus [HIV] disease for which there was no specific provision in any of the systems, to coding and/or keying errors and to actual problems. The detailed analysis of these latter disclosed that the majority of the underlying causes of death processed by the SCB system were correct and that different interpretations were given to the mortality coding rules by each system, that some particular problems could not be explained with the available documentation and that a smaller proportion of problems were identified as SCB errors. CONCLUSION: These results, disclosing a very low and insignificant number of actual problems, guarantees the use of the version of the SCB system for the Ninth Revision of the International Classification of Diseases and assures the continuity of the work which is being undertaken for the Tenth Revision version.