It provides decisional information at an organizational level from integrated and aggregated data, and gives users an intuitive and manageable view of information. A Data Model creates a new repository that integrates data from various sources and then makes the data available for analysis and evaluation aimed at decision-making processes.
A data model should generally be used for analysis. For general analysis, a data model should be or is generally expected to be:
Homogenized
Integrated
Prepared
Detailed and aggregated
The logical design of a data warehouse is based on principles that are different from those used in operational databases as there are issues such as data redundancy and denormalization with relations. Denormalization is the process of integrating multiple small tables into one big table in which there are data redundancy issues, but it is deliberately designed for the data model since it speeds up the query performance. Normalization is the reverse...