Related Experiment Video
Updated: Jul 11, 2025

Executing Complexity-Increasing Queries in Relational MySQL and NoSQL MongoDB and EXist Size-Growing ISO/EN 13606 Standardized EHR Databases
Published on: March 19, 2018
On Distribution Dependent Sub-Logarithmic Query Time of Learned Indexing
Sepanta Zeighami1, Cyrus Shahabi1
1Univerisity of Southern California.
Learned indexes, used in data management, are now theoretically proven to be significantly faster than traditional methods like B-trees. This research provides the first theoretical justification for their superior performance in locating array elements.
Area of Science:
- Computer Science
- Data Management
- Algorithms
Background:
- A core challenge in data management is efficiently locating elements within arrays.
- Learned indexes, which use predictive models for item location, show empirical speedups over traditional methods like B-trees and binary search.
- The theoretical underpinnings of learned indexes' performance advantages have remained largely unproven.
Purpose of the Study:
- To provide a rigorous theoretical justification for the performance gains observed in learned indexes.
- To establish theoretical bounds on the query time achievable by learned indexes under varying space complexities.
- To bridge the gap between the empirical success and theoretical understanding of learned indexes in data retrieval.
Main Methods:
- Developed theoretical models to analyze the query time complexity of learned indexes.
- Established performance guarantees under mild assumptions on data distribution.
- Compared the theoretical query time and space complexity of learned indexes against non-learned methods (e.g., B-trees).
Main Results:
- Demonstrated that learned indexes can achieve sub-linear expected query time (O(log log n)) with the same space complexity as non-learned methods.
- Showed that a near-linear space overhead allows learned indexes to achieve even faster expected query times (O(log n)).
- Provided theoretical proof that learned indexes outperform non-learned methods by orders of magnitude in query speed.
Conclusions:
- The study theoretically validates the significant speed advantages of learned indexes over traditional data structures.
- These findings provide a strong foundation for the continued development and adoption of learned indexes in data management.
- Learned indexes offer a provably more efficient approach to data retrieval compared to established non-learned methods.
More Related Videos
Related Concept Videos
Column Efficiency: Rate Theory
During elution, a solute molecule experiences numerous transitions between stationary and mobile phases, exhibiting irregular residence times in...
Noncompartmental Analysis: Mean Residence Time
After the administration of a drug through intravenous bolus injection, the drug molecules are distributed throughout the body and remain there for varying periods. The MRT represents the average time these drug molecules stay in the...
Choosing Between z and t Distribution
Distributions to Estimate Population Parameter
Poisson Probability Distribution
The...
Probability Distributions
A discrete probability distribution is a probability distribution of discrete random variables. It can be categorized into binomial probability distribution and Poisson...

