Security in Data Warehousing

[seminar surveyer]

---

Presented by:
Rajalakshmi
Janani. S

---

[attachment=6638]

---

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.