Project #31103 - Database system recommendation

I NEED OPTION B

 

Situation:  Your 2-region industrial supply company wants to create a data warehouse where management can obtain a single corporate-wide view of critical sales info. to identify best-selling products, key customers & sales trends.

Currently, Sales & Product info. are stored in several different systems including a divisional sales system running on a UNIX server and a corporate sales system running on an IBM mainframe.  (Hint:  What kind of database software/vender are they likely to be using?)
 

Here are a couple sample files from the 2 systems that would supply the data for the data warehouse:

Mechanical Parts Division Sales System

Prod_No

Product_ Description

Cost_per_Unit

Units_Sold

Sales_Region

Customer_ID

60231

4” Steel bearing

5.28

900,245

N.E.

Anderson

85773

SS assembly unit

12.45

992,111

M.W

Kelly Industries

 

Corporate Sales System

Product_ID

Product_ Description

Unit_Cost

Units_Sold

Sales_

Territory

Division

60231

Bearing, 4”

5.28

900,245

Northeast

Parts

85773

SS assembly unit

12.45

992,111

Midwest

Parts

 

This company would like to create a SINGLE standard format that consolidates these data from both systems, like sample below: 

 

Proposed Data Warehouse Format

Product _ID

Product_ Description

Cost_per_ Unit

Units_ Sold

Sales_Region

Division

Customer_ID

 

 

 

 

 

 

 

 

 

 

 

 

 

 



TO DO:  Have a think about all this, then answer the following Q in 3+ sentences each, total 300+ words.

1.  What business problems are created by not having these data in a single standard format?  What did you notice?

2.  How easy would it be to create 1 database with a single standard format that could store the data from both systems?  Identify the problems that would have to be addressed with the conversion.

3.  Should the problems be solved by database specialists or general business managers?  Why?  Explain.

4.  Who should have the authority to finalize a single company-wide format for this formation in the dat warehouse?  Why?

5.  Would you recommend continuing to use the UNIX server and/or IBM mainframe for your new warehousing database and why?  Explain.

End of Option A.  If you continue to do Option B, it would be worth up to 20 pts. (-- GO for it!) Cool

* * *

6.  You now find out that this industrial supply company has bought another similar company, making it a 5-region operation.  They still need 1 database with a single standard format that could store the data from both systems but think they have outgrown what they planned for (in Option A).

The job has become too big to handle alone!  You enlist the services of consulting group LGI Systems Incorporated, which gives you a list of short essays related to data warehousing.  You decide tocheck out 3 of the essays at their website:  

http://www.dwinfocenter.org/

Summarize the main points of the 3 essays you picked related to this case problem.  

 

7.    They are now considering a data warehouse management system like those listed on the Gartner analysis website:  'Magic Quadrant for Data Warehouse Management Systems' by Mark A. Beyer/Roxane Edjlali, ReportG00255860 from Gartner.com, 3/7/14 at:

https://www.gartner.com/doc/2678018/magic-quadrant-data-warehouse-database

(you don't have to register or buy their report, just read & look at the vendor listing in the T of C and do a little Web searching on some of these listed).  

Pick 3 vender companies that would be appropriate and tell why they should be considered for this problem.



8.  If you found a great website resource that relates to Part B of this problem OTHER than those mentioned above, please cite a full reference for it here & describe in a sentence.


TO HAND IN:  If submitting text in Etudes, please ID at the top Your Name, Ch 6 Database Recommendation

If uploading an attached Word file, please label MW11Assign13.docx (but substitute YOUR own initials for mine)

Click on FINISH/SUBMIT to turn in, 2 tries.  Have fun!

 

Subject Business
Due By (Pacific Time) 05/16/2014 12:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy