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.