2016基础概念培训.pptVIP

了解数据仓库 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 数据仓库 终端用户 数据集市 OLAP 数据仓库 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 维度表 维度是分析中描述性的分类，通过它可以将度量值分离出来进行分析。 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 主键 主键 唯一性 关联事实表与维度表 两个选择 应用主键 (app suffix) ：原业务系统的主键 代理键 (key suffix) 数据仓库系统产生的数字键 product_id_app product_dim_key Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 在维度中分不同的层次 定义层次结构的好处 允许用户从不同的层次展示数据 在分析中采用不同的路径进行钻取 举例：日期 分为，年－半年－季度－月－日期 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 星型模型 Employee_Dim EmployeeKey EmployeeID ... Time_Dim TimeKey TheDate ... Product_Dim ProductKey ProductID ... Customer_Dim CustomerKey CustomerID ... Shipper_Dim ShipperKey ShipperID ... Sales_Fact TimeKey EmployeeKey ProductKey CustomerKey ShipperKey Sales Amount Unit Sales ... Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 雪花模型 在多维表中定义层次 节省存储空间 存取效率较低 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 事实表的组成 维度表 customer_dim 201 ALFI Alfreds product_dim 25 123 Chai 事实表 customer_key product_key time_key quantity_sales amount_sales 外键 201 25 134 400 10,789 事实表中的粒度就是维度表与事实表中相关联的最小级别的数据 134 1/1/2000 time_dim 度量值 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 事实表 库存数, 入库数，出库数 产品的销售数量, 成本,销售额，订单数 度量值：业务数据 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 外键 time_dim_key product_dim_key customer_dim_key product_key customer_key order_date_key 外键约束