Welcome > Use the Transformation Designer > Manage databases > Fuzzy databases

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, any changes to the database require you to update the database and content to ensure those changes are propagatedcorrectly. You are also limited by the size of the memory in the machine running the Kofax TotalAgility - Transformation 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. 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: