asked on

Data Warehouse 2.0 usage in read world.

Dear all,

I see there is a book:

http://www.amazon.com/gp/product/0123743192/ref=ox_sc_sfl_title_1?ie=UTF8&psc=1&smid=ATVPDKIKX0DER

I am a new guys on data warehouse, is DW 2.0 product existing in the planet already? any successful case ?

What is the tools in the world used by expertise to do this? any monitoring and reporting to show us if the DW going into trouble or into trouble already ?

SOLUTION

Vikas Garg

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

magarity

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

marrowyung

ASKER

Vikas Garg,

I knew the basic, from MS point of view, the cube is call data mart, right?

magarity,

"Ask in general terms if your business users need "more" or "better" from your dw and proceed from there."

what is that mean ? please clarify .

"Never redesign or install something new "just because".
Feel free to read books on new ideas so you can be ready but dont get excited about overhauling a dw for the latest buzzwords."

seems conflict on interest, right? don't do sth new but keep reading sth new.. please clarify a bit further.

basically just like to learn what is the diff between DW 1.0 and 2.0. any idea?

ASKER CERTIFIED SOLUTION

Vitor Montalvão

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

marrowyung

ASKER

"DW 2.0 isn't a product but an architecture. Is like Web 2.0. Did you see any company selling Web 2.0?"

yeah, I should say any DW 2.0 related product you can see in the market and I mean exactly about the architecture.

tks. Vitor.

marrowyung

ASKER

oh, my god, the PDF Victor you give me is from famous W H Inmon, I am currently searching data modelling, T-SQL tuning books and DW books:

http://www.amazon.com/gp/product/0123743192/ref=ox_sc_sfl_title_1?ie=UTF8&psc=1&smid=ATVPDKIKX0DER

http://www.amazon.com/gp/product/0764599445/ref=ox_sc_act_title_1?ie=UTF8&psc=1&smid=ATVPDKIKX0DER

both from him and that's why I come and ask.

but I am suggested to read this book first:

http://www.amazon.com/gp/product/1118530802/ref=ox_sc_act_title_7?ie=UTF8&psc=1&smid=ATVPDKIKX0DER

as this is much close to real life than theory.

do you think that PDF is exactly copy of that DW 2.0 books ?

marrowyung

ASKER

basically any tools from MS/Oracle for us to learn and trial play around their DW technology ?

Vitor Montalvão

Unfortunaly I'm not expert in DW but looks like MS knows about this since 2008 so I wouldn't be surprise if SQL Server is ready for DW 2.0 and if SQL Server is ready then Oracle also must be ready.
Here's the MSDN article about it.

marrowyung

ASKER

"ut looks like MS knows about this since 2008 so I wouldn't be surprise if SQL Server is ready for DW 2.0 and if SQL Server is ready then Oracle also must be ready."

yeah, they are, but oracle have warehouse builder tools, this is what I am looking for, a free platform for us to start and learn with.

yeah, I knew the product from that Link, it has the MS version of database RAC ! MS just do it on database tier instead of oracle RAC's cluster tier .

marrowyung

ASKER

I can't find if the PDF is the copy of that book, should not be, as the PDF is not long enough to become a book.

Vitor Montalvão

Sorry, I didn't read the book so can't confirm about the PDF.

marrowyung

ASKER

yeah, I will buy that book if at that moment, no DW 3.0 release. AHHAAH