steps to design Data Architecture

View previous topic View next topic Go down

steps to design Data Architecture

Post  winny on 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

View user profile

Back to top Go down

Re: steps to design Data Architecture

Post  warrent on 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
avatar
warrent

Posts : 41
Join date : 2008-08-18

View user profile

Back to top Go down

Re: steps to design Data Architecture

Post  Robin5William on 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?
avatar
Robin5William

Posts : 1
Join date : 2011-06-24

View user profile

Back to top Go down

Re: steps to design Data Architecture

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