Estudo e elaboração de um conjunto de regras para sintonia de performance em aplicações de banco de dados

Este artigo tem por objetivo apresentar parte do estudo realizado sobre sintonia de performance de banco de dados que consiste em levantar e propor um conjunto de regras que melhore o desempenho de aplicações de banco de dados. São apresentadas algumas considerações sobre sintonia de performance e os aspectos de implementação de sistema de banco de dados que causam impacto no desempenho da aplicação. As regras estudadas referemse á arquitetura do sistema gerenciador de banco de dados ORACLE utilizado como estudo de caso e uma delas é analisada para ilustrar o problema. Além disso, é definido um conjunto de cenários que representam contextos específicos de aplicações reais e que serão utilizados para validar a aplicabilidade das regras propostas. O conjunto de regras será testado para o conjunto de cenários através de um protótipo de ferramenta de tuning baseada em conhecimento. Tal ferramenta deverá auxiliar o administrador de banco de dados no diagnóstico de problemas de performance.The purpose of this article is to present a part of a study on database performance which consists of a survey of tuning situations and propose of a set of rules to improve performance of database applications. Some considerations about tuning will be done and the aspects of database system that cause impact on application performance will be presented. The studied rules rely on the ORACLE database management system architecture that has been used as a case study. Furthermore, one of rules is detailed in order to ilustrate the problem. In addition, a set of database production scenarios is defined which represents specific applications contexts that will be used to validate the proposed rules. The development of a prototype relying on a knowledge based diagnosys tool is under way. It shall be able to help database administrators in the identification of performance problems.Eje: Ingeniería de software. Bases de datosRed de Universidades con Carreras en Informática (RedUNCI

Estudo e elaboração de um conjunto de regras para sintonia de performance em aplicações de banco de dados

Este artigo tem por objetivo apresentar parte do estudo realizado sobre sintonia de performance de banco de dados que consiste em levantar e propor um conjunto de regras que melhore o desempenho de aplicações de banco de dados. São apresentadas algumas considerações sobre sintonia de performance e os aspectos de implementação de sistema de banco de dados que causam impacto no desempenho da aplicação. As regras estudadas referemse á arquitetura do sistema gerenciador de banco de dados ORACLE utilizado como estudo de caso e uma delas é analisada para ilustrar o problema. Além disso, é definido um conjunto de cenários que representam contextos específicos de aplicações reais e que serão utilizados para validar a aplicabilidade das regras propostas. O conjunto de regras será testado para o conjunto de cenários através de um protótipo de ferramenta de tuning baseada em conhecimento. Tal ferramenta deverá auxiliar o administrador de banco de dados no diagnóstico de problemas de performance.The purpose of this article is to present a part of a study on database performance which consists of a survey of tuning situations and propose of a set of rules to improve performance of database applications. Some considerations about tuning will be done and the aspects of database system that cause impact on application performance will be presented. The studied rules rely on the ORACLE database management system architecture that has been used as a case study. Furthermore, one of rules is detailed in order to ilustrate the problem. In addition, a set of database production scenarios is defined which represents specific applications contexts that will be used to validate the proposed rules. The development of a prototype relying on a knowledge based diagnosys tool is under way. It shall be able to help database administrators in the identification of performance problems.Eje: Ingeniería de software. Bases de datosRed de Universidades con Carreras en Informática (RedUNCI

COOKER, um Consultor para Elaporação de Cardápios

Este trabalho apresenta urna experiencia no dcscnvolvimento de um sistema especialista na área de nutrição (COOKER), que visa auxiliar a elaboração de cardápios de refeições. Sao salientadas as fases de desenvolvimiento dé um sistema especialista, dando enfase a fase de aquisição de conhecimento. O trabalho foi consolidado através da constru~io de urn protótipo corn represent~ño de conhecimento baseada em frames e regras. A modelagem do sistema e apresentada e, para cada fase do desenvolvimento, são mostradas as técnicas utilizadas.Eje: Inteligencia artificialRed de Universidades con Carreras en Informática (RedUNCI

COOKER, um Consultor para Elaporação de Cardápios

Este trabalho apresenta urna experiencia no dcscnvolvimento de um sistema especialista na área de nutrição (COOKER), que visa auxiliar a elaboração de cardápios de refeições. Sao salientadas as fases de desenvolvimiento dé um sistema especialista, dando enfase a fase de aquisição de conhecimento. O trabalho foi consolidado através da constru~io de urn protótipo corn represent~ño de conhecimento baseada em frames e regras. A modelagem do sistema e apresentada e, para cada fase do desenvolvimento, são mostradas as técnicas utilizadas.Eje: Inteligencia artificialRed de Universidades con Carreras en Informática (RedUNCI

Attentional Engagement Deficits in Dyslexic Children

Reading acquisition requires, in addition to appropriate phonological abilities, accurate and rapid selection of sublexical orthographic units by attentional letter string parsing. Spatio-temporal distribution of attentional engagement onto 3-pseudoletter strings was studied in 28 dyslexic and 55 normally reading children by measuring attentional masking (AM). AM refers to an impaired identification of the first of two sequentially presented masked objects (O1 and O2). In the present study, O1 was always centrally displayed, whereas the location of O2 (central or lateral) and the O1\u2013O2 interval were manipulated. Dyslexic children showed a larger AM at the shortest O1\u2013O2 interval and a sluggish AM recovery at the longest O1\u2013O2 interval, as well as an abnormal lateral AM. More importantly, these spatio-temporal deficits of attentional engagement were selectively present in dyslexics with poor phonological decoding skills. Our results suggest that an inefficient spatio-temporal distribution of attentional engagement \u2013 probably linked to a parietal lobule dysfunction \u2013 might selectively impair the letter string parsing mechanism during phonological decoding

Impact of Histology and Tumor Grade on Clinical Outcomes Beyond 5 Years of Follow-Up in a Large Cohort of Renal Cell Carcinomas

Introduction: The optimal length for clinical follow-up of renal cell carcinoma (RCC) patients is unclear. We evaluated the impact of ISUP/WHO tumor grade and histological subtype on short- and long-term survival and risk of recurrence/metastasis in a large cohort of RCC patients. Patients and Methods: We studied 1679 RCC patients from a single referral center in Italy. Adjusted hazard ratios for overall survival were estimated using Cox regression models. Adjusted absolute risk of developing recurrence or metastasis was computed considering competing risks of mortality. Results: During up to 13 years of follow-up, 175 (10.4%) RCC patients died, of whom 92% beyond 5 years. Hazard ratio of grade IV clear cell carcinomas (ccRCC) was 3.82 compared to grade II. Notably, 33% of recurrences and 56% of distant metastases occurred beyond 5 years of follow-up. The estimated probabilities of recurrence/metastasis were 15% and 45% within and beyond 5 years of follow-up, respectively. After 5 years, the absolute risk of recurrences increased also for papillary renal cell carcinoma type I (35.2%) and grade I ccRCC (17%). Conclusion: After 5 years of follow-up, both risk of mortality and recurrences or metastases were high and were modified by histological types and tumor grade. These data strongly support histology- and grade-tailored surveillance strategies and long-term follow-up for RCC patients

Publisher Correction: Variations in Dysbindin-1 are associated with cognitive response to antipsychotic drug treatment.

In the original version of this Article, references in the Methods section incorrectly referred to references in the Supplementary References section. The relevant references (now numbered 20, 27, 42, 47, 69-80) have been removed from the Supplementary References section of the Supplementary Information file and added to the References section of the main manuscript, in both the PDF and HTML versions of the Article

Publisher Correction: Variations in Dysbindin-1 are associated with cognitive response to antipsychotic drug treatment.

In the original version of this Article, references in the Methods section incorrectly referred to references in the Supplementary References section. The relevant references (now numbered 20, 27, 42, 47, 69-80) have been removed from the Supplementary References section of the Supplementary Information file and added to the References section of the main manuscript, in both the PDF and HTML versions of the Article