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)

Human mobility patterns at the smallest scales

We present a study on human mobility at small spatial scales. Differently from large scale mobility, recently studied through dollar-bill tracking and mobile phone data sets within one big country or continent, we report Brownian features of human mobility at smaller scales. In particular, the scaling exponents found at the smallest scales is typically close to one-half, differently from the larger values for the exponent characterizing mobility at larger scales. We carefully analyze 12-month data of the Eduroam database within the Portuguese university of Minho. A full procedure is introduced with the aim of properly characterizing the human mobility within the network of access points composing the wireless system of the university. In particular, measures of flux are introduced for estimating a distance between access points. This distance is typically non-Euclidean, since the spatial constraints at such small scales distort the continuum space on which human mobility occurs. Since two different ex- ponents are found depending on the scale human motion takes place, we raise the question at which scale the transition from Brownian to non-Brownian motion takes place. In this context, we discuss how the numerical approach can be extended to larger scales, using the full Eduroam in Europe and in Asia, for uncovering the transi- tion between both dynamical regimes.

A domain-specific language for ETL patterns specification in Data Warehousing Systems

During the last few years many research efforts have been done to improve the design of ETL (Extract-Transform-Load) systems. ETL systems are considered very time-consuming, error-prone and complex involving several participants from different knowledge domains. ETL processes are one of the most important components of a data warehousing system that are strongly influenced by the complexity of business requirements, their changing and evolution. These aspects influence not only the structure of a data warehouse but also the structures of the data sources involved with. To minimize the negative impact of such variables, we propose the use of ETL patterns to build specific ETL packages. In this paper, we formalize this approach using BPMN (Business Process Modelling Language) for modelling more conceptual ETL workflows, mapping them to real execution primitives through the use of a domain-specific language that allows for the generation of specific instances that can be executed in an ETL commercial tool.

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.

Description of behavioral patterns of Podocnemis erythrocephala (Spix, 1824) (Testudines: Podocnemididae) (Red-headed river turtle) in captivity, Manaus, Amazonas, Brazil

The biology and ecology of South American turtles is still poorly known, particularly, for the Brazilian species. Laboratory studies are essential to understand the life cycles of aquatic turtles species and to help in formulating management plans for their conservation. As a contribution to the knowledge of Podocnemis erythrocephala species, we give a description of its species-typical behaviors, categorized as: maintenance, locomotion, feeding, agonistic and reproduction, based on captives observations of four pairs of turtles in an aquarium in Manaus, Brazil. Similarities and differences with the repertoires of other turtle species are discussed, concluding that turtles have much more complex adaptative strategies and social life than was believed.

Recurrence relations for Clifford algebra-valued orthogonal polynomials

The theory of orthogonal polynomials of one real or complex variable is well established as well as its generalization for the multidimensional case. Hypercomplex function theory (or Clifford analysis) provides an alternative approach to deal with higher dimensions. In this context, we study systems of orthogonal polynomials of a hypercomplex variable with values in a Clifford algebra and prove some of their properties.

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.

Patterns of Mycobacterium tuberculosis-complex excretion and characterization of super-shedders in naturally-infected wild boar and red deer

Wild boar (Sus scrofa) and red deer (Cervus elaphus) are the main maintenance hosts for bovine tuberculosis (bTB) in continental Europe. Understanding Mycobacterium tuberculosis complex (MTC) excretion routes is crucial to define strategies to control bTB in free-ranging populations, nevertheless available information is scarce. Aiming at filling this gap, four different MTC excretion routes (oronasal, bronchial-alveolar, fecal and urinary) were investigated by molecular methods in naturally infected hunter-harvested wild boar and red deer. In addition MTC concentrations were estimated by the Most Probable Number method. MTC DNA was amplified in all types of excretion routes. MTC DNA was amplified in at least one excretion route from 83.0% (CI95 70.8-90.8) of wild ungulates with bTB-like lesions. Oronasal or bronchial-alveolar shedding were detected with higher frequency than fecal shedding (p < 0.001). The majority of shedders yielded MTC concentrations <10(3) CFU/g or mL. However, from those ungulates from which oronasal, bronchial-alveolar and fecal samples were available, 28.2% of wild boar (CI95 16.6-43.8) and 35.7% of red deer (CI95 16.3-61.2) yielded MTC concentrations >10(3) CFU/g or mL (referred here as super-shedders). Red deer have a significantly higher risk of being super-shedders compared to wild boar (OR = 11.8, CI95 2.3-60.2). The existence of super-shedders among the naturally infected population of wild boar and red deer is thus reported here for the first time and MTC DNA concentrations greater than the minimum infective doses were estimated in excretion samples from both species.

Diversity of sand flies in domiciliary environment of Santarém, state of Pará, Brazil: species composition and abundance patterns in rural and urban areas

This paper aimed to evaluate the richness, abundance and frequency of sand fly occurrence in rural and urban areas American visceral Leishmaniasis -AVL is endemic in the study area of Santarém municipality, Pará state. Sand flies were collected during 1995-2000, using CDC light traps placed in neighborhoods and rural areas of the municipality. A total of 53.454 individuals and 26 species of sand flies were collected. The most abundant species in both urban and rural environments was Lutzomyia longipalpis, vector of AVL in the area. The highest species richness by capture was in rural area. In all years sampled, the largest number of species of sand fly collected was always in rural areas. The species of sand flies in urban and rural area were similar in 11 species. In the rural area other 11 species were found, a total of 22 species. Shannon-Wiener index ranged from 0.12 to 0.84 at rural areas and 0.08 to 0.34 at urban ones. In general, rural localities showed higher diversity (H') of phlebotomines than urban ones. Individual-based rarefaction curves for each area demonstrated that urban localities had the lowest expected number of phlebotomine species and the richest rural ones reach higher expected values with lower amount of individuals than urban sites. The most frequent species were Lutzomyia longipalpis, Evandromyia carmelinoi and Bichromomyia flaviscutellata.

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.

Cognitive functioning and efficacy of cognitive intervention in Multiple Sclerosis

Tese de Doutoramento em Psicologia Clínica / Psicologia

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.