Need Database

Question

I am studying about cube and i am wonder, is there any databases out there that i can use to study cube?

thanks :)

Answer 1

You can download Oracle from the Oracle site: http://www.oracle.com/technology/software/index.html

(Free to download, free to learn, unlimited evaluation)

edit1 OLAP cubes: http://www.oracle.com/technology/products/bi/olap/index.html group by cubes and rollup: http://www.psoug.org/reference/rollup.html

Answer 2

Microsoft's AdventureWorks Database helps alot if you're using SQL Server. You can find it here: Samples

Answer 3

Cubes and dimensional modeling use relational databases. It's just a particular technique for creating schemas that make reporting and drill down easier.

You can get packages that include tools to make the creation of cubes easier, but at their bottom they're using a relational database.

If you want to learn more about dimensional modeling you can't go wrong reading Ralph Kimball.

Any relational database will do: MySQL, PostgreSQL, SQLLite, Oracle, SQL Server - pick one.