DB2 Forum 2008 Third Quarter Meeting

When:
Thursday, August 28, 2008
08:00-Noon

Meeting Location:
Doubletree Hotel Dallas
4099 Valley View
Dallas, TX 75244
Phone 972.385.9000

Meeting Cost: $10 for non-members, free to members. Membership is $25 per year per person --or-- $100 for 5 people in a company --or-- $350 for unlimited people in a company. You can register at the meeting.

This meeting is sponsored by IBM .

First Speaker
Burt Vialpondo - International Business Machines


Presentation Overview
What the DB2 9.5 DBA and Developer needs to know about pureXML
Learn why DB2 9.5 pureXML is the easiest to use and yet most powerful implementation of XML in a database anywhere. We'll explore why the industry uses XML and what 'pure native storage' really means. Learn about XML storage parsing, XML nodes and regions and basic DML usage against XML. Learn how to insert, load, import and index XML and how DB2 supports XML with various utilities and functionality. Get an introduction of xQuery and understand XSD registering in an XML schema repository. Also get an overview of advanced XML techniques. Finally, learn how DB2 pureXML compares to the Oracle XML DB. This session will also include a demo of DB2 9.5 pureXML.


Speaker Biography


Burt Vialpando has over 24 years IT experience and has worked for IBM for 10 of those years working on database migration related projects. He currently performs technical presales Oracle to DB2 migration work and has conducted over 70 Proof of Technology sessions to over 1,000 Oracle & SQL Server DBAs. An author of man y articles, papers and other assets, he holds many DB2, Oracle and other IT certifications and has multiple IBM patent filings and publishings.

Second Speaker
Mark Wilson - International Business Machines


Presentation Overview
Searching Unstructured Text in DB2 for z/OS: When LIKE Isn't Good Enough

Everyone has 'well-behaved' textual data: city, state, employee last name, and so forth, which are easy to search using SQL. But what about the unstructured data like medical diagnoses and treatments or insurance agent claim notes -- EQUAL or LIKE predicates don't fit the bill very well in these cases, especially if the search terms are not at the beginning of the data in the column. DB2 9 for z/OS introduces a robust solution: the IBM Text Search for DB2 for z/OS feature. This feature allows a DB2 for z/OS user to issue SQL statements to satisfy familiar text search queries on data that is stored in a DB2 database. This presentation describes the previous solutions and their short-comings, and includes: DB2 Text Search architecture, Administration, SQL, Data sharing support, and Recovery considerations.

Speaker Biography

Mark Wilson works throughout North America providing consultation and education, drawing on a broad range of experience from 21 years as a DB2 specialist, and 28 years with IBM. Mark recently concluded leading the customer beta program for IBM's newest mainframe database technology, DB2 V9.1 for z/OS, in the US and Canada. He works with the IBM DB2 Technical Sales force to enable customers to migrate and provides expert knowledge and advice. He fulfilled a similar role with the Version 7 and Version 8 programs. Formerly, in the IBM Advanced Technical Support (Dallas Systems Center) organization, as well as his prior projects in IBM Global Services, he has focused on systems and application performance design reviews, data sharing implementation (installation, performance and recovery), DB2 security, and DB2 locking. In addition, he has extensive experience as an educator, having taught both formal DB2 classes for IBM, as well as customized education for customers and DB2 user groups.