Doctoral Thesis Defense - Ana Luísa Parreira Nunes Alonso

Thursday, February 16, 2017, 2:30pm

Title: Database Replication for Enterprise Applications

Abstract: A common pattern for enterprise applications, particularly in small and medium businesses, is the reliance on an integrated traditional relational database system that provides persistence and where the relational aspect underlies the core logic of the application. While several solutions are proposed for scaling out such applications, database replication is key if the relational aspect is to be preserved. However, it is worrisome that because proposed solutions for database replication have been evaluated using simple synthetic benchmarks, their applicability to enterprise applications is not straightforward: the performance of conservative solutions hinges on the ability to conveniently partition applications while optimistic solutions may experience unacceptable abort rates, compromising fairness, particularly considering long-running transactions. In this thesis, we address these challenges. First, by performing a detailed evaluation of the applicability of database replication protocols based on conservative concurrency control to enterprise applications. Results invalidate the common assumption that real-world databases can be easily partitioned. Then, we tackle the issue of unacceptable abort rates in optimistic solutions by proposing a novel transaction scheduler, AJITTS, which uses an adaptive mechanism that by reaching and maintaining the optimal level of concurrency in the system, minimizes aborts and improves throughput.

Jury: - Rector of the University of Minho

        - Doctor Marco Paulo Amorim Vieira, Associate Professor with Habilitation - Departamento de Engenharia Informática da Faculdade de Ciências e Tecnologia da Universidade de Coimbra

        - Doctor Maria Beatriz Alves de Sousa Santos, Associate Professor with Habilitation - Departamento de Eletrónica, Telecomunicações e Informática da Universidade de Aveiro

        - Doctor Paolo Romano, Associate Professor - Departamento de Engenharia Informática do Instituto Superior Técnico da Universidade de Lisboa

        - Doctor Victor Francisco Mendes Freitas Gomes Fonte, Assistant Professor - Departamento de Informática da Escola de Engenharia da Universidade do Minho

        - Doctor José Orlando Roque Nascimento Pereira, Assistant Professor - Departamento de Informática da Escola de Engenharia da Universidade do Minho (Advisor)

        - Doctor Alexandre Valente da Conceição Pereira de Sousa, Associate Professor - Departamento de Ciências da Comunicação e Tecnologias do Instituto Superior da Maia

Location: Auditorium B2 - CPII - Campus de Gualtar - Universidade do Minho - Braga