Skip to main content


developerWorks  >  Open source | Information Management  >

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

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

developerWorks

Level: Intermediate

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

06 Feb 2007

Register now or sign in using your IBM ID and password.

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.

Objectives

Discover how to manipulate ODF documents using Java™ frameworks shipped with the Java 2 Platform, Standard Edition (J2SE) Development Kit (JDK), such as java.util.zip and Java Architecture for XML Binding (JAXB), along with techniques for handling Binary Large Object (BLOB) data on disk and in the Derby database.

Prerequisites

You should be reasonably comfortable with standard Java tools and have a smattering of SQL experience. The ability to install and configure a Java Virtual Machine (JVM), Apache Ant or Eclipse, and Derby is required.


System requirements

To run the examples in this tutorial, you need the following:

  • JVM
  • Approximately 100MB-200MB of free space, depending on your choice of tool set
  • At least 64MB of RAM for your virtual machine (VM)

Download and install the following programs:



Duration

Under 2 hours


Formats

html, pdf


Share this....

digg Digg this story del.icio.us del.icio.us Slashdot Slashdot it!


Back to top


Document options

Document options requiring JavaScript are not displayed


My developerWorks needs you!

Connect to your technical community


More in this series:
Real-world Apache Derby