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.