Browse > Article
http://dx.doi.org/10.9728/dcs.2018.19.2.335

A Design of Column-Group based Dynamic Page Storage Model for Mixed Workloads  

Park, Kyounghyun (Smart Data Research Group, ETRI)
Wonk, Hee Sun (Smart Data Research Group, ETRI)
Ryu, Keun Ho (Database/Bioinformatics Lab., Chungbuk National University)
Publication Information
Journal of Digital Contents Society / v.19, no.2, 2018 , pp. 335-341 More about this Journal
Abstract
There exists a limit in efficient processing of mixed workloads that database markets requires in recent years since existing database systems utilize a static page storage model. In this paper we propose a dynamic page storage model that can reflect the characteristics of mixed workloads. We also describe how to extract optimized column groups from given mixed workloads and how to construct pages dynamically. Finally, we show in our experiments that the proposed model is more efficient than the existing model in processing given mixed workloads.
Keywords
OLTP/OLAP; Page Storage Model; Mixed Workload; Cost Model; Column Group Selection Algorithm;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Hasso Plattner, "A Common Database Apoproach for OLTP and OLAP using an In-Memory Column Database", SIGMOD Conference, 2009.
2 George P. Copeland and Setrag Khoshafian, "A Decomposition Storage Model", SIGMOD Conference, pp. 268-279, 1985.
3 Anastassia Ailamaki, David J. DeWitt, Mark D. Hill and Marios Skounakis, "Weaving Relations for Cache Performance", VLDB 2001, pp. 169-180, 2001.
4 Franz Farber, Norman May, Wolfgang Lehner, Philipp GroBe, Ingo Muller, Hannes Rauhe and Jonathan Dees, "The SAP HANA Database - An Architecture Overview", IEEE Data Eng. Bull. 35, No. 1, pp. 28-33, 2012.
5 Martin Grund, Jene Kruger and Hasso Plattner, "HYRISE - A Main Memory Hybrid Storage Engine", PVLDB, pp.105-116, 2010.