The Benefits of MultiDimensional Modelling （多维模型的好处）.pdf

Benefits of a Multi-Dimensional Model An Oracle White Paper May 2006 Benefits of a Multi-Dimensional Model Executive Overview 3 Introduction 4 Multidimensional structures 5 Overview 5 Modeling the Business 5 Dimensions 13 Levels 13 Hierarchies 14 Dimensional Queries Conditions 17 Multi-Dimensional Queries 19 Validating Queries 19 Cubes 8 Measures 8 Joins 9 Cube based Calculations 11 Conclusion 22 The Benefits of a Multi-Dimensional Model Page 2 Benefits of a Multi-Dimensional Model EXECUTIVE OVERVIEW The challenge facing every organization today is the sheer quantity of data being captured, at monthly, week, daily and hourly levels. With advancement of technology, the issue of how to store this ever-growing volume of data becomes less of a concern than simply how to effectively analyze it. Every organization knows they have the data to allow their users to generate competitive advantages, if only they could access it in the correct manner and format. The ability to understand the buying patterns within a customer base can make a huge difference to the corporate bottom line. However, for many users the ability to create situations that generate competitive advantages are constrained by the complexity of the underlying data model. Users cannot, and do not wish, to understand these complexities. Many tools and products fail to protect users from the most difficult concepts such as table joins and sequencing. These complexities discourage users from exploring and analyzing their underlying schema and at worst, create queries that while syntactically correct return factually incorrect results. One solution to this issue is to encapsulate a relational schema within business definitions and the