【正文】
虑因素 (Source: Data Warehouse Institute February 96) MOLAP 还是 ROLAP? Client interface Metadata OLAP engine MDDB Data Warehouse Operational Data Data loading OLAP server SQL pass through OLAP engine OLAP server Data Warehouse Metadata Client interface MOLAP ROLAP Middletier server CLIENT Database server SQL ROLAP 和 MOLAP的功能区别 Legacy/Operational/External Systems Transaction Systems Decision Support Systems Knowledge Workers Strategic Tactical WhatIf Analysis Customized Applications Drill Pivot Analysis Forecasting Modeling TimeSeries Query Reporting MOLAP ROLAP MDB RDBMS Data Cache linkage 步骤 3:根据需要创建新的实体 Code_no No_of_transaction Constructor_ID Developer_ID Building date Purchase date Purchase price Address Area Apartment Code_no Transaction_no Name/Company HKID Contact Phone Contact Address Purchase Date Purchase Price Owner Code_no Flat Transaction_no Name HKID Occupy_type (P,R) Contact Phone Contact Address Date Price Occupant Contractor_ID Company Name Address Contact Phone Constructor Code_no Flat No_of_trans Type Floor Area (Building) Area (Actual) Flat Details Developer_ID Company Name Address Contact Phone Developer Day Month Quarter Year