Keep on Learning
From reading this article Database Vendors Improve XML Handling it is clear that at least the database vendors are thinking about XML!
I've been thinking about XML as well. With my job, I try to anticipate learning needs and attempt to have books published in order to help specifically with these needs. Up till now, publishers are reluctant to sign on new XML books as they feel that the market is saturated with good books already, and nothing more is needed. According the publisher, "There must be a gazillion books on XML." One of the best sellers is XML for the World Wide Web, but this published in 2000... can it really be useful to someone who stores and accesses XML from a relational database? I assume that there is some overlap, but is this book sufficient?
When I was selling books in Athens, one of the best selling books was XML Demystified. Personally I think that the only reason we sold out of this book was because it was the only book we had that had XML prominently in the title!
Pat Selinger was our keynote speaker for the conference, and the two recommendations she made to the attendees was for them to learn XML and Content Manager. Immediately after her session ended, there was a line up of people at the bookstore looking for books on both of these topics. So, it wasn't a surprise to me that people went for the book with XML in the title even though some of the other books contained more relevant XML information for this audience.
Matthias Nicola, one of IBM's XML experts, did a quick review of several books regarding the XML content that they contained. For starters, he wasn't very impressed with the TOC of the Demystified book saying that much of it wasn't applicable or pertinent for a database user.
DB2 9 New Features, has limited coverage of DB2 pureXML but doesn't cover DB2 9.5 features. It has four chapters on XML: Chapter 1 is a general introduction to what XML is, and chapter 2 compares XML to relational, etc. That leaves chapter 3 for an introduction of some of the key concepts of DB2 pureXML, more like a overview. Chapter 3 gives you a basic understanding of pureXML and gets you started. Chapter 4 presents 11 performance guidelines.
DB2 9 for Linux, UNIX, and Windows DBA Guide, Reference, and Exam Prep limits XML coverage to one chapter.
The soon-to-be-published book Understanding DB2: Learning Visually with Examples has about 90 pages covering XML. It spends the first 25 pages introducing XML, namespaces, XML schemas, comparing XML to relational, and discussing the old V8 options for managing XML. The remaining 65 pages are condensed but cover most of the relevant pureXML features, including 9.5 features. However, due to the limited length, this chapter does lack depth in some areas, such as XML updates, SQL/XML publishing, and others topics.
So... when I hear this analysis of the existing XML information, it leads me to believe that a book IS needed to help people learn what they need to know to store and access XML using DB2... and perhaps other databases as well. Let me know what you think. Should I fight for such a book to be published? I'd like to hear from you to know what you think.
Beyond published books, IBM has provided many articles and IBM Redbooks on XML, including:
DB2 9 pureXML GuideThis IBM Redbook discusses the pureXML data store, hybrid database design, and administration. It describes XML schemas, industry standards, and how to manage schemas. Also covered are SQL/XML, XQuery, and XPath using easy-to-understand examples. Lastly, the book shows how to use XML technology efficiently in business applications.
DB2 9: pureXML Overview and Fast StartThis 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.
DeveloperWorks Articles including:
* A performance comparison of DB2 9 pureXML and CLOB or shredded XML storage * Get started with Industry Formats and Services with pureXML * Using industry standard data formats with WebSphere ESB and DB2 Version 9 pureXML * DB2 and Ruby on Rails, Part 2: DB2 and pureXML with Ruby on Rails * Document-level security using DB2 9 pureXML and LBAC* 15 best practices for pureXML performance in DB2 9 * Generate Web services for DB2 9 pureXML* XML data solutions with xfy and DB2 9, Part 1: Use pureXML to get the full value of your data * pureXML in DB2 9: Which way to query your XML data?
by Toby Teorey, Sam Lightstone, Tom Nadeau, and H.V. Jaqadish
Published Feb 24, 2011.
(Note that the amazon.com price is currently 40% off the regular price. Not sure how long this will be the case, so if you want the book, buy it soon!)
Yes, the 5th edition! A book only gets updated this often if it is REALLY good and REALLY popular. Have you read any of the editions yet? I’ve seen the book for sale at conferences, but haven’t read it yet.
A whole chapter devoted to XML and web databases. What you need to know to utilize XML rather than relational tables.
A whole chapter describing Object Relational Design. Learn how to make a choice between what is in the database as a BLOB and what is outside in a separate file.
About the book:
Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs?
I copied a couple of reviews from amazon.com to give you an idea of the book’s value:
"Database Modeling and Design is one of the best books that I have seen for explaining how to build database applications. The book is informative, well-written, and concise."-Michael Blaha, DSc., Consultant, Modelsoft Consulting Corp
"This book book is by far the best book available on classic database design. Topics like normalization and many-to-many and n-ary association semantics are without peer in teaching you how to model real-world complexities. This latest edition extends the classic material with extensive discussion of modern tools and other aspects of logical database design. Every database architect should have this book at hand."-Bob Muller, Data Analyst, Poesys Associates
About the authors:
I only know author Sam Lightstone, so let me tell you a bit about him. He works in the IBM Toronto Lab and is a master inventor in the database area. Last year he published his first non-database book, called “Making it Big in Software”. The book is quite successful and is highly recommended if you are in the software business in any role.
Here are some previous blog entries about Sam & his Making it Big book:
I've been posting information about the DB2 Certifications in the past couple of weeks and am very pleased with the interaction I've been receiving on several LinkedIN groups that I'm a member of. The two most active groups that I posted information in were DB2 Professionals and IDUG The World Wide DB2 User Community.
A couple of the comments were about how difficult the Advanced DBA exam was. Here is my response that I want to share with everyone:
Here's another book I'm adding to my reading list:
Here is the information from the back cover of the book:
You can get a discounted copy of this book and meet the author, Jay Baer at the IBM InterConnect Conference on Wednesday, February 25 from 5:10 pm -6:00 pm at the conference bookstore.
Other books that will be featured at the conference with book signings are:
It’s time for the annual IBM Press book sale, which is on from now until Friday December 28, 2012. This is a perfect time to stock up on great books that will help you become more effective at your job. Here’s a list I put together along with reasons why you’d want to read this book.
40% off from IBM Press:
—save 40% on print books, eBooks, and videos during our this Sale. Also, as a special reward for purchasing, you will automatically receive one free month's access to Safari Books Online via email confirmation. Use discount code HS2012 and start shopping now!
Reminder: If you’re in Europe, find these books are featured on the www.pearson-books.com/ibmpressbookshop website that offers 35% off and free shipping within the UK. Shipping fees to the rest of Europe are not free, but very small. Be sure to bookmark this page and share with others who buy technical books in Europe.
Yesterday I was a last minute attendee / booth girl for the BMODUG event that was taking place down the road from my office. I met up with many people I already knew (Tim Johnson, Yvonne Kulker, Joe Borges, Susan Lawson and Melanie Stopfer), but also met quite a few new people. I strongly encouraged the new people to take a look at my blog, so I'll do a short recap today.
At the booth, I was handing out DB2 Gaming DVDs. For those who were not able to get a copy here is the site ibm.com/software/data/education/games.html where you can learn more about the games and also where you can download what you need to play or share the games. Happy Gaming!
I also had a few copies of a DVD that was created last year that contained a bunch of IBM Redbooks. Although it is nice to have a DVD with all this content, it is best to get the IBM Redbooks from the website as you can be sure that the content is most current.
Pearson Education Canada supplied the postcards that provided a Canadian website for you to purchase IBM Press books. The offer is for a 35% discount. Books that you might want to consider from this site are: IBM Press in Canada.
Understanding DB2(R): Learning Visually with Examples (2nd Edition) The book is the best way to learn (or relearn) DB2 for Linux, Unix and Windows. The book is filled with case studies, study questions, and well-written details on everything you'll need to know. Some competitively trained people who have read this book have told me that this is exactly what they needed to take the fear out of switching to DB2!
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep, 6th Edition This is the one book that all DBAs should have on their bookshelf. This book was written by George Baklarz and Paul Zikopoulos, two very well-known DB2 experts who know how to write a good book! The book is the best guide and reference that you can own and will surely be one of the most used books on your bookshelf.
Enterprise Master Data Management: An SOA Approach to Managing Core Information I mentioned this book to a few people yesterday. This is beyond a database topic... but is really insightful as to how data can be managed effectively throughout an industry... I read the book in draft form about a year ago and am surprised with the amount that I've been able to retain. I highly recommend this book if you are looking for a place to go beyond data.
I helped a few people with some certification questions that I have... and since today is testing day, I hope everyone does well on their exams! The best places on the web to go to are:
1) To help you decide where to start, see the certification roadmaps: ibm.com/software/data/education/cert-roadmaps.html.
2) For a breakdown of the exam objectives and the recommended study materials, see ibm.com/software/data/education/certprep.html
Many people were interested in the information I was giving about the ILO classes that are now available. ILO = instructor-led online and means that you sit at your desk at home or work and take part in an actual class via your computer (headphones and mic absolutely essential). You interact with the instructor and the other classmates as you would if you were sitting in a class with them, but you do it without needing to travel! There are 70 different ILO classes now available, some are short and take place in the evening, but others are full day classes. For all information, see: Instructor-Led Online Training. See also a recent blog entry that I wrote.
And finally, community! You are all community, so consider joining one of the groups on ChannelDB2.com:
DB2 in Books
I've listed every published book in this discussion group and I encourage you to use this as a way to reach the authors or to find related information such as events that the authors are taking part in, podcasts or webinars that are related to the book topic, and so on....
DB2 for Linux, UNIX, Windows
This is a place where you can find information about anything related to DB2 for LUW. Feel free to add discussions for areas that are not yet created. I've created a few discussions that you might find useful, including information about the latest ILO courses or current promotions that are being offered.
DB2 for z/OS
Same as the one above, only content is specific to the z platform.
I just started this group to be a collection of the many things that are happening at the IOD conference. With so much information being sent on a daily basis in regards to the conference, isn't it nice to have one spot that collects that information? And better yet, this is a place where you can share your thoughts on events that are taking place at the conference.
What do you think? Worth checking out? I hope so. When you're a member, make me a friend! A girl can never have too many friends!
svisser1 2700018UK9 Tags:  book author iod11 signing conference infosphere data warehouse 6,581 Views
Author Robert Laberge is flying in from Ireland to meet people who are interested in having him sign copies of his book at the IBM Information on Demand 2011 Conference. Come to the Conference bookstore Tuesday October 25 from 10:30 – 11:30 am to meet Bob. Soon you’ll be able to add this signing and others to your Smart Site schedule.
by Robert Laberge
What’s in the Book?
In The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights, business intelligence and data warehousing expert Robert Laberge explains the components and different alternatives in building a data warehouse and describes pros and cons for choosing one path over another. Building a data warehouse is unique for each organization but can be guided by the author’s years of knowledge obtained from working on many differing data warehouse and business intelligence environments in organizations around the world.
The book covers practical and technical aspects of current data warehouse and business intelligence issues with views on realistic solutions within the management and technical arenas. Data warehousing topics are first presented from a high-level overview to ensure the terminology and context is understood, and are then covered in deeper detail to clarify the specifics. These topics all pertain to data warehousing, business intelligence, and performance management.
The Data Warehouse Mentor
About the Author
Robert Laberge is a lead principle consultant for the IBM Industry Models and Assets Lab in Dublin which focuses on data warehousing and business intelligence solutions. He has helped more than 50 large organizations in 20 countries by mentoring, training, and demonstrating data warehouse and business intelligence solutions, including Target, Qwest, ING, Mayo Clinic, Canadian Tire, Shoppers Drug Mart, BMW, Korea Telecom, Scotiabank, Capital One, Reliance Infocomm, and Tata Group. Robert has a Masters of Business Administration from the University of Durham (UK) and has nearly 30 years of experience in IT.
Proven strategies for implementing the right data warehouse and business intelligence solutions for current and future business needs: order the book now!
Other Warehouse events taking place at IOD:
The best way to find out the warehouse specific sessions that are available at IOD this year is to review the roadmaps that were put together to guide you. Here is the mega list!
Other blog entries about IOD Events:
Check out this great offer by IBM Press (Pearson Education):
Free, 250-page Data Management and Architecture eSampler that offers chapters from six books on topics including :
Chapter 4: Enterprise Information Architecture: A Conceptual and Logical View
Chapter 3: A Design Technique: Data Integration Modeling
Chapter 5: MDM Architecture Patterns
Chapter 1: Viral Data
Chapter 5: Elements of BI Solutions: The End User Experience
Chapter 2: Mining Customer Interactions
If you’ve been wondering about the content of these 6 books, getting this sampler is a great way to preview the content so you can determine whether you want to read the entire book. I have a Kindle and preview all of the books I purchase. You should no longer find yourself purchasing a book only to find out once you get home that it isn’t what you thought it would be.
If you like to “Try before you buy”, also consider the offer for trying education classes before you sign up for them.
You haven’t tried ebooks yet? Go outside your comfort zone with an ebook, you’ll be glad you did!
A database expert is in a critical position to become a hero in this big data era. Why? Because you know data.. you know your database. Now you need to know how to expand your knowledge to find the secrets lying dormant in your awesome data.
To help you, I'm posting this podcast which is a conversation between database expert & IBM champion Jean-Marc Blaise and Big Data expert Leon Katsnelson. Perhaps you have the same question? Listen & find out!
Beyond this podcast, we have many other resources available to help you with your learning curve.
First I’ll start with some excellent books.
I thought the book was very well written and covered the history of data, the advent of big data, and what we need to do differently to profit in this new era.
Yes, things will be different. As the author hinted and IBM CEO Ginny stated, big data is like oil was in the industrial age. Lots of things changed then to cope with the precious resource and it is no different now.
The stories about current big data successes are inspirational and the authors make it clear that the untapped potential of data is massive. Don't let this potential slip out of your hands. Learn what you can now to see what you can harness from this incredible asset you have in your hands.
I highly recommend the book. It is a quick read. If you only have time for 1 chapter, read chapter 10. It does a nice job of summarizing all the concepts and issues introduced in the book.
by Paul Zikopoulos, David Corrigan, Tom Deutsch, Krishnan Parasuraman, James Giles, Dirk Deroos
Provides an overview of the IBM Information Management Big Data platform. It’s intended for a broad audience, ranging from those who are brand new to Big Data, to those on the business and management side, to architects, and to developers who want a glimpse into the technical details that underpin this platform.
by Dr. Arvind Sathi
This book discusses three perspectives on Big Data Analytics. First, why is Big Data Analytics becoming so important and what can we do with it. Second, it lists major components of Big Data Analytics - Unstructured Data Analytics, Massively Parallel Processing, Adaptive Real-time and Predictive Modeling, Data Privacy Management, Data Visualization, and Ontologies. Third, it provides a glimpse at implementation concerns and how they must be tackled.
I’ve written a few blog entries in the past few weeks that summarizes blog entries and articles that come recommended in your journey to learn about Big Data:
Likely the best place for you to keep up to date with all the great things that are happening from a Big Data perspective is the Big Data Hub. The breadth of content that you’ll find here will keep you busy for some time. Let me tell you, you’ll be an expert in Big Data very quickly!
Upcoming events to mark on your calendar:
Before March 25 - Tell us your most important big data issues in a fun with with IBM’s Smart Sixteen - Big Data Style! See Big Data Bracketology for a description of the “Smart Sixteen” teams in the big data dance by the four regions.
March 27 at 12:00 noon ET - Join us for our next tweetchat which takes place on Wednesday, March 27 at 12:00 noon ET. Topic is "In-Memory for Big Data Management" with panelists: James Kobielus, analysts from Wikibon and SiliconANGLE, and IBM Champions Alex Philp, Cristian Molaro, Craig Mullins, Cuneyt Goksu and others.
April 30 - Big Data at the Speed of Business - Find out more about managing big data, join IBM for a free event.