Advertisements

Big Data

Multidimensional Databases

Multidimensional databases are generally used to create OLAP applications. They are made up of several tables of facts and dimensions. In this way, each dimension table contains a simple primary key that in turn composes the primary key of the fact table.

What is OLAP (Online Analytical Processing)?

OLAP is the acronym of Online Analytical Processing. It is a solution used in the field of the so-called business intelligence whose objective is to speed up the consultation of large amounts of data. It uses multidimensional structures (or OLAP cubes) that contain summarized data from large databases or Transactional Systems (OLTP).