Scaling In-Memory databases on multicores

Current computer systems have evolved from featuring only a single processing unit and limited RAM, in the order of kilobytes or few megabytes, to include several multicore processors, o↵ering in the order of several tens of concurrent execution contexts, and have main memory in the order of several tens to hundreds of gigabytes. This allows to keep all data of many applications in the main memory, leading to the development of inmemory databases. Compared to disk-backed databases, in-memory databases (IMDBs) are expected to provide better performance by incurring in less I/O overhead. In this dissertation, we present a scalability study of two general purpose IMDBs on multicore systems. The results show that current general purpose IMDBs do not scale on multicores, due to contention among threads running concurrent transactions. In this work, we explore di↵erent direction to overcome the scalability issues of IMDBs in multicores, while enforcing strong isolation semantics. First, we present a solution that requires no modification to either database systems or to the applications, called MacroDB. MacroDB replicates the database among several engines, using a master-slave replication scheme, where update transactions execute on the master, while read-only transactions execute on slaves. This reduces contention, allowing MacroDB to o↵er scalable performance under read-only workloads, while updateintensive workloads su↵er from performance loss, when compared to the standalone engine. Second, we delve into the database engine and identify the concurrency control mechanism used by the storage sub-component as a scalability bottleneck. We then propose a new locking scheme that allows the removal of such mechanisms from the storage sub-component. This modification o↵ers performance improvement under all workloads, when compared to the standalone engine, while scalability is limited to read-only workloads. Next we addressed the scalability limitations for update-intensive workloads, and propose the reduction of locking granularity from the table level to the attribute level. This further improved performance for intensive and moderate update workloads, at a slight cost for read-only workloads. Scalability is limited to intensive-read and read-only workloads. Finally, we investigate the impact applications have on the performance of database systems, by studying how operation order inside transactions influences the database performance. We then propose a Read before Write (RbW) interaction pattern, under which transaction perform all read operations before executing write operations. The RbW pattern allowed TPC-C to achieve scalable performance on our modified engine for all workloads. Additionally, the RbW pattern allowed our modified engine to achieve scalable performance on multicores, almost up to the total number of cores, while enforcing strong isolation.

Bioactive nanocomposite spheres with proved shape memory capability in bone defects

Bioactive glass nanoparticles (BGNPs) promote an apatite surface layer in physiologic conditions that lead to a good interfacial bonding with bone.1 A strategy to induce bioactivity in non-bioactive polymeric biomaterials is to incorporate BGNPs in the polymer matrix. This combination creates a nanocomposite material with increased osteoconductive properties. Chitosan (CHT) is a polymer obtained by deacetylation of chitin and is biodegradable, non-toxic and biocompatible. The combination of CHT and the BGNPs aims at designing biocompatible spheres promoting the formation of a calcium phosphate layer at the nanocomposite surface, thus enhancing the osteoconductivity behaviour of the biomaterial. Shape memory polymers (SMP) are stimuli-responsive materials that offer mechanical and geometrical action triggered by an external stimulus.2 They can be deformed and fixed into a temporary shape which remains stable unless exposed to a proper stimulus that triggers recovery of their original shape. This advanced functionality makes such SMPs suitable to be implanted using minimally invasive surgery procedures. Regarding that, the inclusion of therapeutic molecules becomes attractive.  We propose the synthesis of shape memory bioactive nanocomposite spheres with drug release capability.3   1.  L. L. Hench, Am. Ceram. Soc. Bull., 1993, 72, 93-98. 2.  A. Lendlein and S. Kelch, Angew Chem Int Edit, 2002, 41, 2034-2057. 3.  Ã . J. Leite, S. G. Caridade and J. F. Mano, Journal of Non-Crystalline Solids (in Press)

Connecting free volume with shape memory properties in noncytotoxic gamma-irradiated polycyclooctene

The free volume holes of a shape memory polymer have been analysed considering that the empty space between molecules is necessary for the molecular motion, and the shape memory response is based on polymer segments acting as molecular switches through variable flexibility with temperature or other stimuli. Therefore, thermomechanical analysis (TMA) and positron annihilation lifetime spectroscopy (PALS) have been applied to analyse shape recovery and free volume hole sizes in gamma irradiated polycyclooctene (PCO) samples, as a non-cytotoxic alternative to more conventional PCO crosslinked via peroxide for future applications in medicine. Thus, a first approach relating structure, free volume holes and shape memory properties in gamma irradiated PCO is presented. The results suggest that free volume holes caused by gamma irradiation in PCO samples facilitate the recovery process by improving movement of polymer chains and open t possibilities for the design and control of the macroscopic response.

Enhanced resistive switching and multilevel behavior in bilayered HfAlO/HfAlOx structures for non-volatile memory applications

In this work, hafnium aluminum oxide (HfAlO) thin films were deposited by ion beam sputtering deposition technique on Si substrate. The presence of oxygen vacancies in the HfAlOx layer deposited in oxygen deficient environment is evidenced from the photoluminescence spectra. Furthermore, HfAlO(oxygen rich)/HfAlOx(oxygen poor) bilayer structures exhibit multilevel resistive switching (RS), and the switching ratio becomes more prominent with increasing the HfAlO layer thickness. The bilayer structure with HfAlO/HfAlOx thickness of 30/40 nm displays the enhanced multilevel resistive switching characteristics, where the high resistance state/ intermediate resistance state (IRS) and IRS/low resistance state resistance ratios are 102 and 5 105 , respectively. The switching mechanisms in the bilayer structures were investigated by the temperature dependence of the three resistance states. This study revealed that the multilevel RS is attributed to the coupling of ionic conduction and the metallic conduction, being the first associated to the formation and rupture of conductive filaments related to oxygen vacancies and the second with the formation of a metallic filament. Moreover, the bilayer structures exhibit good endurance and stability in time.

Effector memory CD4+ T cells are associated with cognitive performance in a senior population

Objective: Immunosenescence and cognitive decline are common markers of the aging process. Taking into consideration the heterogeneity observed in aging processes and the recently described link between lymphocytes and cognition, we herein explored the possibility of an association between alterations in lymphocytic populations and cognitive performance. Methods: In a cohort of cognitively healthy adults (n = 114), previously characterized by diverse neurocognitive/psychological performance patterns, detailed peripheral blood immunophenotyping of both the innate and adaptive immune systems was performed by flow cytometry. Results: Better cognitive performance was associated with lower numbers of effector memory CD4(+) T cells and higher numbers of naive CD8(+) T cells and B cells. Furthermore, effector memory CD4(+) T cells were found to be predictors of general and executive function and memory, even when factors known to influence cognitive performance in older individuals (e.g., age, sex, education, and mood) were taken into account. Conclusions: This is the first study in humans associating specific phenotypes of the immune system with distinct cognitive performance in healthy aging.

Transcranial direct current stimulation based metaplasticity protocols in working memory

It has been already shown that delivering tDCS that are spaced by an interval alters its impact on motor plasticity. These effects can be explained, based on metaplasticity in which a previous modification of activity in a neuronal network can change the effects of subsequent interventions in the same network. But to date there is limited data assessing metaplasticity effects in cognitive functioning.

Abnormal interactions between context, memory structure, and mood in schizophrenia: an ERP investigation

This study used event-related potentials to examine interactions between mood, sentence context, and semantic memory structure in schizophrenia. Seventeen male chronic schizophrenia and 15 healthy control subjects read sentence pairs after positive, negative, or neutral mood induction. Sentences ended with expected words (EW), within-category violations (WCV), or between-category violations (BCV). Across all moods, patients showed sensitivity to context indexed by reduced N400 to EW relative to both WCV and BCV. However, they did not show sensitivity to the semantic memory structure. N400 abnormalities were particularly enhanced under a negative mood in schizophrenia. These findings suggest abnormal interactions between mood, context processing, and connections within semantic memory in schizophrenia, and a specific role of negative mood in modulating semantic processes in this disease.

Eating habits and psychopathology: translation, adaptation, reliability of the Nutrition Behavior Inventory to Portuguese and relation to psychopathology

Objective: The Nutrition-Behavior Inventory (NBI) is a self-administered instrument that allows eating habits to be correlated with psychopathological symptoms. The objective was to translate and adapt the NBI to Portuguese, and test the Portuguese NBI’s reliability. The second aim was to verify its sensitivity for identification of risk factors in terms of behavior/eating habits in children and adolescents. Methods: The NBI was translated, adapted, and back-translated. The Portuguese version of the NBI was then applied (N = 96; 9-12 years). In order to verify the internal consistency, Cronbach’s alpha was used. The psychopathological indicators of the participants were accessed using the Child Behavior Checklist (CBCL). The mean CBCL scores were analyzed in relation to the NBI data (cutoff point: ≥ 30 with indicators, and < 30 without). Results: Internal consistency was high (Cronbach’s alpha = 0.89) for the NBI. The CBCL scores correlated significantly with NBI (> 30) on the following: anxiety and depression (p = 0.041), social difficulties (p = 0.028), attention problems (p = 0.001), aggressive behavior (p = 0.015); ADHD (p < 0.001), and conduct problems (p = 0.032). Conclusion: The present results indicate that the NBI is a reliable instrument. The NBI can be useful for evaluating psychopathological symptoms related to the eating habits and behaviors of children and adolescents.

Prodromal Questionnaire: translation, adaptation to Portuguese and preliminary results in ultra-high risk individuals and first episode psychosis

OBJECTIVE: The Prodromal Questionnaire (PQ) is a 92-item self-report screening tool for individuals at ultra-high risk (UHR) to develop psychosis. This study aims to present the translation to Portuguese and preliminary results in UHR and first episode (FE) psychosis in a Portuguese sample. METHODS: The PQ was translated from English to Portuguese by two bilingual researchers from the research program on early psychosis of the Instituto de Psiquiatria HCFMUSP, São Paulo, Brazil (ASAS - "Evaluation and Follow up of Adolescents and Young Adults in São Paulo") and back translated by two other researchers. The study participants (n = 11-) were evaluated through the Portuguese version of the Prodromal Questionnaire (PQ) and SIPS. RESULTS: The individuals at UHR (n = 7) presented a lower score than first episode patients (n = 4). The UHR mean scores and standard deviation on Portuguese version of the PQ were: 13.0 ± 10.0 points on positive symptoms subscale, and FE patients: 33.0 ± 10.0. CONCLUSION: The UHR and FE patients' of this study presented PQ scores similar to the ones found in the literature; what suggests that it is possible to use the PQ in Brazilian help-seeking individuals as a screening tool.

Personal and Social Performance (PSP) scale for patients with schizophrenia: translation to Portuguese, cross-cultural adaptation and interrater reliability

INTRODUCTION: Schizophrenia is a chronic mental disorder associated with impairment in social functioning. The most widely used scale to measure social functioning is the GAF (Global Assessment of Functioning), but it has the disadvantage of measuring at the same time symptoms and functioning, as described in its anchors. OBJECTIVES:Translation and cultural adaptation of the PSP, proposing a final version in Portuguese for use in Brazil. METHODS: We performed five steps: 1) translation; 2) back translation; 3) formal assessment of semantic equivalence; 4) debriefing; 5) analysis by experts. Interrater reliability (Intraclass correlation, ICC) between two raters was also measured. RESULTS: The final version was applied by two independent investigators in 18 adults with schizophrenia (DSM-IV-TR). The interrater reliability (ICC) was 0.812 (p < 0.001). CONCLUSION: The translation and adaptation of the PSP had an adequate level of semantic equivalence between the Portuguese version and the original English version. There were no difficulties related to understanding the content expressed in the translated texts and terms. Its application was easy and it showed a good interrater reliability. The PSP is a valid instrument for the measurement of personal and social functioning in schizophrenia.

A questionnaire to evaluate the impact of chronic diseases: validated translation and Illness Effects Questionnaire (IEQ) reliability study

INTRODUCTION: Patients' perception about their health condition, mainly involving chronic diseases, has been investigated in many studies and it has been associated to depression, compliance with the treatment, quality of life and prognosis. The Illness Effects Questionnaire (IEQ) is a tool which makes the standardized evaluation of patients' perception about their illness possible, so that it is brief and accessible to the different clinical settings. This work aims to begin the transcultural adaptation of the IEQ to Brazil through the validated translation and the reliability study. METHODS: The back-translation method and the test-retest reliability study were used in a sample of 30 adult patients under chronic hemodialysis. The reliability indexes were estimated using the Pearson, Spearman, Weighted Kappa and Cronbach's alpha coefficients. RESULTS: The semantic equivalence was reached through the validated translation. In this study, the reliability indexes obtained were respectively: 0.85 and 0.75 (p < 0.001); 0.68 and 0.92 (p < 0.0001). DISCUSSION: The reliability indexes obtained attest to the stability of responses in both evaluations. Additional procedures are necessary for the transcultural adaptation of the IEQ to be complete. CONCLUSION: The results indicate the translation validity and the reliability of the Brazilian version of the IEQ for the sample studied.

Hybrid hypervisor partially deployed on FPGA

Tese de Doutoramento em Engenharia Eletrónica e Computadores.

Investigation of cognition in schizophrenia: psychometric properties of instruments for assessing working memory updating

Objective This study describes the development of two updating measures of working memory (WM): Letter Updating Test (LUT) and Word Updating Test (WUT). Methods In stage 1, items were created and the instruments were assessed by experts and laymen. In stage 2, tests were given to 15 patients with schizophrenia and 15 paired controls. All were able to understand and respond to the instruments. In stage 3, 141 patients with schizophrenia and 119 healthy controls aged 18 to 60 took part; they were assessed on WM, processing speed (PS) and functional outcome. Results The results showed adequate rates of internal consistency for both measures developed, for both the total sample and each group separately, as well as evidence of convergent validity, discriminant validity and sensitivity to differentiate performance among the groups. Principal component analysis yielded two components, one for updating tests and other for PS measures, indicating factorial validity. Positive and significant, yet low, correlations were found with functionality measures. Conclusion These results provide adequate psychometric parameters for the measures developed, applicable to cognitive research settings in schizophrenia.

The use of canonical correlation analysis to assess the relationship between executive functioning and verbal memory in older adults

Executive functioning (EF), which is considered to govern complex cognition, and verbal memory (VM) are constructs assumed to be related. However, it is not known the magnitude of the association between EF and VM, and how sociodemographic and psychological factors may affect this relationship, including in normal aging. In this study, we assessed different EF and VM parameters, via a battery of neurocognitive/psychological tests, and performed a Canonical Correlation Analysis (CCA) to explore the connection between these constructs, in a sample of middle- aged and older healthy individuals without cognitive impairment (N = 563, 50+ years of age). The analysis revealed a positive and moderate association between EF and VM independently of gender, age, education, global cognitive performance level, and mood. These results confirm that EF presents a significant association with VM performance.