Chapter 6, Problem 9HMP

Program Plan Intro

Industrial Supply Company Scenario:

• A data warehouse has to be created by the company where management can gain a single corporate-wide view of critical sales information for identifying best-selling products in specific geographic areas, sales trends as well as key customers.
• The information regarding sales and products are stored in both the divisional sales system that runs on a UNIX server and a corporate sales system that runs on an IBM mainframe.
• The main aim is to create a single standard format, which consolidates these data from both the systems.

Explanation of Solution

Easiness of creating a database with a single standard format:

• It is ideally easy to create a database with a single standard format. When a new database is constructed, data quality audits and data cleansing must be performed.
• Thee data quality suits and data cleansing can correct any redundancies and inaccuracies in the current systems.
• By using the data cleansing software, the company can combine and integrate the data from all the systems into a single standard format, which is uniform throughout the whole company...

Explanation of Solution

Problem Solving:

• Database specialists help to solve the problems by performing the data quality audits and database cleansing. It also helps to establish an information policy and develop the new database...

Explanation of Solution

Authority to finalize a single company-wide format:

• General business managers have the authority, as they are responsible for the data.
• They have the final power to decide, when managing data resources...