Hasso-Plattner-Institut
Prof. Dr. Tilmann Rabl
 

Danica Porobic

Affiliation: Oracle
Title: An overview of Oracle Columnar Technologies

 

Abstract

Database architectures are constantly evolving due to new hardware technologies and new application requirements. Oracle database takes advantage of these new technologies without requiring application changes while at the same time enabling new types of applications. To utilize modern storage technologies effectively, it is essential to process data close to the storage. For over a decade, Oracle has been developing the Exadata Database Machine with Hybrid Columnar Compression and In Flash Columnar, and Database In-Memory, to achieve this goal. We aggressively push filtering, aggregations, projections, and joins into storage so we only need to return the data that will actually be used higher in the query. In this presentation I will introduce these technologies and discuss how they are tuned for different layers in the storage hierarchy.

Short CV

Danica Porobic is a Principal Member of Technical Staff at Oracle working on the efficient data access methods within the Database In-Memory team. She received her PhD from EPFL where she focused on designing scalable transaction processing systems for non-uniform hardware. She has graduated top of her class with MSc and BSc in Informatics from University of Novi Sad and has worked at Oracle Labs and Microsoft SQL Server.