The data warehouse is there to be accessed by users. The whole purpose of building the data warehouse is to give an identified set of users access to a particular set of data.
数据挖掘交友
The whole area of access to the data is a minefield. There are a host of tools that can be used, each with its own advantages and disadvantages. There is a battle raging in the industry over relational versus multidimensional tools. New terms such as OLAP, MOLAP and ROLAP are being bandied around. This makes the choice of tools an interesting challenge if not an impossible task. The aim of this appendix is to aid you with this task by discussing all of the major issues.
数据挖掘论坛
数据挖掘论坛
Some Tips on Data Access Tool
There are a couple of golden rules relating to tools that need to be adhered to when designing the data warehouse: 数据挖掘实验室
1 Never design the data warehouse to suit a specific tool.
2 Make no assumptions about the type of tool that will be used. 数据挖掘实验室
Rule 1 is the cardinal rule. Never make the mistake of designing the data warehouse around a particular tool. Even if a specific tool has been chosen as a company standard, there is no guarantee that some users with specific needs may not use different tools, or that the standard will not change. The tools marketplace is constantly changing, and any choices made today may be invalid in a few months’ time.
Remember that the data warehouse will evolve over time; new users added later may have different requirements, and different tools. It is an extremely costly and painful task to reorganize a data warehouse after the fact.
数据挖掘交友
Unfortunately, designing the data
