csci403
play

CSCI403 Lecture 34: Data Warehousing (and other buzzwords) OLTP - PowerPoint PPT Presentation

Oct 31, 2023 •193 likes •381 views

CSCI403 Lecture 34: Data Warehousing (and other buzzwords) OLTP OLAP Reporting BI & KD ERP DSS DATA MINING ETL ELT (Yes, really.) DTS Data Warehouse DATA CUBE STAR SCHEMA SNOWFLAKE SCHEMA Homework Read

  1. CSCI403 Lecture 34: Data Warehousing (and other buzzwords)

  2. OLTP

  3. OLAP

  4. Reporting

  5. BI & KD

  6. ERP

  7. DSS

  8. DATA MINING

  9. ETL

  10. ELT (Yes, really.)

  11. DTS

  12. Data Warehouse

  13. DATA CUBE

  14. STAR SCHEMA

  16. SNOWFLAKE SCHEMA

  18. Homework • Read http://tinyurl.com/5lks76 • Buzzwords: • http://www.dqnow.com/buzzwords.html • Books: • Building the Data Warehouse (Inmon) • Data Warehouse Toolkit (Kimball)

More recommend