Geek asks and answers

Asterisk pattern dataset example

I am looking for some OLAP data, preferably in a star scheme (or snowflakes) to test a new tool. I already have a Foodmart database that Mondrian provides. A data type is not important if it has dimensions and related facts. The larger the size, the better for load testing. Does anyone know where I can download such a dataset, ideally, in SQL or CSV? (other formats are good too)

+3
source share
2 answers

Apologies for the fact that MS SQL is focused, but Adventure Works DWH is not bad in terms of snowflake schema design. Not too much data. With some clever SQL, you could generate extra rows in the database.

Alternatively try Project Real - the larger DWH project that MS put together in 2005

+2
source

This article provides a fairly clear description of the stellar scheme: IBM red brick repository (nee Informix)

0
source

More articles:


All Articles