XML Ipedo/MSPB Presentation

1. XML.gov Ipedo/MSPB Presentation Kam Thakker Chetan Patel Alex Cheng July 21, 2004

2. XML.gov Agenda • MSPB/Ipedo Overview • Ipedo EII-related XML Technology Solution Overview • MSPB Search/Query System • Technical/Architectural Specifics

3. Ipedo’s XML Intelligence Platform (XIP)delivers Enterprise Information Integration (EII) by leveraging XML to integrate and manage information from disparate, complex data sources and enable “real-time” business decisions. Integration + Intelligence

4. Customers Life Sciences Telco Manufacturing Finance Government ISVs

5. Risk Management Financial Dashboards Mobile Applications Evaluate Request Custom assembly and conversion Assemble Query evaluated and optimized Rules checking and analysis performed Analyze Virtualize Query federated and dispatched Results returned and aggregated Reports Documents Historical Data Data Warehouses Application Data RDBs Live Data Web Services Message Data EAI and Message Queues Ipedo Creates a “Virtual Data Layer”

6. Ipedo’s Approach: XML-Driven EII • Handles relational data, documents and messages • Applies virtualization layer to make all data queryable • Makes applications format and schema independent • Supports post-integration processing and analysis • Fits with existing developer tools and skills • Provides flexible output into multiple presentation formats

7. Understanding EII

8. Example Government Applications And many others with deep XML integration and search needs

9. Ipedo XIP Key Features • XML Views • Point and click connection to JDBC and Web Services sources • XQuery Builder • Drag-and-drop query and integration • XML Rules Processing • Semantic checks on inbound and cached documents • XML Pipelines • Integrated conversion and rules on inbound processing • Flexible Caching • Configurable, persistent storage for data, queries, and results • Vertical Accelerators • XML-driven “almost applications”

10. Integration Manager • Enhanced View Technology • Real-time Access to External Data • JDBC, Web Service, and XQuery Based Views • Ipedo XML Database Instances • (XQuery views over local/remote IXD instances) • REST-style HTTP sources of XML data • LDAP Directories • Nested Views • Bi-Directional Data Synchronization • Support for HTTP and JMS • Node Level Triggers • Adapters for Oracle and DB2 • Adapter Development Kit

11. XML QUERY: declare namespace ci = "http://www.xb declare namespace air= "http://www.ip for $i in document("xbrl/airlines")/e where $i/ci:generalDocumentInformatio and $i/ci:grossProfit.salesRevenueN and $i/ci:earningsPerShare.dilutedE return <tr><td>{$ci/x:label/text()}</td> <td>{$ci/x:item[1]/text()}</td> <td>{$ci/x:item[2]/text()}</td> <td>{$ci/x:item[3]/text()}</td> </tr> XML QUERY: declare namespace ci = "http://www.xb declare namespace air= "http://www.ip for $i in document("xbrl/airlines")/e where $i/ci:generalDocumentInformatio and $i/ci:grossProfit.salesRevenueN and $i/ci:earningsPerShare.dilutedE return <tr><td>{$ci/x:label/text()}</td> <td>{$ci/x:item[1]/text()}</td> <td>{$ci/x:item[2]/text()}</td> <td>{$ci/x:item[3]/text()}</td> </tr> XQuery Rule 2 XQuery Rule 1 XML Rules Processing • Inspect XML documents and apply content-based rules • Use XQuery/XPath to perform advanced checking and combination conditions • Provide up front compliance, data quality checking, alerts • Specify value ranges • Specify compliance limits • Specify structural dependencies • Integrate with existing rules library, engines <XML> Automate manual process steps

12. XML Management Capabilities • Automatic Schema and Flexible Business-rule Validation on XML Import and Update • Queries Using XQuery and User-Defined Indexes • Indexes are data-type aware, not just text • XML in any international charset • Targeted full-text indexing • Granular (Node-Level) Updates • One operation covers many XML documents • Nodes updated without retrieving entire document • Full Transaction Support • Easy Retrieval of XML Documents by File Name • XML Document Preservation • Tag order preserved • Comments preserved • White space preserved • Schema-less Storage & Indexing of XML Documents • XML Document Versioning

13. Ipedo XQuery Implementation • Conformance with latest W3C XQuery1.0 draft (Nov 2003) • Industrial-strength XQuery engine in production for more than 18 months • Active Member of XQJ Expert Group (JSR 225 – Java API for XQuery) • Strong support for XML namespaces • Support for full text search • XQuery for information integration • XQuery Modules defined using Java or XQuery functions • Extensive XPath/XQuery function library • Highly optimized Query engine • Extends XQuery to support update operations

14. XML Schema Management • Use DTDs and W3C XML Schemas to specify types for data values • Register and manage Schemas in Ipedo’s Schema Manager • Manage change (schema migrations, evolution) using the Schema Manager Framework

15. Developer Friendly • Full Support for Standards • StrictAdherence to W3C Standards • ALL W3C XML Query Use Cases Work • Full Support for XML Schema & DTD • Broad Development Platform Support • Java (including EJB) • .NET • Web Services, SOAP • HTTP • WebDAV Support

16. MSPB Ipedo Search/Query System Demo

17. MSPB/Ipedo Search/Query screen

18. Q & A Thank You