UsefulLinks
Computer Science
Databases
Database Management Systems
1. Introduction to Databases and DBMS
2. Data Models
3. The Relational Model
4. Database Design
5. SQL (Structured Query Language)
6. Storage and File Structure
7. Query Processing and Optimization
8. Transaction Management
9. Recovery Systems
10. Database Security
11. Distributed Database Systems
12. NoSQL Database Systems
13. Data Warehousing and OLAP
14. Emerging Database Technologies
13.
Data Warehousing and OLAP
13.1.
Data Warehousing Concepts
13.1.1.
Data Warehouse Definition
13.1.2.
Characteristics of Data Warehouses
13.1.2.1.
Subject-Oriented
13.1.2.2.
Integrated
13.1.2.3.
Time-Variant
13.1.2.4.
Non-Volatile
13.1.3.
Data Warehouse Architecture
13.1.3.1.
Single-Tier Architecture
13.1.3.2.
Two-Tier Architecture
13.1.3.3.
Three-Tier Architecture
13.2.
ETL Process
13.2.1.
Extract Phase
13.2.1.1.
Data Source Identification
13.2.1.2.
Data Extraction Methods
13.2.2.
Transform Phase
13.2.2.1.
Data Cleaning
13.2.2.2.
Data Integration
13.2.2.3.
Data Transformation
13.2.3.
Load Phase
13.2.3.1.
Initial Loading
13.2.3.2.
Incremental Loading
13.2.3.3.
Refresh Strategies
13.3.
Data Warehouse Schema Design
13.3.1.
Star Schema
13.3.1.1.
Fact Tables
13.3.1.2.
Dimension Tables
13.3.1.3.
Schema Characteristics
13.3.2.
Snowflake Schema
13.3.2.1.
Normalized Dimensions
13.3.2.2.
Schema Characteristics
13.3.3.
Galaxy Schema
13.4.
Online Analytical Processing
13.4.1.
OLAP Concepts
13.4.2.
OLAP Operations
13.4.2.1.
Roll-Up Operation
13.4.2.2.
Drill-Down Operation
13.4.2.3.
Slice Operation
13.4.2.4.
Dice Operation
13.4.2.5.
Pivot Operation
13.4.3.
OLAP Implementation
13.4.3.1.
ROLAP
13.4.3.2.
MOLAP
13.4.3.3.
HOLAP
13.5.
Data Mining Integration
13.5.1.
Data Mining Process
13.5.2.
Knowledge Discovery
13.5.3.
Pattern Recognition
Previous
12. NoSQL Database Systems
Go to top
Next
14. Emerging Database Technologies