GitHunt
BT

Btsan/Join_Subset_Enumerator

Web tool to extract join subsets from SQL queries. Intended to help evaluate cardinality estimation models

Join Enumerator

This tool implements PostgreSQL-style join enumeration for cardinality estimation research.

Algorithm Overview:

  1. Parse query to extract tables and join predicates
  2. Build Equivalence Classes from join predicates
  3. Include transitive joins
  4. Enumerate subsets level-by-level:
    • Check connectivity via ECs
    • Generate SQL with complete join conditions

Only works for inner joins.

Languages

JavaScript50.2%Python49.8%

Contributors

Created December 10, 2025
Updated January 30, 2026