Handling the success application of technique at business enterprise along with the data, business enterprise backlogs a large quantity of production, scientific research and the business data. For the sake of the problem that policy-makers in business enterprises meet when facing extensive data that are hard to get the solution information in time, many business enterprises have already set up the data warehouse, and policy- makers obtain the useful information from the data warehouse by OLAP. This paper introduces the concept of data warehouse, concept of OLAP, analyzes and elaborates the three data storage schema and shows the effect of the OLAP on the data warehouse application. It focuses on the research of OLAP based on RDB, including the features of the ROLAP, and how to use the ROLAP to show the quality of multi-dimension, then Discuss the snowflake schema and star schema.
【CateGory Index】： TP311.13