Masterful data modeling
ER/Studio 7.1 conquers drudgery with easy, insightful tools
The new data lineage feature makes a good start, but it’s not terribly useful just yet. You can define a number of data movement rules for each column in your tables that allow you to document exact standards or expected guidelines for the data in the production system. You can define rules for operations, including backup, updates, archives, recovery, and more. You can also define data sources and targets and map them directly to your model, allowing you to document the dataflow in your environment with relative ease. This is all good. The problem is, getting the information back out of the model in any usable format isn’t nearly as easy as putting it in. You need to write your own code to extract it. It would be nice if ER/Studio could show you the lineage in a nice diagram so you could package it with your data dictionary or publish it by itself.
ER/Studio may be the best overall data modeler on the market. Its combination of features and ease of use puts it leagues ahead of competitors such as Computer Associates’ ERwin. The new capacity-planning capabilities will help architects answer tough questions such as how much space your database will consume one year from now. The repository gives larger shops the capability to wrap security around enterprise data models and define some top-level policies. The data lineage tool still needs some work, but it’s an excellent start and will be of good use to serious data architects.