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


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