Research And Implementation Of Visual Analysis Tool Of OLAP Based On Web

With data base technology extensive use, enterprise information system has produced large amount of data, Important difficult problem been confronted with by the handling crew how to extract information useful for enterprise decision analysis from these great capacity for liquor in the data becoming the enterprise decision-making. The data storehouse (Data Warehouse) technology is to develop under such background. Data storehouse concept was brought forward 1980's medium term, 1990's, the data storehouse already march from the morning exploration stage to pragmatic stage. Apply including that on-line analyses inclusive lot handling (On-Line Analytical Processing, being called OLAP for short) has driven the data storehouse technology's appearing and developing, and the data storehouse technology has promoted development of OLAP technology conversely. the concept of On-line analyses is brought forward by E.F.Codd on 1993. The OLAP target is to satisfy the support making policy or specially appointed inquiry of many dimensions environment and the form for report need, its technology core is the concept of "preserve" , OLAP also so to speak is many dimensions data analysis implement aggregation therefore. As one of OLAP implement SQL SERVER 2000 has provided OLAP resolving scheme OLAP Servers, at the same time, has increased the function that the data excavates, and has called them Analysis Services. Analysis Services has provided a client implement. That has a lot of inconvenience. The first is its operating platform has a harsh demand. Secondly it requires a direct connection of data source server .This is a problem for agencies using a firewall. Also there are other issues, such as installing the necessary controls. To these problems, analysis has been carried out, and solving scheme self has been brought forward. That scheme supports functions such as many dimensions datapicture and many dimensions data sheet operation.