Tagged articles
Data Retrieval
20 articles · Page 1 of 1

liandkAug 11, 2026 · Databases
SELECT is the most frequently used SQL command, handling about 80% of data‑related work; this guide explains its core role, basic operations such as selecting all rows, specific columns, distinct values, and row limits, shows practical code examples, and advises against using SELECT * for better performance.
Data RetrievalSQLSQL Basics
0 likes · 2 min read

This article presents fifteen practical chunking techniques—ranging from line‑by‑line and fixed‑size chunking to semantic and hierarchical methods—explaining their principles, ideal use‑cases, concrete input examples, chunk outputs, and key advantages or cautions for improving Retrieval‑Augmented Generation with large language models.
AIData RetrievalLLM
0 likes · 28 min read

This article details the design and implementation of Matra, an AI‑driven data assistant for a large e‑commerce platform, covering the challenges of legacy data assets, knowledge‑base construction, GraphRAG integration, multi‑stage agent frameworks, practical results, and future plans for continuous improvement.
AIData EngineeringData Retrieval
0 likes · 22 min read

This article explores the emerging field of prompt engineering, detailing its fundamentals, advanced strategies such as chain‑of‑thought, ReAct, and structured frameworks, and demonstrates practical applications in AI agents for data retrieval, SQL generation, and market insight, offering actionable guidance for developers and business users alike.
AI agentsData RetrievalRAG
0 likes · 42 min read

This article explains how large‑language‑model tools like Metaso AI’s “Deep Research” can dramatically speed up reliable data collection for mathematical modeling by providing systematic retrieval workflows, visual summaries, and interactive reports within minutes.
AIData Retrievaldata analysis
0 likes · 6 min read

This article introduces DeepSeek, a high‑efficiency search engine optimized for large‑scale data, explains how to configure it within the Cursor database tool using code snippets, and demonstrates its applications such as semantic search, content recommendation, intelligent data analysis, and document similarity matching.
ConfigurationCursorData Retrieval
0 likes · 6 min read


ITPUBFeb 1, 2025 · Databases
This tutorial explains how to use Elasticsearch's built‑in SQL interface to replace complex Query DSL statements with familiar SQL syntax, covering environment setup, index creation, data insertion, and a variety of query examples such as filtering, ordering, grouping, aggregation, and date manipulation.
Data RetrievalElasticsearchSQL
0 likes · 8 min read

This tutorial shows how to use Elasticsearch's built‑in SQL support to run familiar MySQL‑style queries—creating an index, inserting documents, and performing SELECT, WHERE, ORDER BY, GROUP BY, LIMIT, aggregation, date and string functions—making ES data retrieval as easy as relational databases.
Data RetrievalElasticsearchSQL
0 likes · 7 min read

This article explains how the Volcano Engine DataLeap team leveraged large‑language models to build the “Find Data Assistant”, detailing its design, challenges, embedding‑and‑reranker enhancements, LLM‑driven semantic search, mixing architecture, and practical lessons for improving data asset management and retrieval.
Data RetrievalEmbeddingLLM
0 likes · 17 min read

This article details how the DataLeap team applied large language model technology to build the "Find Data Assistant" platform, addressing the challenges of locating and using massive data assets through a hybrid retrieval architecture, enhanced embedding, reranking, mixed ranking, and answer summarization, while sharing practical lessons and future directions.
Data RetrievalEmbeddingHybrid Ranking
0 likes · 17 min read

This article presents a collection of SQL statements—including SELECT, DELETE, DESCRIBE, and JOIN queries—targeting various tables in the idc_evaluating database, accompanied by detailed English explanations of their purpose, syntax, and result set structure.
Data ManipulationData RetrievalMySQL
0 likes · 10 min read

This guide explains how to use Prometheus' stable V1 API to perform instant and range queries, handle common error codes, parse JSON responses, and fetch metrics programmatically with curl or Python, enabling deeper data analysis and cost management.
APIData RetrievalInstant Query
0 likes · 7 min read

This article examines a business requirement to filter up to 100 000 records from a pool of tens of millions, presenting and evaluating four backend solutions—multithreaded ClickHouse pagination, Elasticsearch scroll‑scan, an ES‑HBase hybrid, and RediSearch + RedisJSON—along with performance data and implementation details.
BackendClickHouseData Retrieval
0 likes · 11 min read

This article explains the standard SQL query execution sequence—including FROM/JOIN, WHERE, GROUP BY, HAVING, SELECT, DISTINCT, ORDER BY, and LIMIT—illustrating each step with examples, code snippets, and diagrams to clarify how data is retrieved and processed.
Data RetrievalSQLSQL Clauses
0 likes · 5 min read

This article explains four practical Python methods—Pandas_datareader, yfinance, Tushare, and JoinQuant—to fetch A‑share market data and manage trading positions, while also providing QR‑code links to free Python learning resources.
Data RetrievalJoinQuantTushare
0 likes · 2 min read

This article explains how Zuoyebang redesigned its massive data retrieval platform by separating compute and storage with the Fluid project on Kubernetes, achieving minute‑level hundred‑TB distribution, elastic caching, and improved stability for real‑time educational services.
Data RetrievalFluidKubernetes
0 likes · 8 min read

Bilibili’s data retrieval journey progressed from a fragmented, chimney‑style pipeline to a unified Flink‑based service layer with the Ark construction system and Akuya SQL engine, and finally to an Iceberg‑driven lakehouse that eliminates data duplication, streamlines cross‑engine optimization, and offers platformized, low‑latency analytics.
BilibiliData RetrievalSQL Engine
0 likes · 14 min read


21CTONov 29, 2021 · Databases
The article explains how shifting complex filtering, validation, and join operations from the database to the application layer reduces scarce database resource usage, improves scalability, and enables more flexible resource allocation for modern web applications.
Application ArchitectureData Retrievaldatabases
0 likes · 7 min read

Learn how to set up Oracle Database for Python, install and configure the 64‑bit Instant Client, resolve common issues like Chinese character encoding, install the cx_Oracle driver, and perform data queries using fetchone, fetchall, and pandas DataFrames.
Data RetrievalInstant ClientOracle
0 likes · 9 min read


ITPUBJan 26, 2016 · Backend Development
This article explores Python's role in Industrial Light & Magic's visual effects for Star Wars, introduces the Star Wars API, and demonstrates Python scripts that query film data and build a simple Star Wars-themed game.
Data RetrievalIndustrial Light & MagicStar Wars API
0 likes · 5 min read
