DB2 Magazine E-Newsletter

April 23, 2003

DB2 Magazine Email Newsletter
Volume 4, Issue 4
www.db2mag.com

*****************************
This message has been sent to you as a valued subscriber of DB2 Magazine by the editors. List removal and subscription information appears at the bottom of this message.
*****************************

IN THIS ISSUE:
1. DB2 Magazine Quarter 2, 2003 Now Online
2. Remembering Relational Pioneer Edgar F. (Ted) Codd
3. DB2 Magazine Trivia Contest: Know the code to win
4. CMP NetSeminar: Java, .Net, and the Path to Data Interoperability
5. Skills and Certification News
6. At the Bookstore: IBM Data Warehousing — With IBM Business Intelligence Tools
7. Now Playing at the DB2 Developer Domain

1. DB2 MAGAZINE QUARTER 2, 2003: THE NEW BUSINESS INTELLIGENCE
Information is getting a lot of action these days — at least it soon will be. In fact, the switch from passive to active repositories of information is one of the key notions behind an emerging new approach to business intelligence (BI), according to author and consultant Michael Gonzales. Gonzales's piece on the new features coming to DB2 that will make the database more aware of online analytic processing — resulting in faster and better support for a range of BI tools — is one of the articles in this issue that sheds light on the new technologies emerging to meet changing BI needs.
http://www.db2mag.com/db_area/archives/2003/q2/gonzales.shtml

Other highlights of the issue include:
* Solving the Data Warehouse Puzzle, which explains how federation technology can help businesses meet new needs by extending their existing data warehouses
http://www.db2mag.com/db_area/archives/2003/q2/devlin.shtml

* Boosting Query Performance With Multidimensional Clustering, an overview of the new multidimensional clustering in DB2 UDB v.8.1 for Linux, Unix, and Windows
http://www.db2mag.com/db_area/archives/2003/q2/bhattacharjee.shtml

* The Power of Partitioning, which debunks misconceptions about partitioning in DB2
http://www.db2mag.com/db_area/archives/2003/q2/snow.shtml

* Plugging in to Faster Data Access, a look at changes in DB2 UDB v.8.1 that speed distributed data access
http://www.db2mag.com/db_area/archives/2003/q2/alvarez.shtml

* Effective Indexes for Data Warehouses, which presents guidelines for mastering the art of index creation
http://www.db2mag.com/db_area/archives/2003/q2/deng.shtml

* Columns on data mining, digital asset management, application platform suites, statistics reports, using programs vs. utilities, and changes in the IBM certification program for DB2 professionals
http://www.db2mag.com/

2. REMEMBERING EDGAR F. (TED) CODD, INVENTOR OF THE RELATIONAL MODEL
Relational database pioneer Edgar F. Codd died Friday in Williams Island, Fla. He was 79. Codd's 1970 paper "A Relational Model of Data for Large Shared Data Banks" launched the relational database industry. When the Association for Computing Machinery (www.acm.org) gave Codd its prestigious A.M. Turing Award in 1981, the citation credited Codd's work for providing "the impetus for widespread research into numerous related areas, including database languages, query subsystems, database semantics, locking and recovery, and inferential subsystems." You can read more about Codd's achievements in articles published April 20 in The Miami Herald and the San Jose Mercury News
The Miami Herald
San Jose Mercury News

3. DB2 MAGAZINE TRIVIA CONTEST
Do you know which IBM product provided the core code base for DB2 Universal Database for Unix, Windows, and OS/2? A correct answer means a chance to win a $100 American Express Gift Cheque.
http://www.db2mag.com/

Not sure you know the answer? DB2 Magazine editorial director Dave Stodder's interview with IBM Toronto Lab's Berni Schiefer should help
http://www.db2mag.com/db_area/archives/2003/q2/stodder.shtml

This month's trivia contest is sponsored by Quest Software.
http://www.quest.com/

4. FREE NETSEMINAR: NOT EITHER/OR, BUT BOTH: JAVA, .NET, AND THE PATH TO DATA INTEROPERABILITY
Intelligent Enterprise magazine hosts this free, interactive seminar on the impact that heated competition between Java and Microsoft's .Net environments will have on the software developers, IT architects, and database managers who must figure out how to support both. Panelists from Microsoft, Sun Microsystems, and other companies will cover critical issues in data connectivity, integration, and interoperability.

Date: Wednesday, May 7, 2003
Time: 11:00 AM - 12:00 PM PDT; 2:00 PM - 3:00 PM EDT
http://webevents.broadcast.com/cmp/wcs/index.asp?event_id=5637

5. SKILLS AND CERTIFICATION NEWS
DB2 UDB V8.1 Self-Study Guide
Advanced DBA Certification Guide and Reference for DB2 Universal Database V8.1 for Linux, Unix, and Windows, a new self-study guide available soon, helps certification candidates prepare for the DB2 UDB V8.1 for Linux, Unix, and Windows Advanced Database Administration Test, #704. For details, check the updated list of certification guides at:
http://www.db2mag.com/bookstore/certification.shtml

Free Testing Offered at the IBM Data Management Technical Conference
IBM is offering free DB2 UDB professional certification testing at the Data Management Technical Conference, October 27-31 in Las Vegas. For information or to register, go to:
http://www-3.ibm.com/services/learning/conf/us/dm/

Henry Kissinger to Speak at IBM Software Symposium
Dr. Henry A Kissinger, former U.S. Secretary of State and a Nobel Peace Prize winner, will deliver a keynote address at the IBM Software Symposium in Munich, Germany, May 19-23. The event offers more than 300 courses on all aspects of IBM's software portfolio, including software development with IBM's newly acquired Rational technologies.
http://www-3.ibm.com/events/symposium2003/index.html?&ca=symposium&me=W&met=de_swhp

For event listings and education resources, go to:
http://www.db2mag.com/education/

6. AT THE BOOKSTORE
IBM Data Warehousing — With IBM Business Intelligence Tools
by Michael L. Gonzales

In IBM Data Warehousing, Michael Gonzales shows how to exploit IBM technologies to get the most from data warehouse investments. These technologies include everything from SMP and MPP technical architectures to DB2 UDB and DB2 OLAP Server. Gonzales, a DB2 Magazine contributor, provides an in-depth look at the BI fundamentals and architecture, data management, and enhanced analytics, plus tips, tricks, and workarounds for maximum performance. Key topics include DB2 features that support BI and data warehousing; IBM technologies for managing warehouses; project management techniques for prioritizing BI iterations and reducing risk; and OLAP, data mining, and spatial analysis. A companion Web site provides links to vendors, technical notes, and other reference material.
http://www.db2mag.com/bookstore/

7. NOW PLAYING AT THE DB2 DEVELOPER DOMAIN
Ask the Experts: Peggy Abelite answers questions about DB2 stored procedures
http://www7b.software.ibm.com/dmdd/library/techarticle/0303abelite/0303abelite.html

Debugging Java Stored Procedures on DB2 for OS/390 and z/OS
http://www7b.software.ibm.com/dmdd/library/techarticle/0303rader/0303rader.html

SQL Reference for Cross-Platform Development (New Version)
http://www7b.software.ibm.com/dmdd/library/techarticle/0206sqlref/0206sqlref.html

Putting Your DB2 Database to the Test: Measuring Performance with JMeter
http://www7b.software.ibm.com/dmdd/library/techarticle/0303bhogal/0303bhogal.html

Parsing Strings in SQL
http://www7b.software.ibm.com/dmdd/library/techarticle/0303stolze/0303stolze1.html

Making Operating System Calls from SQL
http://www7b.software.ibm.com/dmdd/library/techarticle/0303stolze/0303stolze.html

Which Edition of DB2 Connect is Right for You?
http://www7b.software.ibm.com/dmdd/library/techarticle/0303zikopoulos1/0303zikopoulos1.html

SUBSCRIBE TO DB2 MAGAZINE
If you like what you read in this newsletter, you'll love DB2 Magazine.
It's free. It's filled with expert advice.
Don't miss a single issue issue. Sign up today!
http://www.db2mag.com/subscribe/

Get your own copy of this DB2 Email delivered directly to your inbox each month.
http://www.db2mag.com/newsletter/