Skip to main navigation Skip to search Skip to main content

Investigating Machine Learning Models for Cardinality Estimation: An interactive Approach

  • Rui Li
  • , Kangfei Zhao*
  • , Mengyu Li
  • , Jeffrey Xu Yu
  • *Corresponding author for this work
  • Chinese University of Hong Kong

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

Abstract

Recently developed machine learning (ML) models for cardinality estimation improve the accuracy significantly, which inspires database developers to tap learned cardinality estimators into RDBMS. However, query optimization is a complicated task involving multiple factors, and accurate estimations may not necessarily procure optimal query plans. In this demonstration, we present an interactive platform that facilitates the investigation of various learned cardinality estimators and their utilities in query optimization in real RDBMS. We bridge the model zoo and the optimizer of PostgreSQL and provide a graphical interface for users to configure parameters and visualize the results interactively. In addition, our platform exposes extensible interfaces for users to deploy plug-and-play ML estimators and datasets. The demonstration video can be found on YouTube https://www.youtube.com/watch?v=ay3w7V1JhUU.

Original languageEnglish
Title of host publicationDatabase Systems for Advanced Applications - 31st International Conference, DASFAA 2026, Proceedings
EditorsHyungsoo Jung, Tianzheng Wang, Masashi Toyoda, Hyuk-Yoon Kwon, Jae-woong Lee
PublisherSpringer Science and Business Media Deutschland GmbH
Pages713-717
Number of pages5
ISBN (Print)9789819203772
DOIs
Publication statusPublished - 2026
Event31st International Conference on Database Systems for Advanced Applications, DASFAA 2026 - Jeju, Korea, Republic of
Duration: 27 Apr 202630 Apr 2026

Publication series

NameLecture Notes in Computer Science
Volume16540 LNCS
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349

Conference

Conference31st International Conference on Database Systems for Advanced Applications, DASFAA 2026
Country/TerritoryKorea, Republic of
CityJeju
Period27/04/2630/04/26

Keywords

  • Cardinality estimation
  • Machine learning

Fingerprint

Dive into the research topics of 'Investigating Machine Learning Models for Cardinality Estimation: An interactive Approach'. Together they form a unique fingerprint.

Cite this