Incremental maintenance of horizontal view using PIVOT operation and differential files in relational DBMSs
- Authors
- Shin, Sung-Hyun; Moon, Yang-Sae; Kim, Jinho; Kim, Sang Wook
- Issue Date
- Aug-2008
- Publisher
- IEEE
- Citation
- 1st International Conference on the Applications of Digital Information and Web Technologies, ICADIWT 2008, pp.264 - 269
- Indexed
- SCOPUS
- Journal Title
- 1st International Conference on the Applications of Digital Information and Web Technologies, ICADIWT 2008
- Start Page
- 264
- End Page
- 269
- URI
- https://scholarworks.bwise.kr/hanyang/handle/2021.sw.hanyang/171902
- DOI
- 10.1109/ICADIWT.2008.4664356
- ISSN
- 0000-0000
- 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.
- Files in This Item
-
Go to Link
- Appears in
Collections - 서울 공과대학 > 서울 컴퓨터소프트웨어학부 > 1. Journal Articles
![qrcode](https://api.qrserver.com/v1/create-qr-code/?size=55x55&data=https://scholarworks.bwise.kr/hanyang/handle/2021.sw.hanyang/171902)
Items in ScholarWorks are protected by copyright, with all rights reserved, unless otherwise indicated.