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.

The effect of music marketing: A consumer perspective

The purpose of this thesis is to get a consumer perspective regarding event marketing in music festivals. Event marketing is a tool used by marketers that evolved out of philanthropy and commercial sponsorship. Brands are more and more using music or other entertainment moments to create a strong relationship with their clients, and the target group at these events, the millennial generation. Brands use sponsoring and therefore event marketing for several reasons as: increase brand awareness; create brand image; re-position the brand/product in the minds of consumers; increase profit over a short period; and, achieve larger market share. Nonetheless, we wonder how is this tool seen by consumers? To understand this, a preliminary research with nine interviews was conducted to obtain basic ideas about event marketing. Afterwards the main research was developed, also using interviews, to get deeper insights. With this thesis, it is possible to conclude that some brands are able to create brand awareness on attendees through brand sponsorship. Moreover, entertainment activities in festivals are well seen by consumers, they like it and are able to describe it well, even though it is more about the activity itself than the brand promoting it. Furthermore, it was possible to understand that experiential marketing in a festival might have a positive effect on consumers as it might create a link between the event and the brand. Finally, we recommend some actions, for brands to develop in future music festivals.

Crowdfunding

Crowdfunding, as we know it today, is a very recent activity that was born almost accidentally in the end of the 90’s decade. Due to the advent of the internet and the social networks, entrepreneurs are now able to promote their projects to a very large community. Whether it is composed by family, friends, acquaintances or simply people that are interested in the same topic or share the passion, the community is able to fund new ventures by individually investing modest amounts of money. In return, the entrepreneur can offer symbolic rewards, shares or other financial returns. New crowdfunding platforms are born almost every day all over the world, offering a new way of raising capital for their projects or a new way to invest their money in innovative ventures. Although crowdfunding is still finding its place in the financial services, successful cases such as Kickstarter demonstrate the power of the crowd in boosting creativity and productivity, financing thousands of projects by raising millions of dollars from thousands of investors. Due to regulatory restrictions, the most prominent model for now is reward-based crowdfunding, where the investors are prized with symbolic returns or privileged access to the products or services offered by the entrepreneurs. Other models such as peer-to-peer lending are also surging, allowing borrowers access to capital at a lower cost compared to so-called traditional financial institutions, and offering lenders a higher rate of return. But when it comes to offering shares to investors, i.e. using equity-based crowdfunding, entrepreneurs face regulatory obstacles in almost every country, where legislation was passed decades ago with the objective of promoting financially-capable ventures and protecting investors. Access to capital has become more difficult after the global economic recession of 2008, and for most countries it will not get easier in the near future, leaving start-ups and small enterprises with few options to start or expand their operations. In this study we attempt to answer the following research questions: how has equity-based crowdfunding evolved since its creation? Where and how has equity-based crowdfunding been implemented so far? What are the constraints and opportunities for implementing equity-crowdfunding in the world, and more particularly in Portugal? Finally, we will discuss the risks of crowdfunding and reflect on the future of this industry.

Developmental and paleontological insights into skull bone homology and evolution

The Gallus gallus (chicken) embryo is a central model organism in evolutionary developmental biology. Its anatomy and developmental genetics have been extensively studied and many relevant evolutionary implications have been made so far. However, important questions regarding the developmental origin of the chicken skull bones are still unresolved such that no solid homology can be established across organisms. This precludes evolutionary comparisons between this and other avian model systems in which skull anatomy has evolved significantly over the last millions of years.(...)

Portuguese footwear

This case study deals with the reasons why the Portuguese Footwear Cluster evolved from a small industry focused on the Portuguese internal market into a high-tech industry capable of designing and producing some of the best and most expensive shoes in the world. It went from using the low labor costs of an under-developed economy to produce long series of shoes for pre-designated brands in Northern Europe to having the ability to produce some of the highest quality shoes in the world, in small orders, designed and delivered in record timing, while offering a service of excellence. In 1960, when Portugal became a founding member of EFTA, the footwear industry in Portugal was globally irrelevant, producing low quality shoes directed to the puny internal market and its African colonies. The new free trade zone with economies much more developed that itself, led to the transfer of the labor-intensive, low skilled manufacture from the UK and Scandinavian countries to Portugal. Mostly through joint ventures, the industry was able to mechanize itself so it could produce shoes in long series at low prices. It grew based on that model up until the 1990s, when the emergence of the Asian countries meant either a different strategy or extinction. Taking advantage of a clarified leadership of its trade association, it used the European funds made available to it during the 1990s, to modernize its factory floors, so it could become more nimble and flexible, expand its design capabilities and dramatically change its image abroad. The role of the trade association, APICCAPS, was instrumental throughout the process going well beyond what came to be expected of trade associations. It used its privileged position to provide understanding regarding the current situation and competitive landscape, alerting for changes ahead and at the same time providing a strategic vision on how to deal with the challenges. Moreover, it helped companies get the resources they needed by creating a research center in collaboration with a University, by creating a process that allowed companies to learn from each other via the show casing of projects sponsored by the association or by helping industrials traveling to locations where new customers could be found. The case study provides insight on how the trade association leadership, which has no formal authority over its members, was able to guide and motivate an industry through a consistent positive approach. That approach focused on the solutions, on the opportunities and on the success stories of companies in the cluster rather than on what was wrong or needed to be addressed. Based on this case, one could use the leadership role of the trade association to discuss and change leaders’ roles and styles in other sectors or even companies.