Erwin Data Modeler: Difference between revisions
| Line 15: | Line 15: | ||
[[File:ERWin 4.1.4.3643 on Windows 2000 screenshot.png|thumbnail|right|ERwin CASE tool on Windows |
[[File:ERWin 4.1.4.3643 on Windows 2000 screenshot.png|thumbnail|right|ERwin CASE tool on Windows |
||
2000]] |
2000]] |
||
ERwin was created by [[Logic Works]]. It was acquired in 1998 by [[Platinum Technology]], which was later acquired in May 1999 by [[Computer Associates]], who added it to their AllFusion suite under the name ''AllFusion ERwin Data Modeler''. The tool was later renamed to ''CA ERwin |
ERwin was created by [[Logic Works]]. It was acquired in 1998 by [[Platinum Technology]], which was later acquired in May 1999 by [[Computer Associates]], who added it to their AllFusion suite under the name ''AllFusion ERwin Data Modeler''. The tool was later renamed to ''CA ERwin Data Modeler''. |
||
Logic Works' companion products include BPwin – an [[IDEF0]] process modeling tool – and [[ModelMart]] – to support the collaborative development of both data and process models. |
|||
==Distinguishing features== |
==Distinguishing features== |
||
Revision as of 16:45, 9 March 2012
| Developer(s) |
|
|---|---|
| Stable release | r8.0
/ 2011 |
| Operating system | Microsoft Windows |
| Type | CASE tool |
| License | Proprietary EULA |
| Website | www |
CA ERwin Data Modeler (ERwin) is a software tool for data modeling (data requirements analysis, database design etc) of custom developed information systems, including databases of transactional systems and data marts. ERwin's data modeling engine is based upon the IDEF1X method, although it now supports diagrams displayed with information engineering notation as well.
History
ERwin was created by Logic Works. It was acquired in 1998 by Platinum Technology, which was later acquired in May 1999 by Computer Associates, who added it to their AllFusion suite under the name AllFusion ERwin Data Modeler. The tool was later renamed to CA ERwin Data Modeler.
Distinguishing features
- Logical Data Modeling: Purely logical models may be created, from which physical models may be derived. Combinations of logical and physical models are also supported. Supports entity-type and attribute logical names and descriptions, logical domains and data types, as well as relationship naming.
- Physical Data Modeling: Purely physical models may be created as well as combinations of logical and physical models. Supports the naming and description of tables and columns, user defined data types, primary keys, foreign keys, alternative keys and the naming and definition of constraints. Support for indexes, views, stored procedures and triggers is also included.
- Logical-to-Physical Transformation: Includes an abbreviation/naming dictionary called "Naming Standards Editor" and a logical-to-RDBMS data type mapping facility called "Datatype Standards Editor", both of which are customizable with entries and basic rule enforcement.
- Forward engineering: Once the database designer is satisfied with the physical model, the tool can automatically generate a SQL Data Definition Language (DDL) script that can either be directly executed on the RDBMS environment or saved to a file.
- Reverse engineering: If an analyst needs to examine and understand an existing data structure, ERwin will depict the physical database objects in an ERwin model file.
- Model-to-model comparison: The "Complete/Compare" facility allows an analyst or designer to view the differences between two model files (including real-time reverse-engineered files), for instance to understand changes between two versions of a model.
- An "Undo" feature is available in version 7.
Competitors
Competitors include Embarcadero ER/Studio, ModelRight, DeZign for Databases, Oracle Designer, Oracle SQL Developer Data Modeler, Sybase PowerDesigner and IBM Data Architect.
Associated products
- CA ERwin Web Portal
- CA ERwin Data Model Validator
- CA ERwin Saphir Option for ERP
See also
Publications
- Burbank, Donna (2011). Data Modeling Made Simple with CA ERwin Data Modeler r8. Technics Publications. ISBN 9781935504092.
- DeAngelis, Carla (2000). Data Modeling with ERwin. Sams. ISBN 0672318687.
External links
 | This database software-related article is a stub. You can help Wikipedia by expanding it. |