Data warehousing components ppt

What are components of data warehouse?
A typical data warehouse has four main components: a central database, ETL (extract, transform, load) tools, metadata, and access tools.
All of these components are engineered for speed so that you can get results quickly and analyse data on the fly..
What are the components of a data warehouse?
A typical data warehouse has four main components: a central database, ETL (extract, transform, load) tools, metadata, and access tools.
All of these components are engineered for speed so that you can get results quickly and analyse data on the fly..
A data warehouse can be composed of one or multiple databases.
Within each database, data is stored in a tabular format into individual tables.
Tables are composed of rows and columns, out of which each column defines a variable.
Each variable is defined as a data type, such as integer, data field, or string.

What are the components of a data-warehouse?

COMPONENTS OF A DATA-WAREHOUSE: The primary components of a data-warehouse are 1

Source data component Production data internal data Archived data External data 2

Data staging component Extraction of data Transformation of data Synonyms Homonyms Loading of data 3

Data storage component 4

This is the most widely used Architecture of Data Warehouse

It consists of the Top, Middle and Bottom Tier

Bottom Tier: The database of the Datawarehouse servers as the bottom tier

It is usually a relational database system

Data is cleansed, transformed, and loaded into this layer using back-end tools