A Data warehouse, a relational/ multidimensional database , in which the environment often consists of an ETL solution, an OLAP engine ,client analysis tool and other applications that can manage the process of data gathering and delivering to business users.
Basically Data Warehouse, a dedicated database, a central repository containing the data from the various operational sources in an organization.It includes detailed,stable,non-volatile and consistent data which can be analyzed in the time variant.
Types of Datawarehouse:
- Enterprise Data Warehouse: Provides a central database for decision support throughout the enterprise.
- ODS(Operational Data Store) : Having a broad enterprise wide scope,but unlike real enterprise datawarehouse, data is refreshed in real time and used for routine business activities
- Data Mart: A subset of data warehouse,supporting a particular region,business unit or business function.
3 comments:
very nice article.Would you help me t o identify which among these mentioned type is better ?
Thanks for your comments.Actually all the three types mentioned are equally good.The selection depends on the choice of the application for business activity
thanks for your response
Much appreciated
Post a Comment