OLTP vs OLAP or Relational vs Dimensiona - TechRepublic
General discussion
July 9, 2000 at 04:19 AM
intergrow

OLTP vs OLAP or Relational vs Dimensiona

by intergrow . Updated 25 years, 10 months ago

Hello all you fine, smart TechReps,

I’ve recently run into OLAP/OLTP information and relational/Dimensional dB’s. I am familiar with RDBMS but had never heard of DDBMS.

-Researching, I discovered time, multi-dimensions and hierarchical dimensions make up data cubes.
-As well I found some stat calculations from ‘Incremental multidimensional scaling method for database visualization’
Wojciech Basalaj(University of Cambridge).
-And there are many vendors who offer OLAP databases.

I suspect that Multi-dimensional dB’s are still tables, tuples, keys and domains just implimeted oddly.

What I would like to know is: what is a multidimensional databases from the point of view of a SQL coder and is there a normalization scheme for them.

This discussion is locked

All Comments