A database system optimised for reporting, particularly in aggregate. Often, but not always implemented using a star schema.
0
votes
2answers
280 views
SQL Server 2012 Data Warehousing Overall Flow [closed]
I am studying Data Warehousing in SQL Server 2012
I am attempting to learn the various tools included by practicing on the different tools separately.
I have practiced with:
AdventureWorks ...
11
votes
2answers
1k views
Open Source Business Intelligence/DWH solutions
I wonder that this question hasn't already been asked. Google only has very few results for me that don't show a high quality tool
What are some Open Source (also free is ok) solutions for Data ...
6
votes
2answers
253 views
What is the name of this schema pattern
Its been a few years... but I've run into a problem-set that reminds me of a schema design pattern and I'm trying to recall the details.
Essentially, the pattern consists of one database which is 3 ...
6
votes
2answers
4k views
Sql Server 2012 data warehousing and different versions
With Sql Server 2012 there are 3 flagship editions: Enterprise Edition, Business Intelligence, Standard.
The full comparison between the three: ...
9
votes
4answers
565 views
Where should one put indexes in a time dimension table?
After reading the Questions and Answers from this website about indexes, a question came to my mind.
What if, one is using a time dimension table with the lower level of granularity being the day. ...
6
votes
1answer
105 views
Dimension and Fact for same entities?
I'm rather new at DW design and am working on a DW to model some IT infrastructure.
The major problem/question at this point is how to model drive information.
We will be collecting aggregate data ...
4
votes
3answers
676 views
How can I make my SSIS process consume more resources and run faster?
I have a daily ETL process in SSIS that builds my warehouse so we can provide day-over-day reports.
I have two servers - one for SSIS and the other for the SQL Server Database. The SSIS server ...
