DDXQ 2.0 Release Overview

1
Jonathan Robie Nancy Vodicka
2
Webinar Details

• To ask a question during the presentation, type
  it in the QA box.
• A link to the recorded presentation and slides
  will be emailed after the event.
• Teleconference details are

3
DataDirect XQuery 2.0
4
XML from Relational, XML
Jonathan lio
            companynameAmazon.com, Inc.       
 7780    ny            meeBay Inc.        22600        y ticker"IBM"        Int'l
Business Machines C        evenues128200       
         Prog
ress Software        s493.4    o
5
XML from Relational, XML
Jonathan lio
            companynameAmazon.com, Inc.       
 7780    ny            meeBay Inc.        22600        y ticker"IBM"        Int'l
Business Machines C        evenues128200       
         Prog
ress Software        s493.4    o
      let user
doc("request.xml")/performance/userid    for h
in collection("holdings")/holdings,         c
in collection("companies")/companies    where
h/userid eq user and c/ticker eq
h/stockticker    return      ticker" c/ticker "         c/companyname
         c/annualrevenues        
 
6
DataDirect XQuery

• DataDirect XQuery is a high-performance,
  scalable, embeddable XQuery implementation
• that plugs easily into any Java architecture
  and accesses almost any data source
• without being dependent on underlying servers
  or proprietary extensions to XQuery.

MySQL coming soon
7
XQuery for the Java platform

• Pure Java implementation
• Any Java platform
• Any J2EE application server or no server
• Easily embeddable installs like JDBC driver
• XQuery API for Java (XQJ) JDBC-like API for
  XQuery

8
Input and Output

• Relational Databases
• SQL Server 2000, 2005
• Oracle 9i, 10gR1, R2
• DB2 W/U/L  8.x
• DB2 iSeries  v5r2, v5r3
• DB2 z/OS  8
• Sybase  12.5.x, 15
• XML sources
• http ftp and file schemes
• XML in DOM trees
• Drastically reduced memory requirements for large
  XML documents.
• Legacy sources
• Adapters for CSV, EDI, and more

• XML Output
• XML as text
• XML in DOM trees
• XML in SAX streams
• XML in StAX streams

9
Stylus Studio IDE
10
plugin for Eclipse (DataDirect Edition)
11
DataDirect XQuery Benefits

• Productivity
• High level query language less code to write
  and maintain
• Supported by Stylus Studio IDE
• Supported by plugin for Eclipse
• Performance
• Query optimization
• Very selective SQL queries for relational sources
• Relational joins done in the database
• Document projection and streaming for XML sources
• Lazy evaluation and retrieval
• Generally outperforms hand-written code using
  JDBC and Java XML APIs
• Flexibility
• Supports almost all major relational databases
• Easily embeddable in any Java application, on any
  platform, with or without a J2EE application
  server
• Extensible (external Java or SQL functions,
  custom URI resolvers, )

12
XQuery 2.0 Release Highlights

• Performance and Scalability Enhancements
• Enhanced SQL performance, more extensive
  performance suite
• Enhanced XML query performance
• XML Document projection and streaming (improves
  performance, dramatically reduces memory required
  for large XML input)
• Additional pragmas allow user to configure
  performance options
• XML Deployment Adapters
• Query flat-file, EDI, or many other formats as
  though they were XML
• Files are converted on the fly
• Enhanced support for external Java functions
• Additional Database Support
• Updated XQuery Support
• XQuery Candidate Recommendation (November, 2005)
• Now supports XQuery modules
• Tested against the W3C XQuery Test Suite

13
Database throughput
14
Queries that Build Hierarchies
15
XMark Q1 Performance
16
XMark Q1 Memory consumption
17
XML Deployment Adapters
ISA00DATADIRECT00STYLUS200601DATA DIRECT
01STYLUS STUDIO 060504121200503200654321
0I' GSBFDATADIRECTSTYLUS20062006050412121
2256X005030' ST1053389' BGN28102420060504
121212GM' NM12L4Progress Software
Corporation' N314 Oak Park Drive' N4BedfordMA0
1730USAA' REF1ZPRGS' NM12L4Apple Computer,
Inc.' N31 Infinite Loop' N4CupertinoCA95014US
AA' REF1ZAAPL' SE113389' GE1256' IEA12006
54321'
18
XML Deployment Adapters
ISA00DATADIRECT00STYLUS200601DATA DIRECT
01STYLUS STUDIO 060504121200503200654321
0I' GSBFDATADIRECTSTYLUS20062006050412121
2256X005030' ST1053389' BGN28102420060504
121212GM' NM12L4Progress Software
Corporation' N314 Oak Park Drive' N4BedfordMA0
1730USAA' REF1ZPRGS' NM12L4Apple Computer,
Inc.' N31 Infinite Loop' N4CupertinoCA95014US
AA' REF1ZAAPL' SE113389' GE1256' IEA12006
54321'
      for requestedCompany
in doc("adapter//EDI?ticker-request.edi")/X12/TS_
105/GROUP_2    return      let companyInfo
collection("statistical")/statisticalticker eq
requestedCompany/REF/REF02      return        
"           companyInfo/companyname
           companyInfo/annualrevenues
                      
requestedCompany/N3/N301/text()
             requestedCompany/N
4/N401/text()             
requestedCompany/N4/N402/text()
             requestedCompany/N4
/N403/text()             
requestedCompany/N4/N404/text()
                    
19
Customer Scenarios
20
DataDirect XQuery

• DataDirect XQuery is a high-performance,
  scalable, embeddable XQuery implementation
• that plugs easily into any Java architecture
  and accesses almost any data source
• without being dependent on underlying servers
  or proprietary extensions to XQuery.

MySQL coming soon
21
Gevity Integrate SF.com w/Oracle

• Users Gevity Business Development Managers
• Purpose Quickly produce price quotes
• Data Human Resource Data in Oracle 9i, customer
  and prospect data in SalesForce.com
• Can manage accounts from any internet connection
  home, office, prospects office, or any Wi-Fi
  hot spot
• Deliver through many agents browser, cell
  phone, blackberry, etc

22
Summary

• The Challenge?
• Working with XML relational data
• Increasingly difficult for developers to keep up
  with peculiarities in proprietary XML tools
• Why XQuery?
• Based on a standard
• XQuery is best for manipulating data as XML
• XQuery and XQJ integrates easily into their
  environment
• XQuery simplifies merging relational and XML
• Why DataDirect XQuery?
• Lives in middle tier with the application
• Supports Oracle 9i with XQuery, not available
  from Oracle
• Stable product
• Follows standard closer than other
  implementations
• Interface similar to JDBC integrates easily into
  their architecture
• XML Editor for Eclipse wanted an IDE
  to help with learning curve of new language
• First class support for help with queries and
  tuning
• DataDirects length of time in market and
  financial stability

23
To read more

• Check out the Gevity case study
• www.datadirect.com/products/xquery/docs/gevity_cas
  e.pdf

24
Integrating XML Relational
We are integrating ACORD messages with the data
from our customer policy and insurance databases.
Need to process insurance claims and policies
Oracle9i, 10g
Customer Policy Insurance Data
25
Summary

• The Challenge?
• Software vendor working with XML relational
  data
• Data in Oracle 9i/10g, MS SQL Server, and DB2
  databases
• Must work with any Application Server and cannot
  be limited by any other software (must be easily
  embeddable)
• Why XQuery?
• XQuery is best for working with relational and
  XML data, no conversions
• Simplified merging relational and XML
• Develop application faster
• Performance is better than other technologies
• Why DataDirect XQuery?
• Supports multiple database versions (for example,
  Oracle 9i and 10g)
• Provides database vendor independence
• Easily embeddable requires no other platforms or
  products
• XQJ interface easy to use

26
Integrating Other Data Sources
Reporting Application using XQuery
27
Summary

• The Challenge?
• Working with XML, relational data, and other data
  sources
• Why XQuery?
• XQuery allows you to query anything that can be
  represented as XML, no need for conversions
• Simplifies application development (easier, less
  code)
• Why DataDirect XQuery?
• Can query XML, relational, and other data sources
• Comma/Tab/Character Separated Values
• dBase
• HTML
• RTF
• EDI.. and a lot of them (X12, EDIFACT, IATA)
• Custom URI resolvers for proprietary data sources
• Scalable and performs very well compared to other
  solutions.
• No other software limitations and requires no
  other software/platform purchases.

28
Querying Large XML files
XML from web service
Transient Reporting Data
29
Summary

• The Challenge?
• Out of memory errors with XML files (100MB)
• Why XQuery?
• Transient reporting data is XML
• XQuery simplifies application development
• Why DataDirect XQuery?
• Only product theyve found that doesnt get out
  of memory errors processing their XML files
  (3-5G)
• Performance compared to other XQuery products
  such as open source is very good often half the
  time or less.

30
Customer Benefits

• Why do customers choose DataDirect XQuery?
• Productivity
• The easiest way to develop applications/reports
  when dealing with various data sources
  (relational, XML, and legacy data sources).
• Dramatically reduced development time over
  alternative approaches.
• Less maintenance effort (cheaper).
• Stability for developers through our
  standards-based XQuery and XQJ implementations.
• XML tools for query development and testing to
  get developers productive quickly.
• Performance
• Faster execution time with XQuery as compared to
  other technologies.
• Special optimization, mediation best possible
  XQuery performance.
• XML streaming drastically reduces the amount of
  memory required when processing large XML
  documents.
• Flexibility
• Easily embeddable does not require any other
  product or application server.
• Freedom from database vendor and database version.

31
To ask a question now, type it in the QA box.
A QA document will be emailed after the session.