Q
Problem solve Get help with specific problems with your technologies, process and projects.

What are the advantages of having a multi-dimensional database in data warehousing solution?

What are the advantages of having a multi-dimensional database in data warehousing solution?

Please note that we should distinguish between the model of the data warehouse and the database engine in which the data warehouse can be implemented.

The multidimensional model is more advantageous in a data warehouse environment that calls for subject oriented, summarized and time variant data categorization. This model can then be implemented either in a ROLAP (relational implementation of star schema) or MOLAP (the multidimensional implementation). RDMBS implementation of data warehouses is more widely in use.


Dig Deeper on Oracle data warehousing

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close