上海交大数据仓库教程.ppt

* The star schema is recommended while developing the logical data model, and then converting or transforming it to whatever physical structure will be used for the implementation of the model. A normalized snowflake schema is very similar to the entity relationship model. * Notice that each of the dimension entities has a unique identifier and these identifier attributes are also in the fact entity. This is the connector that supports the relationships between each dimension entity and the fact entity. * The logical model is translated into an initial physical model for the database management system to be used for implementation. For example, in a relational implementation, each entity in the model is identified as a table in the relational database. * Granularity-The lowest level of detail for the measures in a fact; the combination of the lowest level of detail in each dimension of the fact. * Dimension-A collection of business data which is related to and gives meaning or relevance to the measure. Fact-A collection of measures and the unique identifiers of their related dimensions. Measure- A numerically valued quantifier of a business activity or item. * Aggregation level - A set of attributes that qualify a desired summarization of measure values like sum of sales revenue by city and customer for the last 6 months. * Dimension Hierarchy- The structure of a dimension containing base or grain attributes and higher level groupings of attributes such as a store within a city within a state, and so forth. * A data mart is not just a small data warehouse. A collection of data marts is not a data warehouse. A data warehouse is not a Decision Support System A data mart is an implementation of a data warehouse with restricted scope of content and support for analytical processing, serving a single department of an organization or a particular data analysis problem domain. A data mart might be larger than a given data warehouse in terms of amount of