Friday, April 07, 2006

DB2 Viper

DB2 Viper is the code name for the next release of DB2. DB2 Viper can handle both relational and XML data. In what it terms as "native XML", the XML data is stored in a parsed heirarchical format rather than requiring it to be transformed into row and column format or store it as a large object. The new storage structure will enable you to query the database using XQuery or SQL. You can download the beta version on the DB2 Viper download site. The administrators can use standard SQL data definition language statements to create database objects to store relational and XML data, and this can be done in a single statement. For example, to create a table with an XML column, you can make the query as follows:

create table case (
 caseNumber  varchar(10) 
                        primary key not null,
 status          varchar(10), 
 schedule varchar(30),
 county   varchar(10),
        arraignmentNotice xml
)
Since the XML data is self-describing, you don't have to give additional information with it. It will be accepted as long as it is well-formed. You can also create an XML index to speedup your searches of the XML data. This requires the index key to defined using an "xmlpattern", which is an XPath expresssion (no predicates, ofcourse) to identify the subset of the XML document. You will also have to specify the SQL datatype represented by the subset selected by the XPath expression. For example:

create index caseIndex on case(arraignmentNotice)
generate key using xmlpattern '/arraignmentNotice/date' 
as sql DATE
The following is a list of the features provided with DB2 Viper
  • Efficient storage techniques for managing XML data in hierarchical format.
  • Support for indexing XML data
  • Support for XQuery as well as SQL (with XML extensions) to query XML data
  • Support for validating XML data using schemas
  • API support for popular languages like Java, C, COBOL and .NET platform
  • An Eclipse based developer's workbench which includes a graphical XQuery builder.
Additional references:
Posted by at
Labels: ,

1 comment:

Subscribe to: Post Comments (Atom)

Popular Posts

  • Using Quartz Scheduler in a cluster
    In a previous post, I described how to use Quartz scheduler for scheduling . In this post, I describe the configuration changes required for...
  • Unit Testing with JUnit 4.0
    JUnit 4 introduces a completely different API to the older versions. JUnit 4 uses Java 5 annotations to describe tests instead of using in...
  • Data Access with Spring and JPA
    The JDBC abstraction layer of Spring framework offers an understandable exception hierarchy, simplifies error handling, and greatly reduces ...
  • Deploy Java Web Application on Heroku with Heroku CLI
    This post will describe how to create and deploy a Java Web Application war to Heroku using Heroku CLI. You will need a basic understanding ...
  • Implementing JMS with Spring: Messaging Client
    Last week, I described how to implement JMS, using a stand-alone client and a Message Driven Bean . In this post and the next, I will descr...
  • Merge PDF files using iText 5
    This is an example code for a simple PDF merge using iText 5. We use three InputStream s in a List as input and merged file is written to th...
  • Implementing JMS with Spring: Message Driven POJO
    The previous post described how to implement a JMS messaging client using Spring JMS . This post will describe how to implement the Message ...
  • Struts 2: Validation
    Update: A new post for validation in struts with annotation is available at: Struts 2 Validation: Annotations . Struts 2.0 relies on a val...
  • Merge PDF files with iText
    New posts with iText 5.5.12 Following are two new posts for PDF Merge with iText 5.5.12 Merge PDF files using iText 5 Merge and Paginate PDF...
  • Merge and Paginate PDF files using iText 5
    In this post we will see a way to merge multiple PDF files while adding page numbers at the bottom of each page in the format Page 1 of 10 ....