Congratulations to Matthias Nicola for being named the best overall speaker from the IDUG EMEA conference that took place last year in Vienna.
Here are the details for the Matthias’ presentation:
E15: The XMLTABLE Function – A Swiss Army Knife for Application Developers
What!? An entire presentation on just one SQL function? Yes! DB2 supports well over 200 functions that can be used in SQL statements, and one of them is XMLTABLE. What makes XMLTABLE different from most other functions are its powerful data transformation capabilities, its versatility, and its diverse set of use cases. Available in DB2 for z/OS and DB2 for Linux, UNIX, and Windows, the XMLTABLE function allows you to read XML data and return relational result sets to your application. Read more.
Matthias Nicola is a senior software engineer at IBM's Silicon Valley Lab, in San Jose, CA, USA. He focuses on all aspects of XML in DB2. Matthias works closely with the DB2 pureXML development team as well as with customers and business partners to help them design, optimize and implement XML solutions. Previously Matthias worked on data warehouse performance at Informix Software.
You can purchase a recording of this session by clicking here and searching for session E15.
Some other details about Matthias that you should know. Not only can he present well, but he wrote a great book too:
You can also keep up with Matthias more regularly through his blog:
Are you attending IDUG this year in Anaheim? It takes place the first week of May and if you’re attending, you can catch two of Matthias’ sessions:
E14 - The XMLTABLE Function – A Swiss Army Knife for Application Developers!
C04: Understanding and Tuning Page Cleaning in DB2
For more information about IDUG, see my blog entry: IDUG = International DB2 User Group
Install, customize, and administer the powerful FileNet enterprise content management platform
By William Carpenter
Overview of Getting Started with IBM FileNet P8 Content Manager
- Quickly get up to speed on all significant features and the major components of IBM FileNet P8 Content Manager
- Provides technical details that are valuable both for beginners and experienced Content Management professionals alike, without repeating product reference documentation
- Gives a big picture description of Enterprise Content Management and related IT areas to set the context for Content Manager
- Written by an IBM employee,William Carpenter,who has extensive experience in Content Manager product development, this book gives practical tips and notes with a step by-step approach to design real Enterprise Content Management solutions to solve your business needs
- IBM FileNet P8 Content Manager, built on top of the mature FileNet platform, is a complete, world class Enterprise Content Management platform. With its rock solid document management features, tight integration with BPM systems and other components, and rich API set, it is a highly scalable and secure solution to common and uncommon Enterprise Content Management requirements.
- Written by a FileNet insider, who is an Enterprise Content Management architect and engineer, this book is a straightforward guide to effectively install, manage, and administer FileNet P8 content Manager. It emphasizes practical, specific, and hands-on information about features for building Enterprise Content Management solutions. At every step, real-world tips and important information are called out to save you time and trouble when building customized solutions.
- Beginning with an overview of Enterprise Content Management, the book moves quickly to the matter of getting a real Content Management system up and running. You learn key Content Management applications that are demonstrated to show you the major concepts that matter you as a developer, administrator, or as an end user. There are separate chapters that describe major platform features, security-related features, and integrations with other commonly used software components. A realistic sample application, designed right infront of you unfolds the genius in IBM Filenet P8 Content Manager. Finally, you take an in-depth look at troubleshooting, support sites, and online resources to help meet your security needs.
- Master the ins and outs of the FileNet P8 platform, easily
What you will learn from this book :
- Install IBM FileNet P8 Content Manager along with its supporting components and pre-requisites
- Configure the Content Management components to make them work in unison
- Learn the building-block features and uses of Content Management and related components
- Master FileNet Enterprise Manager (FEM), the administrator’s tool, to learn the Content Manager features
- Perform various tasks in Workplace XT, one of the stand-alone, end-user applications provided with Content Manager
- Explore authentication, authorization, and other security mechanisms to meet your security needs
- Plan and deploy the components of an Enterprise Content Management platform to a real-world environment
- See how a custom application is designed and created using Content Manager APIs
The book is written in a straightforward style and avoids sales and marketing hype. William J. Carpenter is an Enterprise Content Management architect at IBM who spends every day doing product development and helping others make the best use of the Content Manager product. The numerous tips and notes arise from his years of practical experience with FileNet products.
Most of the book consists of specific recipes for installing and using Content Manager, and it also provides you with clear and precise explanations of the most important features and components. It is written in a conversational style without being “dumbed down”, and the book can be read straight through, from cover to cover. It emphasizes the things you need to know, presented in a logical progression.
Who this book is written for
If you are a CIO, an IT manager, an IT staff engineer, or perhaps a business leader, business analyst, or even an end user who wants to better understand the role that Content Manager plays in your enterprise, irrespective of any previous knowledge of IBM FileNet P8 Content Manager or Enterprise Content Management in general, then this book is a must have for you.
And if you are someone who is just starting to work with Content Management or who is facing a decision about whether to use Content Management or another solution, be assured, you will not find a better guide. Even if you have years of experience, you can still enrich your knowledge with the clear, practical explanations of basic and advanced features. Although it is not a developer’s guide, per se, the API and sample application will help you as an enterprise developer or architect to get your bearings in Content Management technologies.
Both printed book and ebook: $62.29 <---- best value
Congratulations to Bill on the arrival of his first book!
Congratulations to Tony for the upcoming publication of his first book:
Data Integration Blueprint and Modeling
Techniques for a Scalable and Sustainable Architecture
by Anthony Giordano
This is the Rough Cut version of the printed book. Rough Cuts is an interactive publishing service from Safari Books Online that provides you with first access to select pre-published manuscripts.
Data integration accounts for some 70% of the cost and risk of data warehousing and business analytics projects. Now, the leader of IBM's Global Data Integration Practice for Business Intelligence presents a complete reference architecture and best-practice blueprint for higher-quality and lower-cost data integration. Anthony Giordano shows how to build data integration processes that use standardized architectures and processes to support the capture, rationalization, and loading of exceptionally high volumes of data. He introduces data integration patterns for SOA, EAI, and ETL and covers every phase, task, and step required to build mature data integration environments.
This book also:
Provides a common and consistent method of defining and designing data integration processing environments
Shows how to implement reusable processes that reduce the size and complexity of data integration environments
Introduces graphical design techniques for data integration
Covers analysis, design, prototyping, and key information management disciplines such as metadata and data quality
Explains why data governance is crucial and how to get it right
As data analysis has become increasingly important and more tightly integrated with strategy, the processes required to combine data from different sources into meaningful information has become its own discipline. Data Integration Blueprint and Modeling is the definitive guide to that discipline.
About the Author:
Anthony Giordano leads IBM's Global Data Integration Practice for Business Intelligence (BI). He has been part of both PricewaterhouseCoopers and IBM's Global Business Services BI Senior Leadership Team and is one of the coauthors of IBM's Business Intelligence Reference Architecture and Methodology. Giordano has worked in BI and Data Warehousing for more than 20 years. He has extensive experience in both the financial services and automotive industries and has served in roles ranging from partner and consultant to team leader and programmer. He has also taught information management/data warehousing courses at the MBA level.
Neal Fishman, author of book “Viral Data in SOA”, wrote this article “When to use an artificial field length” which was published by IT World.
Changing a data structure can be one of the simplest activities to physically perform. However, when considering the number of programs that act upon a data structure, any type of change to a data structure becomes a very complex activity - which may increase the potential for introducing viral data. Read this article by Neal to better understand how you can avoid the massive problems that will ensue if you introduce viral data into your database.
Neal adapted this article from his book, so if you like it, check out the book.
The title of the book “Viral Data” implies that the book is about Data Quality… but there is much more in the book! Check out these terms that also describe the content of the book:
- data governance
- data modeling
- data quality
- master data management
- data architecture
- data integration
- data provenance
- trusted information
- data quality assessment
For more information on Neal’s book, see my blog entry about his book signing. This entry contains some reader feedback that you’ll appreciate.
Neal had several sessions at the IOD conference this year. Did you catch any of them?
- 3324A Unified Metadata Architectures for Successful Enterprise Metadata Deployments with IBM InfoSphere
- 3120A Data Governance Strategies and Their Value in Your Organization
- 2803B InfoSphere Data Architect and Data Modelers User Group
- 3324B Unified Metadata Architectures for Successful Enterprise Metadata Deployments with IBM InfoSphere
On Dec 15, you can take part in the Virtual IOD and can possibly “attend” one or more of these sessions. Sign up: IBM Information on Demand Virtual Conference on Dec 15: http://ow.ly/3iLxE
This book was recently published by Packt Publishing:
IBM Lotus Sametime 8 Essentials
A User’s Guide
Mastering Online Enterprise Cmmunicaton with this collaborative software
by Marie Scott and Thomas Duff
If you work for IBM, you know and love Sametime as much as I do. For those who don’t work for IBM and don’t use Lotus Notes as their mail server, Sametime is similar to MSN, except it is much more. I personally can’t imagine doing my job without this amazing tool!
Should you read this book? According to the back cover, this book was written for:
If you want to learn how to use IBM Lotus Sametime, then this book is for you. No matter if you’re new to Sametime or want to become a Sametime “power User”, this book contains something for you. The focus is on using Sametime as a user and does not include information about development or administration of a Sametime environment. But any user of Sametime in an organization will be able to take this book, sit down at their computer and learn how to use each feature of Sametime from start to finish.
From this description I think that anyone new to a Lotus Sametime environment would greatly benefit from reading this book. For those who already heavily use this tool, we’ll be able to enhance our skills and become more productive. For those who do not yet use Lotus products in your business, you’ll learn what power you’re missing!
I plan to read the book and hope to get tips on power functions such as:
* How to configure preferences. I’ve already been using the Primary Contacts feature and the Feed feature.
* How to customize Sametime instant messages with emoticons, text styles, graphics, attachments and hyperlinks. I’m using some of these already, but not all.
* Tips for adding voice and video to chats or meetings. This I don’t know about yet and it looks to have major promise.
* How to create and manage online meeting rooms to bring together everyone who needs to be at a specific meeting. I’ve been using online meeting rooms but need to know more about the features that available.
* Get tips on how to improve my usage.
* Connect to other users outside of our organization. This one has real potential. Right now I connect to some people via gtalk and others via MSN. Would be good to put all my business contacts in one place.
NOVEMBER is IBM Month at Packt Publishers. Save on this book or ebooks and more!
DB2 10 for z/OS - Cost Savings ..... Out of the Box
by Roger Miller, David Beulke, Julian Stuhler, Surekha
Roger, Dave, Julian and Surekha are all well known people in the z/OS community and I’m very pleased that we were able to pull the 4 of them together to write a book that will build excitement for the latest release of DB2. In addition to these fine writers / experts, we’ve also included messages from several of the top technical people in the Z area to give you some tips.
What’s in the book? Here is the executive summary:
It’s no longer enough to have IT that is robust, secure and operationally efficient: in the current business climate, it must be cost-effective. With all the key features you expect from DB2® — and new ones, like 64-bit support, scalability up to 20,000 concurrent users, and SQL and pureXML® enhancements — DB2 10 for z/OS® achieves even greater heights of availability, resiliency, reliability and security, all while creating out-of-the-box cost savings. How? Reduced CPU workloads, which directly benefit the bottom line. And that’s just the beginning.
In addition to five to ten percent CPU savings out of the box, and up to 20 percent CPU savings for new workloads, DB2 10 for z/OS also scales five to ten times more than previous versions — with less complexity and cost. Automatic tuning and diagnostics create less need for System z®-specific skills, and refined lock-avoidance techniques create greater concurrency for data access, data definition and data management.
DB210 for z/OS also offers more availability, with fewer planned outages than ever before. And the legendary security that has made DB2 the undisputed leader in enterprise data servers has been increased further, with simplified compliance. Let’s dive deeper into all the new features and enhancements that make DB2 10 z/OS the most impactful version yet.
Business Intelligence Strategy: A Framework for Achieving BI Excellence
by John Boyer, The Nielsen Company; Bill Frank, Johnson
& Johnson; Brian Green, Blue Cross, Blue Shield of Tennessee;
Tracy Harris, IBM; Kay Van De Vanter, The Boeing Company
Business Intelligence is a top priority for organizations around the world.
value of its promise is well known: BI can yield valuable insight that will
achieve competitive advantage, productivity gains, and cost savings. However,
for many organizations, achieving this type of success is difficult; user
is low, politics and culture run deep, and BI programs can be derailed by
beyond technology—often related to people and process.
To address these challenges, a team of BI professionals from leading
organizations has come together to offer practical advice and proven
for preparing a BI strategy that will help you achieve excellence in your
You will learn:
- How to create a business alignment strategy that helps prioritize business
requirements, demonstrate value, and generate a series of wins for your
- What you need to consider in your organizational and cultural strategy to
better navigate politics and culture, organize, and communicate for success
- How to deliver a technology strategy that will improve total cost of
ownership, provide greater IT efficiencies, and address factors that hinder user
IBM Cognos Analytics and Cloud Computing: Best Practices for Deploying
Cognos Business Intelligence to the IBM Cloud
by Anant Jhingran, Stephan Jou, William Lee,
Thanh Pham, Biraj Saha
This book introduces cloud computing, workloads in cloud computing, analytics as a service, and its implementation using Cognos Software and provides guidance and considerations for your cloud solution, such as “Where should the data be located” and “How many images should I create?” Step-by-step instructions on how to install, configure, secure and test a Cognos Business Intelligence deployment in the IBM Cloud are provided to help you get to a point where you have a saved private instance to an image that you can then deploy in minutes on demand.
Learn how to graduate from single images to multiple images and more complicated topologies that are better suited for production workloads and how to secure your Cognos cloud solution.
More advanced topics include moving from a single image to multiple images, scalability and performance, and how to plan for scaling to ensure a high performing solution. Finally, tip are provided to ensure that your Cognos BI cloud solution is highly available and handles failover scenarios.
We’ve just added a new book signing to our already busy schedule:
The Conversation Manager
by Steven Van Belleghem
Wednesday 1:30 – 2:15
About the book
Over the past years, the internet has evolved from a static to a social platform. This evolution has an impact on the way consumers communicate and take purchasing decisions. Unfortunately, most advertisers have failed to evolve along.
Traditional advertising no longer works. Advertisers need to change their day-to-day working methods. The gap between the contemporary consumer and the traditional advertiser is growing on a daily basis.
This era is not the end of the advertising market, though it is the end of the advertiser!
This book offers a solution to this challenge: a change trajectory from advertiser to Conversation Manager. The Conversation Manager has a fresh perspective on how brands operate successfully in cooperation with today's consumer. Conversing with consumers is the key. Listening to and conversing with consumers is a necessary talent to retrain as a Conversation Manager. Using clear examples and clear concepts, the book describes how an advertiser can retrain to become a Conversation Manager.
The book also goes beyond theory alone. It also offers practical tools to start your change process within 48 hours. You will find concrete tips to move your business strategy into the direction of conversation management. You will find numerous practical online tools to help you in your new role: the Conversation Manager.
About the author
Steven Van Belleghem is Managing Partner of innovative research agency InSites Consulting. His passion is helping clients in taking strategic marketing decisions. Steven is specialized in branding, advertising and word-of-mouth strategies. Together with his team, he’s helping companies get a grip on the current consumers through branding, advertising and conversations.
Before Steven joined InSites Consulting, he was a researcher at the Vlerick Leuven Gent Management School. Today, Steven is still a speaker at the school in a large number of executive teaching programs (e.g. brand management, marketing planning, young management program, …). Steven is also a frequent speaker on marketing conferences and business schools.
Steven is married with Evi Seymortier and has one son, Siebe. He’s a fan of good food & wine, FC Bruges and Disney.
We’ll have this session added to the SmartSite for you to add to your schedule, but in the mean time, keep this time in mind to pick up an early copy of Steven’s book. Note that according to amazon.com, this book doesn’t publish until October 30, so you’ll be getting a copy fresh from the printer!
Recently published: SOA and Web Services Interface Design: Principles, Techniques, and Standards
By James Bean
This year at the IBM Information on Demand Conference, James will be signing copies of his latest book. Jim’s signing session is scheduled for Monday, October 25 from 3:30 pm – 4:30 pm. Add this book signing to your schedule via the Smart Site Agenda Builder. His session is Anc # 3847.
About this book:
In SOA and Web Services Interface Design, data architecture guru James Bean teaches you how to design web service interfaces that are capable of being extended to accommodate ever changing business needs and promote incorporation simplicity. The book first provides an overview of critical SOA principles, thereby offering a basic conceptual summary. It then provides explicit, tactical, and real-world techniques for ensuring compliance with these principles. Using a focused, tutorial-based approach the book provides working syntactical examples - described by Web services standards such as XML, XML Schemas, WSDL and SOAP - that can be used to directly implement interface design procedures, thus allowing you immediately generate value from your efforts. In summary, SOA and Web Services Interface Design provides the basic theory, but also design techniques and very specific implementable encoded interface examples that can be immediately employed in your work, making it an invaluable practical guide to any practitioner in today's exploding Web-based service market.
- Provides chapters on topics of introductory WSDL syntax and XML Schema syntax, taking take the reader through fundamental concepts and into deeper techniques and allowing them to quickly climb the learning curve.
- Provides working syntactical examples - described by Web services standards such as XML, XML Schemas, WSDL and SOAP - that can be used to directly implement interface design procedures.
- Real-world examples generated using the Altova XML Spy tooling reinforce applicability, allowing you to immediately generate value from their efforts.
- A companion website with all artwork and code examples accompanies the book.
This is not Jim’s first book. Also from Jim:
XML for Data Architects: Designing for Reuse and Integration
Engineering Global E-Commerce Sites: A Guide to Data Capture, Content, and Transactions
DB2 pureScale: Risk Free Agile Scaling
by Paul Zikopoulos, Matt Huras, Aamer Sachedina, Paul