Complex Data Warehousing and Analysis Tools

Complex Data Warehousing and Analysis Tools

Doulkifli Boukraa (University of Jijel, Algeria)
Release Date: August, 2015|Copyright: © 2016 |Runtime: 2 hrs 33 mins
EISBN13: 9781466695900|DOI: 10.4018/978-1-4666-9590-0

Description

Data warehousing has applications across industries as a way to report and analyze data useful to the success of the organization. Because complex data must be handled uniquely from traditional, or primitive data types, further research on the management and analysis of complex data is essential.

The Complex Data Warehousing and Analysis Tools video lecture addresses the problem of warehousing and analyzing complex data through three aspects: multidimensional modeling, online analytical processing (OLAP), and performance optimization. Research-based discussions as well as a real-world case studies explore warehousing, analyzing, and fragmenting auction data. Professionals, graduate students, and researchers who work with complex data will find this video to be an excellent educational resource.

Topics Covered

  • Complex Data Cubes
  • Fragmentation
  • Multidimensional Modeling
  • Online Analytical Processing
  • Performance Optimization
  • XML Data

Table of Contents

Introduction and Biography
3:11 mins
Section 1:Background
 
Lesson 1:Data Warehousing
8:58 mins
 
Lesson 2:Multi-Dimensional Modeling and OLAP
12:44 mins
 
Lesson 3:Performance Optimization of Data Warehouses
6:48 mins
 
Section 2:Multi-Dimensional Modeling of Complex Data
 
Lesson 4:Conceptual Multi-Dimensional Modeling of Complex Data
13:10 mins
 
Lesson 5:Logical Multi-Dimensional Modeling of Complex Data with XML
10:05 mins
 
Lesson 6:Physical Multi-Dimensional Modeling of Complex Data with XML
7:36 mins
 
Section 3:Online Analytical Processing for Complex Data
 
Lesson 7:Constructing Complex Cubes for Analysis
9:35 mins
 
Lesson 8:Presenting Complex Cubes to End-Users for Analysis
10:38 mins
 
Lesson 9:Analyzing Complex Data Cubes
12:12 mins
 
Section 4:Fragmenting Complex Data Warehouses
 
Lesson 10:Fragmentation in Databases and Relational Data Warehouses
11:57 mins
 
Lesson 11:Fragmentation of XML Data
8:39 mins
 
Lesson 12:Fragmentation of Complex (XML) Data Warehouses
9:16 mins
 
Section 5:Case Study – Warehousing Auction Data
 
Lesson 13:Multi-Dimensional Modeling of Auction Data
12:04 mins
 
Lesson 14:Online Analytical Processing of Auction Data
8:38 mins
 
Lesson 15:Vertical Fragmentation of an Auction Data Warehouse
7:29 mins