Design and development of a multiversion OLAP application

This paper proposes a temporal version mapping concept and a SQL query rewriting technique to support the OLAP query analysis in multidimensional database (MDB) systems modeled on multiversion schema. Based on our proposed model, an integration solution of MDB schema change and multiversion OLAP que...

Full description

Saved in:
Bibliographic Details
Main Authors: Jarernsri L. Mitrpanont, Somchart Fugkeaw
Other Authors: Mahidol University
Format: Conference or Workshop Item
Published: 2018
Subjects:
Online Access:https://repository.li.mahidol.ac.th/handle/123456789/23194
Tags: Add Tag
No Tags, Be the first to tag this record!
Institution: Mahidol University
id th-mahidol.23194
record_format dspace
spelling th-mahidol.231942018-08-20T13:57:13Z Design and development of a multiversion OLAP application Jarernsri L. Mitrpanont Somchart Fugkeaw Mahidol University Computer Science This paper proposes a temporal version mapping concept and a SQL query rewriting technique to support the OLAP query analysis in multidimensional database (MDB) systems modeled on multiversion schema. Based on our proposed model, an integration solution of MDB schema change and multiversion OLAP query analysis performed over the changed database schema are taken into account. In addition, we present the system design and implementation of our prototype system to demonstrate our research idea. Copyright 2006 ACM. 2018-08-20T06:57:13Z 2018-08-20T06:57:13Z 2006-11-21 Conference Paper Proceedings of the ACM Symposium on Applied Computing. Vol.1, (2006), 493-497 2-s2.0-33751024122 https://repository.li.mahidol.ac.th/handle/123456789/23194 Mahidol University SCOPUS https://www.scopus.com/inward/record.uri?partnerID=HzOxMe3b&scp=33751024122&origin=inward
institution Mahidol University
building Mahidol University Library
continent Asia
country Thailand
Thailand
content_provider Mahidol University Library
collection Mahidol University Institutional Repository
topic Computer Science
spellingShingle Computer Science
Jarernsri L. Mitrpanont
Somchart Fugkeaw
Design and development of a multiversion OLAP application
description This paper proposes a temporal version mapping concept and a SQL query rewriting technique to support the OLAP query analysis in multidimensional database (MDB) systems modeled on multiversion schema. Based on our proposed model, an integration solution of MDB schema change and multiversion OLAP query analysis performed over the changed database schema are taken into account. In addition, we present the system design and implementation of our prototype system to demonstrate our research idea. Copyright 2006 ACM.
author2 Mahidol University
author_facet Mahidol University
Jarernsri L. Mitrpanont
Somchart Fugkeaw
format Conference or Workshop Item
author Jarernsri L. Mitrpanont
Somchart Fugkeaw
author_sort Jarernsri L. Mitrpanont
title Design and development of a multiversion OLAP application
title_short Design and development of a multiversion OLAP application
title_full Design and development of a multiversion OLAP application
title_fullStr Design and development of a multiversion OLAP application
title_full_unstemmed Design and development of a multiversion OLAP application
title_sort design and development of a multiversion olap application
publishDate 2018
url https://repository.li.mahidol.ac.th/handle/123456789/23194
_version_ 1763491688046657536