一种优化的复合数据权限模型研究和实现

Research and Implementation of an Optimized Compound Data Access Control Model

随着企业级ERP系统规模的不断扩大,业务数据和基础数据越来越庞大和复杂。传统的复合数据权限方案采用递归的方式查询数据,只能满足一些日常的小数据量操作,对于大数据量的访问操作,往往响应时间过长,难以满足用户需求,影响了用户体验。为了提高响应速度,减少数据过滤时间,同时保证数据的安全性,在传统数据权限模型的基础上,引入了一种改进的前序遍历树算法,对传统模型进行优化,并对其进行设计和实现,提高了查询访问速度,完全满足了用户需求。

The business data and basic data become giant and complex with the development of ERP system.It's difficult to handle huge data operation with the traditional compound data access control model using recursive method,and the user response time becomes too long.In order to decrease the response time and guard the data safety,based on the traditional model,an improved nested set algorithm is brought,the traditional model is optimized and the design and implementation are given.So it can optimize the query access. In the implemention,the HR area code tree and organization tree is used,so it can simplify the right configuration.