SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

Business Intelligence - how to determine the configuration settings for a data mart or warehouse project - notes from field

published 767 days, 16 hours, 26 minutes ago posted by

sa 777 days, 4 hours, 33 minutes ago

Business Intelligence - how to determine the configuration settings for a data mart or warehouse project - notes from field

Fast query response times and timely data refresh are two well-established performance requirements of Online Analytical Processing (OLAP) systems and to provide fast analysis, OLAP systems traditionally use hierarchies to efficiently organize and summarize data. The content of data warehouse (OLAP) database changes infrequently compared to that of transactional database (OLTP). By default the architecture and charter of data warehouse, the storage requirements increase over time and frequently reach...(read more)

category: News | clicked: 3 | | source: sqlserver-qa.net | show counter code

tags: Best Practices, business intelligence, i/o, Memory, olap, readonly, Security, settings, SQL Server

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

Business Intelligence - how to determine the configuration settings for a data mart or warehouse project - notes from field

1 comment posted.

Open ID Login

Standard Login

Forgot Password?

Sign up