Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Best practice to create a new database for Datamart Expand / Collapse
Posted Tuesday, April 02, 2013 8:02 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 8:00 AM
Points: 26, Visits: 22

Is there any guidelines for creating a database for OLAP system.
Post #1437904
Posted Wednesday, April 03, 2013 11:51 AM



Group: General Forum Members
Last Login: 2 days ago @ 9:25 AM
Points: 7,070, Visits: 12,523
Yes. Tons. Lookup dimensional modeling. Lookup the Kimball and Inmon methodologies. Lookup the BI Semantic Model for SQL 2012.

There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1438517
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse