Description

We present experimental results that we obtained on real world database. The results emphasize the need for a database where roles are well defined and queries under different roles do not overlap. We suggest using query templates with minimized role definitions so that the risk model we introduce provides better risk management. Large amount of data and increased demand to extract, analyze and derive knowledge from data are impairing nowadays performance of enterprise mission critical systems such as databases. For databases, the challenging problem is to manage complex and sometimes non-optimized queries executed on enormous datasets stored across several tables. This generally results in increased query response time and loss of employees productivity. In this paper, we investigate the problem of enterprise computing resources availability. Our goal is to minimize performance degradation arising from resource intensive queries. We propose a risk aware approach that decouples the process of analyzing resource requirements of sql queries from their execution. We leverage XACML to con- trol users’ requests and to monitor database loads. This allows us to adjust available resources in a database system to computing resource needs of queries. A query can therefore run in a database if it does not severely impact the performance of the database.