Multi User Profile Orient Access Control based Integrity Management for Security Management in Data Warehouse

Background/Objectives: The Aim of this research work to demonstrate that the security enhancement of data warehousing, the methods face major challenges in integrity management and have the responsibility to restrict the unauthorized user. Methods/Statistical Analysis: There are many access control methods discussed earlier for the problem of integrity management, and some of them have been discussed using the user profiles. Still they suffer from the problem of efficiency in integrity management. Findings: To overcome such issues, in this paper a multi-user profile orient access depths measure based integrity management is proposed. The method maintains a set of Meta data which keep track of data objects in a hierarchical manner according to their importance and sensitivity of the data. The method first identifies a set of objects being specified from the input query and the sensitive tree; the method computes the access depthness measure. The access depthness is computed based on the level of objects being called and the access level the user has been given and the number of objects the user has access. Application/Improvement: Based on computed access depths measure user query is being processed, and the method improves the performance of integrity management.