As a result, organizations can never have too much information about their customers, markets, or products. However, a company's data are often spread over several applications, systems and various formats that can be difficult to access, correlate, and interpret. Consequently, companies are solving this issue by developing data warehouses.
Data warehouses form the core of a comprehensive decision-support system.
Data warehouses allow user access to vast stores of integrated, subject-oriented, and historical data. Performance is a key element in handling large data sets, and taking advantage of the advances in parallel systems is crucial to obtaining that performance. The result is top performance. Optimized system administration is another critical area for very large databases. Tables need to be partitioned transparently to applications and users.