A hybrid filtering approach for storage optimization in main-memory cloud database
Loading...
Date
2015
Authors
Journal Title
Journal ISSN
Volume Title
Type
Article
Publisher
Elsevier B.V.
Series Info
Egyptian Informatics Journal
16
16
Scientific Journal Rankings
Abstract
Enterprises and cloud service providers face dramatic increase in the amount of data stored in private and public clouds. Thus, data storage costs are growing hastily because they use only one single high-performance storage tier for storing all cloud data. There's considerable potential to reduce cloud costs by classifying data into active (hot) and inactive (cold). In the main-memory databases research, recent works focus on approaches to identify hot/cold data. Most of these approaches track tuple accesses to identify hot/cold tuples. In contrast, we introduce a novel Hybrid Filtering Approach (HFA) that tracks both tuples and columns accesses in main-memory databases. Our objective is to enhance the performance in terms of three dimensions: storage space, query elapsed time and CPU time. In order to validate the effectiveness of our approach, we realized its concrete implementation on Hekaton, a SQL's server memory-optimized engine using the well-known TPC-H benchmark. Experimental results show that the proposed HFA outperforms Hekaton approach in respect of all performance dimensions. In specific, HFA reduces the storage space by average of 44�96%, reduces the query elapsed time by average of 25�93% and reduces the CPU time by average of 31�97% compared to the traditional database approach. � 2015
Description
Scopus
MSA Google Scholar
MSA Google Scholar
Keywords
Cloud computing, Cloud storage, Cold data management, Hot/cold data, Main-memory database, Cloud computing, Database systems, Digital storage, Query processing, Cloud service providers, Cloud storages, Database approaches, Hot/cold data, Main memory database, Performance dimensions, Storage optimization, Tpc-h benchmarks, Information management