What are the types of datawarehousing?

EDW (Enterprise datawarehousing)

·         It provides a central database for decision support throughout the enterprise

·         It is a collection of DATAMARTS

DATAMART

·         It is a subset of Datawarehousing

·         It is a subject oriented database which supports the needs of individuals depts. in an 

·         organizations

·         It is called high performance query structure

·         It supports particular line of business like sales, marketing etc..

ODS (Operational data store)

·         It is defined as an integrated view of operational database designed to support operational monitoring

·         It is a collection of operational data sources designed to support Transaction processing

·         Data is refreshed near real-time and used for business activity

·         It is an intermediate between the OLTP and OLAP which helps to create an instance reports