Two-Tier Storage DBMS for High-Performance Query Processing


Sang-Hun Eo, Yan Li, Ho-Seok Kim, Hae-Young Bae, Journal of Information Processing Systems Vol. 4, No. 1, pp. 9-16, Mar. 2008  

10.3745/JIPS.2008.4.1.009
Keywords: DBMS, Storage Management, Query Processing
Fulltext:

Abstract

This paper describes the design and implementation of a two-tier DBMS for handling massive data and providing faster response time. In the present day, the main requirements of DBMS are figured out using two aspects. The first is handling large amounts of data. And the second is providing fast response time. But in fact, Traditional DBMS cannot fulfill both the requirements. The disk-oriented DBMS can handle massive data but the response time is relatively slower than the memory-resident DBMS. On the other hand, the memory-resident DBMS can provide fast response time but they have original restrictions of database size. In this paper, to meet the requirements of handling large volumes of data and providing fast response time, a two-tier DBMS is proposed. The cold-data which does not require fast response times are managed by disk storage manager, and the hot-data which require fast response time among the large volumes of data are handled by memory storage manager as snapshots. As a result, the proposed system performs significantly better than diskoriented DBMS with an added advantage to manage massive data at the same time.


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]
Sang-Hun Eo, Yan Li, Ho-Seok Kim, & Hae-Young Bae (2008). Two-Tier Storage DBMS for High-Performance Query Processing. Journal of Information Processing Systems, 4(1), 9-16. DOI: 10.3745/JIPS.2008.4.1.009.

[IEEE Style]
S. Eo, Y. Li, H. Kim and H. Bae, "Two-Tier Storage DBMS for High-Performance Query Processing," Journal of Information Processing Systems, vol. 4, no. 1, pp. 9-16, 2008. DOI: 10.3745/JIPS.2008.4.1.009.

[ACM Style]
Sang-Hun Eo, Yan Li, Ho-Seok Kim, and Hae-Young Bae. 2008. Two-Tier Storage DBMS for High-Performance Query Processing. Journal of Information Processing Systems, 4, 1, (2008), 9-16. DOI: 10.3745/JIPS.2008.4.1.009.