Intermingling evolutionary and versioning approach for data warehouse by Versioning-Algebra

Abstract

Traditional databases are unable to support analytical business requirements. As a result, the conception of data warehouse was floated. So, data warehouse with its subjective schemas facilitates analytical business requirements. But, Conventional data warehouse cannot handle changes to its operational sources, for such purpose two approaches had been proposed: i) evolution ii) versioning.In this study, we have presented a blend of evolution and versioning approaches with the help of schema-versioning-functions, named: i) versioning function ii) reviving function iii) qualifying function. The paper formalizes algebra for version evolution operations (VEO) by modifying existing calculi. This algebra will provide strong foundations for data warehousing tools which evolutes and maintains multiple versions.