The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

Real-world Apache Derby, Part 3: Portable document storage

Store, search, and extract ODF documents using Derby and IBM DB2, Version 9

Dave Warner (david.warner@ngc.com), Senior Database Administrator, Northrop Grumman IT Solutions

Dave Warner has been working with databases since the early 1980s, focusing on business productivity and analysis. A Sun Certified Java Programmer, he's also certified in Microsoft SQL Server and works with Sybase tools extensively. He was formerly a chief technology officer at a small medical software company and presently works at Northrop Grumman IT Solutions as a senior database administrator.

Summary: Document storage is hot, hot, hot! There has been an explosion of methodologies and tool sets -- both open source and proprietary -- to fulfill the demand for quickly locating and searching documents. Enabling technologies like Alfresco, Sharepoint, or my favorite, TWiki, are powerful, but they have a fairly high learning curve -- or worse, store the documents in a proprietary format. There must be an easier way. Let's take Derby and mash it with a new feature in OpenOffice 2.0, the Open Document Format (ODF). Using these tools, you can create a repository that lets you store, search, and extract ODF documents in a standards-based manner. Also learn to use the power of the improved XML features of IBM® DB2®, Version 9 to make this solution easier to implement.

View more content in this series

Date: 06 Feb 2007
Level: Intermediate
PDF: A4 and Letter (1203 KB | 39 pages)Get Adobe® Reader®

Activity: 8451 views
Comments:

Summary

This tutorial has taken a sample document and, using only standards-based approaches, stored, searched, and retrieved it. Many of the tools mentioned in this tutorial are available at no cost and, in their turn, are becoming de facto standards. Eclipse (the new Emacs) is a joy to use, as is Apache Derby, a JDBC wunderkind. DB2, Version 9 points to the future, with pureXML making several approaches in this tutorial obsolete, but not the underlying standards. And that's the whole point, isn't it?

The fourth and final part of this tutorial series will return to working with SOX documents, completing a miniature SOX tracking application using OpenOffice.org and SQL tools.

Comments