Multidimensional Database Management System

What Does Multidimensional Database Management System Mean?

A multidimensional database management system (MDBMS) is a database management system that uses a data cube as an idea to represent multiple dimensions of data available to users. This database is optimized for data warehouse and online analytical processing applications.

Advertisements

Techopedia Explains Multidimensional Database Management System

A multidimensional database management system (MDDBMS) provides a multidimensional view of data. For instance, in multidimensional analysis, entities such as products, regions, customers and dates represent different dimensions.

MDBMSs are created using input from existing relational databases. They have the ability to process data in a database by allowing answers to be generated quickly. Data is presented to users so as to represent a hypercube or multidimensional array, where every individual data value is contained within cells that are accessible by multiple indexes. The multidimensional systems are capable of moving beyond three dimensions.

MDBMSs are well known for their ability to present data in top level views. The main advantages of using a multidimensional database system are:

  • Increased performance
  • Easy maintenance
  • Enhanced navigation and data presentation

Advertisements

Related Terms

Margaret Rouse
Technology Expert

Margaret is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages.