This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
teaching:dw2013-w3 [2013/10/02 09:26] tcalders [Exercises] |
teaching:dw2013-w3 [2013/10/02 12:56] tcalders [Slides] |
||
---|---|---|---|
Line 14: | Line 14: | ||
* [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/DW02a-ER-Solution.pdf|Solution ER-modeling exercise W1]] | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/DW02a-ER-Solution.pdf|Solution ER-modeling exercise W1]] | ||
* [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/DW02b-Cubes.pdf|Slides lecture]] | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/DW02b-Cubes.pdf|Slides lecture]] | ||
+ | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/explosion.pdf|A note on the database explosion problem]] | ||
===== Exercises ===== | ===== Exercises ===== | ||
* [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/session2.pdf|Exercises]] | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/session2.pdf|Exercises]] | ||
Line 20: | Line 20: | ||
\\ \\ | \\ \\ | ||
For those who wish to explore cube browsing, connect to SSAS (Analysis services); use for instance the "AdventureWorks" database. This database is available on the server. | For those who wish to explore cube browsing, connect to SSAS (Analysis services); use for instance the "AdventureWorks" database. This database is available on the server. | ||
+ | * [[http://technet.microsoft.com/en-us/library/ms124623(v=sql.100).aspx|Description of the database]] | ||
{{:teaching:browsecube.png?600|}} | {{:teaching:browsecube.png?600|}} | ||
* [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/Install_AdventureWorksDW.pdf|Note on installing this database on your own system]] | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/Install_AdventureWorksDW.pdf|Note on installing this database on your own system]] |