What is Data Modeling?
The interpretation and documentation of the current processes and transactions that exist during the software design and development is known as data modeling. The data modeling techniques and tools simplify the complicated system designs into easier data flows which can be used for re-engineering. It is used to create the logical and physical design of a data warehouse.
What is the need for Data Modeling in a Data warehouse
Collecting the Business Requirements
Typically, a data warehouse is designed with the data architects and the business users determining the entities required in the data warehouse and the facts that need to be recorded. This initial design has much iteration before deciding the final model
At this stage, we need to overcome the common drawbacks faced when designing. Since a data warehouse is implemented from an existing system the architects at times implement a larger part of the older system into the new design to save time or leave out details
The logical model captures the business requirements efficiently and serves as a building block for the physical model
