Walmart -- 24 Terabytes Geographic Information Systems National Medical Records Weather images Intelligence Agency Videos
Tourists: Browse information harvested by farmers Farmers: Harvest information from known access paths Explorers: Seek out the unknown and previously unsuspected rewards hiding in the detailed data
Data Industry Usage Technology Volumes
Application-Orientation Loans Credit Card Subject-Orientation Customer Vendor Trust Savings Product Activity
Savings Loans Trust Credit card
field unit encoding
Frequently accessed Rarely accessed Smaller table and so less I/O
Information Less History Normalized Detailed More Data
OLAP Data Mart Lightly summarized Departmentally structured Organizationally structured Atomic Detailed Data Warehouse Data
Data Sources Data Marts Data Warehouse
If you end up creating multiple warehouses, integrating them is a problem
Data Sources Data Warehouse Data Marts
Region = W Rating = M
AND
Juice Cola Milk Crea m
The Telecomm Slice
Drill-Down Roll Up Higher Level of Aggregation Low-level Details
marketing sales finance manufacturing
Store atomic data in industry standard RDBMS. Generate SQL execution plans in the ROLAP engine to obtain OLAP functionality. Obtain multidimensional reports from the DSS Client.
Store atomic data in a proprietary data structure (MDDB), pre-calculate as many outcomes as possible, obtain OLAP functionality via proprietary algorithms running against this data. Obtain multidimensional reports from the DSS Client.
Скачать презентацию Walmart — 24 Terabytes Geographic Information Systems National
45ca2209417f1e119dcf74833e25672e.ppt