This article details Alibaba Cloud's architecture for multimodal data lake retrieval using EMR Serverless StarRocks and DLF Paimon, covering design principles like early filtering and on-demand reading, Global Index mechanics, format selection between Paimon and Lance, real-world deployments in Alibaba's A Lake and AI Data platforms, and a complete autonomous driving loop from bad case detection to model validation.
Autonomous DrivingDLF PaimonData Lake Architecture
Alibaba Cloud's EMR Serverless StarRocks now fully supports Apache Paimon 2.0, enabling unified multimodal analytics and retrieval by integrating vector search, full-text search, scalar filtering, and BLOB handling within a single lakehouse architecture, with best practices for data management and query optimization.
This article introduces Meilisearch as a lightweight, fast alternative to Elasticsearch, detailing its features, Docker installation, and RESTful API usage for index management, settings configuration, document CRUD operations, and advanced search with pagination, sorting, and filtering.
WeChat stores 1.3 billion users' chat records locally on devices using SQLite via its WCDB framework, avoiding EB-scale server costs while enabling instant search via FTS5 full-text indexing, with SQLCipher encryption and automatic sharding at 240MB per database file.
This article explains why WeChat stores chat records locally using SQLite instead of cloud databases, detailing the cost savings, privacy benefits, and performance advantages of embedded databases, along with WeChat's custom WCDB framework, FTS5 full-text search, encryption, and the trade-offs of local-only storage.
Zhihu built a RAG-based database intelligent customer service using MongoDB 8.3's hybrid vector and full-text search, enabling developers to self-serve common DB issues while DBAs maintain a versioned, permission-controlled knowledge base with traceable answers and rollback capabilities.
This article explains MySQL full-text search using inverted indexes as an alternative to LIKE % queries, covering index creation, natural language, boolean, and query expansion modes with syntax examples and performance considerations.
This report validates a read-write separation architecture using Dameng DM8 for transactions and Easysearch for full-text search, syncing 1 million Chinese documents via Logstash; full sync completes in 5.5 minutes, incremental changes propagate within 30 seconds, and search latency drops 12x compared to SQL LIKE while maintaining identical recall.
This article details integrating Dameng DM8 database with Easysearch 2.4.0 via Logstash 9.0 for full-text search, covering version compatibility fixes, JDBC driver configuration, logical deletion handling, timestamp boundary issues, IK analyzer alignment for Chinese text, and benchmark results showing 17x faster queries with consistent recall versus LIKE.
Manticore Search, a C++-based search engine forked from Sphinx, claims to outperform Elasticsearch by up to 15x on small datasets and 4x on large data, offering SQL syntax, MySQL protocol compatibility, real-time inserts, and built-in replication while using minimal memory.
C++ search engineDocker deploymentElasticsearch alternative
StarRocks introduces multimodal capabilities to handle structured, semi-structured, and unstructured data in a single SQL pipeline, combining object processing, full-text and vector search, and lakehouse integration with Paimon and Lance for unified retrieval and analysis.
Alibaba Cloud's EMR Serverless StarRocks Stella 2.2 unifies vector search, full-text search, and AI functions across both internal and lake tables (Paimon, Iceberg, Lance), enabling a single SQL interface for multimodal retrieval, AI-powered analytics, and RAG workloads without data movement.
The article contrasts Elasticsearch’s search‑oriented design—using inverted indexes, near‑real‑time BASE consistency, schema‑free JSON documents, and horizontal scaling—with relational databases’ precise row‑based storage, ACID guarantees, strict schemas, B+‑tree indexes, and vertical scaling, showing how they complement rather than compete.
This article explains why using LIKE% for fuzzy searches in MySQL is inefficient, introduces InnoDB full‑text search (available since MySQL 5.6), describes inverted indexes, shows how to create and query full‑text indexes with natural language, boolean, and query‑expansion modes, discusses relevance calculation, stopwords, token‑size parameters, and provides the syntax for dropping full‑text indexes.
The article explains why many developers stuck with MySQL should consider PostgreSQL, highlighting its superior SQL standards support, MVCC concurrency, rich indexing, JSONB performance, full‑text search, extensive extensions, and practical installation and Java integration steps, while also comparing pros, cons, and ideal use cases.
This article breaks down the underlying logic, ideal scenarios, benchmark data, decision trees, and real‑world case studies for full‑text (BM25), vector, and graph retrieval, showing why hybrid approaches dominate production while each technique has distinct strengths and trade‑offs.
Redis 8.0 consolidates many previously external modules—JSON, time‑series, vector search, probabilistic data structures, and more—into a single package, and this article walks through 16 concrete scenarios ranging from field‑level cache expiration to AI‑ready vector similarity search, showing exact commands and when to prefer each feature.
The article argues that relying on many specialized databases creates operational complexity, higher costs, and maintenance overhead, while PostgreSQL’s extensible ecosystem—offering full‑text search, vector, time‑series, JSONB, and more—delivers comparable or superior algorithms, proven performance, and a simpler, more reliable stack for the vast majority of use cases, especially in AI applications.
PostgreSQL’s extensible architecture lets it evolve from a relational DB into a true multi‑model system supporting graphs, vectors, full‑text, time‑series, GIS and key‑value data, with detailed architecture explanations, practical code demos, cross‑model queries, extension selection, and production‑grade best‑practice tips.
This article walks through the design and implementation of a nested comment system with likes, @‑mentions, and sensitive‑word filtering, plus full‑text search using Elasticsearch, covering database schema changes, backend services, Vue components, and recommendation logic for a technical blog platform.
This article explains PostgreSQL's native full‑text search, its core concepts of tsvector and tsquery, demonstrates how to use built‑in functions and operators, compares built‑in, zhparser, and pg_search extensions for Chinese tokenization, and provides best‑practice tips for indexing, triggers, and performance optimization.
This article walks through integrating Spring Boot with Elasticsearch to enable fuzzy search, keyword highlighting, tokenized queries, and real‑time data sync, covering environment setup, Maven dependencies, application.yml configuration, entity annotations, CRUD via Repository, advanced queries with RestTemplate, IK analyzer usage, common pitfalls, and synchronization strategies.
The Taobao‑Tmall customer operations team built an integrated vector‑plus‑full‑text retrieval solution on Hologres, achieving millisecond‑level recall for massive unstructured knowledge bases, boosting intelligent客服, rule comparison, and sentiment analysis across multiple business scenarios.
This guide explains why pure vector retrieval often fails for version‑specific queries, introduces hybrid search that combines semantic and keyword matching, and provides step‑by‑step code and SQL examples for enabling PgVector hybrid search in LangChain4j 1.11.0.
This guide explains why InnoDB fuzzy queries lose indexes, introduces MySQL full‑text search with inverted indexes, shows how to create and use full‑text indexes via CREATE TABLE and ALTER statements, and demonstrates natural language, boolean, and query‑expansion modes with practical SQL examples.
The article argues that a single PostgreSQL instance can handle caching, queuing, full‑text search, and real‑time notifications, eliminating the need for separate services like Redis, RabbitMQ, and Elasticsearch, while reducing cost and complexity.
VectorChord‑BM25 is a PostgreSQL extension that adds native BM25 ranking and tokenization, delivering up to three‑fold query‑per‑second improvements over ElasticSearch while maintaining comparable relevance scores, and includes detailed installation, usage examples, and performance analysis.
The article explains how PostgreSQL has evolved from a simple relational store into a versatile platform that supports full‑text search, vector similarity, geospatial queries, JSONB, message queues, and analytical workloads, allowing developers to replace multiple specialized tools with a single unified system.
This guide explains why Meilisearch is a lightweight alternative to Elasticsearch, walks through Docker‑based installation, demonstrates index creation, settings configuration, document CRUD operations, and various search queries, all with concrete curl commands and code examples.
This guide explains how InnoDB implements full‑text search with inverted indexes, shows how to create and drop full‑text indexes, demonstrates MATCH() AGAINST() syntax across natural language, boolean, and query‑expansion modes, and covers relevance scoring, stopwords, token size limits, and real‑world query examples.
This guide explains how MySQL InnoDB full‑text search works, covering inverted indexes, index creation, query syntax for natural language, boolean, and query‑expansion modes, relevance calculation, and index maintenance.
This guide walks through installing Meilisearch via Docker, creating indexes, configuring settings, managing documents, and performing instant, sortable, and filtered searches using its RESTful API, while highlighting its speed, low hardware requirements, and multilingual support.
This article compares MySQL's InnoDB and MyISAM storage engines across dimensions such as transaction support, locking, file structure, indexing, full‑text search, and COUNT(*) performance, helping developers choose the appropriate engine based on workload and consistency requirements.
This tutorial explains how to install Xunsearch, integrate it with PHP, and index song data to dramatically improve search performance on a music website, providing step‑by‑step code examples and best practices for building an efficient full‑text search solution.
This tutorial explains how to install Xunsearch, integrate it with PHP, index music data, and execute fast, accurate full‑text searches for songs on a music website, providing code examples and best practices for improving user search experience.
This guide details the four index types in StarRocks 3.3—Bitmap, Bloom Filter, N-Gram Bloom Filter, and Full-Text Inverted Index—covering their core principles, supported data types, creation syntax, ideal use cases (low/high cardinality, fuzzy/long-text queries), anti-patterns, and real-world optimization examples with performance metrics.
This article explains Elasticsearch's core architecture including distributed sharding, near real-time search, inverted indexes, and key concepts like indices, documents, mappings, and replicas, along with typical use cases and the Elastic Stack ecosystem.
This tutorial explains how to use Milvus 2.5's new full‑text, BM25 keyword matching, and hybrid search capabilities—including step‑by‑step setup, schema design, code examples, and RAG integration—to achieve high recall and precision in large‑scale AI vector retrieval scenarios.
This article explains Elasticsearch wildcard type's core advantages for non-prefix wildcard queries, details inverted index structure, compares query efficiency with keyword and text types, and provides optimization strategies including keyword_prefixes, filter clauses, and monitoring.
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.
This article provides a comprehensive overview of ElasticSearch, covering its role as a distributed full‑text search engine built on Lucene, key concepts such as index, type, document, field, shard and replica, the analysis pipeline, inverted index mechanics, and the two‑phase query‑fetch search workflow.
This article explains MySQL's InnoDB full‑text search, covering the theory of inverted indexes, how to create and use full‑text indexes with various MATCH…AGAINST modes, Boolean operators, query expansion, relevance calculation, and index removal, illustrated with practical SQL examples and diagrams.
Elasticsearch, built on Lucene, is a distributed search and analytics engine offering full-text search, log and metric analysis, real-time data processing, and recommendation capabilities; the guide explains its core functions, basic index and document management, and advanced query and aggregation features with practical API examples.
This article explains how MySQL's InnoDB engine implements full‑text search using inverted indexes, shows how to create and use full‑text indexes with various query modes, demonstrates Boolean operators and query expansion, and covers index removal techniques.
This article introduces RediSearch—a Redis module for full‑text search—covers its rich feature set, shows benchmark comparisons with Elasticsearch for index building and query throughput, and provides step‑by‑step installation and command‑line usage examples for creating, querying, and managing indexes.
This tutorial explains how to install Xunsearch, integrate it with PHP, index music data, and perform efficient full‑text song searches on a music website, providing step‑by‑step code examples and best practices for improving search relevance and speed.
This article explains how to install the Xunsearch full‑text search engine, integrate it with PHP, create search objects, set queries, index music data from a database, and process results to improve song search functionality on a music website.
This article introduces RediSearch, a Redis module for full‑text search, outlines its many features, compares its indexing and query performance with Elasticsearch, provides installation methods (source and Docker), and demonstrates command‑line operations for creating indexes, adding documents, searching, and managing indexes.
This tutorial explains how to install Xunsearch, integrate it with PHP, create search objects, execute queries, and index music data to improve song search performance on a music website, providing complete code examples and step‑by‑step instructions.
This guide explains how to install, configure, and use the PHP‑based TNTSearch engine, covering its key features, required dependencies, index creation, various search modes, dynamic updates, custom tokenizers, geo‑search, and text classification with practical code examples.
This article explains InnoDB clustered and secondary indexes, their physical B‑tree storage, page‑size and fill‑factor settings, the three‑phase sorted index build process, and the design, tables, cache, document‑ID handling, transaction semantics, and monitoring of InnoDB full‑text indexes.
RediSearch is a Redis module that provides full‑text search, secondary indexing, and query capabilities; this guide introduces its features, compares performance with Elasticsearch, details installation via source and Docker, and demonstrates index creation, document management, and advanced search queries with code examples.
This article explains how MySQL InnoDB full‑text search works, covering inverted index structures, creation and deletion of full‑text indexes, query syntax for natural language, boolean, and query‑expansion modes, relevance calculation, and practical examples with SQL code.
Manticore Search is a high‑performance, open‑source C++ search engine that builds on Sphinx, offering real‑time indexing, SQL support, distributed search, and significant speed advantages over Elasticsearch, with simple installation via Linux packages or Docker and extensive plugin ecosystems for various applications.
This guide walks you through Milvus 2.5’s new full‑text, keyword‑matching, and hybrid search capabilities, showing how to set up the schema, install dependencies, prepare data with LangChain, and combine dense and sparse vectors for RAG‑enabled retrieval using Python.
This article provides a step‑by‑step guide on setting up Xunsearch with PHP to achieve real‑time full‑text search and automatic index updates, covering environment preparation, server installation, search script implementation, and index‑updating routines.
This article explains how to install Xunsearch, integrate it with PHP, index music data, and perform fast, accurate song searches on a music website using the Xunsearch full‑text search engine.
This article introduces RediSearch—a Redis module for full‑text search—detailing its features, performance comparison with Elasticsearch, index‑building and query benchmarks, installation methods (source and Docker), and comprehensive command‑line examples for creating, querying, updating, and managing indexes.
This tutorial explains how to install Xunsearch, integrate it with PHP, index music data, and perform fast, accurate full‑text searches for songs on a music website, providing code examples and best practices for improving search performance.
The article compares RedisSearch and Elasticsearch across definition, storage model, performance, query capabilities, scalability, ease of integration, and operational considerations, helping readers decide which solution best matches requirements such as real‑time response, data volume, query complexity, and existing tech stacks.
This article explains how to install Xunsearch, integrate it with PHP, index music data, and perform fast, accurate song searches on a music website, providing step‑by‑step code examples and a concluding overview of its benefits.
This guide walks through five real‑world Elasticsearch use cases—including full‑text product search with highlighting, centralized log collection and analysis, personalized video recommendation, price‑range aggregation for e‑commerce, and geo‑location restaurant search—detailing index design, query syntax, Docker setup, and front‑end integration.
This article introduces RediSearch, compares its memory usage and query performance with Elasticsearch on modest hardware, shows installation steps, demonstrates core index commands and Java integration, and concludes with practical advice on using RediSearch as a lightweight full‑text search engine.
This article explains Elasticsearch’s overall structure, the underlying Lucene index layout, the indexing and search processing flow, and how built‑in analyzers work, illustrating each concept with diagrams, token examples, and query scenarios.
This guide walks through installing Quickwit, creating a search‑stream index on the GitHub Archive dataset, streaming matching IDs, setting up ClickHouse tables, and querying via the URL table engine, demonstrating fast full‑text search with concrete performance numbers.
This tutorial explains how to install Xunsearch, integrate it with PHP, index song data, and perform full‑text searches to improve the search experience on a music website, providing code examples and best practices for efficient backend search implementation.
This article explains how to install Xunsearch, integrate it with PHP, and index and query song data to improve search performance on a music website, providing step‑by‑step code examples and best practices.
This article explores how PostgreSQL’s advanced features—UNLOGGED tables, JSONB, SKIP LOCKED, TimescaleDB, pg_cron, PostGIS, full‑text search, JSON generation, pgaudit, and GraphQL adapters—can replace specialized tools like Kafka, Redis, MongoDB, and others, simplifying the tech stack while boosting performance and maintainability.
This guide explains why e‑commerce platforms need a high‑performance search engine, introduces Elasticsearch fundamentals, compares it with traditional engines, and provides step‑by‑step PHP code for installing, configuring, indexing, and querying data, complete with practical examples and best‑practice tips.
This article describes how to combine Elasticsearch’s keyword matching with Milvus’s vector‑based semantic search to build a scalable document search service, covering data preprocessing, architecture, query handling, custom scoring, DSL configuration, and result merging.
This tutorial explains how to leverage Redis Stack modules—especially RediSearch and RedisJSON—to store movie data, build a searchable JSON index, and perform advanced full‑text queries, highlighting, sorting, pagination, custom tokenization, scoring, and index aliasing, with Go code examples.
This article introduces Neo4j, explains its property‑graph model, demonstrates how to write and optimize Cypher queries, explores advanced features like full‑text search and built‑in graph algorithms, and showcases real‑world use cases and integration options for modern applications.
This tutorial explains how to install Xunsearch, integrate it with PHP, index song data, and perform fast, accurate full‑text searches on a music website, providing code examples and best‑practice tips for backend developers.
This article demonstrates how to set up Xunsearch, a C++-based full-text search engine, and integrate it with PHP to achieve real-time search capabilities and automatically update the index, covering environment preparation, installation, sample code for searching, and index maintenance.
RediSearch is a Redis module that adds full‑text search, secondary indexing and powerful query capabilities, offering detailed feature lists, performance benchmarks against Elasticsearch, step‑by‑step installation methods, and comprehensive command‑line examples for creating, querying, and managing indexes.
This article introduces the lightweight Python search library Whoosh, outlines its features, explains how to define schemas, create indexes, and perform queries with example code, and compares it to larger search engines, making it suitable for small search projects.
This article explains how InnoDB full‑text search can replace LIKE% fuzzy queries by using inverted indexes, covering index structures, creation syntax, MATCH() AGAINST() modes, practical demos, query expansion, and index removal, while noting when to prefer external search engines.
RediSearch, a Redis module providing full-text search and secondary indexing, is introduced with its features, performance comparisons against Elasticsearch, benchmark results for index building and query throughput, detailed installation methods, and extensive command examples for creating, querying, updating, and managing indexes.
This article explains the purpose and inner workings of various database indexing algorithms—including B‑Tree, Hash, Bitmap, and Full‑Text indexes—illustrates their strengths and weaknesses with SQL examples, and provides guidance on when to choose each type for optimal query performance.
This guide explains how to install, configure, and use Laravel Scout to add powerful full-text search capabilities to Laravel models, covering driver setup, searchable traits, indexing, custom queries, conditional searching, pagination, and result display.
This article introduces RediSearch, a Redis module for full‑text search, outlines its extensive feature set, compares its indexing and query performance with Elasticsearch, and provides detailed installation steps and command‑line examples for creating, querying, updating, and managing indexes.
This tutorial explains how to install Xunsearch, integrate it with PHP, and index music data to enhance song search performance on a music website, providing step-by-step code examples and best practices for efficient full‑text search implementation.
The Cloud Music team integrated a lightweight on‑device full‑text engine using SQLite FTS5 with a simple tokenizer, replaced JavaScript matching with SQLite’s bm25(), parallelized queries, and cut search latency by 75%, boosting CTR 13% and average playback by 17 seconds while preserving user privacy.
This article explains MySQL InnoDB full-text search, covering inverted index structures, creation and usage of full-text indexes, query modes such as natural language, boolean, and query expansion, and provides practical SQL examples and considerations for effective text searching.
This article explains how MySQL InnoDB implements full‑text search, covering the underlying inverted index structures, how to create and drop full‑text indexes, the MATCH…AGAINST syntax, and detailed examples of natural language, boolean, and query‑expansion search modes with practical SQL demos.
This guide explains how to implement a searchable user‑story interface using PostgreSQL tables with btree and gin indexes, Java record models, Spring Boot data access, and REST controllers to support range and full‑text queries efficiently.
This article explains how MySQL InnoDB implements full‑text search using inverted indexes, shows how to create and drop FULLTEXT indexes, and demonstrates natural language, boolean, and query‑expansion search modes with concrete SQL examples and operator details.
This article explains how to leverage MySQL 5.7's built‑in ngram full‑text parser to implement lightweight Chinese full‑text search, covering configuration, index creation, query modes, operator usage, and performance considerations.
This guide introduces RedisSearch, walks through installation, explains its rich feature set, details core concepts like data models and indexing, shows command‑line operations for creating indexes and querying, and provides a complete PHP example for integrating RedisSearch into applications.
RediSearch, a low‑memory Redis module, offers comparable full‑text search capabilities to Elasticsearch, with faster indexing and query performance on modest hardware; this article explains its features, compares benchmarks, shows Docker installation, and provides Java/Jedis code examples for creating, querying, and managing indexes.
This article explains the concept of full-text retrieval, introduces Elasticsearch as a popular open‑source search engine built on Apache Lucene, and provides detailed step‑by‑step installation instructions for both traditional setups and Docker containers, including required environment configuration and common troubleshooting.
This article explains why MySQL LIKE queries struggle with large datasets, introduces Elasticsearch and Sphinx as powerful PHP search engine alternatives, and provides step‑by‑step PHP code examples for setting up indices, adding documents, and performing full‑text searches.
This article explains how to create optimal MySQL indexes for a service_log table based on various search conditions, covering single‑column, composite, full‑text, prefix, and covering indexes, along with best practices, index size considerations, and practical SQL examples.
This article explains how to achieve high‑performance database search in PHP by optimizing schema, writing efficient SQL, using mysqli/PDO functions, employing caching tools like Memcached or Redis, and integrating full‑text engines such as Elasticsearch, with complete code examples.
Manticore Search is a C++‑based open‑source search engine that builds on Sphinx, offering high‑performance full‑text search, SQL compatibility, and significant speed advantages over Elasticsearch, with detailed usage instructions and Docker deployment examples for developers.
This article compares PostgreSQL and Elasticsearch for full‑text search in Django applications, presenting performance benchmarks on up to 1.5 million records, discussing setup complexity, features like stemming and fuzziness, and concluding that PostgreSQL is preferable for most projects without massive data scales.
This article introduces the lightweight Python search library Whoosh, outlines its key features, demonstrates how to define a schema, create an index from a CSV dataset, and perform full‑text queries with example code, making it suitable for small‑scale search projects.
iOS WeChat’s full‑text search was upgraded by selecting SQLite FTS5, creating a VerbatimTokenizer with multi‑level delimiter support, optimizing table formats to cut index size by 30 %, improving batch index updates and parallel search logic, resulting in 40‑60 % faster query latency.
This article explains the fundamentals of search, why traditional databases struggle with large‑scale text queries, introduces full‑text search and inverted indexes, describes Lucene as the core library, and details ElasticSearch's distributed architecture, features, and common use cases.
This article explains what search is, why traditional databases struggle with full‑text queries, introduces the concepts of inverted indexes and Lucene, and shows how ElasticSearch combines distributed architecture, real‑time analytics, and powerful search features to solve these problems.