Online analytical processing#Multidimensional databases

Called Under a multidimensional database, even MDDB (Multi- dimensional database) or MDBMS (multi -dimensional database management system ), refers to a database system that implements the represented at the conceptual level multidimensional data structures in their physical database and storage structure.

Benefits of a multidimensional database are applied include the ergonomic and intuitive interface and short and stable response times. The disadvantage of this type of database systems, especially for the analysis of operational detail data.

Benefits

  • High access, analysis and presentation flexibility
  • Interactive navigation in the databases
  • Create ad hoc reports and graphs suitable for presentation of results
  • Ergonomic and intuitive user interface
  • Set to fit into the working area of the user
  • If you do not require the learning of technical knowledge about the database
  • Complexity is hidden from the user; short and 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 methods of artificial intelligence and visualization methods
  • Use for data cleansing (eg implausible data analysis due to poorly maintained data fields)

Disadvantages

The disadvantage of this type of database systems, especially for the analysis of operational detail data. For detailed data, transactional, relational systems are better.

560470
de