CODEWITHSUNDEEP
data-warehouse
Nikhil
Nikhil

Reputation: 2318

Dimensional model or Relational model for data warehouse?

I have a pretty trivial questions in data warehouse,

I know we use Dimensional data model to construct data marts and use Relational data model in staging area.

What data model technique we use to store data in central data warehouse? Can we use both? Which is most commonly used? We have RDBMS for relational database model, what is the database used for dimensional modelling?

Upvotes: 0

Views: 3356

Answers (1)

Gilbert Le Blanc
Gilbert Le Blanc

Reputation: 51445

What data model technique [do] we use to store data in central data warehouse?

The Dimensional data model. The reason for having a data mart or a data warehouse is to answer time and other dimensional related queries.

We have RDBMS for [the] relational database model, what is the database used for dimensional modelling?

For small data marts (< 1 million rows), a relational database works for dimensional models. Dimensions have a relationship with the fact tables (packages, SKUs, etc.)

For large data warehouses (> 10 billion rows), you'll get better performance if you use a database designed for online analytical processing. In the 1990's, I managed a DB2 data warehouse that added 2 million fact table rows per day, and it worked well enough.

For medium size data warehouses, it's your choice.

Upvotes: 1

Related Questions