Skip to main content
  • Textbook
  • © 2014

A Course in In-Memory Data Management

The Inner Mechanics of In-Memory Databases

Authors:

  • Presents the inner mechanics of an in-memory database
  • Includes 34 learning units with more than 100 self-tests and comprehensive explanation
  • Explains a major new development in enterprise computing
  • Includes supplementary material: sn.pub/extras

Buy it now

Buying options

eBook USD 74.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book USD 109.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (36 chapters)

  1. Front Matter

    Pages i-xxiii
  2. Introduction

    • Hasso Plattner
    Pages 1-4
  3. The Future of Enterprise Computing

    1. Front Matter

      Pages 5-5
    2. New Requirements for Enterprise Computing

      • Hasso Plattner
      Pages 7-16
    3. Enterprise Application Characteristics

      • Hasso Plattner
      Pages 17-21
    4. Changes in Hardware

      • Hasso Plattner
      Pages 23-32
    5. A Blueprint of SanssouciDB

      • Hasso Plattner
      Pages 33-36
  4. Foundations of Database Storage Techniques

    1. Front Matter

      Pages 37-37
    2. Dictionary Encoding

      • Hasso Plattner
      Pages 39-44
    3. Compression

      • Hasso Plattner
      Pages 45-56
    4. Data Layout in Main Memory

      • Hasso Plattner
      Pages 57-63
    5. Partitioning

      • Hasso Plattner
      Pages 65-69
  5. In-Memory Database Operators

    1. Front Matter

      Pages 71-71
    2. Delete

      • Hasso Plattner
      Pages 73-75
    3. Insert

      • Hasso Plattner
      Pages 77-83
    4. Update

      • Hasso Plattner
      Pages 85-89
    5. Tuple Reconstruction

      • Hasso Plattner
      Pages 91-95
    6. Scan Performance

      • Hasso Plattner
      Pages 97-101
    7. Select

      • Hasso Plattner
      Pages 103-107
    8. Materialization Strategies

      • Hasso Plattner
      Pages 109-116

About this book

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 an online course that was first launched in autumn 2012 with more than 13,000 enrolled students and marked the successful starting point of the openHPI e-learning platform. The course is mainly designed for students of computer science, software engineering, and IT related subjects, but addresses business experts, software developers, technology experts, and IT analysts alike. Plattner and his group focus on exploring theinner 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. Step by step, readers will understand the radical differences and advantages of the new technology over traditional row-oriented, disk-based databases.

In this completely revised 2nd edition, we incorporate the feedback of thousands of course participants on openHPI and take into account latest advancements in hard- and software. Improved figures, explanations, and examples further ease the understanding of the concepts presented. We introduce advanced data management techniques such as transparent aggregate caches and provide new showcases that demonstrate the potential of in-memory databases for two diverse industries: retail and life sciences.

Authors and Affiliations

  • Enterprise Platform and Integration Concepts, Hasso Plattner Institute, Potsdam, Germany

    Hasso Plattner

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.

Bibliographic Information

Buy it now

Buying options

eBook USD 74.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book USD 109.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access