Summers Rubber Company designs its data warehouse

Businesses use data warehouses to provide the vast amount of information users need. In designing data warehouses, they must consider the level of granularity of data, time intervals, data integrity, use of data marts, data scrubbing, distributed design, and trade-offs between system operating costs and response time. We computed querying and update costs for a data warehouse at Summers Rubber Company. While the company staff benefited from the information provided by the data warehouse, there were problems related to data quality and user skills. Using the data warehouse at Summers took disk-storage space of only 18 percent of the transaction database storage requirement and using data marts took only three percent.