Your organization has decided to build a data warehouse. You have defined the
business requirements and agreed upon the scope of your application, and created a
conceptual design. Now you need to translate your requirements into a system
deliverable. To do so, you create the logical and physical design for the data
warehouse. You then define:
■ The specific data content
■ Relationships within and between groups of data
■ The system environment supporting your data warehouse
■ The data transformations required
■ The frequency with which data is refreshed
The logical design is more conceptual and abstract than the physical design. In the
logical design, you look at the logical relationships among the objects. In the physical design, you look at the most effective way of storing and retrieving the objects as well as handling them from a transportation and backup/recovery perspective.
Orient your design toward the needs of the end users. End users typically want to
perform analysis and look at aggregated data, rather than at individual transactions.
However, end users might not know what they need until they see it. In addition, a
well-planned design allows for growth and changes as the needs of users change and
evolve.By beginning with the logical design, you focus on the information requirements and save the implementation details for later.
Big Data Analytics
Logical Versus Physical Design in Data Warehouses
2:24 AM
divjeev
