Francesc Trull
Research topic: Physical Design Optimization of In-Memory Databases
Home University: Universitat Politècnica de Catalunya (UPC)
Host University: Technische Universität Dresden (TUD)
Advisor (Home University): Alberto Abelló (UPC)
Advisor (Host University): Wolfgang Lehner (TUD)
Research Interests: Performance Optimization, Computer Architecture, Algorithms and Data Structures
EDUCATION
November 2014 to the present:
Doctoral Candidate IT4BI. Universitat Politècnica de Catalunya, Technische Universität Dresden
Oct 2012 - Oct 2014:
Oct 2012 - Oct 2014:
MS, Master of Innovation and Research in Informatics. Universitat Politècnica de Catalunya
Thesis title: “External Plan Optimization in SAP HANA”
RESEARCH
The goal of this project is to develop algorithms to find data placements that optimize performance in distributed databases.
The performance of distributed databases depends on the distribution of data and operations across hardware nodes. Spreading the computations across nodes increases parallelism but generates network communication overhead. On the other hand, concentrating computations in one node avoids communication costs but limits performance to the capacity of the node. We tackle the hard problem of finding distributions of the data and computations that simulatneously satisfy these two conflicting objectives. We consider the data used by the system as well as the operations performed on these data. We estimate the time spent processing in the different processors, the time spent accessing data in the different main memory sub-systems, and the time spent transmitting data through the different network links. We develop algorithms to search the data (and operations) placement space and find placements that maximize the database throughput.