[Business Intelligence] OLAP, OLTP, DW, ETL

(1) Date Warehouse

collect subject-oriented, integrated... data

(2) Date Mart

a subset of DW
just store the relevant data

---

(3) OLAP

online analytic processing

3 operations:
   drill-down, slicing/dicing, roll-up


Use 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