Our next quarterly meeting will be held on Monday, March 12th 2012.
 
KU Edwards Campus
Regnier building (southeast corner of the complex)
12600 Quivira Road
Overland Park, KS 66213
(913) 897-8400
 

Please click here for a map

======================================================================
March 2012 Meeting Agenda
======================================================================
8:00 to 8:30       Check in and continental breakfast
----------------------------------------------------------------------
8:30 to 8:45       Paul Murphy, IBM
                        IBM Announcements
----------------------------------------------------------------------
8:45 to 10:00     Curt Cotner, IBM
                        Database Trends and Directions
----------------------------------------------------------------------
10:00 to 10:15    Break
---------------------------------------------------------------------
10:15 to 11:30     David Beulke, IBM
                          Agile Big Data Analytics: Implementing a 22 billion row Data Warehouse
----------------------------------------------------------------------
11:30 to 12:30     Lunch
----------------------------------------------------------------------
12:30 to 12:45     Pat Kittilstad, President
                          User Group Announcements
----------------------------------------------------------------------
12:45 to 2:00      Jay Yothers, IBM
                          DB2 Version 10 Update
----------------------------------------------------------------------
2:00 to 2:15        Break
 ----------------------------------------------------------------------
2:15 to 3:30        Curt Cotner, IBM
                          Change Data Capture

======================================================================

PRESENTATION ABSTRACTS

Curt Cotner

Database Trends and Directions 
Relational database technology has become a key element of most enterprise IT architectures over the course of the last 25 years. During that period of time, relational database products like DB2 have evolved significantly to address the changing technology and business needs of customers. This evolution has come in the form of dramatic improvements in performance, scalability, availability and system management. The evolution has also introduced major functional enhancements to the relational database products that represent significant departures from the original concepts described by Dr. Codd in his seminal research.  For example, customer demand for object database features in the 1990's caused relational products like DB2 to introduce stored procedures, user-defined functions, and triggers as a vehicle for customizing the behavior of the relational database engine.  More recently, most of the major relational products have evolved to include native data stores and query language enhancements to handle XML. In the past few years, a number of new database technologies have been introduced: in-memory data stores, graph stores, column stores, name/value stores, etc.   Some industry pundits have proclaimed that these technologies represent the end of the relational database era. In this session, we will discuss some of these new technology developments, and we will describe some of the work that is being done within IBM to continue the evolution of DB2 to address these new technology and business needs.


Change Data Capture
As DBAs, we introduce all kinds of changes into our DB2 system: new releases of DB2, changes to the DB2 configuration, new hardware, application changes, new SQL, new indexes, rebinding of packages, Runstats changes, etc. With all these changes, it becomes very difficult to make sure that the proposed changes have been validated by testing that includes all the SQL in your production workload. It's also difficult to assess the performance impact of these changes in a very precise manner. This presentation will show how capture/replay technology can be used to automate a thorough test process that will comprehensively test production-like workloads and help you pinpoint any performance improvements or degradations that occur due to the changes you've introduced.                                         


Speaker Bio: Curt Cotner is an IBM Fellow and VP/CTO for IBM's relational database server products. Curt has technical and management oversight of IBM's Data Studio and Optim products that provide application development and administration support for both IBM and non-IBM database products. Curt holds approximately 40 patents in database technolgy topic areas. Prior to taking his current assignment, Curt was the chief architect of the DB2 for z/OS product, where he designed and developed many key features of the DB2 product:
* DRDA support
* distributed 2-phase commit
* Stored procedures
* TCP/IP
* JDBC and SQLJ



David Beulke

Agile Big Data Analytics: Implementing a 22 billion row Data Warehouse 
This presentation discusses the design, architecture, meta-data, performance and other experiences building a big data and analytics DW system. You will learn through this presentation the real life issues, agile development considerations, and solutions for building a data warehouse of 22+ billion rows in six months. This presentation will help you understand techniques to manage, design and leverage the big data issues for a more in-depth understanding of your business.  Also the agile  development processes will be detailed showing how to uncovered complex analytics requirements and other issues early in the development cycle.  This presentation will help you understand all these experiences that took processes from 37 hours to seconds so you can create a successful big data design and scalable data warehouse analytic architecture.


Speaker Bio: David Beulke is an internationally recognized consultant, author and teacher. He is known for his strategic expertise in database performance, data warehouses and internet applications.  He provides data management strategies, architectures, design and system consulting and writes a weekly blog at www.davebeulke.com. He is currently a member of the IBM DB2 Gold Consultant program, an IBM Information Champion, co-author of the IBM and z/OS DB2 Certification exams, co-author of the Business Intelligence Certification exam, past president of the International DB2 Users Group (IDUG), former columnist for DB2 Magazine and former instructor for The Data Warehouse Institute (TDWI).  Dave helps his clients improve their strategic direction, dramatically improve performance and reduce their CPU demand saving millions in their systems, databases and application areas within their mainframe, UNIX and Windows environments.


Jay Yothers

DB2 Version 10 Update  

abstract...

bio...


=======================================================================


Please use this link to register for the March meeting
(Both annual memberships and single meeting attendees must register)





Click on the "Add To Cart" button to pay for the meeting with PayPal.
(You may also pay at the door)

 ======================================================================