{"id":206,"date":"2016-05-25T11:37:49","date_gmt":"2016-05-25T10:37:49","guid":{"rendered":"https:\/\/blog.bham.ac.uk\/itinnovation\/?p=206"},"modified":"2018-05-25T11:45:31","modified_gmt":"2018-05-25T10:45:31","slug":"in-memory-computing-exasol-evaluation","status":"publish","type":"post","link":"https:\/\/blog.bham.ac.uk\/itinnovation\/2016\/05\/25\/in-memory-computing-exasol-evaluation\/","title":{"rendered":"In-memory computing &#8211; EXASOL evaluation"},"content":{"rendered":"<p>EXASOL (http:\/\/www.exasol.com\/en\/) provides an in-memory computing solution for data analytics. It combines in memory,\u00a0columnar storage and massively parallel technologies to support high performance, flexibility and<br \/>\nscalability.<\/p>\n<p>In-memory computing (IMC) is an architecture-style where applications assume all the data required for processing is\u00a0located in the main memory of their computing environment. In-memory computing (IMC) is a broader concept which\u00a0includes in-memory database and in-memory analytics. An in-memory database (IMDB, also known as a main\u00a0memory database or MMDB) is a database whose data is stored in main memory to facilitate faster response times.\u00a0The source data are loaded into system memory in a compressed, non-relational format. In-memory analytics is an\u00a0approach to querying data when it resides in a computer\u2019s random access memory (RAM), as opposed to querying\u00a0data that is stored on physical disks.<br \/>\nWhat benefits can in-memory computing deliver? The main benefit is it improves the speed dramatically. For\u00a0example, data processing consists three components: the processor to perform the calculations, the storage to store and\u00a0manipulate data, and a system to transfer the data between the two. The current bottleneck is the latency storage, more\u00a0specifically, it is the latency of hard disks. Processing power is not used to full capacity because the data to be\u00a0processed is not retrieved fast enough from hard disks. Thus, IMC putting data into memory can dramatically speed up<br \/>\nthe process of data analysis. The diagram below shows a traditional data warehouse approach vs. IMC-enabled data\u00a0warehouse approach. The shift from traditional, hard disk-enabled data warehouses to IMC-enabled warehouses\u00a0implies a reduction in layers on the way from raw data to the results of data analysis.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-207 size-large\" src=\"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-content\/uploads\/sites\/39\/2018\/05\/In_memory_computing-1024x724.jpg\" alt=\"\" width=\"840\" height=\"594\" srcset=\"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-content\/uploads\/sites\/39\/2018\/05\/In_memory_computing-1024x724.jpg 1024w, https:\/\/blog.bham.ac.uk\/itinnovation\/wp-content\/uploads\/sites\/39\/2018\/05\/In_memory_computing-300x212.jpg 300w, https:\/\/blog.bham.ac.uk\/itinnovation\/wp-content\/uploads\/sites\/39\/2018\/05\/In_memory_computing-768x543.jpg 768w, https:\/\/blog.bham.ac.uk\/itinnovation\/wp-content\/uploads\/sites\/39\/2018\/05\/In_memory_computing-250x177.jpg 250w, https:\/\/blog.bham.ac.uk\/itinnovation\/wp-content\/uploads\/sites\/39\/2018\/05\/In_memory_computing.jpg 1163w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/p>\n<p>Figure 1. Traditional data warehouse approach <em>vs.<\/em> IMC-enabled data warehouse approach<\/p>\n<p>Besides the main benefit of quicker speed, IMC can also deliver in process innovation, simplification and flexibility.<\/p>\n<ul>\n<li>Process innovation: The performance gain of quicker processing speed for data makes it possible to consider\u00a0the real time data analysis, which could lead the innovative applications.<\/li>\n<li>Simplification: Due to the reductions in layers on the way from raw data to the results of data analysis, the simpler data models and a more unified interface can be designed.<\/li>\n<li>Flexibility: Integration of additional data sources and modification of the data analysis is more flexible because the reductions in layers.<\/li>\n<\/ul>\n<p>In this report, we introduced what in-memory database is and the issues that require attention when\u00a0considering in-memory computing. We focus our evaluation on the Exasol in-memory database solution in terms of its\u00a0functionality, deployment solutions and license models. The report aims to give the audience a background\u00a0understanding of the in-memory database (IMC) and a detail analysis of the Exasol solution.<\/p>\n<p><a href=\"https:\/\/intranet.birmingham.ac.uk\/it\/innovation\/documents\/public\/Experiments\/InMemoryComputingExasolEvaluation-17May2016.pdf\" target=\"_blank\" rel=\"noopener\">Read the full report.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>EXASOL (http:\/\/www.exasol.com\/en\/) provides an in-memory computing solution for data analytics. It combines in memory,\u00a0columnar storage and massively parallel technologies to support high performance, flexibility and scalability. In-memory computing (IMC) is an architecture-style where applications assume all the data required for processing is\u00a0located in the main memory of their computing environment. In-memory computing (IMC) is a &hellip; <a href=\"https:\/\/blog.bham.ac.uk\/itinnovation\/2016\/05\/25\/in-memory-computing-exasol-evaluation\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;In-memory computing &#8211; EXASOL evaluation&#8221;<\/span><\/a><\/p>\n","protected":false},"author":96,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,6],"tags":[],"class_list":["post-206","post","type-post","status-publish","format-standard","hentry","category-in-memory-computing","category-projects"],"_links":{"self":[{"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/posts\/206","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/users\/96"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/comments?post=206"}],"version-history":[{"count":1,"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/posts\/206\/revisions"}],"predecessor-version":[{"id":208,"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/posts\/206\/revisions\/208"}],"wp:attachment":[{"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/media?parent=206"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/categories?post=206"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/tags?post=206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}