Certified Organization, Volume3, Special Issue 6

ABSTRACT: Data warehouse is a set of integrated databases deliberated to sustain decision-making and problem solving, embracing highly abridged data. Data warehouse happens to be progressively acknowledged subject for contemporary researchers with respect to contemporary inclination of industry and organizational purview. Data warehouse is one of the imperative contrivances for decision support system. Data warehouse is a repository which contains all the organizations data in entire capacity. Concentration of hacking has been intensifying diurnally; hence the incorporation of security mechanism has become a decisive concern for any organization in shielding the sensitive data. The compiled paper illustrates that how an undemanding security mechanism could be applied to defend the warehouse from unauthenticated access and malicious intrusions. The formulated paper also expresses the significant purpose of security mechanism deployment, thereby not degrading the performance of the warehouse, that being the consistent interaction time amid the client and the warehouse. The compiled paper ensures the design and implementation of security mechanism for data warehouse performance enhancement, with the incorporation of the well-knitted two tier user authentication techniques