ER/Studio

ER/Studio is data architecture and database design software developed by Embarcadero Technologies. It works across multiple database platforms and is used by data architects, data modelers, database administrators and business analysts to create and manage database designs, document and reuse data assets. It is similar to CA ERwin Data Modeler, ModelRight, PowerDesigner, Toad Data Modeler, etc.

Features

* Logical and physical design support
* XML Schema generation from either the logical or physical models
* Automation and scripting support
* Forward- and reverse- engineering
* Automated database code generation
* Integration of models and metadata
* Collaboration support including sub model management, repository, “where used”
* Web publishing, RTF, MS Office integration
* Integrate model metadata with other platforms such as BI, ETL, and other modeling tools.
* Data lineage documentation
* Dimensional modeling
* Model completion validation
* Automatic foreign key migration
* Capacity planning

upport

* IDEF1X
* Star schema
* Snowflake Schema

ee also

* Relational Model
* Denormalization
* Data modeling
* Model-driven architecture
* RDBMS
* XML
* XML Schema
* Data warehouse

External links

* [http://www.embarcadero.com/products/erstudio/ Official website]
* [http://www.embarcadero-software.de/produkte_er_studio.html German website]
* [http://www.infoworld.com/articles/ec/xml/00/05/22/000522ecstudio.html Infoworld.com article]
* [http://www.bitpipe.com/detail/PROD/1025205626_676.html Bitpipe.com article]
* [http://www.sqlmag.com/Article/ArticleID/9155/sql_server_9155.html SQL Server magazine article]
* [http://www.felix-colibri.com/papers/db/embarcadero_er_studio/embarcadero_er_studio.html ER Studio Tutorial]