20-10-2010, 11:17 AM
Presented by:
Rajalakshmi
Janani. S
Security in Data Warehousing.ppt (Size: 334 KB / Downloads: 146)
Introduction:
Data warehouse – an integrated repository.
Process involved- read, clean, aggregate and store.
Varied number of applications
Tools to access the warehouse
Characteristics of DW Data
Subject-oriented:
Data is organized around subjects or business dimensions, such as sales, customers, orders, claims, accounts, employees, etc.
Integrated:
Data is collected from several transactional databases, and integrated in a way to provide a unified picture of each subject over time.
Data from different databases is transformed into a common schema, measurement, code, data type.
Aggregated:
Data stored is not transaction-level, but aggregated by products, regions, months/years, or some other business dimension.