Gajendraprabu

• Sep 12th, 2007

 

Mulitidimentional database: OLAP(OnLineAnnaliticalProcessing)

Relational database: OLTP(OnLineTransactionProcessing)

ABHI2411

 Profile Answers by ABHI2411 

• Jan 2nd, 2009

 

A MDDB is generally used where large number of aggregations and summarizations are required along with a very fast retrieval of data.Here the data is stored in the form of multidiemnsional cube(however physically it is also implemented in the form of multidimensional pointers) rather than 2 dimensional regular tables.Here the data retrieval is very fast due to the concept of Sparse and Dense dimensions which helps in searching of data only in concerned blocks.However it is not capable of handling large volumes of data so practically MDDB is mainly placed over some very distinctive modules like Finance(where users cannot afford to wait while retrieving the records).Order Mnagement and Procurement still use the same RDBMS approach.

malay_dutta

 Profile Answers by malay_dutta 

• Jan 27th, 2009

 

An MDDB is generally used where large number of aggregations and summarizations are required along with a very fast retrieval of data.Here the data is stored in the form of multidiemnsional cube(however physically it is also implemented in the form of multidimensional pointers) rather than 2 dimensional regular tables.Here the data retrieval is very fast due to the concept of Sparse and Dense dimensions which helps in searching of data only in concerned blocks.However it is not capable of handling large volumes of data so practically MDDB is mainly placed over some very distinctive modules like Finance(where users cannot afford to wait while retrieving the records).Order Mnagement and Procurement still use the same RDBMS approach.

The answer is right but I would just add a precaution that an MDDB should not be used if  it contains a large number of sparse values else it is just a waste of space.