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.

[Editorial] Introduction to the special issue on COST Action FA1001

This Special Issue gathers selected contributions from experts of the action on several aspects of food structure design explored throughout the actions activity, from basic science to applications and behavior of foods during digestion.

Comparing standard and low-cost tools for gradient evaluation along potential cycling paths

Promoting the use of non-motorized modes of transport, such as cycling, is an important contribution to the improvement of mobility, accessibility and equity in cities. Cycling offers a fast and cheap transportation option for short distances, helping to lower pollutant emissions and contributing to a healthier way of life. In order to make the cycling mode more competitive in relation to motorized traffic, it is necessary to evaluate the potential of alternatives from the perspective of the physical effort. One way to do so consists of assessing the suitability of locations for implementing cycling infrastructures. In this work, four tools to determine the gradient along potential cycling paths are compared. Furthermore, an evaluation of the reliability of some low-cost tools to measure this parameter was conducted, by comparison with standard measurements using cartographic plans, on a field case study applied to the city of Braga, Portugal. These tools revealed a good level of accuracy for the planning stage, but proved to be less reliable for use in design.

Comparative environmental life-cycle analysis of concretes using biomass and coal fly ashes as partial cement replacement material

Nowadays, the concrete production sector is challenged by attempts to minimize the usage of raw materials and energy consumption, as well as by environmental concerns. Therefore, it is necessary to choose better options, e.g. new technologies or materials with improved life-cycle performance. One solution for using resources in an efficient manner is to close the materials' loop through the recycling of materials that result either from the end-of-life of products or from being the by-product of an industrial process. It is well known that the production of Portland cement, one of the materials most used in the construction sector, has a significant contribution to the environmental impacts, mainly related with carbon dioxide emission. Therefore, the study and utilization of by-products or wastes usable as cement replacement in concrete can supply more sustainable options, provided that these type of concrete produced has same durability and equivalent quality properties as standard concrete. This work studied the environmental benefits of incorporating different percentages of two types of fly ashes that can be used in concrete as cement replacement. These ashes are waste products of power and heat production sectors using coal or biomass as fuels. The results showed that both ashes provide a benefit for the concrete production both in terms of environmental impact minimization and a better environmental performance through an increase in cement replacement. It is possible to verify that the incorporation of fly ashes is a sustainable option for cement substitution and a possible path to improve the environmental performance of the concrete industry.

Mechanical analysis of asphalt mixtures produced with waste plastic modified binders

This work compares the viscoelastic properties of an asphalt binder (70/100 pen) modified with different waste plastics and the mechanical properties of the resultant asphalt mixtures. Two different plastic wastes were used, namely recycled HDPE and EVA. Three different polymer modified binders were produced with these plastic wastes: i) 5% HDPE modified binder (P5); ii) 5% EVA modified binder (E5) and; iii) a modified binder with 4% of EVA and 2% HDPE (E4P2). Asphalt mixtures were produced with these modified binders, and their mechanical properties were analysed and compared with a conventional mixture produced with a 30/50 pen bitumen. It was possible to conclude that these recycled polymers are able to improve the mechanical performance of the asphalt mixtures used in road paving.

Study of the interaction between asphalt and plastic wastes in new polymer modified binders (PMB)

The aim of this study is evaluating the interaction between several base pen grade asphalt binders (35/50, 50/70, 70/100, 160/220) and two different plastic wastes (EVA and HDPE), for a set of new polymer modified binders produced with different amounts of both plastic wastes. After analysing the results obtained for the several polymer modified binders evaluated in this study, including a commercial modified binder, it can be concluded that the new PMBs produced with the base bitumen 70/100 and 5% of each plastic waste (HDPE or EVA) results in binders with very good performance, similar to that of the commercial modified binder.

Princípios para a reabilitação sustentável low cost de edifícios antigos: estudo de um quarteirão no centro da cidade do Porto

Dissertação de mestrado em Construção e Reabilitação Sustentável

Cost-effective and lightweight mobile units for MixAR: A comparative trial among different setups

Cultural heritage has arousing the interest of the general public (e.g. tourists), resulting in the increasing number of visitations to archaeological sites. However, many buildings and monuments are severely damaged or completely destroyed, which doesn’t allow to get a full experience of “travelling in time”. Over the years, several Augmented Reality (AR) approaches were proposed to overcome these issues by providing three-dimensional visualization of reconstructed ancient structures in situ. However, most of these systems were made available through heavy and expensive technological bundles. Alternatively, MixAR intends to be a lightweight and cost-effective Mixed Reality system which aims to provide the visualization of virtual ancient buildings reconstructions in situ, properly superimposed and aligned with real-world ruins. This paper proposes and compares different AR mobile units setups to be used in the MixAR system, with low-cost and lightweight requirements in mind, providing different levels of immersion. It was propounded four different mobile units, based on: a laptop computer, a single-board computer (SBC), a tablet and a smartphone, which underwent a set of tests to evaluate their performances. The results show that mobile units based on laptop computer and SBC reached a good overall performance while mobile units based on tablet and smartphone did not meet such a satisfactory result even though they are acceptable for the intended use.

Melhoria da eficiência energética em edifícios dos anos 70: implementação de soluções sustentáveis low-tech e low-cost

Dissertação de mestrado em Construção e Reabilitação Sustentáveis

A cost study of common surface finish systems for steel structures

This paper presents part of a study aimed at finding a suitable, yet cost-effective, surface finish for a steel structure subject to the car washing environment and corrosive chemicals. The initial, life cycle and average equivalent annual (AEAC) costs for surface finishing methods were calculated for a steel structure using the LCCC algorithm developed by American Galvanizers Association (AGA). The cost study consisted of 45 common surface finish systems including: hot-dip galvanization (HDG), metallization, acrylic, alkyd and epoxy as well as duplex coatings such as epoxy zinc and inorganic zinc (IOZ). The results show that initial, life cycle and AEAC costs for hot dip galvanization are the lowest among all the other methods, followed by coal tar epoxy painting. The annual average cost of HDG for this structure was estimated about €0.22/m2, while the other cost-effective alternatives were: IOZ, polyurea, epoxy waterborne and IOZ/epoxy duplex coating.

Cost optimal strategies for the renovation of residential neighbourhoods towards energy and emissions neutrality – Rainha Dona Leonor case study

Buildings are one of the major consumers of energy in Europe. This makes them an important target when aiming to reduce the energy consumptions and carbon emissions. The majority of the European building stock has already some decades and so it needs renovation in order to keep its functionality. Taking advantage of these interventions, the energy performance of the buildings may also be improved. In Portugal the renovation techniques, both regarding energy efficiency measures as well as measures for the use of renewable energy sources, are normally planned at the building scale. It is important to explore the possibility of having large scale interventions, has it has been done in other countries, namely at neighbourhood scale with district energy system in order to optimize the results in terms of costs and environmental impact.

Cost-effective energy and carbon emission optimization in building renovation – A case-study in a low income neighbourhood

Construction sector is one of the major responsible for energy consumption and carbon emissions and renovation of existing buildings plays an important role in the actions to mitigate climate changes. Present work is based on the methodology developed in IEA Annex 56, allowing identifying cost optimal and cost effective renovation scenarios improving the energy performance. The analysed case study is a residential neighbourhood of the municipality of Gaia in Portugal. The analysis compares a reference renovation scenario (without improving the energy performance of the building) with a series of alternative renovation scenarios, including the one that is being implemented.

Project scheduling and cost minimization with multiple availability constrained resources under stochastic conditions

The authors propose a mathematical model to minimize the project total cost where there are multiple resources constrained by maximum availability. They assume the resources as renewable and the activities can use any subset of resources requiring any quantity from a limited real interval. The stochastic nature is inferred by means of a stochastic work content defined per resource within an activity and following a known distribution and the total cost is the sum of the resource allocation cost with the tardiness cost or earliness bonus in case the project finishes after or before the due date, respectively. The model was computationally implemented relying upon an interchange of two global optimization metaheuristics – the electromagnetism-like mechanism and the evolutionary strategies. Two experiments were conducted testing the implementation to projects with single and multiple resources, and with or without maximum availability constraints. The set of collected results shows good behavior in general and provide a tool to further assist project manager decision making in the planning phase.

Cost-efficient one-part alkali-activated mortars with low global warming potential for floor heating systems applications

Increasing building energy efficiency is one the most cost-effective ways to reduce emissions. The use of thermal insulation materials mitigates heat loss in buildings, therefore minimising heat energy needs. In recent years, several papers were published on the subject of foam alkali-activated cements with enhanced thermal conductivity. However, on those papers cost analysis was strangely avoided. This paper presents experimental results on one-part alkali-activated cements. It also includes global warming potential assessment and cost analysis. Foam one-part alkali-activated cements cost simulations considering two carbon dioxide social costs scenarios are also included. The results show that one-part alkali-activated cements mixtures based on 26%OPC + 58.3%FA + 8%CS + 7.7%CH and 3.5% hydrogen peroxide constitute a promising cost-efficient (67 euro/m3), thermal insulation solution for floor heating systems. This mixture presents a low global warming potential of 443 KgCO2eq/m3. The results confirm that in both carbon dioxide social cost scenarios the mixture 26 OPC + 58.3 FA + 8 CS + 7.7 CH with 3.5% hydrogen peroxide foaming agent is still the most cost efficient.

Estudo das propriedades físicas fundamentais de filmes finos intermetálicos do tipo Ti-Me (Me = Al, Au) na funcionalização de elétrodos - sensores para dispositivos biomédicos

Dissertação de mestrado integrado em Engenharia de Materiais