This show will delve into the new Time Travel Query features of the recently released InfoSphere Warehouse and DB2 V10.1. The time travel query feature enables InfoSphere Warehouse and DB2 applications to more seamlessly leverage point in time queries to support a variety of temporal analytics, data audit, data quality and many other operations that require time-sensitive data and processing. We will explore how the function is implemented using concepts of system and business time, and we will consider several useful scenarios for time travel query in a data warehousing solution. The implications of time travel query on data model and application design will be examined as well.
This show will explore the new features in the recently released InfoSphere Warehouse V10.1 that specifically enable realtime warehousing scenarios. New features such as Continuous Data Ingest and Adaptive Compression will be introduced and described in the context of realtime warehousing and operational BI solutions. The session will dive into how each of these functions work, best practices and implications on system architecture and model design and how they compare/contrast to existing data ingest and compression features. Several high-value business scenarios will be described to demonstrate the value of these new features.
The recently released InfoSphere Warehouse (and DB2) V10.1 introduced a number of core engine enhancements that, in particular, accelerate the performance of data warehouse queries, especially in an operational warehousing environment. This session will dive into several of the key features for data warehouse performance in turn, including:
The IBM Netezza 1000 Appliance is purpose built to support very high performance analytical workloads on the relational data warehouse. The 10+ year history of the Netezza Appliance (previously known as TwinFin) has repeatedly demonstrated the superiority of the Netezza appliance parallel processing architecture for processing analytic workloads. In addition to the shared-nothing parallel processing architecture at the foundation of the Netezza appliance, there are also a number of performance features that further enhance query performance. This session will dig down into several of these key features and describe industry-proven best practices to get the best possible performance out of your IBM Netezza appliance data warehouse. Topics that will be covered include best practices for the following areas:
Our Season #3 will end with a terrific presentation on reducing CPU and I/O utilization in DB2 LUW while concurrently achieving performance gains! Our special guest will be Andrew Endicott, DBA Manager at Cardinal Health.
Andrew, with a bit of assistance from your host, Scott Hayes, will talk about Cardinal Health's methodology and process for tuning their DB2 LUW systems, and share some of their many successes. You will hear how hardware upgrades were avoided while delivering better service to end users.
DBI is offering a free Webinar "How to Improve Performance in Minutes!" on 29 June 2012 at 2pm CDT. Visit DBI Events for details and the registration link.
On 23 May 2012, DBI Announced new competitive performance tool pricing incentives. If you have IBM OPM or other performance tools, DBI invites you to trade-in, trade-up, and swap-out those tools while enjoying special license savings. Inquire with your DBI representative for qualifications and details.
Our #1 Job is helping you look great!
Our #2 Job is giving you the documentation to prove it!
Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs.