Industry standard data warehouse models

Are there any resources for industry standard data warehouse models? I'm especially interested in financial models regarding securities (stocks, commodities, etc.).

Are you looking for data models in general?

Or are you looking for designs of data mining models that fit a particular schema?

|||

Both! Rather than reinvent the wheel, it would be nice if such resources existed.

However, my current project regards the securities markets in particular.

|||I'm going to move this thread to the OLAP forum where you may find a better audience to answer about data models. Once you get a data model, then it's easier to talk about data mining (at least from where you're starting)|||Where's the OLAP forum? I thought Analysis Services was the place to ask OLAP questions.|||

Take a look at the Kimball group http://www.kimballgroup.com/

See if you can find datawarehousing model you are looking for.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Indexing strategies

Dear all,
I'd like to explore more about indexing strategies and would appreciate
a reference to some good resources this regard including book names.

Best regardsThis is your best choice (In my opinion)

Inside Microsoft SQL Server 2000
by Kalen Delaney
http://www.amazon.com/exec/obidos/t...=glance&s=books

Denis the SQL Menace
http://sqlservercode.blogspot.com/

Indexes and tuning resources

I'm something of an amateur when it comes to table indexing and tuning and was hoping everyone could recommend some quick-read resources that I can better my knowledge and understanding. I know there are books that cover these topics but I really need some quick solutions and need to better understand these things as quickly as possible. Thanks!

- JamesJames,

Your best bets are

Books Online (either intalled locally or online at http://msdn2.microsoft.com/en-us/library/ms313868.aspx).

SQL TechNet center at (there are whitepapers and webcasts)
http://www.microsoft.com/technet/prodtechnol/sql/default.mspx

and other resources such as (look for learning links, they may cross-ref the above info)
http://www.microsoft.com/sql/default.mspx

Regards,
Boris.