Role-based Security Model Of Data Warehouse And Implementation

The 21st century will be an informational time which takes the computer technology and the knowledge economy as the core.Along with the computer technology and the networking rapid development and the database application unceasing deepening,the data warehouse and the data mining technology become one of computer science area of technology hot spots. The personnel caring data warehouse security and the correlation technical data are few,which cause the data warehouse to be in the dangerous region of security aspect.Moreover,the data quantity increases,the summary increase as well as the data value unceasing increase unceasingly along with the data warehouse in,also causes the data warehouse the safety control to appear especially importantly,is different because of the data warehouse and the common business database, it' s secure hidden danger lies in by no means creates the data the destruction,but is divulges a secret with the strategy.The access control design and the secure plan are in a data warehouse construction important work.The data warehouse system use is the multi-dimensional data model,it' s data originates from the database, but it also has some difference with the traditional operation database model,the relational model basis data sheet implementation protection, but multi-dimensional data model basis dimension,level,granularity level implementation data protection;At the same time,the data warehouse security also has certain relation with the operating system security, namely the data warehouse security and the operating system security and links the database system safety is related.This article author participates in and realizes "the Yunnan Province Economic and Trade Committee' s key enterprise dynamic examination system",is the Yunnan Province Economic and Trade Committee for Yunnan Province key enterprise's many economic indicators,then proposed the corresponding economic policy and a development plan key project,uses SQL 2000 Analysis the Service data warehouse technology realization,may the very good development customer need each item of report form through Reporting Service,has realized the Yunnan Province Economic and Trade Committee to the entire province each key enterprise's examination request.In the item design process,as a result of the data privacy and the system safety need,the author acts according to the data warehouse security "the smallest jurisdiction" the principle,proposed one kind based on the role data warehouse security model,through this model design and the realization,has solved this system safety control.This article main structure arrangement is as following:First chapter is the introductory remarks part,mainly to aspects and so on this article research background,content,method,major point and innovation, paper structure narrates and the explanation;Second chapter for data warehouse safe outline,description and data warehouse safe correlation primary coverage;Third chapter is "the Yunnan Province Economic and Trade Committee key enterprise dynamic examination system" and the data warehouse structure,the data warehouse and realizes the method based on the role access control,uses many kinds of methods safely through the correlation data warehouse,summarizes based on the role access control and the method merit and the realization process.The fourth chapter analysis based on the role data warehouse safe establishment general method,the existing role security model and the insufficiency,proposed own role security model,and to proposed the model feasibility and the concrete realization must solve the main question carries on the analysis. The fifth chapter realization proposes based on the role data warehouse security model,and applies it in "the Yunnan Province Economic and Trade Committee key enterprise dynamic examination system".