一种用于Oracle到PostgreSQL迁移的混合依赖感知任务分解与动态智能体生成框架
A Hybrid Dependency-Aware Framework for Task Decomposition and Dynamic Agent Generation in Oracle-to-PostgreSQL Migration
浏览论文内容
中文总结 AI 辅助
本文提出一种混合依赖感知框架，通过跨文件依赖图与动态智能体生成，提升Oracle到PostgreSQL迁移的完整性与成功率，实验验证了其有效性。
中文摘要 AI 辅助
基于大型语言模型（LLM）的数据库迁移通常被视为直接的代码转换，尽管企业级Oracle系统包含异构的SQL和PL/SQL工件，这些工件具有不同的依赖关系、执行顺序、复杂性和验证需求。本文提出了一种混合依赖感知框架，该框架识别迁移任务、构建跨文件依赖图、压缩循环依赖，并在运行时利用任务规范生成专门的迁移智能体。确定性路径将基于ANTLR的解析与类型化依赖提取相结合，而LLM回退仅用于无法可靠解析的单元。在包含116个Oracle文件的语料库上，该流水线生成了1,037个单元，覆盖零缺口，并提取了1,271个源自AST的依赖。回退机制处理了165个解析错误单元，恢复了496个额外验证的依赖，消除了未解析依赖单元，并将已解析的内部边从446条增加到527条。该图包含四个尊重依赖的阶段，而循环处理通过Tarjan强连通分量（SCC）压缩单独验证。一项补充实验在1,006个PL/SQL文件上重新生成了623个脚本（约62%），其中380个（约61%）在PostgreSQL 16中成功执行。表的再生成功率约为85%，而在评估的规范中介基线之下，没有查询再生成功，过程化对象仍然强烈依赖模式上下文。这些结果推动了依赖感知的上下文传递、任务特定验证和差异化智能体路由。本文还形式化了任务到智能体的映射，引入了执行反馈的监控和诊断，并定义了单片式、静态分解、依赖感知和动态编排迁移策略的受控比较。
英文摘要
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.
发表机构
- EPAM Systems（EPAM系统公司）
机构由 AI 辅助整理，请以论文原文为准。
