Summers rubber company designs its data warehouse

Businesses use data warehouses to provide the vast amount of information us ers need. In designing data warehouses, they must consider the level of gra nularity of data, time intervals, data integrity, use of data marts, data s crubbing,distributed design, and trade-offs between system operating costs and response time. We computed querying and update costs for a data warehou se at Summers Rubber Company. While the company staff benefited from the in formation provided by the data warehouse, there were problems related to da ta quality and user skills. Using the data warehouse at Summers took disk-s torage space of only 18 percent of the transaction database storage require ment and using data marts took only three percent.