By Hasso Plattner

​-Presents the interior mechanics of an in-memory database
-Includes 34 studying devices with greater than a hundred self-tests and complete explanation
-Explains a big new develoment in firm computing

Recent achievements in and software program improvement, equivalent to multi-core CPUs and DRAM capacities of a number of terabytes in keeping with server, enabled the creation of a progressive expertise: in-memory facts administration. This know-how helps the versatile and intensely quickly research of huge quantities of firm info. Professor Hasso Plattner and his learn crew on the Hasso Plattner Institute in Potsdam, Germany, were investigating and educating the corresponding suggestions and their adoption within the software program for years.

This ebook relies at the first on-line direction at the openHPI e-learning platform, which used to be introduced in autumn 2012 with greater than 13,000 beginners. The e-book is designed for college kids of desktop technology, software program engineering, and IT comparable matters. despite the fact that, it addresses enterprise specialists, determination makers, software program builders, know-how specialists, and IT analysts alike. Plattner and his team specialise in exploring the internal mechanics of a column-oriented dictionary-encoded in-memory database. lined subject matters comprise - among others - actual information garage and entry, easy database operators, compression mechanisms, and parallel subscribe to algorithms. past that, implications for destiny company functions and their improvement are mentioned. Readers are bring about comprehend the novel variations and merits of the recent know-how over conventional row-oriented disk-based databases.

Show description

Read Online or Download A Course in In-Memory Data Management PDF

Best management books

Product Innovation, Interactive Learning and Economic Performance, Volume 8 (Research on Technological Innovation, Management and Policy) (Research on Technological Innovation, Management and Policy)

The purpose of this booklet is to give a contribution to the certainty of product innovation - the way it happens and the way it impacts organisations and the economic climate. It hyperlinks product innovation to interactive studying and to the functionality of corporations. It reports the interconnections among those 3 parts at the foundation of certain facts units and targeted case stories.

Dienstleistungen im Gesundheitssektor: Produktivität, Arbeit und Management

​Die Branche der Gesundheitsdienstleistungen ist in einem fühlbaren und stetigen Wandel. Die Gründe sind vielfältig: Der soziodemografische Wandel, ein verändertes Gesundheitsbewusstsein und -verhalten und wirtschaftspolitische Einflüsse wie die Privatisierungen der letzten Jahren in diesem Bereich werden immer wieder benannt.

Additional resources for A Course in In-Memory Data Management

Sample text

Logs and snapshots are necessary to restore the database in case of failure. The largest advantage so far is that main memory access depends on timedeterministic processes in contrast to seek-times of HDDs that depend on mechanical parts. Thus, runtimes of in-memory processing can be calculated (although it might be complicated). Observations from using in-memory databases show that response times are smooth—always the same—and not varying like it is the case with disks and their response time variations due to disk seeks.

Second, the impact of retrieving the actual values for the encoded columns is actually rather small. When selecting tuples, only the corresponding values from the query have to be looked up in the dictionary for the column scan. Generally, the result set is small compared to the total table size, so the lookup of all other selected columns to materialize the query result is not that expensive. Carefully written queries also only select those columns that are really needed, which not only saves bandwidth but also further reduces the number of necessary lookups.

An additional 31 bit field is added to store the number of occurrences (dlog2 ð1:4 billionÞ e ¼ 31 bit). 4 billion times 8 bit, only 31 bit þ 8 bit ¼ 39 bit are really necessary. , 17 % of storage space is saved. Another advantage of prefix encoding is direct access with row number calculation. 4 billion should be considered and then filtered by the gender value. Although we see that we have reduced the required amount of main memory, it is evident that we still store much redundant information for all other countries.

Download PDF sample

Download A Course in In-Memory Data Management by Hasso Plattner PDF
Rated 4.20 of 5 – based on 20 votes