A shared-disk parallel cluster file system

Dissertação apresentada para obtenção do Grau de Doutor em Informática Pela Universidade Nova de Lisboa, Faculdade de Ciências e Tecnologia

Estabilização dinâmica em patologia degenerativa da coluna lombar: estado da arte e contributo pessoal

Resumo Este trabalho encontra-se dividido em três capítulos distintos. No primeiro, é caracterizada a doença degenerativa lombar, demorando-se o autor na descrição pormenorizada das alterações anatómicas, biomecânicas, e bioquímicas inerentes à sua ocorrência. Segue-se a descrição da evolução das diferentes formas de terapêutica, enumerando as que de forma clássica mais frequentemente são utilizadas (cirúrgicas e não cirúrgicas). No segundo capítulo, são referidos os mais recentes avanços tecnológicos nesta área, mencionando, nas suas vertentes biomecânicas, clínicas e terapêuticas, as particularidades das estabilizações dinâmicas interespinhosas e pediculares, bem como da artroplastia de disco. Após esta longa introdução, inicia-se o terceiro capítulo no qual se apresenta um estudo prospectivo da avaliação clínica, funcional, imagiológica e da variação da densidade mineral óssea vertebral em 20 doentes com patologia degenerativa, tratados com sistemas de estabilização dinâmica semi-rígida interespinhosa, e seguidos durante dois anos. Do estudo realizado conclui-se que os sistemas referidos são eficazes clínica e funcionalmente no tratamento de doentes com doença degenerativa lombar. Mais ainda, estes instrumentais proporcionam um aumento da altura do disco confirmado na incidência radiográfica de perfil no nível instrumentado. Constatámos ainda que a densidade mineral óssea vertebral dos doentes intervencionados, avaliada com sistema DXA, não demonstra diferenças com significância estatística ao longo do tempo, omparativamente à determinada em idêntica população mas sem qualquer patologia lombar. Acresce que se obteve uma correlação entre a funcionalidade física e a BMD radial, com significância estatística crescente nas duas medições realizadas. Abstract This study is divided in three different chapters. In the first one the author describes the anatomical, biomechanical and biochemical changes that go along with degenerative lumbar spine disease. The therapeutically possibilities are mentioned, mainly with the classic fusion and decompression as well as the non surgical options. Then, in the second chapter, the author describes, from the biomechanical, clinical and therapeutically point of view, the new techniques of dynamic stabilization, interspinous and pedicular systems, as well as disc replacement. After this introduction, in the third chapter a prospective clinical, functional, imagiologic and vertebral bone mineral density variation study is presented. Twenty patients with degenerative lumbar spine disease are selected, and operated with a semi rigid interspinous system device, and followed for a two year period. The author concludes that the interspinous semi rigid systems were clinically and functionally effective in lumbar degenerative patients. It was also founded that the disc height at the implant segment level increased after surgery. Bone density was assessed with a DXA system device. As far as vertebral bone density is concerned, the author found no differences what so ever inside the group during the study, or to an identical control group without any lumbar pathology. The correlation study between the BMD and physical function showed that there was only significant statistically data in radial BMD measurement, and this happened with growing correlation from year 2006 to 2007.

Burrows-wheeler transform in secondary memory

Master’s Thesis in Computer Engineering

Epidemiological characterization, antimicrobial resistance and virulence mechanisms of human and animal streptococci

Dissertação para obtenção do Grau de Doutor em Biologia

Unstabilised rammed earth: characterization of material collected from old constructions in South Portugal and comparison to normative requirements

International Journal of Architectural Heritage, 8: 185–212, 2014

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.

Fuel switching

The present Master dissertation is a project whose main objective is to identify value creation opportunities through fuel switching in the Portuguese industry, services, agriculture and fishing sectors. Fuel switching opportunities are characterized by type of fuel transition, type of technology transition, economy subsectors prone to have fuel switching and value created through fuel shift. Results suggest tomato concentrate, dairy, beer manufacturing and sugar refining subsectors is where prevalence of fuel oil steam boilers is high, for such cases conversion to natural gas steam boilers should result in operations having a ratio of NPV over CAPEX larger than ten and a payback period just under one year. Results further suggest food, beverages, textile, chemicals and wood subsectors currently operate between ten and twenty cogeneration Diesel engines that can be either modified to operate with natural gas or replaced by new natural gas cogeneration systems. Financial modeling indicates that both options have great value creation potential. The current analysis aims to be used by natural gas suppliers and energy project promoters to identify new potential deals as well as by heavy energy consumers to mitigate their energy related costs.