Balancing of Business Data Model and Transactional Data Model
The business information oriented system and enterprise data both are equally essential and important for an organization. So, the equilibrium between the two must be maintained properly. Data warehouse is information oriented system used to convert business rules into useful information as it is useful in tactical and strategic business decisions it is defined for business data model. A relational database consists of a collection of tables contains enterprise data it is defined for transactional data model. The authors use ER Model in relational database to define enterprise data as objects or entities on the other hand in data warehouse they use dimensional cubes based on facts and dimensions.