Column masking of tables

Details Column masking of tables Column masking of tables

2007-12-18

2007-12-18

Cottingham, John (Department: 2167)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

10763583

ABSTRACT:
Returning rows having column values masked is disclosed. In response to receiving a database command, a modified database command is created that specifies whether to mask a value by returning a mask of the value instead of the value.In an embodiment, the condition expression is included in a policy function that is referenced by a policy. In an embodiment, the policy determines how the condition expressions are used. The condition expression may be used to determine which column values to mask. The condition expression may also be used to filter which rows are returned.

REFERENCES:
patent: 5133075 (1992-07-01), Risch
patent: 5241305 (1993-08-01), Fascenda et al.
patent: 5265221 (1993-11-01), Miller
patent: 5276901 (1994-01-01), Howell et al.
patent: 5335346 (1994-08-01), Fabbio
patent: 5428778 (1995-06-01), Brookes
patent: 5499368 (1996-03-01), Tate et al.
patent: 5659738 (1997-08-01), Letkeman et al.
patent: 5748899 (1998-05-01), Aldrich
patent: 5751949 (1998-05-01), Thomson et al.
patent: 5765154 (1998-06-01), Horikiri et al.
patent: 5787428 (1998-07-01), Hart
patent: 5815574 (1998-09-01), Fortinsky
patent: 5832226 (1998-11-01), Suzuki et al.
patent: 5848408 (1998-12-01), Jakobsson et al.
patent: 5864842 (1999-01-01), Pederson et al.
patent: 5940818 (1999-08-01), Malloy et al.
patent: 5963932 (1999-10-01), Jakobsson et al.
patent: 6026388 (2000-02-01), Liddy et al.
patent: 6035298 (2000-03-01), McKearney
patent: 6098081 (2000-08-01), Heidorn et al.
patent: 6134549 (2000-10-01), Regnier et al.
patent: 6253203 (2001-06-01), O'Flaherty et al.
patent: 6275824 (2001-08-01), O'Flaherty et al.
patent: 6275825 (2001-08-01), Kobayashi et al.
patent: 6308273 (2001-10-01), Goertzel et al.
patent: 6363387 (2002-03-01), Ponnekanti et al.
patent: 6449609 (2002-09-01), Witkowski
patent: 6487552 (2002-11-01), Lei et al.
patent: 6493722 (2002-12-01), Daleen et al.
patent: 6539398 (2003-03-01), Hannan et al.
patent: 6578037 (2003-06-01), Wong et al.
patent: 6587854 (2003-07-01), Guthrie et al.
patent: 6609121 (2003-08-01), Ambrosini et al.
patent: 6618721 (2003-09-01), Lee
patent: 6631371 (2003-10-01), Lei et al.
patent: 6678822 (2004-01-01), Morar et al.
patent: 6684227 (2004-01-01), Duxbury
patent: 6757670 (2004-06-01), Inohara et al.
patent: 6847998 (2005-01-01), Arcieri et al.
patent: 6920457 (2005-07-01), Pressmar
patent: 6986060 (2006-01-01), Wong
patent: 6996557 (2006-02-01), Leung et al.
patent: 7117197 (2006-10-01), Wong et al.
patent: 2001/0021929 (2001-09-01), Lin et al.
patent: 2002/0095405 (2002-07-01), Fujiwara
patent: 2003/0014394 (2003-01-01), Fujiwara et al.
patent: 2003/0236781 (2003-12-01), Lei et al.
patent: 2003/0236782 (2003-12-01), Wong et al.
patent: 2004/0139043 (2004-07-01), Lei et al.
patent: 2004/0254948 (2004-12-01), Yao
patent: 2005/0050046 (2005-03-01), Puz et al.
patent: 2005/0177570 (2005-08-01), Dutta et al.
patent: 1 089 194 (2001-04-01), None
patent: 2002/312220 (2002-10-01), None
International Preliminary Examining Authority, “Written Opinion”, PCT/US2003/041541, mailing date Sep. 1, 2005, 6 pages.
Current Claims, PCT/US2003/041541, 3 pages.
Motro, Amihai, “An Access Authorization Model for Relational Databases Based on Algebraic Manipulation of View Definitions,” Data Engineering, 1989, XP010015183.
Michael Stonebraker et al., “Access Control in a Relational Data Base Management System by Query Modification,” ACM/CSC-ER, 1974, XP-002319462, pp. 180-186.
T.F. Keefe et al., “Secure Query-Processing Strategies,” IEEE, No. 3, Mar. 1989, XP 000122365, pp. 63-70.
International Search Authority, “Notification of Transmittal of the International Search Report and the Written Opinion of the International Searching Authority, or the Declaration,” International Application No. PCT/US2004/043480, Apr. 22, 2005, 12 pages.

Affiliated with

Also associated with

Rating

Column masking of tables does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Column masking of tables, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Column masking of tables will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3897186