Scribd
Upload
47 views11 pages

DBMS Extensions for Data Warehousing

This document discusses database management system (DBMS) extensions for data warehouses. It describes how DBMS extensions address limitations of relational DBMS for data warehousing, including new features for query languages, materialized views for summary data management, and parallel processing. The key DBMS extensions are query language extensions, materialized views, and parallel processing capabilities to improve performance for data warehouse querying, loading, and transformations.

Uploaded by

Oneedastargirl Chase
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
47 views11 pages

DBMS Extensions for Data Warehousing

This document discusses database management system (DBMS) extensions for data warehouses. It describes how DBMS extensions address limitations of relational DBMS for data warehousing, including new features for query languages, materialized views for summary data management, and parallel processing. The key DBMS extensions are query language extensions, materialized views, and parallel processing capabilities to improve performance for data warehouse querying, loading, and transformations.

Uploaded by

Oneedastargirl Chase
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

Information Systems Program

Module 1
DBMS Extensions and
Example Data Warehouses

Lesson 3: DBMS Extensions


Lesson Objectives
• Review data warehouse characteristics
• Discuss DBMS extensions
• Reflect on importance of DBMS extensions

Information Systems Program


Data Comparison
Operational databases
Current and some
historical
Individual
Few rows per request
Highly volatile

Data warehouses
Historical
Individual and
summarized
Thousands of rows per
request
Non volatile and
refreshed
3

Information Systems Program


Database Technology and Deployment
Limitations
Data
warehouse
technology and
deployments

Missing data
managemen
t features

Performan
Lack of
ce
integration
limitation

Information Systems Program


Relational DBMS Dominance for Data
Warehouse Processing
Relational
DBMS usage
for DWs

New DW
features

DW Relational
performance DBMS
improvement dominance

Lack of
scalability of
data cube
engines
5

Information Systems Program


DBMS Extensions

Query
language
extensio
ns

Information Systems Program


Query Language Extensions

Motivation

●
Limitations of GROUP BY/HAVING clauses
●
Tedious and inefficient with SQL and external tools

SELECT statement extensions

●
Combine retrieval and analysis
●
Subtotal operators
●
Analytic processing model and new functions
7

Information Systems Program


Summary Data Management

Motivation

●
Static environment
●
Large number of rows to retrieve per query

Stored queries known as materialized views (MVs)

●
Which MVs to store?
●
How to combine MVs and user queries?
●
When and how to update MVs?
8

Information Systems Program


Parallel Processing
Tasks

●
Joins and summary calculations
●
Loading
●
Data transformations such as parsing and merging

Features

●
Transparent
●
Scalable
●
Commodity components and open source software
9

Information Systems Program


DBMS Usage for Loading and Transformation

Data
Source

Data Extract Transform


Load DW Tables
Source (Relational
DBMS)

Data
Source

10

Information Systems Program


Summary
• Data warehouse characteristics
• Need for DBMS extensions
• Types of DBMS extensions

11

Information Systems Program

You might also like