A Course in In-Memory Data Management: The Inner Mechanics by Hasso Plattner

By Hasso Plattner

Recent achievements in and software program improvement, similar to multi-core CPUs and DRAM capacities of a number of terabytes consistent with server, enabled the creation of a innovative expertise: in-memory facts administration. This expertise helps the versatile and intensely quickly research of big quantities of company information. Professor Hasso Plattner and his study workforce on the Hasso Plattner Institute in Potsdam, Germany, were investigating and educating the corresponding techniques and their adoption within the software program for years.

This ebook is predicated on a web direction that was once first introduced in autumn 2012 with greater than 13,000 enrolled scholars and marked the winning place to begin of the openHPI e-learning platform. The direction is principally designed for college kids of laptop technological know-how, software program engineering, and IT comparable matters, yet addresses company specialists, software program builders, expertise specialists, and IT analysts alike. Plattner and his team specialize in exploring the interior mechanics of a column-oriented dictionary-encoded in-memory database. coated issues contain - among others - actual info garage and entry, simple database operators, compression mechanisms, and parallel sign up for algorithms. past that, implications for destiny firm functions and their improvement are mentioned. step-by-step, readers will comprehend the unconventional transformations and merits of the hot know-how over conventional row-oriented, disk-based databases.

In this thoroughly revised 2nd variation, we include the suggestions of hundreds of thousands in fact individuals on openHPI and take into consideration most modern developments in demanding- and software program. better figures, causes, and examples extra ease the certainty of the techniques provided. We introduce complex information administration innovations akin to obvious combination caches and supply new showcases that display the potential for in-memory databases for 2 assorted industries: retail and lifestyles sciences.

Show description

Read Online or Download A Course in In-Memory Data Management: The Inner Mechanics of In-Memory Databases PDF

Similar data mining books

Data Structures and Algorithms (Software Engineering and Knowledge Engineering, 13)

This can be a good, updated and easy-to-use textual content on information constructions and algorithms that's meant for undergraduates in laptop technological know-how and data technological know-how. The 13 chapters, written via a global team of skilled academics, disguise the elemental techniques of algorithms and lots of the very important facts constructions in addition to the idea that of interface layout.

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

Fresh achievements in and software program improvement, reminiscent of multi-core CPUs and DRAM capacities of a number of terabytes in keeping with server, enabled the creation of a innovative expertise: in-memory facts administration. This know-how helps the versatile and intensely speedy research of big quantities of company information.

Machine Learning and Knowledge Discovery in Databases: European Conference, ECML PKDD 2014, Nancy, France, September 15-19, 2014. Proceedings, Part I (Lecture Notes in Computer Science)

This three-volume set LNAI 8724, 8725 and 8726 constitutes the refereed complaints of the ecu convention on computer studying and data Discovery in Databases: ECML PKDD 2014, held in Nancy, France, in September 2014. The one hundred fifteen revised examine papers awarded including thirteen demo tune papers, 10 nectar tune papers, eight PhD tune papers, and nine invited talks have been conscientiously reviewed and chosen from 550 submissions.

Learning to Love Data Science: Explorations of Emerging Technologies and Platforms for Predictive Analytics, Machine Learning, Digital Manufacturing and Supply Chain Optimization

Until eventually lately, many folks proposal titanic facts was once a passing fad. "Data technology" used to be an enigmatic time period. this present day, substantial information is taken heavily, and information technological know-how is taken into account downright horny. With this anthology of news from award-winning journalist Mike Barlow, you’ll savor how info technology is essentially changing our global, for larger and for worse.

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

Sample text

In an UMA (a) Fig. 4 (a) Shared FSB, (b) Intel quick path interconnect [Int09] (b) 26 4 Changes in Hardware system every processor observes the same speeds when accessing an arbitrary memory address as the complete memory is accessed through a central memory interface as shown in Fig. 4a. In contrast, in NUMA systems, every processor has its primary used local memory as well as remote memory supplied from the other processors. This setup is shown in Fig. 4b. The different kinds of memory from the processors point of view introduce different memory access times between local memory (adjacent slots) and remote memory that is adjacent to the other processing units.

Accessing the stored state requires raising the word access line and the state is immediately available for reading. In contrast, DRAM cells can be constructed using a much simpler structure consisting of only one transistor and a capacitor. The state of the memory cell is stored in the capacitor while the transistor is only used to guard the access to the capacitor. This design is more economical compared to SRAM. However, it introduces a couple of complications. First, the capacitor discharges over time and while reading the state of the memory cell.

The smallest transferable unit between each level is one cache line. Caches, where every cache line of level i is also present in level i þ 1 are called inclusive caches otherwise the model is called exclusive caches. All Intel processors implement an inclusive cache model. This inclusive cache model is assumed for the rest of this text. When requesting a cache line from the cache, the process of determining whether the requested line is already in the cache and locating where it is cached is crucial.

Download PDF sample

Rated 4.67 of 5 – based on 36 votes