Need help with the following questions. Please no previous or Wiki answers, Find

Question

Need help with the following questions. Please no previous or Wiki answers,

Find an example of an actual data warehouse. For this example, describe the content, purpose, user access methods, and sources of data (what on-line transaction processing [OLTP] databases feed data into the data warehouse) - (make sure that your example is not just a normalized OLTP database that someone has mistakenly misnamed a data warehouse or data mart, or just a vendor's advertisement/description of their product). In addition to answering the question above, to get full credit on this assignment your data warehouse should be publically accessible so that the rest of the class and I can experience it.

Explanation / Answer

For an actual data warehouse, here I will explain how you can setup an e-commerce based DWH

A data warehouse provides a basis for online analytic processing and data mining for improving business intelligence by turning data into information and knowledge

OLTP systems are typically designed by developing entityrelationship diagrams (ERD). Here, we are considering centralized e-commerce transactional system.

Consider a simple example where products are sold to registered customers (It can be further extended to include inventory employee information etc.)

Content:

The methodology to build a dimensional model consists of the following four steps:

1. Choose the data mart

2. Choose the grain of fact table

3. Choose the appropriate dimensions

4. Choose the facts.

Your datawarehouse design will depend upon the end user, the way they want to consume the data

e.g, In any e-commerce data model, you will have following dimensions and facts:

Dimension:

1. Products (ProductCode,ProductName)

2. Customer (CustomerCode,CustomerName, CustomerInformation)

Fact:

Sale -> (ProductCode,UserCode,Amount, Date)

Purpose:

This data warehouse can be used to see the trend of sale and purchase of the products in a e-commerce website.

These trends can be further used to make business decisions

Sources of data:

Source of data here will be the transactional database which will be used by the transactional system.

In many cases this is a centralized database hosted online, or it will be installed on each location of the store.

Then you need to merge the data from multiple databases into your database.

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.