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

▶
csci403
SMART_READER_LITE
LIVE PREVIEW

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

Oct 31, 2023 193 likes •385 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

slide-1
SLIDE 1

CSCI403

Lecture 34: Data Warehousing (and other buzzwords)

slide-2
SLIDE 2

OLTP

slide-3
SLIDE 3

OLAP

slide-4
SLIDE 4

Reporting

slide-5
SLIDE 5

BI & KD

slide-6
SLIDE 6

ERP

slide-7
SLIDE 7

DSS

slide-8
SLIDE 8

DATA MINING

slide-9
SLIDE 9

ETL

slide-10
SLIDE 10

ELT

(Yes, really.)

slide-11
SLIDE 11

DTS

slide-12
SLIDE 12

Data Warehouse

slide-13
SLIDE 13

DATA CUBE

slide-14
SLIDE 14

STAR SCHEMA

slide-15
SLIDE 15
slide-16
SLIDE 16

SNOWFLAKE SCHEMA

slide-17
SLIDE 17
slide-18
SLIDE 18

Homework

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