{"action":"closed","issue":{"url":"https://api.github.com/repos/42mandychen/cs304/issues/1","repository_url":"https://api.github.com/repos/42mandychen/cs304","labels_url":"https://api.github.com/repos/42mandychen/cs304/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/42mandychen/cs304/issues/1/comments","events_url":"https://api.github.com/repos/42mandychen/cs304/issues/1/events","html_url":"https://github.com/42mandychen/cs304/issues/1","id":221731839,"number":1,"title":"Data Warehousing","user":{"login":"42mandychen","id":17522943,"avatar_url":"https://avatars1.githubusercontent.com/u/17522943?v=3","gravatar_id":"","url":"https://api.github.com/users/42mandychen","html_url":"https://github.com/42mandychen","followers_url":"https://api.github.com/users/42mandychen/followers","following_url":"https://api.github.com/users/42mandychen/following{/other_user}","gists_url":"https://api.github.com/users/42mandychen/gists{/gist_id}","starred_url":"https://api.github.com/users/42mandychen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/42mandychen/subscriptions","organizations_url":"https://api.github.com/users/42mandychen/orgs","repos_url":"https://api.github.com/users/42mandychen/repos","events_url":"https://api.github.com/users/42mandychen/events{/privacy}","received_events_url":"https://api.github.com/users/42mandychen/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-04-14T03:05:43Z","updated_at":"2017-04-15T00:46:02Z","closed_at":"2017-04-15T00:46:02Z","body":"- [x] Compare and contrast OLAP and OLTP processing (Lecture 16_DW(1).pdf, P27)\r\n- [x] ETL (Lecture 16_DW(1).pdf, P19)\r\n- [x] Star Schema (Lecture 16_DW(1).pdf, P36-40, exercise P41-42)\r\n- [x] Snowflake Schema (Lecture 16_DW(1).pdf, P46-48)\r\n- [x] Compare Star Schema and Snowflake Schema (Lecture 17- 18_DW(2 and 3).pdf, P2)\r\n- [x] ROLAP & MOLAP & HOLAP (Lecture 17- 18_DW(2 and 3).pdf, P5, P35-36)\r\n- [x] OLAP Operations (Lecture 17- 18_DW(2 and 3).pdf)\r\n  - [x] Roll-up/Drill-up (P16-19)\r\n  - [x] Drill-down/Roll-down (P20-22)\r\n  - [x] Slicing (P23-25)\r\n  - [x] Dicing (P26-27)\r\n  - [x] Pivoting (P28-29)\r\n- [x] View Materialization \r\n  - [x] Partial materialization: HRU Algorithm (Lecture 19_DW(4).pdf, P3-P20, exercise Revision.pdf P3-13)\r\n  - [x] Full materialization: Pipesort (only need to know [ideas](https://piazza.com/class/ix0usr0399p54o?cid=954), and pipeline generation)"}}
{"actor":{"display_login":"42mandychen"}}