OLAP - Revision history

Tedyun at 09:58, 13 November 2013

2013-11-13T09:58:41Z

2013-11-13T09:54:04Z

2013-11-13T09:33:57Z

2013-11-13T09:19:24Z

Example

2013-11-13T09:16:59Z

2013-11-13T09:13:00Z

2013-11-13T09:10:58Z

2013-11-13T09:09:12Z

2013-11-13T09:07:10Z

2013-11-13T09:04:37Z

← Older revision		Revision as of 09:58, 13 November 2013
Line 77:		Line 77:
	# http://en.wikipedia.org/wiki/Online_analytical_processing		# http://en.wikipedia.org/wiki/Online_analytical_processing
	# http://en.wikipedia.org/wiki/OLAP_cube		# http://en.wikipedia.org/wiki/OLAP_cube
		+	# http://en.wikipedia.org/wiki/Essbase

@@ Line 72: / Line 72: @@
 * "Slice" and "dice"
 * ''With Cube'' and ''With Rollup''
 http://en.wikipedia.org/wiki/OLAP_cube

← Older revision		Revision as of 09:33, 13 November 2013
Line 72:		Line 72:
	* "Slice" and "dice"		* "Slice" and "dice"
	* ''With Cube'' and ''With Rollup''		* ''With Cube'' and ''With Rollup''
		+	http://en.wikipedia.org/wiki/OLAP_cube

@@ Line 29: / Line 29: @@
 ; Fact table
 : Sales(storeID, itemID, custID, qty, price)
-:: ''dimension attributes'': storeID, itemID, custID (=> ''foreign keys'')
+:* ''dimension attributes'': storeID, itemID, custID (=> ''foreign keys'')
-:: ''dependent attributes'': qty, price
+:* ''dependent attributes'': qty, price
 ; Dimenstion tables

← Older revision		Revision as of 09:16, 13 November 2013
Line 66:		Line 66:
	Group By dimension-attrs <u>With Rollup</u>		Group By dimension-attrs <u>With Rollup</u>
	=> For hierarchical dimensions, portion of With Cube.		=> For hierarchical dimensions, portion of With Cube.
		+
		+	=== OLAP Queries ===
		+	* Star join
		+	* Drill-down and roll-up
		+	* "Slice" and "dice"
		+	* ''With Cube'' and ''With Rollup''

@@ Line 53: / Line 53: @@
 === SQL Constructs ===
-'''WITH CUBE''' and '''WITH ROLLUP'''
+Two queries to support (multidimensional) OLAP: '''WITH CUBE''', '''WITH ROLLUP'''
   Select dimension-attrs, aggregates
   From tables

@@ Line 54: / Line 54: @@
 === SQL Constructs ===
 ; '''WITH CUBE''' and '''WITH ROLLUP'''
-<pre>Select dimension-attrs, aggregates
+ Select dimension-attrs, aggregates
-From tables
+ From tables
-Where conditions
+ Where conditions
-Group By dimension-attrs <u>With Cube</u></pre>
+ Group By dimension-attrs <u>With Cube</u></pre>

← Older revision		Revision as of 09:07, 13 November 2013
Line 51:		Line 51:
	* Drilling-down corresponds to ''adding'' a '''GROUP BY''' attribute.		* Drilling-down corresponds to ''adding'' a '''GROUP BY''' attribute.
	* Rolling-up corresponds to ''removing'' a '''GROUP BY''' attribute.		* Rolling-up corresponds to ''removing'' a '''GROUP BY''' attribute.
		+
		+	=== SQL Constructs ===
		+	; '''WITH CUBE''' and '''WITH ROLLUP'''
		+	<pre>Select dimension-attrs, aggregates
		+	From tables
		+	Where conditions
		+	Group By dimension-attrs <u>With Cube</u></pre>

@@ Line 38: / Line 38: @@
 === OLAP Queries ===
-; Join -> Filter -> Group -> Aggregate
+; Join → Filter → Group → Aggregate
-; Performance
+* Performance
-:# Inherently very slow: special indexes, query processing techniques
+*# Inherently very slow: special indexes, query processing techniques
-:# Extensive use of materialized views
+*# Extensive use of materialized views