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.

Understanding impact readiness in Portugal’s social sector and designing a framework for capacity-building for social impact

This project is based on the theme of capacity-building in social organisations to improve their impact readiness, which is the predictability of delivering intended outcomes. All organisations which have a social mission, non-profit or for-profit, will be considered to fall within the social sector for the purpose of this work. The thesis will look at (i) what is impact readiness and what are the considerations for building impact readiness in social organisations, (ii) what is the international benchmark in measuring and building impact readiness, (iii) understand the impact readiness of Portuguese social organisations and the supply of capacity building for social impact in Portugal currently, and (iv) provide recommendations on the design of a framework for capacity building for impact readiness adapted to the Portuguese context. This work is of particular relevance to the Social Investment Laboratory, which is a sponsor of this project, in its policy work as part of the Portuguese Social Investment Taskforce (the “Taskforce”). This in turn will inform its contribution to the set-up of Portugal Inovação Social, a wholesaler catalyst entity of social innovation and social investment in the country, launched in early 2015. Whilst the output of this work will be set a recommendations for wider application for capacity-building programmes in Portugal, Portugal Inovação Social will also clearly have a role in coordinating the efforts of market players – foundations, corporations, public sector and social organisations – in implementing these recommendations. In addition, the findings of this report could have relevance to other countries seeking to design capacity building frameworks in their local markets and to any impact-driven organisations with an interest in enhancing the delivery of impact within their work.

O "Check-up" do conhecimento: aprender e avaliar

Relatório de estágio de mestrado em Educação Pré-Escolar e Ensino do 1.º do Ensino Básico

Shaking table tests of a two-storey log house

This paper presents the findings of an experimental campaign that was conducted to investigate the seismic behaviour of log houses. A two-storey log house designed by the Portuguese company Rusticasa® was subjected to a series of shaking table tests at LNEC, Lisbon, Portugal. The paper contains the description of the geometry and construction of the house and all the aspects related to the testing procedure, namely the pre-design, the setup, instrumentation and the testing process itself. The shaking table tests were carried out with a scaled spectrum of the Montenegro (1979) earthquake, at increasing levels of PGA, starting from 0.07g, moving on to 0.28g and finally 0.5g. The log house did not suffer any major damage and remained in working condition throughout the entire process. The preliminary analysis of the overall behaviour of the log house is also discussed.

Analysis of the seismic performance of a two storey log house

The dearth of knowledge on the load resistance mechanisms of log houses and the need for developing numerical models that are capable of simulating the actual behaviour of these structures has pushed efforts to research the relatively unexplored aspects of log house construction. The aim of the research that is presented in this paper is to build a working model of a log house that will contribute toward understanding the behaviour of these structures under seismic loading. The paper presents the results of a series of shaking table tests conducted on a log house and goes on to develop a numerical model of the tested house. The finite element model has been created in SAP2000 and validated against the experimental results. The modelling assumptions and the difficulties involved in the process have been described and, finally, a discussion on the effects of the variation of different physical and material parameters on the results yielded by the model has been drawn up.

Para cá e para lá dos muros: relações familiares na interface entre o interior e o exterior da prisão

Tese de Doutoramento em Sociologia

Educação para a sustentabilidade: O uso de Sistemas de Informação Geográfica Participativos como instrumento de participação de crianças e adolescentes na construção de sociedades mais sustentáveis

Tese de Doutoramento em Ciências da Educação (Área de Conhecimento: Educação ambiental e para a Sustentabilidade)

Metallic glass/PVDF magnetoelectric energy harvester working up to the radiofrequency range

Companies and researchers involved in developing miniaturized electronic devices face the basic problem of the needed batteries size, finite life of time and environmental pollution caused by their final deposition. The current trends to overcome this situation point towards Energy Harvesting technology. These harvesters (or scavengers) store the energy from sources present in the ambient (as wind, solar, electromagnetic, etc) and are costless for us. Piezoelectric devices are the ones that show a higher power density, and materials as ceramic PZT or polymeric PVDF have already demonstrated their ability to act as such energy harvester elements. Combinations between piezoelectric and electromagnetic mechanism have been also extensively investigated. Nevertheless, the power generated by these combinations is limited under the application of small magnetic fields, reducing the performance of the energy harvester [1]. In the last years the appearance of magnetoelectric (ME) devices, in which the piezoelectric deformation is driven by the magnetostrictive element, enables to extract the energy of very small electromagnetic signals through the generated magnetoelectric voltage at the piezoelectric element. However, very little work has been done testing PVDF polymer as piezoelectric constituent of the ME energy harvester device, and only to be proposed as a possibility of application [2]. Among the advantages of using piezopolymers for vibrational energy harvesting we can remember that they are ductile, resilient to shock, deformable and lightweight. In this work we demonstrate the feasibility of using magnetostrictive Fe-rich magnetic amorphous alloys/piezoelectric PVDF sandwich-type laminated ME devices as energy harvesters. A very simple experimental set-up will show how these laminates can extract energy, in amounts of μW, from an external AC field.

O Sinclinal de ferro de Torre de Moncorvo: um recurso mineral como catalisador de um Tempolntermitente

Dissertação de mestrado integrado em Arquitectura

A five year follow-up study of 11 patients with bipolar disorder

OBJECTIVE: To study the long-term follow-up of patients with bipolar disorder (BPD). METHOD: Eleven outpatients with BPD type I were followed up naturalistically for five years at a university teaching hospital. The Clinical Global Impression Scale (BPD version) was used to evaluate the occurrence of affective episodes, and the Strauss-Carpenter Outcome Scale was used to evaluate social and occupational functioning. RESULTS: The majority of patients were symptomatic most of the time, with predominantly depressive episodes. Overall, patients remained euthymic a mean of 47.7% of the time. Despite a low rate of hospitalization, social and occupational functioning was poor in the majority of patients. A poor disease course with respect to work-related functioning was associated with fewer months of euthymia with a longer duration of depressive episodes. The total number of months of euthymia negatively correlated with the patient's age and disease duration. CONCLUSION: Despite the small sample size, the present findings appear to corroborate previous studies on the evolution of BPD. Most of the patients had a poor disease course, with long symptomatic periods, particularly depressive episodes, and significantly impaired social and occupational functioning.

Looking for mechanisms regulating lung growth in CDH: rat and human studies

Tese de Doutoramento em Ciências da Saúde

Long-term prognosis of geriatric major depression in relation to cognition and white matter integrity: follow up of two cases

INTRODUCTION: The geriatric depression (GD) represents one of the most frequent psychiatric disorders in outpatient services specialized in old-age treatment. OBJECTIVE: The course of two illustrative cases of GD is discussed, highlighting its clinical picture after antidepressant treatment and underlining variables related to disease prognosis, treatment effectiveness and conversion to major cognitive disorders such as vascular dementia (VD). METHODS: The cognitive performance, depressive symptoms, autonomy and brain structural measurements as white matter hyperintensities (WMH) and hippocampal size, and microstructural integrity of WM with diffusion tensor imaging were followed during four years. RESULTS: Case 1, with a severe degree of WMH, was associated with worsening cognition and increasing functional disability. Case 2, with mild WMH, an improvement of cognitive functioning could be seen. CONCLUSIONS: The existence of different subtypes of GD, as presented in this report, points a pathophysiological heterogeneity of GD, and suggests a possible continuum vascular depression (VaDp) and vascular cognitive impairment (VCI).

Cognitive-behavioral therapy for anxiety disorders in children and adolescents: a systematic review of follow-up studies

Objective To conduct a systematic review about the long-term response to cognitive-behavioral therapy (CBT) for anxiety disorders (ADs) in children and adolescents. Methods The PubMed and ISI Web of Science databases were consulted. Search in the databases was performed in November 2012 and included cohort studies after CBT for ADs in children and adolescents with a follow-up period over 12 months. Results A total of 10 papers met the inclusion criteria. The follow-up period ranged from 12 months to 13 years and the results generally showed maintenance of the short-term benefits with CBT. However, the studies presented limitations, especially regarding methods, such as lack of a control group and losses to follow-up. Conclusion The long-term benefits of CBT were identified, however it would be interesting to conduct other studies with more frequent assessment periods, in order to minimize losses to follow-up, in addition to evaluating children and adolescents in the various stages of their development.

Improving diagnostic yield in obscure gastrointestinal bleeding - how virtual chromoendoscopy may be the answer

Background and aim: A significant proportion of patients presenting with obscure gastrointestinal bleeding (OGIB) have negative small bowel capsule endoscopy (SBCE) examinations, and yet remain at risk of rebleeding. We aimed to evaluate whether a second-look review of SBCE images using flexible spectral color enhancement (FICE) may improve the detection of potentially bleeding lesions. Materials and methods: This was a retrospective, single-center study including consecutive patients with OGIB subjected to SBCE, whose standard white light examination was nondiagnostic. Each SBCE was reviewed using FICE 1. New findings were labeled as either P1 or P2 lesions according to bleeding potential. Patients were followed up to assess the incidence of rebleeding. Results: A total of 42 consecutive patients were included. Sixteen patients (38%) experienced rebleeding after a mean follow-up of 26 months. Review of SBCE images using FICE 1 enabled the identification of previously unrecognized P2 lesions, mainly angioectasias, in nine patients (21%) and P1 lesions, mainly erosions, in 26 patients (62%). Among patients who experienced rebleeding, 13/16 (81%) were diagnosed with P1 lesions with FICE 1 (P=0.043), whereas 3/16 (19%) had confirmed nondiagnostic SBCE and only 1/16 (6%) had newly diagnosed P2 (plus P1) lesions. An alternative source of bleeding outside the small bowel was found in only 3/16 (19%) patients with rebleeding during the follow-up. Conclusion: In a significant proportion of patients with OGIB, FICE 1 may detect potentially bleeding lesions previously missed under conventional white light SBCE. Review of nondiagnostic SBCE with FICE 1 may be a valuable strategy to obviate the need for further investigations in patients with OGIB, particularly for those who experience rebleeding.