Fuzzy databases

A fuzzy database is an export of a single table or view from a relational database.

Examples of why you would use a fuzzy database instead of a relational database include:

  • The database is relatively static

  • The relational database is on a secured network and not readily available

  • The database contains sensitive data in another table or view

  • The database is large

  • A fuzzy index enables fast searching and matching of text values using non-exact string matching either in record sets or in specific columns

A Local Fuzzy Database is added, configured, and maintained within the project itself. A Remote Fuzzy Database however, is added to a project, but configured and maintained using the Kofax Search and Matching Server. See the Kofax Search and Matching Server Getting Started Guide for more information.

If you add a Local Fuzzy Database to your project and start processing batches, any changes to the database require you to update the database and batch class to ensure those changes are propagated through to any batches. You are also limited by the size of the memory in the machine running Kofax Transformation Modules - Server or one of the user interactive modules.

The advantages of using Remote Fuzzy Databases instead of Local Fuzzy Databases are that any changes to a database are handled outside of the Kofax Capture workflow. This means that you do not need to update either the project or the associated batch class. Also, since the Kofax Search and Matching Server runs in 64-bit, the memory on the production machine is no longer a limiting factor, and databases that contain a significantly increased amount of data are supported.

To manage fuzzy databases: