The registered tables are managed through an administration panel used for creating or editing them, allowing for the configuration of specific settings (e.g., partitioning, domain, etc.).

From a structural perspective, the main challenge was to design an architecture capable of flexibly and dynamically managing permissions, access levels, and visualization methods for each application component, in alignment with the organizational structure typical of the banking sector. Given the large volumes of data involved, special attention was dedicated to optimizing processes and the resources required to ensure a smooth, responsive, and scalable software solution.

In terms of usability, the key challenge was to design user interface components that accurately reflected SQL logic while remaining intuitive and accessible to users with low to intermediate knowledge of relational data structures.

The project was initiated based on clear and well-defined requirements, which allowed for the reduction of preliminary project analysis activities in favor of greater precision and focus during the structural and architectural analysis phases. The main analysis activities carried out included:

• Creation of mockups
• ER and class modeling
• Analysis of the main application workflows
• Identification and prioritization of project sprints

The overall development followed the Agile methodology, with sprints being analyzed, developed, released, and tested according to the assigned priorities.

• Oracle database
• ORM Hibernate
• Java Spring Boot
• Angular

The platform is currently in production and is used by over 80 banks across the country. The solution has helped optimize several processes within the banking sector, streamlining workflows that were previously very resource- and time-intensive.