Determining which subjects will be created and populated in the data warehouse is called subject definition. A subject is a logical concept; for example, an organizationís customers, including their names, addresses, etc. From this business logic, a logical data model is developed. Next, the logical model is translated into a physical data model that defines the actual data storage architecture for the data warehouse. Physical models can be based on several design constructs, such
showed first 75 words of 271 total
showed last 75 words of 271 total
the technical aspects of data access, making information resources access-friendly. Ideally, end users access data from the data warehouse without knowing where the data reside, the format, or any other physical attributes.
The business benefits derived from implementing a data warehouse are tremendous. Data warehousing offers organizations an opportunity to reinvent the tools used for decision making by making the tremendous amounts of data collected by business yield copious amounts of useful information about customers.