Publication: Olap application development for multiple versions query in multidimensional database systems
Issued Date
2005-12-01
Resource Type
Other identifier(s)
2-s2.0-84883279983
Rights
Mahidol University
Rights Holder(s)
SCOPUS
Bibliographic Citation
18th International Conference on Computer Applications in Industry and Engineering 2005, CAINE 2005. (2005), 152-157
Suggested Citation
Jarernsri L. Mitrpanont, Somchart Fugkeaw Olap application development for multiple versions query in multidimensional database systems. 18th International Conference on Computer Applications in Industry and Engineering 2005, CAINE 2005. (2005), 152-157. Retrieved from: https://repository.li.mahidol.ac.th/handle/123456789/16460
Research Projects
Organizational Units
Authors
Journal Issue
Thesis
Title
Olap application development for multiple versions query in multidimensional database systems
Author(s)
Other Contributor(s)
Abstract
OLAP is an analytical tool necessary for strategic decision support. The analytical query is typically made over a multidimensional database (MDB) or a data warehouse (DW). Thus, the query result reflects the analytical views of structure and content of the underlying database. If there are changes in MDB or DW, the query result will represent the information according to the current database schema and instances. However, the historical data may be needed for an advance decision support analysis such as multi-period of data analysis, trend prediction, and what-if analysis. In this paper, we propose temporal version mapping concept and SQL query rewriting technique that is capable of supporting the OLAP query analysis in multidimensional database systems modeled on multiversion schema. Finally, we present our implementation system prototype as a supporting tool for the analytical queries made on several versions of multidimensional database.