Algorithmic Complexity Attacks on All Learned Cardinality Estimators: A Data-centric Approach

Fuente: arXiv
Guardado en:
Detalles Bibliográficos
Autores principales: Li, Yingze, Liu, Xianglong, Wang, Dong, Wang, Zixuan, Wang, Hongzhi, Zhang, Kaixing, Guan, Yiming
Formato: Preprint
Publicado: 2025
Materias:
Acceso en línea:
Etiquetas: Agregar Etiqueta
Sin Etiquetas, Sea el primero en etiquetar este registro!
_version_ 1866911049149579264
author Li, Yingze
Liu, Xianglong
Wang, Dong
Wang, Zixuan
Wang, Hongzhi
Zhang, Kaixing
Guan, Yiming
author_facet Li, Yingze
Liu, Xianglong
Wang, Dong
Wang, Zixuan
Wang, Hongzhi
Zhang, Kaixing
Guan, Yiming
contents Learned cardinality estimators show promise in query cardinality prediction, yet they universally exhibit fragility to training data drifts, posing risks for real-world deployment. This work is the first to theoretical investigate how minimal data-level drifts can maximally degrade the accuracy of learned estimators. We propose data-centric algorithmic complexity attacks against learned estimators in a black-box setting, proving that finding the optimal attack strategy is NP-Hard. To address this, we design a polynomial-time approximation algorithm with a $(1-κ)$ approximation ratio. Extensive experiments demonstrate our attack's effectiveness: on STATS-CEB and IMDB-JOB benchmarks, modifying just 0.8\% of training tuples increases the 90th percentile Qerror by three orders of magnitude and raises end-to-end processing time by up to 20$\times$. Our work not only reveals critical vulnerabilities in deployed learned estimators but also provides the first unified worst-case theoretical analysis of their fragility under data updates. Additionally, we identify two countermeasures to mitigate such black-box attacks, offering insights for developing robust learned database optimizers.
format Preprint
id arxiv_https___arxiv_org_abs_2507_07438
institution arXiv
publishDate 2025
record_format arxiv
spellingShingle Algorithmic Complexity Attacks on All Learned Cardinality Estimators: A Data-centric Approach
Li, Yingze
Liu, Xianglong
Wang, Dong
Wang, Zixuan
Wang, Hongzhi
Zhang, Kaixing
Guan, Yiming
Databases
Learned cardinality estimators show promise in query cardinality prediction, yet they universally exhibit fragility to training data drifts, posing risks for real-world deployment. This work is the first to theoretical investigate how minimal data-level drifts can maximally degrade the accuracy of learned estimators. We propose data-centric algorithmic complexity attacks against learned estimators in a black-box setting, proving that finding the optimal attack strategy is NP-Hard. To address this, we design a polynomial-time approximation algorithm with a $(1-κ)$ approximation ratio. Extensive experiments demonstrate our attack's effectiveness: on STATS-CEB and IMDB-JOB benchmarks, modifying just 0.8\% of training tuples increases the 90th percentile Qerror by three orders of magnitude and raises end-to-end processing time by up to 20$\times$. Our work not only reveals critical vulnerabilities in deployed learned estimators but also provides the first unified worst-case theoretical analysis of their fragility under data updates. Additionally, we identify two countermeasures to mitigate such black-box attacks, offering insights for developing robust learned database optimizers.
title Algorithmic Complexity Attacks on All Learned Cardinality Estimators: A Data-centric Approach
topic Databases
url https://arxiv.org/abs/2507.07438