During the planning process of a data warehouse and BI solution, what elements will determine the choice of these 2 approaches:
The size of the data warehouse is under 100 Gig.
Douglas Hackney's Answer: The primary decision point between RDBMS data storage and MOLAP engines such as Express or Essbase are write-back requirements in applications such as budgeting and forecasting. RDBMS structures are not suitable for this requirement. Another major factor is response time. The precalculated nature of the MOLAP data sets lends itself to very quick response. RDBMS ROLAP approaches suffer from long response times.
Your 100 gig estimate doesn't mean much because the size of the multidimensional data structures used in these systems will be affected by their capability to compress the data and their approach to handling data scarcity inherent in MOLAP data structures.
Sid Adelman's Answer: The most important element is the user's requirements. What will they be doing? What questions will they ask? What analysis will they be doing? What kind of comparisons are they doing? Are the nature of the queries multidimensional? What data do they need? What form do they want it? Will the data they want need to be summarized?
Register or login for access to this item and much more
All Information Management content is archived after seven days.
Community members receive:
- All recent and archived articles
- Conference offers and updates
- A full menu of enewsletter options
- Web seminars, white papers, ebooks
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access