On the Performance of Three In-Memory Data Systems for On Line Analytical Processing.
Saved in:
| Title: | On the Performance of Three In-Memory Data Systems for On Line Analytical Processing. |
|---|---|
| Authors: | HRUBARU, Ionuț, FOTACHE, Marin |
| Source: | Informatica Economica; Mar2017, Vol. 21 Issue 1, p5-15, 11p |
| Subject Terms: | INFORMATION storage & retrieval systems, DATABASES, BIG data, CACHE memory, SQL |
| Abstract: | In-memory database systems are among the most recent and most promising Big Data technologies, being developed and released either as brand new distributed systems or as extensions of old monolith (centralized) database systems. As name suggests, in-memory systems cache all the data into special memory structures. Many are part of the NewSQL strand and target to bridge the gap between OLTP and OLAP into so-called Hybrid Transactional Analytical Systems (HTAP). This paper aims to test the performance of using such type of systems for TPCH analytical workloads. Performance is analyzed in terms of data loading, memory footprint and execution time of the TPCH query set for three in-memory data systems: Oracle, SQL Server and MemSQL. Tests are subsequently deployed on classical on-disk architectures and results compared to in-memory solutions. As in-memory is an enterprise edition feature, associated costs are also considered. [ABSTRACT FROM AUTHOR] |
| Copyright of Informatica Economica is the property of Informatica Economica and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.) | |
| Database: | Complementary Index |
Full Text Finder 
Nájsť tento článok vo Web of Science Be the first to leave a comment!