Chapter 2. Multidimensional Clustering Tables
When analysts ask questions about their business, they are typically along the lines of dimensions: “What were my sales in the east region in the year 2000? What were the sales of blue widgets in Mexico in the fourth quarter of year 2001?”
A challenge facing today's relational database vendors is that their technologies only support ordered data storage and access of data across a single interest (or dimension). The alternative is to investigate Multidimensional OnLine Analytical Processing (MOLAP) engines. MOLAP offers proprietary vendor storage engines designed for multidimensional analysis. However, MOLAP comes at a cost of proprietary access application programming interfaces (APIs), a proprietary ...
Get DB2® Version 8: The Official Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
