期刊名称：International Journal of Innovative Research in Science, Engineering and Technology
印刷版ISSN：2347-6710
电子版ISSN：2319-8753
出版年度：2014
期号：NCETAS
页码：165
出版社：S&S Publications
摘要：Data warehouse is a set of integrated databases deliberated to sustain decision-making and problemsolving, embracing highly abridged data. Data warehouse happens to be progressively acknowledged subject forcontemporary researchers with respect to contemporary inclination of industry and organizational purview. Datawarehouse is one of the imperative contrivances for decision support system. Data warehouse is a repository whichcontains all the organizations data in entire capacity. Concentration of hacking has been intensifying diurnally; hencethe incorporation of security mechanism has become a decisive concern for any organization in shielding the sensitivedata.The compiled paper illustrates that how an undemanding security mechanism could be applied to defend the warehousefrom unauthenticated access and malicious intrusions. The formulated paper also expresses the significant purpose ofsecurity mechanism deployment, thereby not degrading the performance of the warehouse, that being the consistentinteraction time amid the client and the warehouse.The compiled paper ensures the design and implementation of security mechanism for data warehouse performanceenhancement, with the incorporation of the well-knitted two tier user authentication techniques.
关键词：Data Warehouse; Dimension Table; Fact Table; View; ETL; Two Tier User Authentication.
