• Journal of Internet Computing and Services
    ISSN 2287 - 1136 (Online) / ISSN 1598 - 0170 (Print)
    https://jics.or.kr/

Column-aware Transaction Management Scheme for Column-Oriented Databases


Si-Woo Byun, Journal of Internet Computing and Services, Vol. 15, No. 4, pp. 125-134, Aug. 2014
10.7472/jksii.2014.15.4.125, Full Text:
Keywords: column-oriented database, flash memory, Datawarehouse, column-aware locking, Simulation

Abstract

The column-oriented database storage is a very advanced model for large-volume data analysis systems because of its superior I/O performance. Traditional data storages exploit row-oriented storage where the attributes of a record are placed contiguously in hard disk for fast write operations. However, for search-mostly datawarehouse systems, column-oriented storage has become a more proper model because of its superior read performance. Recently, solid state drive using MLC flash memory is largely recognized as the preferred storage media for high-speed data analysis systems. The features of non-volatility, low power consumption, and fast access time for read operations are sufficient grounds to support flash memory as major storage components of modern database servers. However, we need to improve traditional transaction management scheme due to the relatively slow characteristics of column compression and flash operation as compared to RAM memory. In this research, we propose a new scheme called Column-aware Multi-Version Locking (CaMVL) scheme for efficient transaction processing. CaMVL improves transaction performance by using compression lock and multi version reads for efficiently handling slow flash write/erase operation in lock management process. We also propose a simulation model to show the performance of CaMVL. Based on the results of the performance evaluation, we conclude that CaMVL scheme outperforms the traditional scheme.


Statistics
Show / Hide Statistics

Statistics (Cumulative Counts from November 1st, 2017)
Multiple requests among the same browser session are counted as one view.
If you mouse over a chart, the values of data points will be shown.


Cite this article
[APA Style]
Byun, S. (2014). Column-aware Transaction Management Scheme for Column-Oriented Databases. Journal of Internet Computing and Services, 15(4), 125-134. DOI: 10.7472/jksii.2014.15.4.125.

[IEEE Style]
S. Byun, "Column-aware Transaction Management Scheme for Column-Oriented Databases," Journal of Internet Computing and Services, vol. 15, no. 4, pp. 125-134, 2014. DOI: 10.7472/jksii.2014.15.4.125.

[ACM Style]
Si-Woo Byun. 2014. Column-aware Transaction Management Scheme for Column-Oriented Databases. Journal of Internet Computing and Services, 15, 4, (2014), 125-134. DOI: 10.7472/jksii.2014.15.4.125.