This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
teaching:dw2013-w3 [2013/10/02 09:26] tcalders [Exercises] |
teaching:dw2013-w3 [2013/10/03 10:55] tcalders [Exercises] |
||
|---|---|---|---|
| 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]] - [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/solutions/solutions2.pdf|Solutions]] |
| For the exercises, please consider using SQL-Server to try out the queries and study sparsity. | For the exercises, please consider using SQL-Server to try out the queries and study sparsity. | ||
| \\ \\ | \\ \\ | ||
| 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]] | ||