IndexIQ Edge: A Secure, Air-Gapped Platform for Learned Indexes with Drift Monitoring and Natural Language Querying

B-Trees form the foundation of most indexing techniques, being reliable because they make no assumptions about the data. However, the downside of this is the failure to recognize underlying patterns, such as ordered IDs or timestamps incrementing consistently over time. Learned indexes use an underlying model to determine where a particular record is located and can, therefore, be substantially more efficient. Nevertheless, they are not widely used by industry players due to a lack of offline tools for analyzing their applicability relative to a B-Tree and determining when the index becomes outdated. IndexIQ Edge, our air-gapped platform for industrial scenarios, comes with three components. First, there is the twostage Recursive Model Index (RMI) compiled with Numba. The RMI performs a lookup at 0.70µs on average on 1,000,000 keys, which is 3.0× more efficient than the corresponding lookup on a SQLite B+ Tree while using 33% less memory. Second, there is an adaptation of FLAN-T5 for translating plain language queries into SQL; it includes a tokenizer which silently drops the characters < and >, so we had to introduce a text placeholder workaround. Thirdly, there is a drift monitor that signals whenever a new data set causes the index to lose accuracy or go stale, prompting a retraining recommendation. Because the entire system runs locally on the host machine, teams can speed up their lookups without ever sending sensitive data to the cloud.

Authors

Publication Details

Journal
Preprints.org
Published
2026-11-13
DOI
https://doi.org/10.20944/preprints202611.1387.v1
Primary Topic
Advanced Database Systems and Queries
Type
preprint
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
preprint

IndexIQ Edge: A Secure, Air-Gapped Platform for Learned Indexes with Drift Monitoring and Natural Language Querying

Shivshankar Patil, Bharathi V C, G S Gowtham, Rameshwaran G S et al.
Preprints.org
Advanced Database Systems and Queries
preprint

IndexIQ Edge: A Secure, Air-Gapped Platform for Learned Indexes with Drift Monitoring and Natural Language Querying

Shivshankar Patil, Bharathi V C, G S Gowtham, Rameshwaran G S, Aditiyaa N K
preprint en

Abstract

B-Trees form the foundation of most indexing techniques, being reliable because they make no assumptions about the data. However, the downside of this is the failure to recognize underlying patterns, such as ordered IDs or timestamps incrementing consistently over time. Learned indexes use an underlying model to determine where a particular record is located and can, therefore, be substantially more efficient. Nevertheless, they are not widely used by industry players due to a lack of offline tools for analyzing their applicability relative to a B-Tree and determining when the index becomes outdated. IndexIQ Edge, our air-gapped platform for industrial scenarios, comes with three components. First, there is the twostage Recursive Model Index (RMI) compiled with Numba. The RMI performs a lookup at 0.70µs on average on 1,000,000 keys, which is 3.0× more efficient than the corresponding lookup on a SQLite B+ Tree while using 33% less memory. Second, there is an adaptation of FLAN-T5 for translating plain language queries into SQL; it includes a tokenizer which silently drops the characters < and >, so we had to introduce a text placeholder workaround. Thirdly, there is a drift monitor that signals whenever a new data set causes the index to lose accuracy or go stale, prompting a retraining recommendation. Because the entire system runs locally on the host machine, teams can speed up their lookups without ever sending sensitive data to the cloud.

Preprints.org
Advanced Database Systems and Queries
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Laika access coming soon