Thursday, October 16, 2014

Write Short Note on Data Warehouse

Data Warehousing is the process of constructing and using the data warehouse. The data warehouse is constructed by integrating the data from multiple heterogeneous sources. This data warehouse supports analytical reporting, structured and/or ad hoc queries and decision making. Data Warehousing involves data cleaning, data integration and data consolidations.

Using Data Warehouse Information

There are decision support technologies available which help to utilize the data warehouse. These technologies helps the executives to use the warehouse quickly and effectively. They can gather the data, analyse it and take the decisions based on the information in the warehouse. The information gathered from the warehouse can be used in any of the following domains:
  • Tuning production strategies - The product strategies can be well tuned by repositioning the products and managing product portfolios by comparing the sales quarterly or yearly.
  • Customer Analysis - The customer analysis is done by analyzing the customer's buying preferences, buying time, budget cycles etc.
  • Operations Analysis - Data Warehousing also helps in customer relationship management, making environmental corrections.The Information also allow us to analyse the business operations.

Integrating Heterogeneous Databases

To integrate heterogeneous databases we have the two approaches as follows:
  • Query Driven Approach
  • Update Driven Approach

Query Driven Approach

This is the traditional approach to integrate heterogeneous databases. This approach was used to build wrappers and integrators on the top of multiple heterogeneous databases. These integrators are also known as mediators.

Process of Query Driven Approach:

  • when the query is issued to a client side, a metadata dictionary translate the query into the queries appropriate for the individual heterogeneous site involved.
  • Now these queries are mapped and sent to the local query processor.
  • The results from heterogeneous sites are integrated into a global answer set.

Disadvantages

  • The Query Driven Approach needs complex integration and filtering processes.
  • This approach is very inefficient.
  • This approach is very expensive for frequent queries.
  • This approach is also very expensive for queries that requires aggregations.

Update Driven Approach

We are provided with the alternative approach to traditional approach. Today's Data Warehouse system follows update driven approach rather than the traditional approach discussed earlier. In Update driven approach the information from multiple heterogeneous sources is integrated in advance and stored in a warehouse. This information is available for direct querying and analysis.

Advantages

This approach has the following advantages:
  • This approach provide high performance.
  • The data are copied, processed, integrated, annotated, summarized and restructured in semantic data store in advance.
  • Query processing does not require interface with the processing at local sources.

5 comments:

21st Century Software Solutions said...

Data Warehousing Online Training, ONLINE TRAINING – IT SUPPORT – CORPORATE TRAINING http://www.21cssindia.com/courses/data-warehousing-online-training-29.html The 21st Century Software Solutions of India offers one of the Largest conglomerations of Software Training, IT Support, Corporate Training institute in India - +919000444287 - +917386622889 - Visakhapatnam,Hyderabad Data Warehousing Online Training, Data Warehousing Training, Data Warehousing, Data Warehousing Online Training| Data Warehousing Training| Data Warehousing| If you’re serious about a career in IT, 21st Century would like to provide you a guidance don’t hesitate to organize a free demo session. For any further information regarding the courses once go through our website Visit:http://www.21cssindia.com | Call Us +917386622889 - +919000444287 - contact@21cssindia.com

Jack George said...

Data Warehousing Training "
Data Warehousing Online Training
Send ur Enquiry to contact@21cssindia.com
Introduction to Data warehousing
Who needs Data warehouse?
Why Data warehouse is required?
Types of Systems" more… Online Training- Corporate Training- IT Support U Can Reach Us On +917386622889 - +919000444287 http://www.21cssindia.com/courses/data-warehousing-online-training-29.html

Priya Kannan said...

Great post! I am see the great contents and step by step read really nice information.I am gather this concepts and more information. It's helpful for me my friend. Also great blog here with all of the valuable information you have.
Data Warehousing Training in Chennai

mathimathi said...

Stumbled across this - you are an amazing writer. Clearly very pretty too. Keep it up!
Oracle apps training |
Oracle Training in Chennai |
Oracle dba training in chennai

mathimathi said...

Thanks for publishing this blog, really awesome. Only experienced professional can do this.
Software Testing Training |
Software Training |
Software Testing Training in Chennai