Tagged articles

range query

6 articles · Page 1 of 1

Jan 4, 2024 · Big Data

BKD-Tree: Theory, Construction, Query, Update and Practical Compression Strategies for Large-Scale Numeric Range Search

This article presents a comprehensive technical overview of the BKD-Tree data structure, detailing its algorithmic foundations, construction and query processes, dynamic update mechanisms, and the space‑efficient compression techniques used in production search engines for massive multidimensional numeric datasets.

BKD-TreeSearch Engineindex compression

0 likes · 55 min read

BKD-Tree: Theory, Construction, Query, Update and Practical Compression Strategies for Large-Scale Numeric Range Search

Laravel Tech Community

Aug 1, 2023 · Backend Development

Advanced Elasticsearch Queries: Bool, Range, Fuzzy, Filter, and Sorting

This article introduces advanced Elasticsearch query techniques, covering boolean queries with must/must_not/should clauses, range and fuzzy queries, filter usage that does not affect scoring, and single- and multi-field sorting, each illustrated with concrete request examples.

Advanced QueryBool queryElasticsearch

0 likes · 4 min read

Advanced Elasticsearch Queries: Bool, Range, Fuzzy, Filter, and Sorting

Shepherd Advanced Notes

Mar 27, 2023 · Databases

Why MySQL Uses B+ Trees for Indexing

The article explains the fundamentals of tree data structures, compares B, B+, B*, and red‑black trees, and shows how B+ trees reduce disk I/O and improve range query performance, which is why MySQL adopts B+ trees for its indexes.

B+TreeData StructuresMySQL

0 likes · 15 min read

MaGe Linux Operations

Mar 20, 2023 · Operations

How to Retrieve and Analyze Prometheus Monitoring Data via API

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

How to Retrieve and Analyze Prometheus Monitoring Data via API

Senior Brother's Insights

Feb 23, 2022 · Databases

Why MySQL Sometimes Skips Your Index on Range Queries (and How to Fix It)

This article explains why MySQL may ignore an index on range queries, shows example queries with EXPLAIN output, describes the optimizer's row‑count threshold that triggers a full table scan, and offers guidance on keeping indexes effective.

DatabaseMySQLrange query

0 likes · 4 min read

Why MySQL Sometimes Skips Your Index on Range Queries (and How to Fix It)

IT Services Circle

Feb 9, 2022 · Fundamentals

Range Maximum Query Using Sparse Table – Theory, Preprocessing, and C++ Implementation

This article explains how to answer range maximum queries on a static array efficiently by preprocessing with a sparse table, achieving O(n log n) build time and O(1) query time, and provides a complete C++ implementation with state compression and interval decomposition.

C++PreprocessingRMQ

0 likes · 7 min read

Range Maximum Query Using Sparse Table – Theory, Preprocessing, and C++ Implementation