A detailed analysis on data warehousing

Abstract

The usage of specialised design approaches is required for multidimensional modelling. Regardless of the facts that it's been written on how to develop a data warehouses, no consensus on a design methodology has emerged. This paper is based on a comprehensive discussion conducted during the Perspectives Workshop Data Warehousing just at Crossroads at Dagstuhl, and it seeks to explain some unsolved challenges in data warehouses modelling and design. Conceptual models, logical models, design techniques, comparability, and designs for new architectures as well as workloads are all factors that are taken into account.