Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

steps to design Data Architecture

3 posters

Go down

steps to design Data Architecture  Empty steps to design Data Architecture

Post  winny Wed Jun 22, 2011 10:55 pm

Hi folks,
I have been following this forum from past 6 months and it had helped me lot.I would like to thank you all and appreciate your time in discussing about various topics.AND THIS IS MY FIRST POST IN THE FORUM. I am in to data modeling from past 6 months. Now I got an opportunity to build a data ware house. I would like what are the steps to be consider build a data architecture for the data warehouse.
Could you also please suggest me a book where I can find the information on how to build a data architecture?

winny

Posts : 4
Join date : 2011-03-23

Back to top Go down

steps to design Data Architecture  Empty Re: steps to design Data Architecture

Post  warrent Thu Jun 23, 2011 7:45 pm

Hi, Winny,

We're glad you've found the forum to be useful. Your question is a bit broad to answer here, but it sounds like you are looking for what we call the enterprise data warehouse bus architecture, or the bus matrix for short. Here are some Kimball Group references to get you started:

the Data Warehouse Toolkit, 2nd Ed, (Wiley, 2002), pages 78-88
the Data Warehouse Lifecycle Toolkit, 2nd Ed, (Wiley, 2008), pages 248-253
The Matrix - a 1999 article by Ralph in Intelligent Enterprise
The Matrix Revisited - a 2002 update by Margy
Divide and Conquer - a description of how the bus matrix and conformed dimensions are required for distributed data warehouses.

This should keep you busy!
--Warren
warrent
warrent

Posts : 41
Join date : 2008-08-18

Back to top Go down

steps to design Data Architecture  Empty Re: steps to design Data Architecture

Post  Robin5William Fri Jun 24, 2011 4:01 am

Thanks for sharing this info warrent....I am a computer science student and having data warehousing this year.So can you please suggest me some good tutorial for this?
Robin5William
Robin5William

Posts : 1
Join date : 2011-06-24

Back to top Go down

steps to design Data Architecture  Empty Re: steps to design Data Architecture

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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