Dimensional data modeling CASE tool and DW design practice
4 posters
Page 1 of 1
Dimensional data modeling CASE tool and DW design practice
Hi all,
what dimensional data modelling CASE tool do you use to describe your Data warehouse design?
Do you use any feature able to "translate" the logical desing in physical design (e.g. "create table" SQL scripts, etc.)?
In your job, do you consider a conceptual design before che logical design(e.g. that described in http://tinyurl.com/ovt9or4) ?
Many thanks for your answers
what dimensional data modelling CASE tool do you use to describe your Data warehouse design?
Do you use any feature able to "translate" the logical desing in physical design (e.g. "create table" SQL scripts, etc.)?
In your job, do you consider a conceptual design before che logical design(e.g. that described in http://tinyurl.com/ovt9or4) ?
Many thanks for your answers
Rosanero4Ever- Posts : 8
Join date : 2013-07-16
Re: Dimensional data modeling CASE tool and DW design practice
I've used ERwin and ER-Studio.
For dimensional models, I have found little value in building a logical (or conceptual) model, so I focus purely on the physical model. Both tools will "forward engineer" the model by either creating a SQL script or connecting directly to the database.
For dimensional models, I have found little value in building a logical (or conceptual) model, so I focus purely on the physical model. Both tools will "forward engineer" the model by either creating a SQL script or connecting directly to the database.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: Dimensional data modeling CASE tool and DW design practice
ERwin and ER-Studio aren't free. Do you know any free software?
Rosanero4Ever- Posts : 8
Join date : 2013-07-16
Re: Dimensional data modeling CASE tool and DW design practice
The closest thing to a conceptual model would be the bus matrix. Any spreadsheet will do.
I believe Visio has some rudimentary modeling capabilities. I'm not sure if it will generate DDL.
I believe Visio has some rudimentary modeling capabilities. I'm not sure if it will generate DDL.
Re: Dimensional data modeling CASE tool and DW design practice
ngalemmo, so don't you use any case software for your dw design (logical and physical)?
Rosanero4Ever- Posts : 8
Join date : 2013-07-16
Re: Dimensional data modeling CASE tool and DW design practice
Usually ERWin, it depends on what the client uses. ERStudio and PowerDesigner are other commonly used tools. I was responding to your question about free/low cost tools.
Re: Dimensional data modeling CASE tool and DW design practice
There's another discussion of this subject here:
http://forum.kimballgroup.com/t2027-uses-of-a-data-modeling-tool
My post near the bottom has info on using the Excel templates developed by the Kimball Group.
Good luck!
http://forum.kimballgroup.com/t2027-uses-of-a-data-modeling-tool
My post near the bottom has info on using the Excel templates developed by the Kimball Group.
Good luck!
![-](https://2img.net/i/empty.gif)
» Adherence to dimensional modeling in practice
» Need for a dimensional modeling tool?
» Uses of a data modeling tool
» Dimensional Modeling design
» Model Design best practice - add columns or pivot data for multiple rows ?
» Need for a dimensional modeling tool?
» Uses of a data modeling tool
» Dimensional Modeling design
» Model Design best practice - add columns or pivot data for multiple rows ?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|