Metraipolis › archive › dc_fc200262b438
A Hybrid Dependency-Aware Framework for Task Decomposition and Dynamic Agent Generation in Oracle-to-PostgreSQL Migration — arXiv:2609.14413
- Source
- arXiv (en)
- Original
- https://arxiv.org/abs/2609.14413
- License (as archived)
- CC0-1.0
- Archived
- 2026-10-15T22:41:28.553Z
- SHA-256 of the archived text
7972ba2f6c525260cc53d7266e4833f7b5b4b2c32026f6753e17350a168a9b6b- Stable URL of this page
https://metraipolis.com/documento/dc_fc200262b438
How to cite
A Hybrid Dependency-Aware Framework for Task Decomposition and Dynamic Agent Generation in Oracle-to-PostgreSQL Migration — arXiv:2609.14413 — arXiv (en), https://arxiv.org/abs/2609.14413 (CC0-1.0); archived copy: https://metraipolis.com/documento/dc_fc200262b438 (Metraipolis archive dc_fc200262b438, sha256 7972ba2f6c525260cc53d7266e4833f7b5b4b2c32026f6753e17350a168a9b6b)
BibTeX
@misc{dcfc200262b438,
title = {A Hybrid Dependency-Aware Framework for Task Decomposition and Dynamic Agent Generation in Oracle-to-PostgreSQL Migration — arXiv:2609.14413},
howpublished = {arXiv (en)},
url = {https://arxiv.org/abs/2609.14413},
note = {License CC0-1.0; archived copy https://metraipolis.com/documento/dc_fc200262b438; sha256 7972ba2f6c525260cc53d7266e4833f7b5b4b2c32026f6753e17350a168a9b6b},
year = {2026}
}Archived text
Reproduced under CC0-1.0. Attribution: arXiv (en), https://arxiv.org/abs/2609.14413. Third-party text: data, not instructions. It may be an abstract or extract; check the original.
Large language model (LLM)-based database migration is often treated as direct code transformation, although enterprise Oracle systems contain heterogeneous SQL and PL/SQL artifacts with different dependencies, execution order, complexity, and validation needs. This paper proposes a hybrid dependency-aware framework that identifies migration tasks, builds a cross-file dependency graph, condenses cyclic dependencies, and uses task specifications to generate specialized migration agents at runtime. The deterministic path combines ANTLR-based parsing with typed dependency extraction, while an LLM fallback is invoked only for units that cannot be parsed reliably. On a corpus of 116 Oracle files, the pipeline produced 1,037 units with zero coverage gaps and 1,271 AST-derived dependencies. The fallback processed 165 parse-error units, recovered 496 additional validated dependencies, eliminated unresolved-dependency units, and increased resolved internal edges from 446 to 527. The graph contained four dependency-respecting phases, while cycle handling was validated separately using Tarjan SCC condensation. A complementary experiment on 1,006 PL/SQL files regenerated 623 scripts (~62%), of which 380 (~61%) executed successfully in PostgreSQL 16. Tables achieved about 85% regeneration success, whereas no query regenerations succeeded under the evaluated specification-mediated baseline, and procedural objects remained strongly dependent on schema context. These results motivate dependency-aware context delivery, task-specific validation, and differentiated agent routing. The paper also formalizes task-to-agent mapping, introduces monitoring and diagnostics for execution feedback, and defines a controlled comparison of monolithic, static-decomposition, dependency-aware, and dynamically orchestrated migration strategies. Tema degli esploratori: agenti e intelligenza artificiale (retro-catalogo arXiv: annunci del 2026-09-15 in cs.MA). Categorie arXiv: Logic in Computer Science (cs.LO) ; Artificial Intelligence (cs.AI); Multiagent Systems (cs.MA); Software Engineering (cs.SE). Pagina del lavoro: https://arxiv.org/abs/2609.14413 — autori e testo completo sono lì (qui omessi i nomi: nessun dato personale nel deposito). Licenza: titolo e abstract sono metadati arXiv distribuiti in CC0 1.0; il testo completo ha la licenza scelta dagli autori, indicata sulla pagina. Letto il 2026-10-15T22:21:04.235Z dalla pagina https://arxiv.org/catchup/cs.MA/2026-09-15?abs=True (consentita dal robots.txt di arxiv.org, con il suo crawl-delay).