期刊名称：International Journal of Database Management Systems
印刷版ISSN：0975-5985
电子版ISSN：0975-5705
出版年度：2014
卷号：6
期号：3
页码：33
DOI：10.5121/ijdms.2014.6303
出版社：Academy & Industry Research Collaboration Center (AIRCC)
摘要：In recent years, the number of digital information storage and retrieval systems has increased immensely.Data warehousing has been found to be an extremely useful technology for integrating such heterogeneousand autonomous information sources. Data within the data warehouse is modelled in the form of a star orsnowflake schema which facilitates business analysis in a multidimensional perspective. As userrequirements are interesting measures of business processes, the data warehouse schema is derived fromthe information sources and business requirements. Due to the changing business scenario, the informationsources not only change their data, but also change their schema structure. In addition to the sourcechanges the business requirements for data warehouse may also change. Both these changes results in datawarehouse schema evolution. These changes can be handled either by just updating it in the DW model, orcan be developed as a new version of the DW structure. Existing approaches either deal with sourcechanges or requirements changes in a manual way and changes to the data warehouse schema is carriedout at the physical level. This may induce high maintenance costs and complex OLAP serveradministration. As ontology seems to be a promising solution for the data warehouse research, in thispaper an ontological approach to automate the evolution of a data warehouse schema is proposed. Thismethod assists the data warehouse designer in handling evolution at the ontological level based on whichdecision can be made to carry out the changes at the physical level. We evaluate the proposed ontologicalapproach with the existing method of manual adaptation of data warehouse schema.
关键词：Data Warehouse Evolution; Multidimensional Schema Evolution; Data Warehouse Schema Changes
