Research On OLAP Security Based On Production Line Quality Control System

With the advent of the era of b ig data, data warehouse has been widely used in various fields, the analytical processing technology of enterprise data warehouse has became more mature. The managers of enterprise can make the decisions by the important data which can be extracted from the analysis system, loss or disclosure of data will directly affect the decision- making efficiency and the development of enterprises. Therefore, to ensure the safety of OLAP system has became more important. C urrently, the methods used to ensure the security of data warehouse are identity authentication, access control, data encryption and so on, how to fit the actual application requirements and under the premise of the min impact of system, to choose the effective security technologies to ensure the enterprises OLAP systems is the key issue.Background with “hisense production line quality control system”, this dissertation researched the security technologies of OLAP, aimed at the actual used of OLAP, especially to research identity authentication, access control, data encryption. Through the analysis of OLAP system function and the demand for security, to compare these technologies and background with this OLAP system and the time of encryption or decryption, finally to choose the method of security: dyna mic message identity authentication, security level of role access control, partition data encryption. During to compare the time of system performance, to use the partition data encryption may impact the system. So, based on the data construction and operation of this O LAP system, this article has improved the method of data encryption, to combine the structured encryption and the partition data encryption, finally to verify the feasibility of the improved data encryption method by experiments.