Help Center> DataArts Studio> FAQs> DataArts Architecture> What Is the Difference Between ER Modeling and Dimensional Modeling?
Updated on 2022-08-03 GMT+08:00

What Is the Difference Between ER Modeling and Dimensional Modeling?

  • ER modeling is transactional and complies with 3NF modeling.
  • Dimensional modeling mainly refers to the design of fact tables and dimension tables. Dimensional modeling is mainly used to implement multi-angle and multi-layer data query and analysis.

DataArts Studio is a data lake operations platform. Dimensional modeling is used more frequent.

DataArts Architecture FAQs

more