Technical Deep-Dive in a Column-Oriented In-Memory Database
Martin Faust,
Hasso-Plattner-Institute –
Abstract:
Column-oriented databases are on trend in industry (SAP HANA, Vertica) and academia (C-Store, MonetDB, HYRISE) alike. With the recent advances of hardware and the availability of machines with terabytes of RAM the idea of a main memory database becomes viable for large installations. The speed of main memory allows to rethink the classic separation between transactional and analytical systems and thereby provide a single-source-of-truth database system that allows users to run analytical queries on the up-to-date transactional data instead of a stale OLAP version. The talk will focus on our findings of the database utilization of large ERP customers and the conclusions that led to the design of an in-memory column store. We will cover the memory hierarchy and its implications on database design, basic data structures and usage examples that benefit from the ability to run analytical-style queries on the transactional data. The talk is a condensed version of our online lecture “In-Memory Data Management” which attracted over 10.000 students when held at openHPI.de in September 2012.
Date: 2013-Apr-29 Time: 16:00:00 Room: 336
For more information:
Upcoming Events
Workshop “Metabolism and mathematical models: Two for a tango” – 2nd Edition
Title: Workshop Metabolism and mathematical models: Two for a tango – 2nd Edition
Dates: October 25-26, 2022
Location: This workshop will be held in a virtual way
The topic of this workshop is metabolism in general, with a special focus, although not exclusive, on parasitology. Besides an exploration of the biological, biochemical and biomedical aspects, the workshop will also aim at presenting some of the mathematical modelling, algorithmic theory and software development that have become crucial to explore such aspects.
This workshop is being organised in the context of two projects, both with the Inria European Team Erable. One of the projects involves a partnership with the University of São Paulo (USP), in São Paulo, Brazil, more specifically the Institute of Mathematics and Statistics (IME) and the Institute of Biomedical Sciences – Inria Associated Team Capoeira – and the other involves the Inesc-ID/IST in Portugal, ETH in Zürich and EMBL in Heidelberg – H2020 Twinning Project Olissipo.
The workshop is open to all members of these two projects but also, importantly, to the community in general.
The program and more details are available here.