For a Microsoft SQL Server or an Oracle database you can also use stored procedures for the database import and automatic update. The use for the database import is that it returns the database records to create the fuzzy index from and allows to perform additional steps. For example, to log the access for your sensitive data. A stored procedure for the automatic update needs to return a date and a time that indicates when the database source was last changed.

This means that you have to ensure that the date for altering the database is stored and updated for any change. For example, it is necessary to know when a bank account is changed or when a customer is removed from the database altogether. The automatic update is performed only if your data has changed since the previous update.

The following are examples of functions and stored procedure syntax:

• Stored procedure for database import

  • Oracle Server sample

  • Microsoft SQL Server sample

• Stored procedure for automatic update

  • Oracle Server sample

  • Microsoft SQL Server sample