373: Top 10 Techniques to Supercharge Very Large Database Systems
Chethan Thippeswamy , VeriSign, Inc Biography
Objectives: | Transform VLDBs into highly scalable powerhouses that can dynamically meet most reporting req. Avoid costly mistakes with respect to ETL, Storage and Report generation while setting up new VLDBs Eliminate iterative tuning of queries for most new canned or ad-hoc reports. |
Abstract: | Very large databases (VLDB) such as data warehouses have become vital decision support systems for internal management and external customers. Building and maintaining such systems is challenging because of rapid increase in data volumes and ever changing reporting requirements. Over time, maintenance activities override tuning efforts resulting in severe performance degradation. This session discusses the top 10 proven techniques to ‘super-charge’ your VLDB by dramatically reducing load times and exponentially improving query performance. Techniques such as high speed ETL, advanced analytic functions, star transformation and materialized views will be discussed. Finally, performance metrics achieved by using these techniques will also be presented to illustrate the various tuning concepts. After attending this session, the attendees will be able apply the techniques discussed to supercharge their existing VLDBs and avoid the common pitfalls while setting up new ones. |
Audiernce Focus: | DBA |
Expertise: | Intermediate |
Track: | Database |
Date: | Wednesday, April 16, 2008 |
Time: | 4:30 PM - 5:30 PM |