Comparison : Assessing Support for Top-Down Data Modeling in Two Leading Tools
Idera ER/Studio Data Architect vs. erwin Data Modeler
ER/Studio and erwin Data Modeler are long-standing players in the data modeling tools market, focusing completely on the production of Logical Data Models (LDMs) and Physical Data Models (PDMs). Both tools have powerful utilities for building models and databases, but data professionals choosing between them may want to know more about the specifics of their performance.
Author: George McGeachie
George McGeachie, an independent expert in modeling and metadata with more than 30 years of experience, assesses Idera ER/Studio and erwin Data Modeler Standard Edition in this first-of-its-kind whitepaper. With a focus on support for top-down data modeling, McGeachie provides an in-depth examination of the process of creating several models with each tool, walking the reader through the capabilities and limitations of each.
In this whitepaper, you’ll learn how ER/Studio and erwin Data Modeler compare when building databases using two distinct approaches – Silo Design and Enterprise Logical Data Model (ELDM)-Driven Modeling – and how they perform when:
- Building and editing LDMs
- Generating, updating, and denormalizing PDMs
- Creating databases
- Merging selected parts of LDM into ELDM
McGeachie explains how each tool performs in the separation of logical and physical data views, as well as in the traceability of the links between the models, and provides his recommendations.
Register to read the full comparison.
Topics : Data Governance,Data Modeling,Enterprise Architecture,Metadata,
Products : ER/Studio Data Architect,ER/Studio Data Architect Professional,ER/Studio Enterprise Team Edition,