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.

Growth hacking model for B2B saas startups

The following project introduces a model of Growth Hacking strategies for business-tobusiness Software-as-a-Service startups that was developed in collaboration with and applied to a Portuguese startup called Liquid. The work addresses digital marketing channels such as content marketing, email marketing, social marketing and selling. Further, the company’s product, pricing strategy, partnerships and website communication are examined. Applying best case practices, competitor benchmarks and interview insights from numerous industry influencers and experts, areas for improvement are deduced and procedures for each of those channels recommended.

Why an entrepreneur should be a marketeer

Inspired by the booming startup culture that’s transforming Lisbon’s business setting, the present case study tests the hypothesis that great marketing is the main key to any new business’ success, by analyzing the history and environment of a premature Portuguese tech startup company exploring the market of destination weddings, Wedmint, and its inbound marketing strategy.

Developing a gamification system to increase customer lifetime value at MyGon

There have never been so many touch points between companies and consumers as there are today, which paradoxically makes it very challenging for companies to be able to retain and engage customers. Gamification is a strategy used by a large number of companies to increase customer engagement and customer lifetime value. This work aims at developing a gamification system for MyGon, a Portuguese startup working in the market of discounts and experiences. In addition to examining the literature concerning gamification, its elements and characteristics, recommendations were developed for addressing MyGon’s business goals of increasing conversion and customer engagement. The gamification mechanisms suggested include badges, missions, points, leaderboards and levels.

Ontology-based representation and generation of workflows for micro-task human-machine computation

Doctoral Program in Computer Science

O meu ponto de vista é um ponto de escuta. O poder do som nos filmes de Manoel de Oliveira

Tese de Doutoramento em Ciências da Comunicação - Especialidade em Comunicação Audiovisual

Relação entre desempenho motor e variáveis antropométricas em crianças e adolescentes de Florianópolis, SC/Brasil

O objetivo foi analisar a relação entre desempenho motor (DM) e variáveis antropométricas de crianças e adolescentes de escolas públicas de Florianópolis. Metodologia: 300 alunos do 3º ao 5º ano e da 4ª a 6ª série do Ensino Fundamental, entre os 8 e 16 anos. Os resultados vão ao encontro à literatura, que indicam correlações negativas entre DM e variáveis antropométricas em crianças e adolescentes.

Implementação de ferramentas Lean numa empresa de componentes para calçado

Dissertação de mestrado em Engenharia Industrial

Desenvolvimento de um concentrador solar com sistema de seguimento

Dissertação de mestrado em Engenharia Mecânica

Desenvolvimento e otimização do projeto mecatrónico para um Tribómetro Linear

Dissertação de mestrado integrado em Engenharia Mecânica

Development of a thermoelectric generator for the exhaust of a vehicle

Dissertação de mestrado integrado em Engenharia Mecânica

Desenvolvimento de um Controlador com DSP para um Motor CA de 30 kW para o CEPIUM

Dissertação de mestrado integrado em Engenharia Eletrónica Industrial e Computadores

Desenvolvimento de um Posto de Carregamento Lento com BMS e Interface com o Cockpit para o CEPIUM

Dissertação de mestrado integrado em Engenharia Eletrónica Industrial e de Computadores

Desenvolvimento de um Range Extender para Veículo Elétrico

Dissertação de mestrado integrado em Engenharia Eletrónica Industrial e de Computadores

Válvula rotativa inovadora para motores a 2 tempos possibilitando sobre-expansão

Dissertação de mestrado integrado em Engenharia Mecânica