Answer to Question #211897 in Databases | SQL | Oracle | MS Access for Ali

Question

Explain in detail the concept of modeling the Business Data Warehousing 

(BDW)?

Answer 1

Modeling involves creation of data models for the data in the warehouse. The model is
a conceptual representation of Data objects, 
the associations between different data objects, and the rules. 
It helps in the visual representation of data and enforces 
business rules, regulatory compliances, and government policies on the data.
Data Models ensure consistency in naming conventions, 
default values, semantics, security while ensuring quality of the data.