Seven important keys for this are as follow.
1.Understand what forecasting is and is not
As a result of this a better environment will established for business activities. Accuracy and remove the game plan is also can be achieved.
2. Forecast demand and plan supply
In this way you can improve capital planning and customer service.
3. Communicate, corporate and collaborate
It is very helpful to get all important information for to forecast and it is trustable for user. More accurate and relevant forecast can be got.
4. Eliminate island of analysis
With this key more reliable and accurate forecast can be achieved.
5. Use tools wisely
With the help of this efficiency and effectiveness will be get.
6. Make it important
With the help of this forecasting key developers can take serious the issue that are under discussion. Accuracy and credibility can also be achieved.
Forecast performance can be including in the individual performance plans. Errors can be removed and improvement can be also achieved. Confidence of the forecasting can also be increased.
CS614 Assignment 3 Solution and Discussion
Assignment No. 03
Semester: Fall 2019
CS614: Data Warehousing Total Marks: 15
Due Date: 27-Jan-2020
The objective of this assignment is to enhance the learning capabilities of the students about:
• Join Techniques
• Hash based join
• Sort-Merge join
Please read the following instructions carefully before submitting assignment:
You need to use MS word document to prepare and submit the assignment on VU-LMS.
It should be clear that your assignment will not get any credit if:
The assignment is submitted after due date.
The assignment is not in the required format (.doc or docx)
The submitted assignment does not open or file is corrupt.
Assignment is copied(partial or full) from any source (websites, forums, students, etc)
HyperMart is an online shopping store currently acquiring a large number of customers.
Normalized table structures for the shopping store are given below:
Order_ID Order_Date 100 2-Feb-2019 201 2-Feb-2019 300 4-Feb-2019 …. …
Order details Table
Detail_ID Order_ID Product_ID Product_Quantity Sale_Amount 100 100 2 1 100 101 100 3 2 200 200 201 5 1 50 201 201 7 1 90 300 300 15 1 600 301 300 56 1 800 302 300 57 1 850 …. … … …. …
• Assume 1:12 record count ratio between Order and Order detail for online store’s database
• Assume 10,000 orders
For the given relations you are required to calculate the following costs in terms of I/O operations and find out which joining technique is better for given scenario. Tasks you are required to perform are as under;
- Cost of Sort-Merge Join
- Cost of Hash-Join
- On the basis of your calculations, suggest better joining technique between sort-merge and hash join for the given scenario
Best of Luck!