Why is data organised in star schema in a data warehouse ?

CS Professional · Information Technology and Systems Audit · PYQS · June 2015
Why is data organised in star schema in a data warehouse ?

Answer & Explanation:

Star schema is the simplest style of data warehouse schema. In a data warehouse, data is organized in a star schema for several reasons: Ease of Understanding and Navigation: It allows users to quickly understand, navigate, and analyze large multidimensional data sets. Referential Integrity: Star schema is designed to enforce referential integrity of loaded data. Structure: It consists of a few "fact tables" (possibly only one, justifying the name) referencing any number of "dimension tables". Efficient Navigation: Navigating through data is efficient because dimensions are joined through fact tables, simplifying queries and improving performance.

Topics: Data Warehousing

Open in Interactive Practice Hub · Full Practice Hub · Chapter Weightage · More in this subject

Related Questions in this Topic