<< MS SQL's 'binn' directory | Home | The little things that can screw up a software project >>

Of Data Warehouses and Data Marts

Wednesday, August 29, 2007 2:59 PM

So, readers, what are your thoughts. If you have 5 data marts, 2 of which have a heavy load. How do those get implemented? Ignoring machines, focus on databases.

A. Put all 5 data marts into one database.

B. Put the 2 heavy data marts in their own separate databases, and the other three data marts in one database.

C. One data mart per database. Always.

Feedback

# re: Of Data Warehouses and Data Marts

Unless your company is loaded, option C is normally too costly. Open A doesn't sound like an option at all. So my guess is either Option B, or that the 2 heavy datamarts be splitted into 2 servers so that you have 1 heavy + 2 light on 1 server and 1 heavy + 1 light on 1 server.

Cheers
8/31/2007 6:50 AM | Nestor

# re: Of Data Warehouses and Data Marts

I wouldn't think of option C as being costly, its one box, one instance of SQL Server with 5 databases (ie Datamarts). 8/31/2007 7:44 AM | Dru

Comments have been closed on this topic.

Of Data Warehouses and Data Marts

Feedback

# re: Of Data Warehouses and Data Marts

# re: Of Data Warehouses and Data Marts

News

Archives

Tools

Syndication: