Datenschutzerklärung|Data Privacy

A. Borusan

13.02.2012, 17 Uhr s.t. TU Berlin, EN building, seminar room EN 719 (7th floor), Einsteinufer 17, 10587 Berlin: "HYRISE - A Hybrid In-Memory Storage Engine" (Martin Grund, HPI)

In this talk I will present my research findings in the area of enterprise application-aware database systems. Based on the current evolution in computer hardware architectures, main memory plays an increasing important role for modern database systems. To fully leverage the performance properties of main memory, database systems need to be aware of the properties of enterprise applications. Therefore I will show some analysis of enterprise applications and their data usage and how this can affect the database layer.

Current database systems lack features that optimize the physical storage engine based on the workload of the applications (without replication) due to the high cost of rearranging the data on disk. Using our research prototype - HYRISE - I present a system that depending on the input workload allows selecting an optimal vertical partitioning for the tables of the application. To validate the approach we used an adapted application benchmark.

Since modern enterprise applications will evolve faster then the previous generations it becomes more important to track changes of the workload and provide a high-performance algorithm to adapt to changes. As an outcome we will present an adapted version of our initial algorithm that allows incremental calculating of the optimal layout to reduce the overall search space.

The talk concludes with a summary of the specific contributions and an outlook for future research in the area of hybrid main memory database systems.