| 摘要 |
A system for tracking read/unread information in a relational database on a per-row, per user basis. Software hooks internal to the relational database, and that cover all access points of the relational database, ensure that tracking code is invoked for all accesses to the database. A tracking table tracks read/unread information on a per-user, per-row level. The internal software hooks are attached to database operations causing database reads. The tracking table may be exposed as part of the metadata for the database. The system may be embodied to track either table rows which have been read, or table rows that are unread. Database table rows may be tracked as read only when individually selected, or whenever they are part of a group of rows in a result set for a select operation. Compression of the tracking table may be accomplished using mechanisms for tracking sets of multiple rows.
|
