Understanding Data Warehousing
page 2 of 8
by Arindam Ghosh
Average Rating: 
Views (Total / Last 10 Days): 35600/ 77

Comparison of data warehouse and operational data

The data warehouse is distinctly different from the operational data used and maintained by day-to-day operational systems. Data warehousing is not simply an “access wrapper” for operational data, where data is simply “dumped” into tables for direct access. Among the differences:



Application Oriented

Subject Oriented


Summarized (or otherwise refined)

Accurate, as of the moment of access

Represents values over time, snapshots


Not Updated

Run repetitively and non-reflectively

Run heuristically

Requirements for processing not completely understood before development

Requirements for processing understood before initial development

Compatible with the Software Development Life Cycle

Completely different life cycle

Performance sensitive (immediate response required when entering a transaction)

Performance relaxed (immediacy not required)

Accessed a unit at a time (limited number of data elements for a single record)

Accessed a set at a time (many records of many data elements)

Transaction driven

Analysis driven

High availability and not redundant

Relaxed availability and redundancy is a fact of life

Managed in its entirety

Managed by subsets

Static structure; variable contents

Flexible structure

Small amount of data used in a process

Large amount of data used in a process

View Entire Article

User Comments

Title: sakota   
Name: said Ahmed
Date: 2008-04-09 5:22:55 AM
Very nice and cute...

Product Spotlight
Product Spotlight 

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2021 ASPAlliance.com  |  Page Processed at 2021-11-29 12:33:05 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search