Two-Tier Storage DBMS for High-Performance Query Processing

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 respo...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:JIPS(Journal of Information Processing Systems) 2008-03, Vol.4 (1), p.9-16
Hauptverfasser: Eo, Sang-Hun, Li, Yan, Kim, Ho-Seok, Bae, Hae-Young
Format: Artikel
Sprache:kor
Schlagworte:
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
container_end_page 16
container_issue 1
container_start_page 9
container_title JIPS(Journal of Information Processing Systems)
container_volume 4
creator Eo, Sang-Hun
Li, Yan
Kim, Ho-Seok
Bae, Hae-Young
description 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 disk-oriented DBMS with an added advantage to manage massive data at the same time.
format Article
fullrecord <record><control><sourceid>kiss_kisti</sourceid><recordid>TN_cdi_kisti_ndsl_JAKO200816863296682</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><kiss_id>2692737</kiss_id><sourcerecordid>2692737</sourcerecordid><originalsourceid>FETCH-LOGICAL-k502-f9007e2cb1be96974c3d0921d87730e172dc85c9d6d8f666149935340fd9f3ad3</originalsourceid><addsrcrecordid>eNo9jktLw0AYRQdRMNT-AjezcTkwj8zjw1Wtj6qVVppFdyGZRxzaJjJTkf57A4qrexeHc-8ZKjgFTgyV23NUMNCKABPbSzTNObaUaikVZ7JAt9X3QKroE94ch9R0Ht_fvW1wGBJexO6DrH0a-6HprcfvXz6d8DoN1o-WvrtCF6HZZz_9ywmqHh-q-YIsV0_P89mS7CTlJMA457ltWetBgS6tcOM35ozWgnqmubNGWnDKmaCUYiWAkKKkwUEQjRMTdPOr3cV8jHXv8r5-mb2uOKWGKaMEB6UMH7nrfy7XnykemnSquQKuhRY_8OVLmw</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype></control><display><type>article</type><title>Two-Tier Storage DBMS for High-Performance Query Processing</title><source>Elektronische Zeitschriftenbibliothek - Frei zugängliche E-Journals</source><creator>Eo, Sang-Hun ; Li, Yan ; Kim, Ho-Seok ; Bae, Hae-Young</creator><creatorcontrib>Eo, Sang-Hun ; Li, Yan ; Kim, Ho-Seok ; Bae, Hae-Young</creatorcontrib><description>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 disk-oriented DBMS with an added advantage to manage massive data at the same time.</description><identifier>ISSN: 1976-913X</identifier><identifier>EISSN: 2092-805X</identifier><language>kor</language><publisher>한국정보처리학회</publisher><subject>DBMS ; Query Processing ; Storage Management</subject><ispartof>JIPS(Journal of Information Processing Systems), 2008-03, Vol.4 (1), p.9-16</ispartof><lds50>peer_reviewed</lds50><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><link.rule.ids>230,314,776,780,881</link.rule.ids></links><search><creatorcontrib>Eo, Sang-Hun</creatorcontrib><creatorcontrib>Li, Yan</creatorcontrib><creatorcontrib>Kim, Ho-Seok</creatorcontrib><creatorcontrib>Bae, Hae-Young</creatorcontrib><title>Two-Tier Storage DBMS for High-Performance Query Processing</title><title>JIPS(Journal of Information Processing Systems)</title><addtitle>JIPS(Journal of Information Processing Systems)</addtitle><description>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 disk-oriented DBMS with an added advantage to manage massive data at the same time.</description><subject>DBMS</subject><subject>Query Processing</subject><subject>Storage Management</subject><issn>1976-913X</issn><issn>2092-805X</issn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>2008</creationdate><recordtype>article</recordtype><sourceid>JDI</sourceid><recordid>eNo9jktLw0AYRQdRMNT-AjezcTkwj8zjw1Wtj6qVVppFdyGZRxzaJjJTkf57A4qrexeHc-8ZKjgFTgyV23NUMNCKABPbSzTNObaUaikVZ7JAt9X3QKroE94ch9R0Ht_fvW1wGBJexO6DrH0a-6HprcfvXz6d8DoN1o-WvrtCF6HZZz_9ywmqHh-q-YIsV0_P89mS7CTlJMA457ltWetBgS6tcOM35ozWgnqmubNGWnDKmaCUYiWAkKKkwUEQjRMTdPOr3cV8jHXv8r5-mb2uOKWGKaMEB6UMH7nrfy7XnykemnSquQKuhRY_8OVLmw</recordid><startdate>20080330</startdate><enddate>20080330</enddate><creator>Eo, Sang-Hun</creator><creator>Li, Yan</creator><creator>Kim, Ho-Seok</creator><creator>Bae, Hae-Young</creator><general>한국정보처리학회</general><scope>HZB</scope><scope>Q5X</scope><scope>JDI</scope></search><sort><creationdate>20080330</creationdate><title>Two-Tier Storage DBMS for High-Performance Query Processing</title><author>Eo, Sang-Hun ; Li, Yan ; Kim, Ho-Seok ; Bae, Hae-Young</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-k502-f9007e2cb1be96974c3d0921d87730e172dc85c9d6d8f666149935340fd9f3ad3</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>kor</language><creationdate>2008</creationdate><topic>DBMS</topic><topic>Query Processing</topic><topic>Storage Management</topic><toplevel>peer_reviewed</toplevel><toplevel>online_resources</toplevel><creatorcontrib>Eo, Sang-Hun</creatorcontrib><creatorcontrib>Li, Yan</creatorcontrib><creatorcontrib>Kim, Ho-Seok</creatorcontrib><creatorcontrib>Bae, Hae-Young</creatorcontrib><collection>Korean Studies Information Service System (KISS)</collection><collection>Korean Studies Information Service System (KISS) B-Type</collection><collection>KoreaScience</collection><jtitle>JIPS(Journal of Information Processing Systems)</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext</fulltext></delivery><addata><au>Eo, Sang-Hun</au><au>Li, Yan</au><au>Kim, Ho-Seok</au><au>Bae, Hae-Young</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><atitle>Two-Tier Storage DBMS for High-Performance Query Processing</atitle><jtitle>JIPS(Journal of Information Processing Systems)</jtitle><addtitle>JIPS(Journal of Information Processing Systems)</addtitle><date>2008-03-30</date><risdate>2008</risdate><volume>4</volume><issue>1</issue><spage>9</spage><epage>16</epage><pages>9-16</pages><issn>1976-913X</issn><eissn>2092-805X</eissn><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 disk-oriented DBMS with an added advantage to manage massive data at the same time.</abstract><pub>한국정보처리학회</pub><tpages>8</tpages><oa>free_for_read</oa></addata></record>
fulltext fulltext
identifier ISSN: 1976-913X
ispartof JIPS(Journal of Information Processing Systems), 2008-03, Vol.4 (1), p.9-16
issn 1976-913X
2092-805X
language kor
recordid cdi_kisti_ndsl_JAKO200816863296682
source Elektronische Zeitschriftenbibliothek - Frei zugängliche E-Journals
subjects DBMS
Query Processing
Storage Management
title Two-Tier Storage DBMS for High-Performance Query Processing
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-19T11%3A16%3A33IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-kiss_kisti&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.genre=article&rft.atitle=Two-Tier%20Storage%20DBMS%20for%20High-Performance%20Query%20Processing&rft.jtitle=JIPS(Journal%20of%20Information%20Processing%20Systems)&rft.au=Eo,%20Sang-Hun&rft.date=2008-03-30&rft.volume=4&rft.issue=1&rft.spage=9&rft.epage=16&rft.pages=9-16&rft.issn=1976-913X&rft.eissn=2092-805X&rft_id=info:doi/&rft_dat=%3Ckiss_kisti%3E2692737%3C/kiss_kisti%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rft_kiss_id=2692737&rfr_iscdi=true