Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-10-03
2006-10-03
Corrielus, Jean M. (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
07117197
ABSTRACT:
One embodiment of the present invention provides a system that selectively audits accesses to a relational database system. This system starts by receiving a query from a client at a database server. The system processes this query at the database server to produce a query result. The system also creates an audit record for rows in relational tables that are accessed by the query, and that satisfy an auditing condition. Next, the system records the audit record in an audit record store and returns the query result to the client. Integrating the auditing facility into the relational database system in this manner ensures that auditing is performed in the same way regardless of which application generates the query. Furthermore, this auditing is transparent to applications and users. In one embodiment of the present invention, the system additionally modifies the query so that processing the query causes the audit record to be created and recorded for rows in relational tables that are accessed by the query and that satisfy the auditing condition. In a variation on this embodiment, the auditing condition is associated with a table in the relational database system.
REFERENCES:
patent: 5519859 (1996-05-01), Grace
patent: 5625815 (1997-04-01), Maier et al.
patent: 5794252 (1998-08-01), Bailey et al.
patent: 5799323 (1998-08-01), Mosher et al.
patent: 6023509 (2000-02-01), Herbert et al.
patent: 6041310 (2000-03-01), Green et al.
patent: 6064951 (2000-05-01), Park et al.
patent: 6351753 (2002-02-01), Jagadish et al.
patent: 6553392 (2003-04-01), Mosher et al.
patent: 6584477 (2003-06-01), Mosher, Jr.
patent: 2003/0014394 (2003-01-01), Fujiwara et al.
patent: 2005/0257272 (2005-11-01), Nakao
patent: WO9912144 (1999-03-01), None
Elmasri et al. (Fundamentals Of Database System), Copy right 2000, p. 252-253.
PLattini et al. Secure database: state of the art, Security Technogy, 2000, date Oct. 23-25, 2000, p. 228-237.
John L. Berg. Data base directions: the next steps, ACM SIGMOS, ACM Press, date Nov. 1976.
Publication: “Access control in a relational data base management system by query modification” by Stonebraker and Wong, Proc.ACM Ann. Conf. San Diego, CA, Nov. 1974, pp. 180-187.
Lei Chon Hei
Sack Patrick F.
Wong Daniel Man-Hung
Corrielus Jean M.
Oracle International Corp.
Park Vaughan & Fleming LLP
To Baoquoc N.
LandOfFree
Selectively auditing accesses to rows within a relational... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Selectively auditing accesses to rows within a relational..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Selectively auditing accesses to rows within a relational... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3708848