Informações Principais
     Resumo
     Abstract
     Introdução
     Conclusão
     Download
  
  
  
 
Abstract
 
 
Acadêmico(a): Paulo Alberto Bugmann
Título: Ferramenta Web para Modelagem Lógica em Projetos de Bancos de Dados Relacionais
 
Abstract:
This study presents the implementation of an application for modeling logic in the design of relational databases, developed to run in a web environment using the Java platform, the MVC architecture and some design patterns such as DAO and Command. To make the interface more user-friendly system was used at times, the set of techniques known as AJAX, offering features similar to desktop applications. The application developed was drawn from the work of WebModeler Bachmann (2007), including new features and improving. The App allows control of projects databases and their versions, and enables the restriction of user access to certain projects. It also allows diagrams to be created to model the tables, columns and relationships graphically, with the option of printing, reduce and enlarge the diagram. Still, there is the possibility to register the tables and indexes scripts to generate the SQL statements needed to create the database modeled and also to upgrade an existing database, applying the changes made between two versions. Finally, there is the possibility of developing graphical UML diagrams such as use case diagram and classes and activities.