Papers › Agentic Cost-Aware Query Planning with Knowledge Distillation for Big Data Analytics

Agentic Cost-Aware Query Planning with Knowledge Distillation for Big Data Analytics

18 May 2026arXiv:2605.17831added by Syntology

Mahdi Naser-Moghadasi

Title, abstract, authors and date from arXiv's metadata (CC0); this paper is not in the Papers with Code archive (frozen 2025-07-28).

Query optimization in big data analytics remains computationally expensive, particularly for resource-constrained environments where traditional optimizers fail to satisfy memory and latency constraints. We present an agentic query planning system that combines a rule-based teacher planner, UCB1 bandit exploration, cost-aware prediction, and knowledge distillation to a lightweight student planner. Our teacher planner generates SQL plans using six key optimization strategies, while UCB1 bandit search efficiently explores the plan space under explicit resource constraints. A Random Forest cost model predicts query latency from plan features, enabling cost-aware decisions. A distilled student planner (Logistic Regression or Gradient Boosting) learns to mimic teacher-bandit decisions for fast inference. Evaluation on NYC Taxi and IMDB datasets demonstrates 23% latency reduction compared to default planners while maintaining 94% constraint satisfaction. The student planner achieves 89% accuracy in replicating optimal plans with 15x faster inference time. Our single-file implementation enables reproducible big-data analytics on resource-limited machines and is publicly available at https://github.com/mahdinaser/agentic-kd-planner.

PaperPDFCode Syntology ranMethod as code

In Syntology View this paper on Syntology, its page in Syntology's graph. That page adds which of its functions are also present in other papers' code Syntology holds, with dates, and its dated run record as JSON and a README badge. It also lists the repositories linked to the paper, the abstract and the calls for agents.

For agents, on Syntology's MCP service (how to connect):

Code

Syntology 15 code samples harvested from 1 repository linked to this paper: 13 ran (of which 3 constructed an object rather than computing a result; 7 with no instrument failure: 3 honoured, 0 violated, 4 with no contract checked; 6 where Syntology's instrument failed) · 2 unverified. Where Syntology's instrument failed: 6 where our contract draft was wrong; failures of Syntology's instrument, not of the code.

By repository: found in paper text by Syntology: 15 samples from 1 repository, 13 ran (7 with no instrument failure; 6 where Syntology's instrument failed). The run record, sample by sample. “Ran” means executed on a synthesized input, not that the code is correct or reproduces the paper.

Levels written on 2026-09-22 (UTC): the dates Syntology's graph wrote each sample's verification level, not when the code executed.

mahdinaser/agentic-kd-planner found in paper text by SyntologySyntology: 15 samples, 13 ran (6 instrument-failed) · 2 unverified report

Reachability, where shown, is from one Syntology probe window (2026-09-16 to 2026-09-18); repositories not probed show nothing. GitHub stars are not tracked.

Code Syntology ran Syntology

15 samples harvested: 13 ran (of which 3 constructed an object rather than computing a result; 7 with no instrument failure: 3 honoured, 0 violated, 4 with no contract checked; 6 where Syntology's instrument failed) · 2 unverified. “Where Syntology's instrument failed” counts failures of Syntology's instrument, not of the code. Syntology's record for this page last changed ; when this build read Syntology's graph is in the build record. That date is not when the samples ran.

3ran · honoured contract
6ran · our draft was wrong
4ran
2unverified

Licence: 15 of the 15 samples are pointer only, meaning Syntology does not serve that copy's text. This page shows no code text for any sample; each one links to its file in the repository.

Harvested from mahdinaser/agentic-kd-planner. “Ran” means the sample executed on a synthesized input. It does not mean the output is correct, and nothing here reproduces the paper's results. A line beginning “fixture:” under a sample that ran gives the arguments Syntology's fixture called the sample with, each as name:type/rank/element kind (? where none was recorded), and the type of what the fixture's run returned, exactly as the harness recorded them; the arguments and the returned type were recorded by two separate runs of the same fixture. No output value is shown, and a returned type says nothing about whether the output was right. “Level recorded” gives the UTC date when Syntology's graph wrote the sample's verification level, not when the code executed; where the level was written before Syntology's graph kept that date, the row says “level recorded, date not recorded”. “Honoured” and “violated” refer to a contract Syntology drafted from the code itself. “Our draft was wrong” and “the contract check could not run” are failures of Syntology's instrument, not of the code: the sample ran on Syntology's synthesized input, and then the drafted contract did not describe it, or the check itself raised an error (RAISES), lacked a dependency (DEP_MISSING) or ran out of time (TIMEOUT); hover the label for which. A metamorphic tier, where shown, is evidence of the output's shape, not that the sample implements the method.

Each sample ends with its code_sha256. A sample's code_sha256 is Syntology's identity for that exact code. It is printed in full (16 hexadecimal characters for every sample in this build), and get_code(code_sha256="…") takes it exactly as printed. An agent calls it on Syntology's MCP service (how to connect); click an identity to copy that call.

Repository labels, per sample. official repository: The archive marks this repository official for the paper. named in the paper: The archive records that the paper mentions this repository; it is not marked official. community (archive-listed): In the archive's code links for this paper, not marked official and not recorded as mentioned in the paper. found in paper text by Syntology: Syntology found this repository in the paper's own text; whether it is the authors' implementation is not asserted. community: Not in the archive's code links for this paper; a community repository Syntology harvested. Samples are grouped by repository: a repository marked official first, then by how directly the repository is tied to the paper, then in the archive's order; never by how many ran. Licence labels name the repository's licence as recorded at harvest. “Pointer only” means Syntology does not serve that copy's text, for one of six reasons: no licence file was found; the licence was not identified; the licence is recorded as permissive but that copy's record is not marked cleared; the licence is outside the permissive list Syntology serves text under (MIT, Apache-2.0, BSD and similar); this paper's copy was not located, so its licence is not recorded; or this paper's copy is cleared, but the stored copy of the same code that Syntology serves is not. Some licences outside that list permit redistribution, such as WTFPL, and GPL-3.0 under its conditions; they are simply not on the list. Hover a licence label for the reason. File links open the file on GitHub at the default branch, which may have changed since the harvest.

A function or class name links to its page when the name occurs in the harvested code of at least 5 papers; the name is a string, not an identity.

mahdinaser/agentic-kd-planner found in paper text by Syntology 15 samples, 13 ran (6 instrument-failed) · 2 unverified
PlanFlags agentic_kd_planner.py ran · metamorphic tier: deterministic no licence file found · pointer only · fe0a156c43207c8a · report fixture: returned PlanFlags · level recorded 2026-09-22
QueryResult agentic_kd_planner.py ran · metamorphic tier: deterministic no licence file found · pointer only · bb71795e4eba07e5 · report fixture: returned QueryResult · level recorded 2026-09-22
SchemaStats agentic_kd_planner.py ran no licence file found · pointer only · ff70f01c792d105b · report fixture: returned SchemaStats · level recorded 2026-09-22
_reorder_joins agentic_kd_planner.py ran · our draft was wrong no licence file found · pointer only · 863506fb9ed605a9 · report fixture: signature from_part:str/0/str, schema_stats:SchemaStats/0/? · returned str · level recorded 2026-09-22
build_sql agentic_kd_planner.py ran · our draft was wrong no licence file found · pointer only · 64538ebc37a35c13 · report fixture: signature plan_flags:PlanFlags/0/?, sql_gold:str/0/str, domain:str/0/str, schema_stats:SchemaStats/0/? · returned str · level recorded 2026-09-22
canonical_hash agentic_kd_planner.py ran · our draft was wrong no licence file found · pointer only · 315cab65c954a0fe · report fixture: signature df:DataFrame/0/? · returned str · level recorded 2026-09-22
estimate_memory agentic_kd_planner.py ran · honoured contract fingerprinted no licence file found · pointer only · 075cd244ab2fb22e · report fixture: signature rows:int/0/int, avg_row_width_bytes:int/0/int · returned float · level recorded 2026-09-22
estimate_query_mem_mb agentic_kd_planner.py ran · honoured contract fingerprinted no licence file found · pointer only · f4aa72cbc5cae3a0 · report fixture: signature row_est:int/0/int, projected_cols:int/0/int · returned float · level recorded 2026-09-22
execute_sql in 9 papers agentic_kd_planner.py ran · our draft was wrong no licence file found · pointer only · c7e9ac1f774b6e8b · report fixture: signature conn:DuckDBPyConnection/0/?, sql:str/0/str, timeout_ms:int/0/int · returned tuple · level recorded 2026-09-22
extract_features in 73 papers agentic_kd_planner.py ran · honoured contract no licence file found · pointer only · 5ce5caa7c7ab66fa · report fixture: signature sql_gold:str/0/str, domain:str/0/str, schema_stats:SchemaStats/0/?, plan_flags:PlanFlags/0/? · returned ndarray · level recorded 2026-09-22
get_duckdb_conn agentic_kd_planner.py ran · our draft was wrong no licence file found · pointer only · 8eee41b2cf8ace24 · report fixture: signature mem_gb:int/0/int · returned DuckDBPyConnection · level recorded 2026-09-22
get_system_ram_gb agentic_kd_planner.py ran · metamorphic tier: well formed no licence file found · pointer only · e897d047fc2ad726 · report fixture: returned int · level recorded 2026-09-22
hash_result agentic_kd_planner.py ran · our draft was wrong no licence file found · pointer only · 8ffe3f3b4e365234 · report fixture: signature df:DataFrame/0/? · returned str · level recorded 2026-09-22
AgenticPlanner agentic_kd_planner.py unverified no licence file found · pointer only · 13c95da34b9df9bf · report
set_global_seeds agentic_kd_planner.py unverified no licence file found · pointer only · f84ae83f0ff0cb30 · report

Method as code Syntology

What Syntology's graph records as this paper's claimed method, lifted into code: each assembly names its bricks (functions and classes), each with its own role and its own verification level. An assembly is not a check that the code implements the method correctly or reproduces the paper's results. Levels are each brick's own verification level in Syntology's graph (level 0: no recorded run), listed brick by brick and never combined into one level; “ran” means the brick executed on a synthesized input, not that its output is correct, and the instrument figure counts failures of Syntology's instrument, not of the code. Where a model read the code against the paper's claim, each assembly's label verdict is one model's judgement, kept in this page's JSON twin; it is not calibrated, so no card prints it.

1 assembly on this paper: 1 harvested, 0 generated.

harvested Assembly for Agentic Cost-Aware Query Planning with Knowledge Distillation (graph method: Agentic Cost-Aware Query Planning with Knowledge Distillation). 15 bricks; individually on a fixture: 13 ran (of which 3 constructed an object rather than computing a result; 7 with no instrument failure: 3 honoured, 0 violated, 4 with no contract checked; 6 where Syntology's instrument failed) · 2 unverified. The assembly has not been run end-to-end.

  1. AgenticPlanner entry · level 0 · unverified · 13c95da34b9df9bf
  2. PlanFlags helper · level 1 · ran · fe0a156c43207c8a
  3. QueryResult helper · level 1 · ran · bb71795e4eba07e5
  4. SchemaStats helper · level 1 · ran · ff70f01c792d105b
  5. build_sql data_transform · level 1 · ran · our draft was wrong · 64538ebc37a35c13
  6. canonical_hash helper · level 1 · ran · our draft was wrong · 315cab65c954a0fe
  7. estimate_memory helper · level 1 · ran · honoured contract · 075cd244ab2fb22e
  8. estimate_query_mem_mb helper · level 1 · ran · honoured contract · f4aa72cbc5cae3a0
  9. execute_sql helper · level 1 · ran · our draft was wrong · c7e9ac1f774b6e8b
  10. extract_features data_transform · level 1 · ran · honoured contract · 5ce5caa7c7ab66fa
  11. get_duckdb_conn helper · level 1 · ran · our draft was wrong · 8eee41b2cf8ace24
  12. get_system_ram_gb helper · level 1 · ran · e897d047fc2ad726
  13. hash_result helper · level 1 · ran · our draft was wrong · 8ffe3f3b4e365234
  14. set_global_seeds helper · level 0 · unverified · f84ae83f0ff0cb30
  15. _reorder_joins helper · level 1 · ran · our draft was wrong · 863506fb9ed605a9

Each brick ends with its code_sha256, Syntology's identity for that exact code; click one to copy the get_code call that returns it. For agents, on Syntology's MCP service: assembly(arxiv_id="2605.17831") returns these assemblies with each brick's role and wiring (how to connect).

Results from the paper

The Papers with Code archive ends with its 2025-07-28 snapshot. This paper's arXiv identifier, 2605.17831, was issued in May 2026, after that date, so the archive has no leaderboard rows for it.

Report a problem or propose a change · a person checks every report against the paper or source before anything changes; decisions are listed on /corrections