Database Modeling
Design conceptual, logical and physical database with sophisticated ERD. Model the entities, stored procedures, triggers and their relationships with easy-to-use diagramming environment.
Entity relationship diagram
Entity relationship diagram (ERD) is used to present the Entity-Relationship Model in software engineering industry. ERD can be used for visualizing conceptual data structure and physical database schema. Agilian supports conceptual, logical and physical data modeling.
The following movie shows how to create conceptual data model and transit the conceptual data model to physical. The movie shows also the modeling of physical database schema and, stored procedure.
Object-Relational Mapping diagram
Mapping View:
Object-relational mapping diagram (ORM diagram) presents the mapping between classes and entities visually. Visualization between classes and entities can help developer to gain more understanding of how a row of data in database transform to/from object in memory. The following movie shows how to visualize the mapping between classes and entities.
Stored procedure and trigger
Agilian can design, reverse and generate stored procedures and database triggers. Flexible grouping helps to group stored procedures and triggers in meaningful way.
