=======Study Group On Business Intelligence, Fall 2012=======
[[http://daisylunch.cs.aau.dk/doku.php?id=index|Back to the Daisy lunch main page]]

**Time:** Fridays 12-14 on November 2, 9, 16, 30 and December 7 and 14

**Place:** 0.2.11 

**Schedule:**

^ Date ^ Topic ^Speaker ^ Readings ^ Attendants ^
| Nov 2 | Multidimensional Databases and Data Warehousing | Torben Bach Pedersen | Synthesis Lecture (SL) [[http://www.morganclaypool.com/doi/abs/10.2200/S00299ED1V01Y201009DTM009|Multidimensional Databases and Data Warehousing]], Ch. 1 and 2. Can be downloaded for free from the AAU network. Physical copies can be BORROWED from Christian Thomsen, SLV300, room 3.2.33. [[http://people.cs.aau.dk/~tbp/teaching_files/TBP_Nov2.pdf|Slides]] | Asif, Manolis. Dalia, Gissel, Jinling, Benjamin, Tanvir (1 hour), Sari (1 hour) | 
| Nov 9 | Complex Multidimensional Data | Torben Bach Pedersen and Gissel | SL Ch. 3 + Pedersen, Jensen, Dyreson: [[http://www.cise.ufl.edu/~mschneid/Research/thesis_papers/PJD01IS.pdf|A Foundation for Capturing and Querying Complex Multidimensional Data]]. [[http://people.cs.aau.dk/~tbp/teaching_files/TBP_Nov9.pdf|TBP slides]] [[http://people.cs.aau.dk/~tbp/teaching_files/Velardes.pdf|Gissel slides]] | Gissel, Asif, Sari, Tanvir, Jinling, Manolis | 
| Nov 23 | Extract-Transform-Load (ETL) | Torben Bach Pedersen and Sari | SL Ch. 4.6, Ch. 9 and 10 in Kimball, Ross, Thornwaite, Mundy, Becker: Online access via AUB:[[http://primo.aub.aau.dk/primo_library/libweb/action/dlDisplay.do?vid=desktop&afterPDS=true&institution=AUB&docId=dedupmrg26562001|Data Warehouse Lifecycle Toolkit (2nd Edition)]] + Thomsen, Pedersen: [[http://dbtr.cs.aau.dk/DBPublications/DBTR-25.pdf|pygrametl: a powerful programming framework for extract-transform-load programmers]] [[http://people.cs.aau.dk/~tbp/teaching_files/TBP_Nov23.pdf|TBP slides]] [[http://vixra.org/abs/1211.0136|Sari slides]]| Asif, Benjamin, Dalia, Gissel, Jinling, Manolis, Sari, Tanvir  | 
| Nov 30 | (Pre-)Aggregation in Multidimensional Databases | Asif + Manolis | SL Ch. 4.1, Harinarayan, Rajaramn, Ullman: [[http://people.cs.aau.dk/~simas/dat5_08/papers/P205.pdf|Implementing Data Cubes Efficiently]] + Xin, Han, Li, Shao, Wah: [[http://www.cs.uiuc.edu/~hanj/pdf/tkde07_dongxin.pdf|Computing Iceberg Cubes by Top-Down and Bottom-Up Integration: The StarCubing Approach]] [[http://people.cs.aau.dk/~tbp/teaching_files/Asif.pdf|Asif slides]] [[http://people.cs.aau.dk/~tbp/teaching_files/Manolis.pdf|Manolis slides]]| Asif, Jinling, Benjamin, Manolis, Sari, Tanvir, Dalia, Gissel (until 13.30)| 
| Dec 7 | Bitmap indices and near-realtime DWs | Jinling + Dalia| SL4.2,4.3 and Deliège, Pedersen: [[http://www.icdt.tu-dortmund.de/proceedings/edbticdt2010proc/edbt/papers/p0228-Deliege.pdf|Position list word aligned hybrid: optimizing space and performance for compressed bitmaps]] + SL Ch. 5 and Thomsen, Pedersen, Lehner: [[http://people.cs.aau.dk/~tbp/articles/PID525407.pdf|RiTE: Providing On-Demand Data for Right-Time Data Warehousing]] [[http://daisylunch.cs.aau.dk/lib/exe/fetch.php?media=rite.pptx|Dalia slides]] [[http://people.cs.aau.dk/~tbp/teaching_files/jinling.pdf|Jinling slides]] | Jinling, Benjamin, Dalia, Manolis, Asif, Sari| 
| Dec 14 | Cause-Effect Data Mining | Tanvir + Benjamin | Pei, Han, Mortazavi-Asl, Wang, Pinto, Chen, Dayal, Hsu: [[http://www.cs.uiuc.edu/~hanj/pdf/tkde04_spgjn.pdf|Mining Sequential Patterns by Pattern-Growth: The PrefixSpan Approach]] + Middelfart, Pedersen, Krogsgaard: [[http://people.cs.aau.dk/~tbp/articles/Bitmap_Sentinels.pdf|Efficient Sentinel Mining Using Bitmaps on Modern Processors]] [[http://people.cs.aau.dk/~tbp/teaching_files/Tanvir.pdf|Tanvir slides]] [[http://people.cs.aau.dk/~tbp/teaching_files/benjamin.pdf|Benjamin slides]]|  Tanvir, Manolis, Benjamin, Dalia, Gissel, Jinling, Sari | 

All/most links are only accessible from the AAU network.