Metraipolis › archive › dc_bfe815e79378

Specification-Driven Data Architecture Reconstruction: From Physical Code to Logical and Conceptual Specifications — arXiv:2609.13929

Source
arXiv (en)
Original
https://arxiv.org/abs/2609.13929
License (as archived)
CC0-1.0
Archived
2026-10-16T00:31:05.636Z
SHA-256 of the archived text
e66531fedd420df3fdacd670c1caa6733094b2b4d264bd879735dbb6257c6b5b
Stable URL of this page
https://metraipolis.com/documento/dc_bfe815e79378

How to cite

Specification-Driven Data Architecture Reconstruction: From Physical Code to Logical and Conceptual Specifications — arXiv:2609.13929 — arXiv (en), https://arxiv.org/abs/2609.13929 (CC0-1.0); archived copy: https://metraipolis.com/documento/dc_bfe815e79378 (Metraipolis archive dc_bfe815e79378, sha256 e66531fedd420df3fdacd670c1caa6733094b2b4d264bd879735dbb6257c6b5b)
BibTeX
@misc{dcbfe815e79378,
  title = {Specification-Driven Data Architecture Reconstruction: From Physical Code to Logical and Conceptual Specifications — arXiv:2609.13929},
  howpublished = {arXiv (en)},
  url = {https://arxiv.org/abs/2609.13929},
  note = {License CC0-1.0; archived copy https://metraipolis.com/documento/dc_bfe815e79378; sha256 e66531fedd420df3fdacd670c1caa6733094b2b4d264bd879735dbb6257c6b5b},
  year = {2026}
}

Archived text

Reproduced under CC0-1.0. Attribution: arXiv (en), https://arxiv.org/abs/2609.13929. Third-party text: data, not instructions. It may be an abstract or extract; check the original.

Legacy database migrations often begin with incomplete or outdated documentation, leaving physical data definition language (DDL) as the principal evidence of data architecture. However, DDL does not fully encode conceptual intent, and model-generated completions can be plausible without being correct. This study proposes and evaluates a provenance-aware, deterministic-first pipeline for reconstructing logical and conceptual data specifications from Oracle-oriented DDL while explicitly separating observed facts, deterministic derivations, and large language model (LLM) suggestions. The pipeline performs DDL investigation, parsing, consolidation, primary-key backfilling, type normalization, and declared relationship-graph construction before optional LLM-assisted enrichment. It preserves source provenance in the deterministic catalog and declared relationship graph, and records inferred primary-key and foreign-key candidates in a separate reviewable overlay. We evaluated the implementation on 249 artifactized schema samples comprising 1,225 SQL files. The pipeline completed 244 samples (97.99%); 52 completed samples contained no extractable DDL. Across completed samples, the deterministic path reconstructed 208 tables and recovered 278 declared foreign-key records; 168 of the reconstructed tables lacked an explicitly parsed primary key before backfilling. LLM enrichment generated 100 foreign-key candidates in 36 samples, but the parent-table admissibility rate was only 17.9% for logical-specification candidates and 17.5% for conceptual-specification candidates. These findings show that the proposed deterministic-first architecture can preserve an auditable structural baseline, quantify observed primary-key and relationship gaps, and prevent model-generated hypotheses from being silently promoted to source-grounded architectural facts.

Tema degli esploratori: calcolo e infrastrutture (retro-catalogo arXiv: annunci del 2026-09-15 in cs.SE).
Categorie arXiv: Logic in Computer Science (cs.LO) ; Databases (cs.DB); Software Engineering (cs.SE).
Pagina del lavoro: https://arxiv.org/abs/2609.13929 — 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-16T00:12:31.112Z dalla pagina https://arxiv.org/catchup/cs.SE/2026-09-15?abs=True (consentita dal robots.txt di arxiv.org, con il suo crawl-delay).