Invention Grant
- Patent Title: Query optimization on VPD protected columns
-
Application No.: US13278095Application Date: 2011-10-20
-
Publication No.: US09886481B2Publication Date: 2018-02-06
- Inventor: Chon Hei Lei
- Applicant: Chon Hei Lei
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Becker Bingham LLP
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F21/62

Abstract:
A method and apparatus for preserving optimization hints in a transformed query is provided. In one embodiment, the methodology is implemented by query optimization logic. Upon receiving a first query to access values in a column of a table protected by an access control policy, the query optimization logic creates a second query that is equivalent to the first query as subject to the access control policy. Furthermore, the second query contains a new predicate that conjunctively joins a clone of a first expression in a predicate of the first query with a second expression that is derived, based on the access control policy, from the first expression. In one embodiment, the query optimization logic submits the second query for execution.
Public/Granted literature
- US20120095988A1 QUERY OPTIMIZATION ON VPD PROTECTED COLUMNS Public/Granted day:2012-04-19
Information query