International Journal of Engineering Associates
Data warehouse systems integrate data from heterogeneous sources and are used by decision makers to analyze the status and the development of an organization. Due to the sensitive data contain in the DW it is most important to specify a security, from early stages of DW design so that data must be secured. The process of developing a data warehouse starts with identifying and gathering requirements, designing the dimensional model followed by testing and maintenance. The design phase is the most important activity in the successful building of a data warehouse.