Save, modify, annotate and share diagrams with groups while tracking modifications.Allows for Forward and Reverse Engineering of database schema - create a database from an ER diagram, or extract a diagram from an existing database.Supports all major databases and versions including: Oracle, DB2 for LUW, DB2 for iSeries, MS SQL Server, Sybase ASE, Sybase IQ, Sybase Anywhere, Informix, PostgreSQL and MySQL.Sharing a diagram with a team and collaborating on schema changes is easy using integrated support for Subversion (SVN) and CVS source control clients.
The ER Modeler works with every database you already access in Aqua Data Studio, regardless of vendor or version. Taking advantage of a visual model can cut down training time and costs, and allows users to write more effective SQL statements to extract relevant data. The ER Modeler will allow you to create, annotate and distribute visual models of your databases that can be shared with other employees or collaborators on your project. In order to write effective SQL queries, you must understand the entity relationships in the database you are referencing. You can further save, annotate and distribute the models you create to your team so that they may easily create SQL statements with a better understanding of the schema and relationships. The ER Modeler in Aqua Data Studio is capable of producing an Entity-Relationship diagram from existing databases, complete with foreign key relationships. Imagine you walk into a company with several complex databases and are asked to reverse engineer them to produce practical models. Once your visual model is complete, Aqua Data Studio can instantly insert the SQL necessary to create your database. The Entities and Relationship palettes allow you to see and map out relationships between each of the entities involved in your database. The classic use of an Entity-Relationship Modeler is to design or model your database visually before you enter a single line of code. There are 3 primary uses of the ER Modeler, depending on your needs and how far along your database has developed. The ER Modeler is easy enough for a novice to use but functional enough for an experienced Data Architect. This greatly reduces development time and can vastly improve your understanding of database schemas and relationships. Once scripted, manipulating the resulting diagrams will alter the relationships and objects of any corresponding database.
Changes made to an ER diagram can be automatically scripted to make the associated changes in database schemas. It will allow you to create, explore, detail, and modify database schemas in order to create fully editable diagrams of database relationships and objects. The Entity-Relationship (ER) Modeler is a powerful database diagramming tool.
0 kommentar(er)
