[Business Intelligence] OLAP, OLTP, DW, ETL

(1) Date Warehouse

collect subject-oriented, integrated... data

(2) Date Mart

a subset of DWjust store the relevant data

---

(3) OLAP

online analytic processing3 operations:   drill-down, slicing/dicing, roll-upUse a category of software technology -> analyze data -> transfrom into info. and knowledge -> reflect the reality

---

(4) OLTP

 online transaction processing data entry and retrieve data in the DB

(5) OLTP vs OLAP

---

(6) ETL

  extract, transform, load  extract(read) data from the DB  transfrom(convert) data into the form what we need  load(put) data in the DW