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 conversation is currently closed to new comments.
Relational VS Dimensional are different database architectures for different applications. Relational databases are designed for OLTP. Dimensional (data warehouses or datamarts) are design for OLAP or reporting.
The classic relational database uses normalization techniques to optimize for OLTP. In a nutshell, the data warehouse goes a step further to ususally a star schema for the purpose of optimizing OLAP and aggregate reporting. Essentially we denormalize to create a data mart.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
OLTP vs OLAP or Relational vs Dimensiona
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.