This workflow demonstrates how the Exorbyte Single-Field Indexer and Approximate Index Matcher can significantly improve data-matching performance through efficient indexing.
The workflow:
Loads customer data (names, email addresses, phone numbers etc.) and creates an index on the customer names
Samples 2,000 names from the same data
Queries the index using the Approximate Index Matcher to find the best match for each of the 2,000 names out of the 100,000 indexed entries.
Repeats the same operation without indexing, using KNIME's String Matcher node.
Compares the execution times of the two matcher nodes.
🔎Insights
Simplicity: Exorbyte’s Single-Field Indexer and Approximate Index Matcher enable straightforward index creation and efficient fault-tolerant querying.
Speed: Index-based matching completes in fractions of a second, compared to several minutes when using non-indexed matching with the String Matcher node.