CODEWITHSUNDEEP
databaseetldata-warehouseolap
Giovanni Mosquera
Giovanni Mosquera

Reputation: 126

OLAP vs OLTP Schema explanation

After reading a lot of resources about the differences and the key points, I still have a confusion of the two models and I've created two databases with defined tables and relationships

The one supposed to be OLTP: OLTP Schema Here is stored each sale

The one supposed to be an OLAP: OLAP Schema My questions about this one are:

  1. Aren't the OLAP databases supposed to be "Unnormalized"? There I'm still watching the same relationships than the OLTP model
  2. Is the model correct? I mean... in the fact I'll store the total sales day by day per product (aggregated data)

Upvotes: 1

Views: 82

Answers (0)

Related Questions