分区加密与结构化加密相结合实现OLAP的数据安全性

Implementation of Data Security of OLAP System Combined Partition Encryption with Structured Encryption

随着数据仓库、OLAP、数据挖掘技术的普及,基于数据仓库的决策支持系统在企业得到了广泛应用。而企业决策支持系统所涉及的数据是企业决策所需的重要数据,这些数据的丢失或泄露将直接影响企业的生存与发展,确保企业决策系统OLAP的安全性从而保护数据安全有其重要的意义。因此OLAP系统的数据安全性已成为数据安全领域的研究热点。以某"生产线质量控制决策分析系统"为研究平台,分析了系统的安全需求,针对平台上OLAP系统的多维数据,结合分区加密及结构化加密的特点,使用分区加密与结构化加密相结合,实现了OLAP系统的数据加密。通过实践证明,这种混合加密策略既能保证数据的安全性,又不影响OLAP系统的性能。该研究方案在同类系统中具有一定的推广应用价值。

With the popularization of data warehouse, OLAP and data mining technology, decision support system based on data ware- house has been widely used in enterprise, and the data involved in enterprise decision support system is important for enterprise decision -making. The loss or disclosure of these data will directly affect the survival and development of enterprises. To ensure the security of the enterprise decision-making system OLAP in order to protect data security has its important significance. Therefore, the data security of OLAP system has become a research hotspot in data security field. The security requirements of the system is analyzed based on a ＂quali- ty control decision analysis system of production line＂. According to the multi-dimensional data of the OLAP system on the platform, combined with the characteristics of partition encryption and structured encryption, the combination of them is used to achieve the OLAP system data encryption. The practice shows that this hybrid encryption strategy can not only guarantee the security of data,but also does not affect the performance of OLAP system. The research program has a certain value in the same kind of system.