Incremental maintenance of horizontal view using PIVOT operation and differential files in relational DBMSs
DC Field | Value | Language |
---|---|---|
dc.contributor.author | Shin, Sung-Hyun | - |
dc.contributor.author | Moon, Yang-Sae | - |
dc.contributor.author | Kim, Jinho | - |
dc.contributor.author | Kim, Sang Wook | - |
dc.date.accessioned | 2022-10-07T10:07:26Z | - |
dc.date.available | 2022-10-07T10:07:26Z | - |
dc.date.created | 2022-09-16 | - |
dc.date.issued | 2008-08 | - |
dc.identifier.issn | 0000-0000 | - |
dc.identifier.uri | https://scholarworks.bwise.kr/hanyang/handle/2021.sw.hanyang/171902 | - |
dc.description.abstract | To analyze multidimensional data conveniently and efficiently, OLAP(On-Line Analytical Processing) systems are widely using views with horizontal form to represent measurement values over multiple dimensions, while conventional RDBMSs usually manage tables with vertical form. In this paper, we propose an incremental maintenance of these horizontal views which updates efficiently them according to the changes of base source tables. We first propose an overall framework processing queries over horizontal views transformed from source tables with vertical form. In order to execute this view maintenance process efficiently, we keep every changes of source tables into differential files then we modify the horizontal views with the differential files. Because differential files have vertical forms, their tuples are converted to horizontal forms which are identical to horizontal views then they are applied to the maintenance of these views. Experimental results show that the proposed method is more effective than existing methods. | - |
dc.language | 영어 | - |
dc.language.iso | en | - |
dc.publisher | IEEE | - |
dc.title | Incremental maintenance of horizontal view using PIVOT operation and differential files in relational DBMSs | - |
dc.type | Article | - |
dc.contributor.affiliatedAuthor | Kim, Sang Wook | - |
dc.identifier.doi | 10.1109/ICADIWT.2008.4664356 | - |
dc.identifier.scopusid | 2-s2.0-57949093990 | - |
dc.identifier.bibliographicCitation | 1st International Conference on the Applications of Digital Information and Web Technologies, ICADIWT 2008, pp.264 - 269 | - |
dc.relation.isPartOf | 1st International Conference on the Applications of Digital Information and Web Technologies, ICADIWT 2008 | - |
dc.citation.title | 1st International Conference on the Applications of Digital Information and Web Technologies, ICADIWT 2008 | - |
dc.citation.startPage | 264 | - |
dc.citation.endPage | 269 | - |
dc.type.rims | ART | - |
dc.type.docType | Conference Paper | - |
dc.description.journalClass | 1 | - |
dc.description.isOpenAccess | N | - |
dc.description.journalRegisteredClass | scopus | - |
dc.subject.keywordPlus | Changes of base | - |
dc.subject.keywordPlus | Existing methods | - |
dc.subject.keywordPlus | Framework processing | - |
dc.subject.keywordPlus | Incremental maintenances | - |
dc.subject.keywordPlus | Multidimensional datums | - |
dc.subject.keywordPlus | Multiple dimensions | - |
dc.subject.keywordPlus | View maintenances | - |
dc.subject.keywordPlus | Maintenance | - |
dc.identifier.url | https://ieeexplore.ieee.org/document/4664356 | - |
Items in ScholarWorks are protected by copyright, with all rights reserved, unless otherwise indicated.
222, Wangsimni-ro, Seongdong-gu, Seoul, 04763, Korea+82-2-2220-1365
COPYRIGHT © 2021 HANYANG UNIVERSITY.
Certain data included herein are derived from the © Web of Science of Clarivate Analytics. All rights reserved.
You may not copy or re-distribute this material in whole or in part without the prior written consent of Clarivate Analytics.