EDBT 2026 Demo / reviewers in the wild / expert
Yirui Zhan
dblp:354/7223
· DBLP profile ↗
1ranked-venue papers
1as first author
1since 2021 · last 2025
0009-0009-6856-958XORCID · reported
Domains — the database's venue-derived domains; a paper can count in several
Databases, data management, data science and information retrieval · 1 · 1 first-author · 1 since 2021
Expertise — from the expertise taxonomy: the topics of the expert's papers under the CCF categories. A weight counts papers with recency: 1 for a paper about the topic, 0.3 when the topic is its context, halved every five years.
| Databases, data mining, and information retrieval
1 paper |
Query processing and optimization · 50% Indexing and storage engines · 50% |
Topics — the 4 heaviest of 4, each with the papers that count most for it
| Topic | Weight | Papers | Last | Evidence papers |
|---|---|---|---|---|
Query processing and optimization
cardinality estimation |
0.9 | 1 | 2025 | SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index · Proc. ACM Manag. Data 2025 |
Indexing and storage engines › succinct data structures › self-index
FM-index |
0.9 | 1 | 2025 | SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index · Proc. ACM Manag. Data 2025 |
Indexing and storage engines
learned index |
0.9 | 1 | 2025 | SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index · Proc. ACM Manag. Data 2025 |
Query processing and optimization › selectivity estimation
substring selectivity estimation |
0.9 | 1 | 2025 | SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index · Proc. ACM Manag. Data 2025 |
Methods — techniques the papers use, named apart from their topics
suffix tree · 0.9spline interpolation · 0.9
| Year | Publication | Venue | Position |
|---|---|---|---|
| 2025 | SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-IndexabstractAccurate cardinality estimation of substring queries, which are commonly expressed using the SQL LIKE predicate, is crucial for query optimization in database systems. While both rule-based methods and machine learning-based methods have been developed to optimize various aspects of cardinality estimation, their absence of error bounds may result in substantial estimation errors, leading to suboptimal execution plans. In this paper, we propose SSCard, a novel S ub S tring Card inality estimator that leverages a space-efficient FM-Index into flexible database applications. SSCard first extends the FM-Index to support multiple strings naturally, and then organizes the FM-index using a pruned suffix tree. The suffix tree structure enables precise cardinality estimation for short patterns and achieves high compression via a pushup operation, especially on a large alphabet with skewed character distributions. Furthermore, SSCard incorporates a spline interpolation method with an error bound to balance space usage and estimation accuracy. Additional innovations include a bidirectional estimation algorithm and incremental update strategies. Extensive experimental results in five real-life datasets show that SSCard outperforms both traditional methods and recent learning-based methods, which achieves an average reduction of 20% in the average q-error, 80% in the maximum q-error, and 50% in the construction time, compared with second-best approaches. Yirui Zhan, Wen Nie, Jun Gao 0003 |
Proc. ACM Manag. Data | 1 |