On the Soundness Property for SQL Queries of Fine-grained Access Control in DBMSs
On the Soundness Property for SQL Queries of Fine-grained Access Control in DBMSs
复制标题
DBMS中细粒度访问控制的SQL查询的健全性
DOI：
--
复制
发表时间：
2009
期刊：
影响因子：
--
通讯作者：
Tao Jiang
中科院分区：
文献类型：
--
作者：
Jie Shi;Hong Zhu;Ge Fu;Tao Jiang
dbms中的细粒度访问控制方法应满足稳健性的要求，即在没有细粒度访问控制的情况下，在细粒度访问控制控制下的方法所返回的查询的答案与没有细粒度访问控制时的答案一致。然而，现有的技术不能保证所有SQL查询的正确性。因此，对于一种方法，实际需要声明，对于哪种类型的SQL查询，该方法可以保证可靠性。在本文中，我们提出了为此目标的初步努力。首先提出了一种带有查询修改的新算法。然后，我们对稳健性理论进行了细化、扩展和增强，并说明了对于哪些类型的SQL查询，所提出的算法可以保证稳健性。最后，我们利用查询修改实现了该算法，并进行了性能评估，表明该方法是可行的。
The fine-grained access control approaches in DBMSs should satisfy soundness property which requires the answer of a query returned by the approach under the control of fine-grained access control is consistent with the answer when there is no fine-grained access control. However, existing techniques cannot guarantee soundness property for all SQL queries. Therefore, for an approach, there is a practical need to state that, for which kinds of SQL queries, soundness property can be guaranteed by this approach. In this paper,we present our initial e ort for this objective. We firstly proposed a new algorithm with query modification. Then,we refine, extend and enhance the theory about soundness property, and state that, for which kinds of SQL queries, the soundness property is guaranteed by the proposed algorithm.Finally, we implement the algorithm using query modification and performance evaluation has also been conducted,which indicates this approach is feasible.