Data Warehouse Performance and Scalability

Document Sample
Data Warehouse Performance and Scalability Powered By Docstoc
					Data Warehouse Performance is optimum today! ">Customers are using Data
Warehousing systems from large providers like Teradata, IBM, Oracle and HP as well
as from various other vendors like NewGen, Vertica etc.
  Having data warehouse problems and failures?
  鈥?Your data warehouse or BI architecture or reporting has changed 鈥?Your
systems is slow or crashes because your business intelligence tool doesn 鈥檛 scale
as users expect 鈥?Your data volumes have increased significantly 鈥?Your ETL
(Extract, Transform and Load) process fails to achieve a complete loading
  Do you want to scale and tune your system for 25 Million transactions or 2 Million
transactions? One major force driving the requirement for high availability in the data
warehouse system is the use of analytics and Business Intelligence oriented
functionality in OLTP applications, creating a highly use of the data warehouse as a
source of information for the OLTP applications requiring high-performance queries.
Most data warehouses are mission-critical, serving in an increasingly mixed workload
capacity, including as a data source for online applications. 鈥 淒 eep mining
鈥?analysts and business analysts are running complex queries and fast-running
tactical queries, each with differing service-level expectations driven by business
users, customers and executives of their Company. These differing workloads are all
competing for CPU, memory and disk access. At the same time, data latency
continues to progress from batch to continuous loading demands.
  The complex mixed workload consists of:
  鈥?Continuous data loading, similar to an OLTP workload
  鈥?Batch data loading
  鈥?Summary and aggregate management to support dashboards and prebuilt reports
  鈥?Large numbers of standard reports ranging in the thousands per day requiring
SQL tuning, index creation, new types of storage partitioning and other types of
optimization structures in the data warehouse
  鈥?Business analytics in which business process professionals with limited query
language experience use prebuilt analytic data objects with aggregated data (pre-joins)
and designated dimensional drill downs (summary)
  鈥?An increasing number of query users with a random, unpredictable use of the
  Automation, Performance and Scalability
  鈥?The Business Intelligence tool is a customer-facing interface so it 鈥檚 the initial
  鈥?Automate Regression testing of the Business Intelligence tool 鈥?Automate
Performance/Scalability testing of the Business Intelligence tool
  鈥?Performance may be an issue at the Data Warehouse or any other data source
  鈥?Characterize each source and subsystem 鈥檚 response under load
  Ensure your Data Warehouse Performance is optimum today!