Data processing: database and file management or data structures – Database and file access – Database access control methods
Reexamination Certificate
2004-10-13
2010-06-22
Vo, Tim T. (Department: 2168)
Data processing: database and file management or data structures
Database and file access
Database access control methods
C707S999001, C707S999009, C707S999107, C713S189000
Reexamination Certificate
active
07743069
ABSTRACT:
A database system providing SQL extensions for automated encryption and decryption of column data is described. In one embodiment, for example, in a database system, a method is described for providing automated encryption support for column data, the method comprises steps of: defining Structured Query Language (SQL) extensions for creating and managing column encryption keys, and for creating and managing database tables with encrypted column data; receiving an SQL statement specifying creation of a particular column encryption key; receiving an SQL statement specifying creation of a database table having particular column data encrypted with the particular column encryption key; and in response to a subsequent database operation that requires the particular column data that has been encrypted, automatically decrypting the particular column data for use by the database operation.
REFERENCES:
patent: 4375579 (1983-03-01), Davida et al.
patent: 5163097 (1992-11-01), Pegg
patent: 5191611 (1993-03-01), Lang
patent: 5228094 (1993-07-01), Villa
patent: 5606610 (1997-02-01), Johansson
patent: 5737419 (1998-04-01), Ganesan
patent: 5920630 (1999-07-01), Wertheimer et al.
patent: 5924094 (1999-07-01), Sutter
patent: 5956400 (1999-09-01), Chaum et al.
patent: 5987440 (1999-11-01), O'Neil et al.
patent: 5991399 (1999-11-01), Graunke et al.
patent: 6029160 (2000-02-01), Cabrera et al.
patent: 6038315 (2000-03-01), Strait et al.
patent: 6185685 (2001-02-01), Morgan et al.
patent: 6233617 (2001-05-01), Rothwein et al.
patent: 6327595 (2001-12-01), Lyson et al.
patent: 6336121 (2002-01-01), Lyson et al.
patent: 6360324 (2002-03-01), Van
patent: 7093137 (2006-08-01), Sato et al.
patent: 7111005 (2006-09-01), Wessman
patent: 7155612 (2006-12-01), Licis
patent: 7266699 (2007-09-01), Newman et al.
patent: 7269729 (2007-09-01), He et al.
patent: 2001/0056541 (2001-12-01), Matsuzaki et al.
patent: 2004/0255133 (2004-12-01), Lei et al.
patent: 2005/0198490 (2005-09-01), Jaganathan et al.
Mattsson, Ulf, A Database Encryption Solution That is Protecting Against External and Internal Threats, and Meeting Regulatory Requirements, Jul. 28, 2004.
Banks Barbara J.
Chitkara Rajnish K.
Patel Anita R.
Gortayo Dangelino N
Smart John A.
Sybase Inc.
Vo Tim T.
LandOfFree
Database system providing SQL extensions for automated... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Database system providing SQL extensions for automated..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database system providing SQL extensions for automated... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4228570