Business Intelligence & Multi-Dimensional Databases. Nirmal Jonnalagedda. Outline. BI: History BI: Overview Common Functions of BI BI: What can you do with it? Multidimensional Databases Contrast MDD and Relational Databases When is MDD (In)appropriate? MDD Features Pros/Cons of MDD.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
A multidimensional database (MDDB) is a computer software system designed to allow for the efficient and convenient storage and retrieval of large volumes of data that are
These perspectives are called dimensions.
An automobile manufacturer wants to increase sale volumes by examining sales data collected throughout the organization. The evaluation would require viewing historical sales volume figures from multiple dimensions such as
The Relational Structure
Multidimensional Structure multidimensional database has matured into the database engine of choice for data analysis applications
Volume figure when car type = SEDAN, color=BLUE, & dealer=GLEASON?
First, consider situation 1
Now consider situation 2
1. Set up a MDD structure for situation 1, with LAST NAME
and Employee# as dimensions, and AGE as the measurement.
2. Set up a MDD structure for situation 2, with MODEL and
COLOR as dimensions, and SALES VOLUME as the measurement.
MDD Structures for the Situations
Note the sparseness in the second MDD representation
The greater the number of inherent interrelationships between the elements of a dataset, the more likely it is that a study of those interrelationships will yield business information of value to the company.
Examples of applications that are suited for multidimensional technology:
PRINT TOTAL.(SALES_VOLUME KEEP MODEL DEALERSHIP)
SELECT MODEL, DEALERSHIP, SUM(SALES_VOLUME)
GROUP BY MODEL, DEALERSHIP
ORDER BY MODEL, DEALERSHIP
? require only a few seconds in MDB