How to choose the right tool in the data warehouse project, allowing engineering technicians and business managers to face difficulties, in choosing an OLAP tool, generally should generally be from the function, applicability, performance, telescopic and future development trends 5 Comprehensive consideration. Overall, these five important importance is difficult to divide, but should pay attention to the following points:
● Although functions are the most eye-catching and most obvious aspects, because of the faster development update, a version of the product is often short-term;
● In the practice of data warehouse project, customer needs are often unstable, and will change with the progress of the project, therefore, the ability of the product is very important;
● Performance needs to be subject to the subjective requirements of the project. From this perspective, performance depends to a certain extent on input;
● From the long run, applicability, scalability, and future development trends are three very important factors;
● From functional aspect, if you want to select a multi-dimensional database product, you should pay attention to the limitations of the product on the number of dimensions, cross-might processing power, data summary calculation capabilities, and data read and write processing capabilities, etc. Database products, you should pay attention to the ability, multi-dimensional analysis capabilities of the multi-dimensional data view, limitations of data volume, and limitations of the number of concurrent access, and dimension exchange capabilities.
