A Course in In-Memory Data Management: The Inner Mechanics - download pdf or read online

By Hasso Plattner

ISBN-10: 3642552692

ISBN-13: 9783642552694

ISBN-10: 3642552706

ISBN-13: 9783642552700

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

This booklet relies on a web path that was once first introduced in autumn 2012 with greater than 13,000 enrolled scholars and marked the profitable place to begin of the openHPI e-learning platform. The direction is especially designed for college students of laptop technology, software program engineering, and IT comparable matters, yet addresses company specialists, software program builders, expertise specialists, and IT analysts alike. Plattner and his team specialise in exploring the interior mechanics of a column-oriented dictionary-encoded in-memory database. lined issues contain - among others - actual info garage and entry, easy database operators, compression mechanisms, and parallel subscribe to algorithms. past that, implications for destiny firm purposes and their improvement are mentioned. step-by-step, readers will comprehend the novel variations and benefits of the recent know-how over conventional row-oriented, disk-based databases.

In this thoroughly revised 2nd variation, we comprise the suggestions of hundreds of thousands after all contributors on openHPI and take note of most up-to-date developments in tough- and software program. superior figures, factors, and examples extra ease the knowledge of the options provided. We introduce complicated info administration suggestions resembling obvious combination caches and supply new showcases that show the potential for in-memory databases for 2 assorted industries: retail and existence sciences.

Show description

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

Similar data mining books

Download e-book for iPad: Automated Data Collection with R: A Practical Guide to Web by Simon Munzert, Christian Rubba, Dominic Nyhuis, Peter Meiner

A fingers on advisor to internet scraping and textual content mining for either novices and skilled clients of R Introduces basic thoughts of the most structure of the net and databases and covers HTTP, HTML, XML, JSON, SQL.

Provides uncomplicated thoughts to question internet files and knowledge units (XPath and normal expressions). an in depth set of routines are offered to lead the reader via every one process.

Explores either supervised and unsupervised recommendations in addition to complex innovations akin to facts scraping and textual content administration. Case reports are featured all through besides examples for every strategy provided. R code and ideas to routines featured within the e-book are supplied on a helping site.

Download e-book for iPad: Data Mining Cookbook by Olivia Parr Rud

Now on hand, this insightful e-book indicates you the way to create and enforce versions of the main frequently asked information mining questions for advertising, revenues, probability research, and purchaser courting administration and help. as well as actual global event and realizing, you will get time-tested confirmed modeling options that handle particular inquiries to assist you locate creative new how one can raise revenue and minimize expenditures.

New PDF release: Multi-disciplinary Trends in Artificial Intelligence: 8th

This booklet constitutes the refereed convention court cases of the eighth foreign convention on Multi-disciplinary developments in synthetic Intelligence, MIWAI 2014, held in Bangalore, India, in December 2014. The 22 revised complete papers have been rigorously reviewed and chosen from forty four submissions. The papers function quite a lot of themes masking either concept, tools and instruments in addition to their diversified purposes in several domain names.

Download PDF by Emmanouel Garoufallou, Imma Subirats Coll, Armando Stellato,: Metadata and Semantics Research: 10th International

This ebook constitutes the refereed lawsuits of the tenth Metadata and Semantics learn convention, MTSR 2016, held in Göttingen, Germany, in November 2016. The 26 complete papers and six brief papers provided have been conscientiously reviewed and chosen from sixty seven submissions. The papers are equipped in numerous classes and tracks: electronic Libraries, details Retrieval, associated and Social info, Metadata and Semantics for Open Repositories, study info structures and information Infrastructures, Metadata and Semantics for Agriculture, meals and surroundings, Metadata and Semantics for Cultural Collections and purposes, eu and nationwide initiatives.

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

Example text

Proteomics research benefits from the integration of relational database operators and arbitrary mathematical operations in SanssouciDB, allowing the proteomics researcher to compose complex analysis pipelines in one environment using clinical patient data as well as raw spectrum data inside one database. Since every parameter and algorithm influences the accuracy of the resulting statistical model, iterative tuning of such pipelines in real-time is a requirement in this field: here the fast traversal of data and algorithm execution is crucial.

The more often identical values appear, the better dictionary encoding can compress a column. As we noted in Sect. 6, enterprise data has low entropy. Therefore, dictionary encoding is well suited and yields a good compression ratio in such scenarios. In the following, we calculate the possible savings for the first name and gender columns of our world-population example. H. 1007/978-3-642-55270-0__6, © Springer-Verlag Berlin Heidelberg 2014 39 40 6 Dictionary Encoding Fig. 1 Compression Example Given the world population table with 8 billion rows and 200 Byte per row: Attribute # of distinct values First name Last name Gender Country City Birthday 5 million 8 million 2 200 1 million 40,000 Sum Size (Byte) 49 50 1 49 49 2 200 The complete amount of data is: 8 billion rows 200 Byte per row D 1:6 TB Each column is split into a dictionary and an attribute vector.

Enterprise Resource Planning (ERP) systems, for example, typically create transactional data to capture the operations of a business. More and more event and stream data is created by modern manufacturing machines and sensors. At the same time, large amounts of unstructured data is captured from the web, social networks, log files, support systems, and others. Business users need to query these different data sources as fast as possible to derive business value from the data or coordinate the operations of the enterprise.

Download PDF sample

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

by Jason

Rated 4.93 of 5 – based on 21 votes