Reference no: EM132194227

The case study retail store has expressed a desire to eventually be able to analyze the data that are collected from engaging in business, both in its brick-and-mortar store and in its online store.

Because the system had to be redesigned from the ground up, the goal of taking the business online using a Web-based database was pushed back.

Eventually, the company wants to be able to run statistical analyses against the data that it is collecting and to be able to drill down through the data to transform them into various desired formats.

In addition, the company would like to acquire data sets from other providers to engage in decision-support initiatives. What recommendations can you propose to support these business intelligence goals?

Part 1 Future Database System Implementation Plan (4-5 pages) What fundamental differences exist between object-oriented and object-relational database systems and Web-based database systems? Would these differences impact your retail store?

Include details of what changes would need to be introduced to the database if it was used to build a data mart or a data warehouse. Include details of what considerations would need to be made if the database were to become a distributed database.

What specific types of business intelligence could be gathered from the database? How would this information assist in the decision-making process for your retail store? How would your retail store benefit from data warehousing in the following areas? Return on investment on business intelligence initiatives (Provide a 3-year estimate.)

Competitive advantage (based on local or target area) Increased productivity of decision-makers (related to business process decision-making)

How would you address the following data warehousing problems if they occurred in your retail store?

Required data were never captured. There is a high demand for disk space and other resources. There are hidden problems with source systems.

Provide your analysis as to how this part of the project fulfills the mission and 1 or more goals of the case study organization.

All sources should be cited both in-text and in References using APA format.