Dimensional data modeling CASE tool and DW design practice

View previous topic View next topic Go down

Dimensional data modeling CASE tool and DW design practice

Post  Rosanero4Ever on Fri Dec 27, 2013 4:53 am

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

Rosanero4Ever

Posts : 8
Join date : 2013-07-16

View user profile

Back to top Go down

Re: Dimensional data modeling CASE tool and DW design practice

Post  BoxesAndLines on Fri Dec 27, 2013 1:54 pm

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.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Dimensional data modeling CASE tool and DW design practice

Post  Rosanero4Ever on Fri Dec 27, 2013 2:05 pm

ERwin and ER-Studio aren't free. Do you know any free software?

Rosanero4Ever

Posts : 8
Join date : 2013-07-16

View user profile

Back to top Go down

Re: Dimensional data modeling CASE tool and DW design practice

Post  ngalemmo on Fri Dec 27, 2013 3:19 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Dimensional data modeling CASE tool and DW design practice

Post  Rosanero4Ever on Sun Dec 29, 2013 2:51 pm

ngalemmo, so don't you use any case software for your dw design (logical and physical)?

Rosanero4Ever

Posts : 8
Join date : 2013-07-16

View user profile

Back to top Go down

Re: Dimensional data modeling CASE tool and DW design practice

Post  ngalemmo on Mon Dec 30, 2013 3:05 am

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Dimensional data modeling CASE tool and DW design practice

Post  Mike Honey on Sun Jan 12, 2014 10:03 pm

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!
avatar
Mike Honey

Posts : 185
Join date : 2010-08-04
Location : Melbourne, Australia

View user profile http://www.mangasolutions.com

Back to top Go down

Re: Dimensional data modeling CASE tool and DW design practice

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum