Is this usage of SQL Server a datawarehouse? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Is this usage of SQL Server a datawarehouse?

Hello
I am new with analysis service and datawarehousing, therefore I have this basic question.
I once saw the following practice and I would like to ask if this is a very simplistic "data warehouse" or in fact is just a "regular" database:
A company consolidates sales data into a single SQL Server 2000 database. A web reporting software is used to query the data.
One must have Analysis Service running to in fact say that you have a data warehouse?
Thanks a lot.

Hi,
In my experience (and opinion) a datawarehouse is defined by design, and not necessarily by the existence of cubes. By this I mean that if you have a database designed through dimensional modelling you have a datawarehouse.
Datawarehouses are used for reporting through cubes (and cube reports) and normal reports (querying the database directly). The true value of the warehouse will only realise when you start doing analysis through cubes, but alot of times people don’t do that as the first step.
Hope this answers your question. [:)]

OLAP is different and normal SQL Server is different.
As per your explanation I believe this is not a data warehouse, to accomplish this purpose, Analysis Services creates multidimensional cubes from data in the data warehouse fact and dimension tables. Numerical measures are also summarized into preaggregated values during cube construction. Cubes are stored in multidimensional structures that are designed for rapid query response, combining preaggregated information with raw fact data to respond to a wide variety of queries.
Do you see any of such of database/cubes within the enterprise manager?

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |