Database Architecture and Design
Casestudio 2 is a physical modelling package. [1CASE] Within the constraints of the target physical database it allows you to create a schema, tables, dictionaries, triggers, stored procedures etc. You can create declarative (referential) or programmatic (Triggers and Stored Procedures) integrity. Pricing $370 USD.
Erwin has been around a while and is now owned by compyter associates. You can visit the CA web site or view this PDF brochure. I used this product several years ago. It was quite good. It allowed physical and logical models. Pricing = $4000USD range.
Embarcadero produces ER Studio and a raft of tools for the database developer. It allows physical and logical models. Pricing $2000 and up.
ER Studio Issues
It does not support some of the DBMS's that I work with. Check the supported list (and the versions supported) very carefully.
All of the Database Modelling tools have their strengths and weaknesses. Do not assume that paying a higher price will get you the features you need. Case Studio 2 has some capabilities not possessed by the two more expensive packages. In some cases the ability to generate a model for a particular RDBMS is available only on Case Studio 2.
Casestudio 2: Since some would decalre it a conflict of interest I will admit that I assisted in writing the product manual for CS2. This came about when I purchased CS2 and found the manual frustrating to use. I offered to update it and correct the English. If you understand the limitations of the RDBMS target to which you are directing your efforts, and the limitations of the particular implementation of the Relational Model as realized by the DB vendor, CS2 can be quite useful - despite the limitation of offering only a physical model. Considering the low cost, CS2 can deliver very high value.
|PMC Home | What's New | Contact Us|
Found a mistake? A broken link? Let the
Webmaster know. Your
assistance is always appreciated!.
Updated January 27, 2005