Adv. DBMS Data Warehouse CSC5301. Review Hachim Haddouti. Do You Remember?. DSS. Data cube. MD. OLTP. RollUp. drill down. Slice/dice. MD. ROLAP. Star schema. MOLAP. Data mining. Data extraction. Fact table. Data Warehouses.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Adv. DBMSData WarehouseCSC5301
Mining of mobile phone calls:
(Caller, Callee, Time, Duration, Geogr. Location) ~ 100 B/tuple
107 users * 10 calls/(day*user) * 100 B/call =
= 1010 B/day ~ 3*1012 B/year = 3 TB/year
Scanning data at 107 B/s takes
3*1012/107 = 3*105 s > 3 days
Data Warehouse Architecture
a disaster for querying a huge amount of data (time)
not understandable for users and they can not be navigated usefully by DBMS software.
hard to visualize; many possible connections between tables,
To avoid redundancy
Better data organisation
Business queries (why, what if)
Typical DWH Analyses/Queries
Data Cube Representation
Not possible with classical DB-technology alone
Solution 1: ROLAP relational online analytical processing, built on top of relational DBS, additional middleware or client front end (star schema)
Solution 2: MOLAP: multidimensional online analytical processing