Forum .LRN Q&A: Re: Datawarehousing at dotLRN

Posted by Carl Robert Blesius on
I do not really understand your post or question(s) Pablo, but I did find a good reference on Multidimensional DB technology that helped a little

Based on this document I think the underlying data model in .LRN has little to do with "Cubo Models" or "Multiple Dimensions".

Here is snipit from the document:

Using a Structured Query Language database management
system offers considerable flexibility in structuring
data. However, formulating many desirable
computations such as cumulative aggregates (sales in
year to date), combining totals and subtotals, or determining
rankings such as the top 10 selling products is
difficult if not impossible in standard SQL. Also, transposing
rows and columns requires manually specifying
and combining multiple views. Although SQL
extensions such as the data cube operator3 and query
windows4 will remedy some of these problems, the
SQL-based relational model does not handle hierarchical
dimensions satisfactorily

We use SQL around here.

Posted by melina dee on
thanx for sharing the information about the Multidimensional DB technology and then script of the document