A flash-based decomposition storage model

Authors:
Qingling Cao;Zhichao Liang;Yulei Fan;Xiaofeng Meng
Affiliations:
School of Information, Renmin University of China, Beijing, China;School of Information, Renmin University of China, Beijing, China;School of Information, Renmin University of China, Beijing, China;School of Information, Renmin University of China, Beijing, China
Venue:
DASFAA'12 Proceedings of the 17th international conference on Database Systems for Advanced Applications
Year:
2012

Citing 10
Cited 0

A decomposition storage model

SIGMOD '85 Proceedings of the 1985 ACM SIGMOD international conference on Management of data
C-store: a column-oriented DBMS

VLDB '05 Proceedings of the 31st international conference on Very large data bases
Integrating compression and execution in column-oriented database systems

Proceedings of the 2006 ACM SIGMOD international conference on Management of data
Design of flash-based DBMS: an in-page logging approach

Proceedings of the 2007 ACM SIGMOD international conference on Management of data
Sybase IQ multiplex - designed for analytics

VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Column-stores vs. row-stores: how different are they really?

Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Fast scans and joins using flash drives

Proceedings of the 4th international workshop on Data management on new hardware
Understanding intrinsic characteristics and system implications of flash memory based solid state drives

Proceedings of the eleventh international joint conference on Measurement and modeling of computer systems
Query processing techniques for solid state drives

Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
SQL server column store indexes

Proceedings of the 2011 ACM SIGMOD International Conference on Management of data

Quantified Score

Hi-index	0.00

Visualization

Abstract

The traditional HDD-based columnar storage is an important technology to improve the performance of query-intensive database. However, some features of HDD weaken the advantages of columnar storage. In this paper, we study the advantages of SSD over HDD on columnar storage and propose a new columnar storage model based on SSD, named Flash Based Decomposition Storage Model(FBDSM). FBDSM stores each attribute of a table in a column and each column has a log table to store its recently updated data, which will be merged with original data periodically. In this way, FBDSM not only provides efficient update, but also almost has no negative impact on query performance.