The Research And Implementation Of Data Warehouse United Identity Authentication System

With several years of technique development, data warehouse has become a strong data platform for enterprises that want to develop Business Intelligence. By establishing data warehouse platform, it can fulfil" the function of OLAP and data mining, which may offer critical data resource for company leader's decision. But as for enterprise data warehouse, a big resource environment, it can provide lots of interfaces. In the meantime, current developped data warehouse rarely concern the system security. To those big system such as data warehouse, system security concerns several factors with few standards. As for the security about data warehouse's outside interface, how to make a united interface for foreign applications for the safe use of all kinds of data warehouse resource has become enterprises' focus problem.Aiming at this problem, this paper summarized the traditional data warehouse system. By learning SOA, the digital signature related theories and Web Services technique, it offered data warehouse united identify authentication system that provide safe outside interface. This paper deeply analyzed how data warehouse provides safe application interface through internet, based on Web Services network security theory. By applying SOA, data warehouse can offer united application interface in complicated environment. As for this identity authentication system offered in this paper, it's on the basis of such data warehouse system, and by signing the SOAP message, it offered the security of Web Services message level. It included operation interface module, certification management module, encryption and authentication module, public interface module and authenticating client terminal, totaling 5 parts. It fulfiled the process of data's xml-encapsulating, SOAP message integrating, signing of SOAP message, verifying signature and xml-parsing.