Data warehouse testing and security: A conspectus

Abstract

Data warehouse is a central storage facility that stores information from many sources which can be in structured or unstructured format, queries this information for retrieval based on certain input facts and delivers the outcome analysis to many analysts, to meet decision support and business intelligence requirement. Not much research has been carried out in this research area in the past few years. In this research paper, we are discussing the data warehouse architecture and the testing techniques that are used for best suited to be used for the data warehouses. Literature for the testing techniques is integrated at one place and the outcome is to focus on security issues while performing data warehouse testing.