Please use this identifier to cite or link to this item: https://hdl.handle.net/10216/176117
Full metadata record
DC FieldValueLanguage
dc.creatorBernardo António Coelho Gonçalves
dc.date.accessioned2026-08-07T01:39:42Z-
dc.date.available2026-08-07T01:39:42Z-
dc.date.issued2026-07-22
dc.date.submitted2026-07-31
dc.identifier.othersigarra:787326
dc.identifier.urihttps://hdl.handle.net/10216/176117-
dc.descriptionLegacy systems built with Oracle Forms still support core business operations in many organizations, yet their migration to modern microservice platforms is delayed and hampered by the fact that critical requirements and business rules are embedded in PL/SQL trigger code and form metadata rather than in explicit documentation. Manually recovering these requirements is slow, costly, and error-prone. This dissertation proposes an automated, multi-agent pipeline that reverse-engineers Oracle Forms applications into structured software requirements. Each form's XML export is parsed into an Abstract Syntax Tree that retains only the necessary information, while the database schema and PL/SQL packages are extracted from the accompanying DDL. These artifacts are merged into a Unified Application Behavior Graph, used both to cluster the forms into candidate microservices and to provide context to the LLMs. A deterministic depth-first traversal then collects the relevant context for a Writer agent - a large language model equipped with tools - which generates functional requirements, business rules, integration requirements, and pre/post-conditions in structured JSON, while a Verifier agent checks each requirement for grounding, coverage, and consistency against the source. The approach was applied to a real project within the company. The extracted requirements were externally validated through a questionnaire completed by the application's developers and aligned with the ISO/IEC/IEEE 29148 quality characteristics, using stratified sampling and Krippendorff's α as the inter-rater reliability metric.
dc.description.abstractLegacy systems built with Oracle Forms still support core business operations in many organizations, yet their migration to modern microservice platforms is delayed and hampered by the fact that critical requirements and business rules are embedded in PL/SQL trigger code and form metadata rather than in explicit documentation. Manually recovering these requirements is slow, costly, and error-prone. This dissertation proposes an automated, multi-agent pipeline that reverse-engineers Oracle Forms applications into structured software requirements. Each form's XML export is parsed into an Abstract Syntax Tree that retains only the necessary information, while the database schema and PL/SQL packages are extracted from the accompanying DDL. These artifacts are merged into a Unified Application Behavior Graph, used both to cluster the forms into candidate microservices and to provide context to the LLMs. A deterministic depth-first traversal then collects the relevant context for a Writer agent - a large language model equipped with tools - which generates functional requirements, business rules, integration requirements, and pre/post-conditions in structured JSON, while a Verifier agent checks each requirement for grounding, coverage, and consistency against the source. The approach was applied to a real project within the company. The extracted requirements were externally validated through a questionnaire completed by the application's developers and aligned with the ISO/IEC/IEEE 29148 quality characteristics, using stratified sampling and Krippendorff's α as the inter-rater reliability metric.
dc.language.isoeng
dc.rightsembargoedAccess
dc.subjectEngenharia electrotécnica, electrónica e informática
dc.subjectElectrical engineering, Electronic engineering, Information engineering
dc.titleFrom Legacy to Reactive: Interpreting Source Code into Requirements for Automated App Generation
dc.typeDissertação
dc.date.embargo2029-07-21
dc.contributor.uportoFaculdade de Engenharia
dc.subject.fosCiências da engenharia e tecnologias::Engenharia electrotécnica, electrónica e informática
dc.subject.fosEngineering and technology::Electrical engineering, Electronic engineering, Information engineering
thesis.degree.disciplineMestrado em Engenharia de Software
thesis.degree.grantorFaculdade de Engenharia
thesis.degree.grantorUniversidade do Porto
thesis.degree.level1
rcaap.embargofctDados confidenciais.
Appears in Collections:FEUP - Dissertação

Files in This Item:
File Description SizeFormat 
787326.pdf
  Restricted Access
From Legacy to Reactive: Interpreting Source Code into Requirements for Automated App Generation1.82 MBAdobe PDFView/Open


Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.