xml

Leveraging pureXML, Part 1

In the first part of this three-part series on IBM DB2 pureXML, I show you how to get started with pureXML on a DB2 Express-C 9.5 database. You learn how to create and insert XML data into a relational table, and how to query that data using SQL, SQL/XML and XQuery. Next, you learn how [...]

Author :  Joe Lennon
Joe is a 25-year-old web applications developer and technical writer from Cork, Ireland. For his day job, Joe builds web applications in PL/SQL and JavaScript for Core International, a leading provider of enterprise HR software in Ireland and the UK. Joe is also a published author, having his debut book, "Beginning CouchDB" published in 2009 by Apress. In addition, Joe is a regular contributing author to IBM's developerWorks technical library website. Joe is also contributing to a forthcoming IBM Press book, "Getting Started with .NET and DB2". Aside from software, Joe enjoys gaming, TV, eating out, motoring and frequent holidays in Spain. He lives in Cork with his girlfriend, Jill and their dog, Toby.

In the first part of this three-part series on IBM DB2 pureXML, I show you how to get started with pureXML on a DB2 Express-C 9.5 database. You learn how to create and insert XML data into a relational table, and how to query that data using SQL, SQL/XML and XQuery. Next, you learn how to expose this data to applications using Web Services in IBM Data Studio. You create a database procedure that will insert data into the database, and this is also exposed as a Web Service. In Parts 2 and 3 you will learn how to take all of this and harness it in your applications, first in an Adobe Flex application for posting status updates, and then publishing profile badges an RSS feeds using PHP. You will also learn how to push your updates to Twitter using the Twitter API.

The pureXML® capabilities of IBM DB2® allow you to store XML natively in a database without modification, while Adobe Flex applications can read XML directly and populate Flex user interfaces. In this three-part article series, you will create a microblogging application that takes advantage of pureXML, Web services, and Adobe Flex; and even allows you to publish your microblogging updates on Twitter.

Read the article at http://www.ibm.com/developerworks/xml/library/x-db2mblog1/index.html

Leave a Reply