Publication: Direct access versioning for multidimensional database schema creation
Issued Date
2006-12-01
Resource Type
Other identifier(s)
2-s2.0-34547373091
Rights
Mahidol University
Rights Holder(s)
SCOPUS
Bibliographic Citation
Proceedings - Sixth IEEE International Conference on Computer and Information Technology, CIT 2006. (2006)
Suggested Citation
Jarernsri L. Mitrpanont, Somchart Fugkeaw Direct access versioning for multidimensional database schema creation. Proceedings - Sixth IEEE International Conference on Computer and Information Technology, CIT 2006. (2006). doi:10.1109/CIT.2006.79 Retrieved from: https://repository.li.mahidol.ac.th/handle/20.500.14594/23189
Research Projects
Organizational Units
Authors
Journal Issue
Thesis
Title
Direct access versioning for multidimensional database schema creation
Author(s)
Other Contributor(s)
Abstract
This paper proposes a multidimensional schema management approach by focusing on the dimension version update to support the multiple versions query in OLAP application. The evolution support of the multidimensional database (MDB) is based on the schema versioning concept. We introduce the Direct Access Versioning (DAV) technique to minimize cost of schema version creation of the MDB schema appearing in data warehouse (DW) systems. The technique maintains the change of dimension data by retaining only the changed class of dimensions in a supporting dimension version (SDV) which will be available for an immediate construction of any schema version. Thus, the efficiency of schema version construction is significantly improved since no dynamic dimension instance conversion is required. © 2006 IEEE.