A Course in In-Memory Data Management: The Inner Mechanics of In-Memory Databases

by Hasso Plattner

Overview

Recent achievements in hardware and software development, such as multi-core CPUs and DRAM capacities of multiple terabytes per server, enabled the introduction of a revolutionary technology: in-memory data management. This technology supports the flexible and extremely fast analysis of massive amounts of enterprise data. Professor Hasso Plattner and his research group at the Hasso Plattner Institute in Potsdam, Germany, have been investigating and teaching the corresponding concepts and their adoption in the software industry for years.

This book is based on the first online course on the openHPI e-learning platform, which was launched in autumn 2012 with more than 13,000 learners. The book is designed for students of computer science, software engineering, and IT related subjects. However, it addresses business experts, decision makers, software developers, technology experts, and IT analysts alike. Plattner and his group focus on exploring the inner mechanics of a column-oriented dictionary-encoded in-memory database. Covered topics include - amongst others - physical data storage and access, basic database operators, compression mechanisms, and parallel join algorithms. Beyond that, implications for future enterprise applications and their development are discussed. Readers are lead to understand the radical differences and advantages of the new technology over traditional row-oriented disk-based databases.

Product Details

ISBN-13:	9783642365249
Publisher:	Springer-Verlag New York, LLC
Publication date:	04/22/2013
Sold by:	Barnes & Noble
Format:	eBook
File size:	3 MB

About the Author

Prof. Dr. h.c. Hasso Plattner is the chair of the "Enterprise Platform and Integration Concepts" research group at HPI, which focuses mainly on In-Memory Data Management for Enterprise Applications. He is author and co-author of over 50 scientific publications and has served conferences such as ACM SIGMOD as a keynote speaker. He is author of "In-Memory Data Management" and currently serves as a visiting professor at the Stanford University Institute of Design. Hasso Plattner is also a co-founder of SAP AG, where he served as CEO until 2003 and has since been chairman of the supervisory board. SAP AG today is the leading provider of enterprise software solutions. In his role as chief software advisor, he concentrates on defining the mid- and long-term technology strategy and direction of SAP.

Table of Contents

​Introduction.- The Future of Enterprise Computing: New Requirements for Enterprise Computing.- Enterprise Application Characteristics.- Changes in Hardware.- A Blueprint of SanssouciDB.- Foundations of Database Storage Techniques: Dictionary Encoding.- Compression.- Data Layout in Main Memory.- Partitioning.- In-Memory Database Operators: Delete.-  Insert.- Update.- Tuple Reconstruction.- Scan Performance.- Select.- Materialization Strategies.- Parallel Data Processing.- Indices.- Join.- Aggregate Functions.- Parallel Select.- Workload Management and Scheduling.- Parallel Join.- Parallel Aggregation.- Advanced Database Storage Techniques: Differential Buffer.- Insert- Only.- The Merge Process.- Logging.- Recovery.- On-the-fly Database Reorganization.- Foundations for a New Enterprise Application Development Era: Implications on Application Development.- Database Views.- Handling Business Objects.- Bypass Solution.- Self Test Solution.

Editorial Reviews

From the reviews:

“I would recommend it primarily to database practitioners and database implementers seeking to better understand the physical layer of in-memory database systems. … The material will be of interest to database developers interested in physical-layer implementation. It may also be of some interest to application developers working with in-memory databases, particularly SanssouciDB.” (S. Thomas, Computing Reviews, September, 2013)

From the Publisher