Tagged articles
fuzzy search
51 articles · Page 1 of 1
This article explains how to implement pagination using Redis Sorted Sets (ZSet) and multi-condition fuzzy queries using Hash with HSCAN, then combines both by caching filtered results in pattern-keyed ZSets for efficient paginated retrieval, including TTL-based expiration and data freshness strategies.
CachingHSCANHash
0 likes · 11 min read

This comprehensive guide covers nine essential ElasticSearch query types including match_all, term, terms, range, prefix, wildcard, regexp, bool compound queries, and fuzzy queries, with practical code examples for each method.
Elasticsearchbool queryfuzzy search
0 likes · 7 min read

This article explains how to implement pagination using Redis Sorted Sets, achieve multi‑condition fuzzy queries with Hashes and HSCAN, and then combine both techniques into a single solution while discussing performance trade‑offs and optimization strategies such as key expiration and data‑sync methods.
HSCANHashPagination
0 likes · 9 min read

This article examines why encrypted data hampers fuzzy queries, categorizes three implementation approaches—from naïve in‑memory decryption to conventional token‑based indexing and advanced algorithmic schemes—evaluates their performance, storage overhead, and security trade‑offs, and provides practical references.
Securityfuzzy searchtokenization
0 likes · 10 min read

This article analyzes three categories of techniques—naïve, conventional, and advanced—for performing fuzzy queries on encrypted fields, compares their memory and performance trade‑offs, provides concrete code examples and storage calculations, and recommends the most practical approach for production systems.
Database Securityencrypted datafuzzy search
0 likes · 13 min read

This article walks through the challenge of implementing MySQL‑LIKE style front‑and‑back wildcard searches in Elasticsearch, comparing match, match_phrase, n‑gram, legacy wildcard queries, and the new wildcard field type introduced in ES 7.9+, with code samples, performance benchmarks, and practical recommendations for choosing the optimal solution.
ElasticsearchN-gramfuzzy search
0 likes · 10 min read

This article explores the challenges of fuzzy searching encrypted data, categorizes three implementation approaches—naïve, conventional, and advanced—examines their trade‑offs, provides practical examples and performance calculations, and offers recommendations for secure and efficient query solutions.
Securitydatabaseencryption
0 likes · 10 min read

This article explains how to achieve conditional queries and pagination in Redis using Sorted Sets and Hashes, outlines the implementation steps for pagination, fuzzy multi‑condition search, their combination, and discusses performance optimizations such as expiration and real‑time data handling.
HashPaginationRedis
0 likes · 11 min read

This article examines three categories of techniques—naïve, conventional, and advanced—for enabling fuzzy queries on encrypted data, evaluates their pros and cons, provides implementation details, performance considerations, and references to real‑world solutions, guiding developers toward secure and efficient search strategies.
databaseencrypted datafuzzy search
0 likes · 12 min read

The article explains how to perform fuzzy queries in Redis using KEYS, SCAN, and collection‑type scans, enumerates commands that can block the single‑threaded server such as KEYS *, HGETALL, LRANGE, and provides practical mitigation strategies like incremental scans, key sharding, and asynchronous deletion.
RedisSCANblocking
0 likes · 24 min read

This article explains how to use Redis Sorted Sets for efficient pagination, leverages Hashes and HSCAN for multi‑condition fuzzy queries, and combines both techniques with performance‑optimizing strategies such as expiration and real‑time updates.
HashPaginationRedis
0 likes · 10 min read

This article introduces Elasticsearch's powerful Query DSL and walks through common query types—including match_all, term, terms, range, prefix, wildcard, regexp, bool, and fuzzy queries—providing clear explanations and complete JSON request examples for each.
Elasticsearchbool queryfull-text search
0 likes · 5 min read

The article explains how to retrieve coupon templates linked to a specific product ID in MySQL, compares a simple LIKE‑based fuzzy search with a more accurate multi‑value JSON index approach, and provides step‑by‑step SQL code and performance considerations.
Coupon TemplateIndexingJSON
0 likes · 6 min read

This article explains how to use Redis Sorted Sets and Hashes to achieve efficient pagination, fuzzy multi‑condition queries, and their combination, while also discussing performance‑optimisation strategies such as temporary ZSet expiration and data‑freshness handling, before concluding with a brief promotional segment.
HashPaginationRedis
0 likes · 12 min read

This article explains how to retrieve coupon templates linked to a specific product ID in MySQL, comparing a simple fuzzy‑search approach with a more accurate and performant multi‑value JSON index solution, and provides step‑by‑step SQL code examples.
Coupon TemplateJSONMulti-Value Index
0 likes · 6 min read

The article presents a Spring Boot 3.4 solution that uses Redis SortedSet for fast pagination and Hash with HSCAN for multi‑condition fuzzy search, combining them via a temporary ZSet with TTL to deliver high‑performance, memory‑efficient queries on complex data sets.
HSCANPaginationRedis
0 likes · 6 min read

This article examines the challenges of fuzzy searching encrypted data and presents three categories of solutions—naïve in‑memory decryption, conventional database‑level approaches, and advanced algorithmic methods—evaluating their implementation steps, security implications, and performance trade‑offs.
Algorithmencryptionfuzzy search
0 likes · 11 min read

This article introduces Fuse.js, a dependency‑free JavaScript library for client‑side fuzzy searching, explains its core concepts, installation methods, basic usage with code examples, and advanced configuration options for customizing search behavior.
Fuse.jsJavaScriptLibrary
0 likes · 8 min read

This article explains how to implement pagination, multi‑condition fuzzy search, and their combination using Redis Sorted Sets and Hashes, discusses performance optimizations and expiration strategies, and also contains promotional material for ChatGPT services and a community offering.
HashRedisSorted Set
0 likes · 12 min read

By leveraging Redis sorted sets for ordered pagination and hash fields with HSCAN for multi‑condition fuzzy matching, the article shows how to build a cached query pipeline that creates temporary ZSets keyed by pattern, supports efficient page retrieval, and uses expirations and refresh strategies to balance freshness and performance.
HashRedisZSet
0 likes · 9 min read

This article examines why encrypted data is unfriendly to fuzzy search, categorises three implementation strategies—naïve, conventional, and advanced—analyses their advantages and disadvantages, and provides practical guidance and reference links for securely enabling fuzzy queries on encrypted fields.
algorithm designdatabase queryencrypted data
0 likes · 11 min read

This article examines the challenges of fuzzy searching encrypted data and compares three implementation approaches—naïve, conventional, and advanced—detailing their principles, performance implications, storage costs, and security trade‑offs, ultimately recommending the conventional token‑based method for most practical applications.
Algorithmdatabaseencryption
0 likes · 13 min read

This article examines the challenges of fuzzy searching encrypted data and compares three categories of solutions—naïve, conventional, and advanced—detailing their implementation ideas, performance trade‑offs, storage costs, and security implications for real‑world applications.
Algorithmencryptionfuzzy search
0 likes · 10 min read

This article examines three categories of techniques—naïve, conventional, and advanced—for enabling fuzzy queries on encrypted data, comparing their implementation steps, performance impact, storage overhead, and security trade‑offs, and provides practical examples and reference links for further study.
Securitydatabaseencrypted data
0 likes · 11 min read

This guide demonstrates how to install PyMySQL or mysql‑connector‑python, connect to a MySQL database from Python, execute LIKE‑based fuzzy queries, handle results, and safely close resources, with detailed code examples and practical tips.
MySQLPyMySQLPython
0 likes · 7 min read

This article examines various techniques for enabling fuzzy queries on encrypted fields, comparing naive memory‑based methods, conventional token‑based approaches that leverage database indexes, and advanced cryptographic schemes, and recommends practical solutions for real‑world applications.
Database Encryptionencrypted datafuzzy search
0 likes · 12 min read

The article examines why encrypted sensitive fields such as passwords, phone numbers, and bank details need special handling, categorises three families of fuzzy‑search solutions for encrypted data, evaluates their security, performance and storage costs, and recommends a balanced conventional method for production use.
Algorithmdata protectiondatabase
0 likes · 10 min read

This article reviews three categories of techniques for performing fuzzy queries on encrypted data—naïve (memory‑based), conventional (database‑level encryption or tokenization), and advanced algorithmic solutions—detailing their implementation ideas, advantages, drawbacks, and practical recommendations.
fuzzy search
0 likes · 10 min read

The article explains how to use Redis Sorted Sets for efficient pagination, employ Hashes with HSCAN for multi‑condition fuzzy matching, combine both techniques into a unified solution, and apply expiration‑based optimizations to keep the cache lightweight and responsive.
HashPaginationRedis
0 likes · 10 min read

This article explains why traditional LIKE queries fail on encrypted sensitive fields, analyzes common scenarios, and presents four practical solutions—including tokenized ciphertext mapping—along with environment setup, Maven dependencies, and complete Spring Boot code to enable secure fuzzy searches on encrypted data.
JavaMyBatisSpring Boot
0 likes · 13 min read

This article compares Elasticsearch's ngram analyzer and the newer wildcard field for fuzzy searching, detailing configuration steps, performance trade‑offs, storage impact, and practical test results to help engineers choose the optimal approach for their use case.
ElasticsearchNGramSearch Optimization
0 likes · 8 min read

This article explores multiple strategies for enabling fuzzy search on encrypted phone numbers, including in‑memory caching, database decryption functions, segment‑wise storage, and dedicated fuzzy‑search fields, comparing their trade‑offs in performance, memory usage, and data consistency.
BackendMySQLencryption
0 likes · 10 min read

This article explores practical methods for performing fuzzy searches on encrypted phone numbers, covering in‑memory caching, database decryption functions, segment‑based storage, and adding dedicated fuzzy‑search fields to balance security, performance, and scalability.
Database DesignMySQLencryption
0 likes · 10 min read

This article explains how to enable fuzzy searches on encrypted sensitive fields such as names, phone numbers, and ID numbers in a Spring Boot backend by using a tokenized ciphertext mapping table, outlining four possible solutions, recommending the tokenized approach, and providing complete configuration and code examples.
Database EncryptionMySQLSpring Boot
0 likes · 11 min read

This article examines why encrypted data hinders fuzzy queries and presents three categories of solutions—naïve, conventional, and advanced—detailing their implementations, performance trade‑offs, and security implications to help developers choose an appropriate approach.
Algorithmencrypted datafuzzy search
0 likes · 9 min read

This article examines three categories of approaches—naïve, conventional, and advanced—for enabling fuzzy queries on encrypted fields, comparing their implementation steps, performance trade‑offs, storage costs, and security implications, and provides practical examples such as in‑memory decryption, tag mapping, database functions, tokenization, and algorithm‑level designs.
Database Securityencrypted dataencryption
0 likes · 11 min read

This article explains how to use Redis Sorted Sets and Hashes to achieve pagination, fuzzy multi‑condition queries, and their combination, while also discussing performance optimizations such as expiration and update strategies for generated ZSet collections.
HashPaginationZSet
0 likes · 8 min read

This article explains how to enable fuzzy search on encrypted sensitive fields such as phone numbers and ID numbers in a MySQL database by using Spring Boot, AOP, tokenized ciphertext mapping tables, and encrypted keyword queries to balance security and query performance.
BackendDatabase SecurityMySQL
0 likes · 11 min read

This article reviews why reversible encryption is needed for certain sensitive fields, classifies three categories of fuzzy‑search‑on‑encrypted‑data techniques—naïve, conventional, and advanced—and evaluates their implementation steps, performance trade‑offs, and practical recommendations.
AESAlgorithmdata security
0 likes · 11 min read

This article examines why encrypted data hinders fuzzy queries and compares three categories of solutions—naïve, conventional, and advanced—detailing their implementation steps, performance trade‑offs, storage costs, and practical suitability for real‑world systems.
data securityencryptionfuzzy search
0 likes · 11 min read

This article examines the challenges of performing fuzzy searches on encrypted data and compares three categories of solutions—naïve, conventional, and advanced—detailing their implementation methods, performance trade‑offs, storage costs, and security implications for real‑world applications.
Securitydatabaseencryption
0 likes · 12 min read

This article examines why encrypted data hinders fuzzy queries and compares three categories of solutions—naïve in‑memory decryption, conventional database‑level techniques, and advanced algorithmic methods—highlighting their trade‑offs in security, performance, and storage overhead.
encrypted datafuzzy searchperformance
0 likes · 10 min read

This article examines the challenges of fuzzy searching encrypted data and compares three categories of solutions—naïve (sand‑wich), conventional, and advanced (super)—detailing their implementation ideas, performance implications, and suitability for real‑world applications.
Algorithmdata securitydatabase
0 likes · 11 min read

This article examines various techniques for enabling fuzzy search on encrypted data, comparing naïve, conventional, and advanced algorithmic approaches, evaluating their security, performance, and storage trade‑offs, and provides practical implementation guidance and reference resources.
data privacydatabaseencryption
0 likes · 11 min read

This article examines why encrypted data hinders fuzzy queries, categorizes three implementation approaches—from naive in‑memory decryption to conventional database tricks and advanced algorithmic solutions—evaluates their security, performance, and storage impacts, and provides practical references for real‑world systems.
Algorithmdata securitydatabase
0 likes · 11 min read

This article examines why encrypted data resists fuzzy queries, categorizes three implementation strategies—from naïve to advanced—evaluates their security, performance, and storage trade‑offs, and recommends the most balanced approach for real‑world applications.
databaseencryptionfuzzy search
0 likes · 10 min read

This article examines why encrypted data hinders fuzzy queries, categorizes three implementation strategies—from naïve to conventional to advanced—explains their mechanisms, evaluates performance and security trade‑offs, and provides practical references for building searchable encrypted fields.
AlgorithmSecuritydata privacy
0 likes · 12 min read

This article examines why encrypted data is unfriendly to fuzzy search, categorizes three implementation strategies—naïve, conventional, and advanced—analyzes their advantages and drawbacks, and recommends practical solutions for secure yet searchable encrypted fields.
data privacyfuzzy searchinformation security
0 likes · 10 min read

This article examines the challenges of fuzzy searching encrypted data and presents three categories of solutions—naïve, conventional, and advanced—detailing their implementation ideas, performance trade‑offs, and practical recommendations for secure and efficient query processing.
data privacyfuzzy searchinformation security
0 likes · 11 min read

This article examines why encrypted data is unfriendly to fuzzy queries, categorizes three implementation approaches—naïve, conventional, and advanced—and evaluates their security, performance, and storage trade‑offs while providing practical code examples and reference resources.
Algorithmdata privacyfuzzy search
0 likes · 10 min read

This article examines the difficulty of fuzzy searching encrypted fields and compares three solution families—naïve memory‑loading or tag‑table tricks, conventional token‑based encryption with indexable columns, and advanced algorithmic designs—highlighting their security, performance, and storage implications while recommending the most practical approach.
AlgorithmSecuritydatabase
0 likes · 10 min read
