DEV Community

loading...
Cover image for Data Warehouse so simple...

Data Warehouse so simple...

lijindanieljoseph profile image Lijin Daniel Joseph ・1 min read

Whats up guys..?? I know you eagerly to find out the dataware house and datawarehousing..
Mainly dataware house means that a DATABASE.It maintained seperately from organisation to operational databases.

Now Data Warehousing also very important term..It is the process of constructing and using data warehouses.It mainly tools and architecture that used by company executives for organize,understand and use data for taking straegic decisions..

Main features of DATA WAREHOUSE are:

  1. Subject Oriented: Databases organized based on major subjects like customer,supplier,product etc..
  2. Integrated: Databases constructed by integrating multiple differrent sources.
  3. Time-Variant: Data are stored for provide information in historical perpective.
  4. Non-Volatile: Physically seperate store of data for transfer from application data.

The construction of data warehouse require mainly 3 process..

  1. DATA CLEANING
  2. DATA INTEGRATION
  3. DATA CONSOLIDATION..

THese are the important points for the DATA WAREHOUSE...

If you like this conent.. then please FOLLOW ME for more updates.

THANK YOU

HAVE A NICE DAY

Discussion

pic
Editor guide