数据仓库安全需求模型研究

Security requirements model for data warehouse

研究了数据仓库安全需求的形式化描述.阐述了数据仓库的几种主要安全需求,在多维表达式查询语言(MDX)的基础上,使用与微软SQLSERVER数据库中CREATECUBE语句类似的语法定义了一种多维安全约束语言(MDSCL)来描述数据仓库的安全策略.以典型的销售立方体为例,给出了多维安全约束语言支持的几种安全约束类型.结果表明,用多维安全约束语言表示的安全模型符合数据仓库的开放本质,能够描述数据仓库的大部分安全需求,实用性强,方便系统管理员、设计人员及终端用户理解和运用.

This paper focused on the formal description of data warehouse security requirements. Security requirements for data warehouse were presented. Based on multidimensional expressions (MDX), a multidimensional security constraint language (MDSCL) was defined to describe the security strategy of data warehouse by syntax similar to the CREATE CUBE statement in Microsoft SOL SERVER database. This approach makes the language readable for system administrators and designers, or end-users. Taken a typical scales cube as an example several safety constraint type supported by multi-dimentional safety constraint type were given. The security model represented by MDSCL accorded with the open nature, of data warehouses and can describe most of security requirements in data warehouse in practice.