Version 4 2025-03-22, 03:17
Version 3 2025-03-18, 09:35
Version 2 2025-03-17, 12:06
Version 1 2025-03-15, 03:55
journal contribution
posted on 2025-03-22, 03:17 authored by RISE riseRISE riseRISE
RISE is an automated rule-driven SQL dialect translation tool that utilizes dialect-aware query reduction.
RISE consists of the following five parts：
- adaptiveparser.py: Parse the SQL queries into the corresponding abstract syntax trees.
- queryreduction.py: Apply dialect-aware query reduction to the source SQL queries.
- llmtranslator.py: Translate the simplified queries with specific dialect directly using LLMs.
- rulegen.py: Extract the translation rules between the queries before and after translation.
- applyrule.py: Apply the rules to directly translate the corresponding dialects in the source SQL queries.
Evaluation
- TPC-DS: 99 queries from PostgreSQL to MySQL.
- SQLProBench: 44 queries from PostgreSQL to Oracle.
