'Sum amt' diaporamas de présentation

Data Warehousing and OLAP

Data Warehousing and OLAP. Warehousing. Growing industry: $8 billion in 1998 Range from desktop to huge: Walmart: 900-CPU, 2,700 disk, 23TB Teradata system Lots of buzzwords, hype slice & dice, rollup, MOLAP, pivot,. Outline. What is a data warehouse? Why a warehouse? Models & operations

798 views • 58 slides

Modelo Multidimensional

1.27k views • 35 slides

Modelo Multidimensional

1.15k views • 35 slides

Question 1.

Question 1. Name is the unique candidate key in the table STUDENT. Each row in the table describes a different student. A student may only have two majors and one minor. To each major corresponds a unique minor. Question 1a

233 views • 18 slides

Lecture 10: More OLAP - Dimensional modeling

Lecture 10: More OLAP - Dimensional modeling. www.cl.cam.ac.uk/Teaching/current/Databases/. Conceptual Modeling of Data Warehouses. Modeling data warehouses: dimensions & measures Star schema : A fact table in the middle connected to a set of dimension tables

362 views • 18 slides