Technical Deep-Dive in a Column-Oriented In-Memory Database
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:
INESC-ID ESR Talks – February 2023
If you are a masters/PhD student or a postdoctoral fellow, come and present your work in an informal and friendly environment – and savour some tasty snacks!
Individual talks will be 10-15 minutes plus time for feedback. Enroll on your selected date by emailing pedro.ferreira[at]inesc-id.pt.
Happening on the second Wednesday of every month (4pm-5pm):
- 15 February (Alves Redol, Room 9)
- 15 March (Alves Redol, Room 9)
- 12 April (Alves Redol, Room 9)
- 10 May (Alves Redol, Room 9)
- 14 June (Alves Redol, Room 9)
- 12 July (Alves Redol, Room 9)
We hope to see you there!