Here's another book that was just recommended to me:
Querying XMLXQuery, XPath, and SQL/XML in context (The Morgan Kaufmann Series in Data Management Systems)by Jim Melton, Stephen Buxton
Foreword by Don Chamberlin
Although the book was written BEFORE the release of DB2 9, it is an excellent product-indepentant book that can help you learn how to query the XML you wish to store in a database.
From the Back CoverThere is no more authoritative pair of authors on Querying XML than Jim Melton and Stephen Buxton. Best of all, as readers of Jim's other books know, his informal writing style will teach you what you need to know about this complex subject without giving you a headache. If you need a comprehensive and accessible overview of Querying XML, this is the book you have been waiting for.-from the foreword by Don Chamberlin, IBM Fellow, Almaden Research Center
Enjoy! Susan[Read More]
The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.
Keep on Learning
From archive: August 2006 X
svisser1 2700018UK9 4,702 Views
svisser1 2700018UK9 4,539 Views
Last month we published an ebook entitled: DB2 9: pureXML Overview and Fast StartYou can find this ebook on the redbook site: http://www.redbooks.ibm.com/abstracts/sg247298.html
This ebook is a collection of important XML articles that previously appeared on devworks, written by Cynthia M. Saracco, Don Chamberlin, and Rav Ahuja. We feel that this is the essential group of articles that you need to read to quickly become aware of how XML would benefit your company.
Here is the Table of Contents:Chapter 1. Managing XML for maximum returnChapter 2. What’s new in DB2 9: XML to the core Chapter 3. Get off to a fast start with pureXML Chapter 4. Querying XML data with SQL Chapter 5. Querying XML data with XQuery Chapter 6. Developing Java applications for XML data Chapter 7. Case study: Storebrand Foreword by Sal Vella; V.P., IBM DB2 Development:
Services Oriented Architectures (SOA) are an integral part of building an agile enterprise capable of making decisions quickly, and responding rapidly to new products and services opportunities, as well as to competitive threats. The explosive growth of XML data in businesses today across multiple industries has underscored the role of XML as the "fabric of Services Oriented Architectures" and the need to integrate XML data into enterprise information infrastructure.
DB2 9 (previously code-named “Viper”) enables an information-centric approach to service oriented architecture implementations, which rely upon the ability to access a myriad of data stored across multiple formats. With its dual pure XML data management and traditional relational data capability, DB2 9 delivers information as a service in SOA environments, connecting information on-the-fly, where you need it, and when you need it!
XML data requires the same coveted qualities of service that relational databases provide: high availability, reliability, protection, and performance. The pureXML™ technology in DB2 9 unlocks the latent potential of XML by providing simple efficient access to XML with the same levels of security, integrity, and resiliency taken for granted with relational data. With pureXML innovation in DB2 9, your organization can expect breakthrough increases in availability, speed, and versatility of your XML information, along with dramatically reduced development and administrative costs.
This IBM Redbook serves as an introduction to the hybrid XML data services in DB2 9 for Linux, UNIX, and Windows. It also provides data server professionals a fast start for using and exploring pureXML capabilities in DB2 9 and get them started with leveraging XML information for maximum return.
It isn't due to publish until December, but the excitement for this book is already increasing. Pre-order the book from amazon.com now and get a 37% discount:
IBM DB2 9 New Features (Paperback)by Paul Zikopoulos, George Baklarz, Leon Katsnelson, Chris EatonList Price: $39.99You Save: $14.80 (37%)
Part of the foreword, written by Dr. Ambuj Goyal:
As you dig into this treatise, you’ll be learning about one of the most innovative deliveries of information management capability in the last 25 years. Innovation like that doesn’t come easily. Including features like pureXML™, and “deep” compression capabilities, DB2 9 is the culmination of over 5 years of research, and comes as a result of more than 750 people and the resources from IBM research facilities collaborating across 8 countries. Our effort builds on IBM’s long string of database innovation, including the invention of relational database over 30 years ago.
You’ll learn the details of DB2 9 in this book. But just as important, each chapter attempts to position the data server innovation of DB2 9 and how that will enable the business innovation your company needs. Enjoy it!***
I've been working with all four authors for many years now and believe that they are the best people to deliver this type of information to you. I expect this book to be a very huge seller. About the authors:*Paul C. Zikopoulos, BA, MBA, is an award-winning writer and speaker with the IBM Database Competitive Technologies team. He has more than ten years of experience with DB2 products and has written numerous magazine articles and books about it. Paul has co-authored several top-selling books.*George Baklarz, B Math, M Sc (Comp Science) is a senior manager in the DB2 Worldwide Pre-sales Support Group. He works closely with customers to help them understand new Information Management technology and to gain their feedback for improving DB2 products. He has more than 20 years of experience with DB2 and has co-authored a number of books. In addition, he is a member of the International DB2 Users Group Speaker and Volunteer Hall of Fame. In his spare time, he lectures at the University of Guelph (Database Theory) and presents at a variety of user conferences, including the International DB2 Users Group.*Leon Katsnelson works in the IBM Toronto Lab where he manages a team of product managers responsible for the IBM DB2 UDB products. Leon is a recognized expert in the areas of DB2 application development and DB2 Connect. Leon has 20 years of experience with complex database and network systems. Leon has worked on DB2 Connect from very beginning and worked on this project as the product planner, development manager and product manager. He is often referred to “the father of DB2 Connect”.*Chris Eaton is Senior Product Manager for DB2 Universal Database primarily focused on planning and strategy for DB2 UDB. Chris has been working with DB2 on the Linux, UNIX, Windows platform for over 13 years. From customer support to development manager of the DB2 Control Center team to Externals Architect and now as Product Manager for DB2 UDB, Chris has spent his career listening to customers and working to make DB2 a better product. Chris is also the author of The High Availability Guide for DB2 available from Prentice Hall.*Susan[Read More]
svisser1 2700018UK9 4,479 Views
A series of webinars aimed at DB2 application developers begins tomorrow, Tuesday August 29, 2006. The first one is titled "XML and DB2": For developers who want to know how to develop XML applications in DB2, how XML works in DB2 and what the unique and essential benefits are, this is the webinar you need to attend. Specifically, the following topics will be covered:
1) How does pureXMLTM integrate with DB2 9?2) How do you develop XML applications in DB2?3) What are the unique and essential XML benefits provided by DB2 9?
Other webinars planned for this series include:
1) Rational Application Developer & DB2 - Working Together2) Using DB2 9 Developer Workbench (DWB)3) .NET Development with DB24) Perl / Zend and DB25) EGL and DB2
Following are the details for the first webinar:
DATE: August 29, 2006TIME: 11:30 Central / 12:30 EasternDURATION: 2 hoursAUDIO: Tollfree: 1-888-791-6044Toll: 1-517-623-4202Passcode: 38606
WEBCAST:Prior to conference:1) When joining the web conference, you will be asked for an IBM ID and password.2) To verify an existing IBM ID and password, please visit http://www.ibm.com/account/profile to ensure valid sign incredentials and review your registration information.3) If you need a new IBM ID and password, visit http://www.ibm.com/account/profile/us?page=reg to register.4) If this is your first IBM Web Conference, attend the special "test" meeting to make sure that you can join easily. Visit http://www.ibm.com/collaboration/collaboratenow and click "test meeting"5) IBM employees please use your intranet id and password.6) To join the conference, a Windows 2000 or Windows XP computer is required.
To join conference:1) Direct your web browser to the following URL: https://www.ibm.com/collaboration/webconferences/meetingdetails.jsp?meetingId=2CF84BA00A5CFDC45B3D6F1B0D43C0A42) When asked, enter your user name and password. Customers use your IBM ID.3) When prompted, enter the web conference password: db2ibm4) Dial into audio conference with number and passcode listed above.
Additional web conference details:Conference name: AD_WebinarPassword: db2ibm
The SOA Compass book continues to be a fast moving book. Have you had a chance to look at it yet? To download one of the chapters, see http://www.ibmpressbooks.com/bookstore/product.asp?isbn=0131870025&rl=1 This site also contains many customer reactions to the book such as this one:
"Service-Oriented Architecture offers a pathway tonetworking of intra- and inter-corporate business systems.The standards have the potential to create far more flexibleand resilient business information systems than have beenpossible in the past. This book is a must-read for those whocare about the future of business IT." –Elizabeth Hackenson,CIO, MCI
If you have access to Books 24x7 or Safari, you should be able to read this book entirely or in part electronically.
Today's electronic edition of DB2 Magazine has an article by Howard Fosdick about the IBM Business Intelligence certification exam. His article discusses the credentials required as well as directs the reader to the appropriate study materials.
Here's an intro and link to the article:
With companies clamoring for business intelligence, a certification credential can give DBAs and programmers an significantedge with employers. Certification columnist Howard Fosdick hands out the inside intel on passing IBM's DB2-based business intelligence exam.
--Read Fosdick's columnhttp://news.db2mag.com/cgi-bin4/DM/y/eycu0FlZ1Y0FLd0EhzV0AH
I'm sure you've heard about the big combined conference for the Information Management brand that is taking place this fall. If not, here are the facts about the conference:
IBM Information On Demand 2006 (http://www.ibm.com/software/data/ondemandbusiness/conf2006/), October 15-20th, 2006, Anaheim, CA IBM Information Management is hosting its first-ever global conference this year, IBM Information On Demand 2006, for business and IT executives, managers, professionals, database administrators and developers.
One event, more value IBM Information On Demand 2006 incorporates six previous Information Management conferences:IBM DB2® Information Management Technical Conference; IBM Content Management Technical Conference; Business Intelligence Customer Solutions Summit; IMS Technical Conference; Master Data Management Conference; and Information Integration Live!
By combining individual conferences into one global event, you gain access and exposure to the full breadth of IBM Information Management technologies and experts. More IBM technical and business solutions content will be in one place than ever before! Select from over 800 sessions: a 2 1/2 day business leadership track with 180 sessions and a 4 1/2 day technical track with 650 sessions.
I've just been informed that I am able to attend the conference. I'll have to find a few sessions that I'd like to attend, but my primary goal of the week will be to run a few round table discussions. There will be one about skills and another specifically for publishing. I've also been asked to help coordinate the author signings that we have set up. I've also arranged for a great giveaway at the keynote session. I may stop by to see if the certification team needs help with the exams, or maybe I'll take one or more of the new V9 exams that will be launched at the conference, and available free of charge.
Let me know if you are going and what you are most looking forward to.
Last week I received an email from a friend who was in a bookstore in the Tulsa OK airport. He found the IBM Press book "Can two rights make a wrong". Not many IBM Press books end up in bookstores, especially in airports, because they are not considered mass appeal books like a Microsoft books tend to be. But maybe this is a start!
So instead of looking for DB2 or IBM books in bookstores, try some of the great online bookstores that are available that tend to offer greatly discounted prices. Some of my favourites:
United States: http://www.ibmpressbooks.com(At checkout time, uUse the coupon code IBMSALES to get a 35% discount.)
Canada:http://www.pearsontech.ca/db2(Always a 30% discount)
Europe http://www.pearson-books.com/ibmpressbookshop/ (Always a 35% discount and free shipping to residents of EMEA.)
India:http://www.prakashbooks.com/(Search on DB2. Prices in local currency for residents of India.)
svisser1 2700018UK9 4,780 Views
Scott Ambler recently contacted me to tell me that he is now an employee of IBM working in the Rational area and that he and co-author Sadalage Pramodkumar have published a book that might be of interest to the database community. Scott gave me a copy of the book and it certainly looks interesting. Take a look at the abstract of the book and let me know what you think:
Refactoring Databases: Evolutionary Database DesignAuthors: Scott W. Ambler, Pramodkumar J. SadalageISBN: 0321293533
This comprehensive guide and reference helps you overcome the practical obstacles to refactoring real-world databases by covering every fundamental concept underlying database refactoring. Using start-to-finish examples, the authors walk you through refactoring simple standalone database applications as well as sophisticated multi-application scenarios. You’ll master every task involved in refactoring database schemas, and discover best practices for deploying refactorings in even the most complex production environments.
The second half of this book systematically covers five major categories of database refactorings. You’ll learn how to use refactoring to enhance database structure, data quality, and referential integrity; and how to refactor both architectures and methods. This book provides an extensive set of examples built with Oracle and Java and easily adaptable for other languages, such as C#, C++, or VB.NET, and other databases, such as DB2, SQL Server, MySQL, and Sybase.
Using this book’s techniques and examples, you can reduce waste, rework, risk, and cost–and build database systems capable of evolving smoothly, far into the future.
*****Save 40% on Select DB2 Books For a limited time, you can save 40% plus free US shipping on three of our most popular DB2 books. Enter case-sensitive coupon code: IBMDB2 at Step #3 during checkout to receive the discount, and complimentary shipping. Order now as this offer expires 12/31/06.