paper-with-me

홈 › Papers

NFL: Robust Learned Index via Distribution Transformation

2022-05-24 · Shangyu Wu, Yufei Cui, Jinghuan Yu, Xuan Sun, Tei-Wei Kuo, Chun Jason Xue

Recent works on learned index open a new direction for the indexing field. The key insight of the learned index is to approximate the mapping between keys and positions with piece-wise linear functions. Such methods require partitioning key space for a better approximation. Although lots of heuristics are proposed to improve the approximation quality, the bottleneck is that the segmentation overheads could hinder the overall performance. This paper tackles the approximation problem by applying a \textit{distribution transformation} to the keys before constructing the learned index. A two-stage Normalizing-Flow-based Learned index framework (NFL) is proposed, which first transforms the original complex key distribution into a near-uniform distribution, then builds a learned index leveraging the transformed keys. For effective distribution transformation, we propose a Numerical Normalizing Flow (Numerical NF). Based on the characteristics of the transformed keys, we propose a robust After-Flow Learned Index (AFLI). To validate the performance, comprehensive evaluations are conducted on both synthetic and real-world workloads, which shows that the proposed NFL produces the highest throughput and the lowest tail latency compared to the state-of-the-art learned indexes.

📄 PDF Abstract BibTeX arXiv:2205.11807

Code (1)

luffy06/nfl 공식 구현 pytorch

Similar Papers 제목 키워드 기반

A Learned Index for Exact Similarity Search in Metric Spaces

2022-04-21 · Yao Tian, Tingyun Yan, Xi Zhao, Kai Huang 외

Indexing is an effective way to support efficient query processing in large databases. Recently the concept of learned index, which replaces or complements traditional index structures with machine learning models, has b…

BIG-bench Machine Learning

Learned Indexes for Dynamic Workloads

2019-02-02 · Chuzhe Tang, Zhiyuan Dong, Minjie Wang, Zhaoguo Wang 외

The recent proposal of learned index structures opens up a new perspective on how traditional range indexes can be optimized. However, the current learned indexes assume the data distribution is relatively static and the…

On Distribution Dependent Sub-Logarithmic Query Time of Learned Indexing

2023-06-19 · Sepanta Zeighami, Cyrus Shahabi

A fundamental problem in data management is to find the elements in an array that match a query. Recently, learned indexes are being extensively used to solve this problem, where they learn a model to predict the locatio…

Management

WaZI: A Learned and Workload-aware Z-Index

2023-10-06 · Sachith Pai, Michael Mathioudakis, Yanhao Wang

Learned indexes fit machine learning (ML) models to the data and use them to make query operations more time and space-efficient. Recent works propose using learned spatial indexes to improve spatial query performance by…

Identification of Time-Varying Transformation Models with Fixed Effects, with an Application to Unobserved Heterogeneity in Resource Shares

2020-08-12 · Irene Botosaru, Chris Muris, Krishna Pendakur

We provide new results showing identification of a large class of fixed-T panel models, where the response variable is an unknown, weakly monotone, time-varying transformation of a latent linear index of fixed effects, r…