Multidimensional database

from Wikipedia, the free encyclopedia

Under a multi-dimensional database (also multi-dimensional database , MDDB or multi-dimensional database management system , MDBMS ) refers to a database system , the multidimensional shown at a conceptual level data structures converts in their physical database and storage structure.

The advantages of a multidimensional database include the ergonomic and intuitive user interface and short and stable response times. This type of database system is disadvantageous above all for the analysis of operational detailed data.

Database.svg

advantages

  • High access, analysis and presentation flexibility
  • Interactive navigation in the databases
  • Creation of ad-hoc reports and graphics for the appropriate presentation of results
  • Ergonomic and intuitive user interface
  • Should fit into the user's field of work
  • Shouldn't require learning technical knowledge about the database
  • Spares the user from recognizing the complexity; short, stable response times (system availability)
  • Discovery of hidden information and relationships with high value for management decisions (data pattern recognition / data mining)
  • Use of various artificial intelligence and visualization methods
  • Use for data cleansing (e.g. implausible analysis data due to poorly maintained data fields)

disadvantage

This type of database system is disadvantageous above all for the analysis of operational detailed data. Transaction-oriented, relational systems are better suited for detailed data .

See also

literature

  • Nils Clausen: OLAP - Multidimensional Databases. Addison-Wesley-Longman, Bonn 1998, ISBN 3-8273-1402-X .