Concepts - What is the difference between choosing a multidimensional database and a relational database?

GeekInterview.com > Interview Questions > Data Warehousing > Concepts

Go To First | Previous Question | Next Question

Concepts | Question 27 of 31

What is the difference between choosing a multidimensional database and a relational database?

Total Answers and Comments: 3

Last Update: January 27, 2009 Asked by: vishnukumar

Sponsored Links

Best Rated Answer

—

Submitted by: ABHI2411

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.

Above answer was rated as good by the following members:
malay_dutta, feeblenoise

September 12, 2007 03:06:23

Gajendraprabu

RE: What is the difference between choosing a multidim...

Mulitidimentional database: OLAP(OnLineAnnaliticalProcessing)

Relational database: OLTP(OnLineTransactionProcessing)

Is this answer useful? Yes | No

0 2

Overall Rating: -2

January 02, 2009 05:59:54

ABHI2411

Member Since: January 2009 Contribution: 4

RE: What is the difference between choosing a multidimensional database and a relational database?

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.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

January 27, 2009 03:04:21

malay_dutta

Member Since: January 2009 Contribution: 1

RE: What is the difference between choosing a multidimensional database and a relational database?

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.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank