Browse Prior Art Database

A Light-Weight Method to Optimize the Detection of Modified Objects in a Database

IP.com Disclosure Number: IPCOM000130645D
Publication Date: 2005-Oct-31
Document File: 1 page(s) / 34K

Publishing Venue

The IP.com Prior Art Database

Abstract

There is no easy way to detect database-record changes. In order to detect changes, a program has to pull data down to the client and compare with cached values. This process is expensive and should be avoided. One proposed solution is to create a table that stores details about each change to the database including the table name, the key to the record changed, and a list of the fields that were modified. This table can then be polled much more efficiently as it only contains new values when something has changed. Microsoft has introduced a notification service for SQL server, but it requires installing the notification services software and writing notification and subscription software. Our proposed solution differs from the Microsoft solution because it is much simpler and can be used on older versions of a database. It does not require any additional software to be installed, configured, etc. It requires the installation of a few database tables and triggers. It is not a true notification but in fact is an efficient polling method.

This text was extracted from a Microsoft Word document.
This is the abbreviated version, containing approximately 100% of the total text.

OPTIMIZED DATABASE-CHANGE DETECTION

A Light-Weight Method to Optimize the Detection of Modified Objects in a Database

Disclosed Anonymously

There is no easy way to detect database-record changes.  In order to detect changes, a program has to pull data down to the client and compare with cached values.  This process is expensive and should be avoided.

One proposed solution is to create a table that stores details about each change to the database including the table name, the key to the record changed, and a list of the fields that were modified.  This table can then be polled much more efficiently as it only contains new values when something has changed.

Microsoft has introduced a notification service for SQL server, but it requires installing the notification services software and writing notification and subscription software. Our proposed solution differs from the Microsoft solution because it is much simpler and can be used on older versions of a database.  It does not require any additional software to be installed, configured, etc.  It requires the installation of a few database tables and triggers.  It is not a true notification but in fact is an efficient polling method.