Dimensional Modeling - ADAPT methodology (Design for Analytical Processing Technologies)

> (OLAP|Analytic) > Dimensional Modeling - Dimensional Schemas

Table of Contents

1 - About

ADAPT is the first design methodology specifically created to represent the objects and operations found in OLAP databases.

OLAP databases provide a multidimensional view of the data and are designed to answer analytical questions such as “Why?” and “How?” Dimensions, hierarchies, cubes, measures, and calculations, the basic OLAP database building blocks, were created to facilitate answering strategic questions.

Using a simple Visio stencil, you can create a blueprint of an OLAP system and validate the application design against the business requirements before you spend a lot of time on implementation details.

2 - Reference