CODEWITHSUNDEEP
sql-serverssascubesolap-cube
Emiliano Poggi
Emiliano Poggi

Reputation: 24826

Is a single table a bad starting point for OLAP cubes (SQL Server Analysis Services)?

I'm going to use a single table to aggregate historical data about our (very big) virtual infrastructure. The table will be composed of 15 to 30 fields, and I esitmate from 500 to 1000 records a day.

Why a single table? A couple of reasons:

Now my question:

If I'm planning in the future to build cubes upon this table is the "single-table" choice a bad solution? Do cubes rely on relational databases or they can be easily built upon single-table databases?

Thanks for any suggestion

Upvotes: 0

Views: 899

Answers (1)

MicSim
MicSim

Reputation: 26796

Can't tell you specifically about SQL Server Analysis Services, but for OLAP you typically use denormalized and aggregated data. That means fewer tables than in a normal relational scenario. And as your data volume is not really big (365k rows/year - even small for OLAP), I don't see any problem using a single table for your data.

Upvotes: 2

Related Questions