复旦商务智能概论--3在线分析处理-(精品课件).ppt

MOLAP与ROLAP HOLAP的特点 以HOLAP格式存储的立方体，要比以OLAP格式存储的立方体小，在查询总结数据时，又比ROLAP快。 HOLAP存储格式一般比较适合于需要总结数据的查询有较快的响应时间，同时基数据的量又比较大的场合。 推荐资料（IBM红皮书） DB2 OLAP Server IBM BI certification guide 谢谢！ * * Before managers can make crucial business decisions, the raw data that is keyed into a database must undergo a transformation. Many companies use online transaction processing (OLTP) systems to handle the input and storage of data. Once collected, data typically goes through a reporting process where queries are written, data is sorted and lookups are performed in a data warehouse. Once the reporting process is finished, data is analyzed and becomes useful information for decision-making. * What is OLAP? – On-line Analytical Processing (OLAP) is a method by which managers and executives are able to gain access to data. This access is fast, consistent and interactive, allowing a wide variety of possible perspectives. OLAP transforms raw data into precise, accurate and timely information, usable by the entire enterprise.” /olapterms.cfm –Multidimensional logical view of data –Independent of how the data is stored?? Multidimensional data analysis –Slice and dice, drill-down, roll-up, pivoting –Powerful data transformation engine?? Statistics along several dimensions?? Support for forecasting, trend analysis, statistical analysis?? Powerful information presentation –2D/3D, charts, graphs?? OLAP usually involves a multidimensional data store (MDDB) * “On-line Analytical Processing (OLAP) is a method by which managers and executives are able to gain access to data. This access is fast, consistent and interactive, allowing a wide variety of possible perspectives. OLAP transforms raw data into precise, accurate and timely information, usable by the entire enterprise.” /olapterms.cfm * If you are building an OLAP application and the source data is from a Data Warehouse, a Relational Data Mart or an ODS, probably there is no need to apply complex transformations on the source da