Aiming at the research of the OLAP safety of a production line quality control system, combined with a variety of security scheme,such as user identity authentication, user access control and data encryption, to realize the OLAP system safety. First of all, through dynamic message password for access to authenticate a user,the user will be the right operation interface according to the charac-ter level,which will avoid the threats of inferences. At the same time,to encrypt the sensitive data by the combination of structured and partition encryption method will prevent the malicious users to steal important information from the background. Through the comparison of the response time consumption of before and after,the results show that this security scheme cannot influence the performance of sys-tem and meet the requirements of system security.%针对某生产线质量控制系统的OLAP安全性研究，文中结合运用了用户身份认证、用户访问控制以及数据加密等多种安全性方案实现系统OLAP安全性。在OLAP系统安全性方案实现中具体体现为：首先，通过动态短信密码对访问用户进行身份验证；其次，对用户角色操作级别进行了详细分析，用户将根据角色级别对应权限登录相应的系统操作界面，用以避免推理威胁；最后，实现了对数据仓库中存储的企业敏感数据结合了结构化加密与分区加密方法，有效预防恶意用户从后台侵入盗取企业重要信息。在所有安全方案得以实现后，通过对采取了安全性方案前后的OLAP系统进行用户相同查询请求的响应时间开销进行直观数据对比，验证了该方案达到不影响系统性能且满足系统安全性的要求。
展开▼
