Query optimization on VPD protected columns

Details Query optimization on VPD protected columns Query optimization on VPD protected columns

2007-06-18

2011-11-22

Le, Debbie (Department: 2168)

Data processing: database and file management or data structures

Database and file access

Database access control methods

C707S662000, C707S714000, C707S781000

Reexamination Certificate

active

08065329

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.

REFERENCES:
patent: 6983275 (2006-01-01), Koo et al.
patent: 7216126 (2007-05-01), Choy
patent: 7243097 (2007-07-01), Agrawal et al.
patent: 7464080 (2008-12-01), Cotner et al.
patent: 7584178 (2009-09-01), Dettinger et al.
patent: 7685194 (2010-03-01), Kabra et al.
patent: 7685437 (2010-03-01), Hacigumus et al.
patent: 2003/0014394 (2003-01-01), Fujiwara et al.
patent: 2006/0248592 (2006-11-01), Agrawal et al.
patent: 2007/0055658 (2007-03-01), Hsiao et al.
patent: 2007/0174285 (2007-07-01), Dutta et al.
patent: 2008/0189258 (2008-08-01), Miejer et al.
patent: 2008/0263006 (2008-10-01), Wolber et al.

Affiliated with

Also associated with

Rating

Query optimization on VPD protected columns does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Query optimization on VPD protected columns, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Query optimization on VPD protected columns will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4292773