• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Introduction to Data Warehouse

What is a Data Warehouse?

According to Inmon, famous author for several data warehouse books, “A data warehouse is a subject oriented, integrated, time variant, non volatile collection of data in support of management’s decision making process”.

 

Example

In order to store data, over the years, many application designers in each branch have made their individual decisions as to how an application and database should be built. So source systems will be different in naming conventions, variable measurements, encoding structures, and physical attributes of data. Consider a bank that has got several branches in several countries, has millions of customers and the lines of business of the enterprise are savings, and loans. The following example explains how the data is integrated from source systems to target systems.

 

 

Example of Source Data

 

System NameAttribute NameColumn NameDatatypeValues
Source SystemCustomer ApplicationCUSTOMER_APPLICATION_DATE NUMERIC(8,0)11012005
1Date
Source SystemCustomer ApplicationCUST_APPLICATION_DATEDATE11012005
2Date
Source SystemApplication DateAPPLICATION_DATEDATE01NOV2005
3

 

In the aforementioned example, attribute name, column name, datatype and values are entirely different from one source system to another. This inconsistency in data can be avoided by integrating the data into a data warehouse with good standards.

 

Example of Target Data(Data Warehouse)

Target SystemAttribute NameColumn NameDatatypeValues
Record #1Customer Application DateCUSTOMER_APPLICATION_DATE DATE01112005
Record #2Customer Application DateCUSTOMER_APPLICATION_DATE DATE01112005
Record #3Customer Application DateCUSTOMER_APPLICATION_DATEDATE01112005

 

In the above example of target data, attribute names, column names, and datatypes are consistent throughout the target system. This is how data from various source systems is integrated and accurately stored into the data warehouse

Summary
Review Date
Reviewed Item
Introduction to Data Warehouse
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Introduction to Data Warehouse"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.