Is it still worthwhile to consider a multidimensional database?

tganley

With the advent of relational databases, is there still a place for MDDBs in data warehousing today, or is that considered obsolete technology?

Answer this Question

Answers

2 total
blackdog
Vote Up (14)

 

What's kind of funny is that a decade ago the question would have probably been is it still worthwhile to consider a relational database since multidimensional databases allow such higher levels of data organization.  Since then, relational databases have become the "go-to" standard, general purpose tool for data management.  For most purposes the relative ease of use (if you know SQL) and flexibility of a relational database is the best choice.  On the other hand, if you have a task that requires multiple variable events, it can make more sense to organize the data in the "cube" model of a MDDB, which makes it  possible to use the quantitative descriptions of an event set to analyze each dimension at different detail levels. 

http://www.learndatamodeling.com/multidim_db.htm

 

jimlynch
Vote Up (14)

For those who aren't familiar with MDB, here's a good definition:

What is a Multidimensional Database?
http://www.wisegeek.com/what-is-a-multidimensional-database.htm

"A multidimensional database is a form of database that is designed to make the best use of storing and utilizing data. Usually structured in order to optimize online analytical processing (OLAP) and data warehouse applications, the multidimensional database can receive data from a variety of relational databases and structure the information into categories and sections that can be accessed in a number of different ways. Even persons who have relatively little experience working with a database often find that a multidimensional database, or MDB, requires only a short time to master.

While just about every relational database is structured for keyword searches and building a query by specifying fields and perimeters, the multidimensional database goes one step further. Rather then building a query, a user simply poses the question in everyday verbiage. This approach is used with several online help tools associated with software programs such as word processing and spreadsheet applications, as well as several of the more popular search engines currently in use."

Ask a question

Join Now or Sign In to ask a question.
SAP reported a strong growth in cloud revenue and fast adoption of its HANA platform in the first quarter, while its software revenue dipped from the same quarter in the previous year.
Oracle is rolling out a new in-memory application for its J.D. Edwards ERP (enterprise resource planning) software that's aimed at giving customers real-time insights into their supply chain in order to avoid calamities and optimize day-to-day business.
Teradata is hoping to gain ground in the hotly competitive data-warehousing and analytics market with QueryGrid, a new product that allows users to run a single SQL-based query across multiple data stores, from Teradata's own system to Hadoop and rival databases.
SimpleQL thinks the best way to bring business intelligence to people who've never drilled into big data is to help them decide what they want to know.
Business groups in a growing number of companies appear to be plowing ahead on data analytics projects with little input or help from their own IT organizations.
SAP is continuing to merge its HANA in-memory database platform with its Business Warehouse data warehousing software, with the latest update adding support for HANA's real-time data loading services.
Splunk and Tableau have formed a strategic alliance through which Tableau's visual analytics business intelligence platform can connect to machine data from Splunk as a native data source. The partners say the alliance will drive new kinds of real-time business analytics.
Informatica hopes to save business analysts time by allowing them to build their own queries and reports, without requiring the IT department to do all the assembly work.
Microsoft is about to make a fresh run at its CRM (customer relationship management) rival Salesforce.com with new capabilities for marketing automation, customer support and social media monitoring.
Intel is continuing to build out its array of software tools for the Hadoop open-source big data processing framework, with an emphasis on the security and reliability features demanded by large enterprises.

White Papers & Webcasts

See more White Papers | Webcasts

Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+