Browse Prior Art Database

Database Read Triggers

IP.com Disclosure Number: IPCOM000214109D
Publication Date: 2012-Jan-10
Document File: 1 page(s) / 17K

Publishing Venue

The IP.com Prior Art Database

Abstract

Disclosed is a method to create a database trigger that executes every time a user reads the database.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 100% of the total text.

Page 01 of 1

Database Read Triggers

Database products and software provide a trigger mechanism that performs a given function when a database record updates. There is no such trigger when a user merely reads the database. Such a trigger would be very helpful in auditing access to the database as well as tracking which users are interested in specific data. As a result, this helps create targeted advertisements for those users.

Known solutions include reading through the database software logs or System Management Facility (SMF) records, but this requires access to these logs as well as the skill to parse them. It is also very time consuming.

The solution here provides a way to create a database trigger that executes every time a user reads the database.

The solution modifies current database software syntax for the CREATE TRIGGER statement to allow something like:
CREATE TRIGGER mytrigger AFTER SELECT OF column-name ON table-name triggered-action.

A possible triggered action is an update of an audit log that would then clearly show the history of accesses to the table.

1