WhitePaper
Integration of Altova Tools with IBM?? DB2?? 9 pureXML?? demonstrated via the Online Brokerage Application Scenario
Ready for
data server software
Altova, Inc. 900 Cummings Center, Suite 314-T Beverly, MA, 01915-6181, USA Tel: 978-816-1600 Fax: 978-816-1606
l l l l
l
Web: www.altova.com
Integration of Altova Tools with IBM DB2 9 pureXML
Altova?? and IBM?? WhitePaper
Integration of Altova Tools with IBM?? DB2?? 9 pureXML?? demonstrated via the Online Brokerage Application Scenario
February 27, 2008 Irina Kogan Erin Cavanaugh Liz Andrews ikogan@ca.ibm.com erin.cavanaugh@altova.com liz.andrews@altova.com
Abstract 1 Introduction 2 Background 2.1 DB2 9 pureXML 2.2 Altova Tools: XMLSpy, MapForce, StyleVision, DatabaseSpy 2.3 TPoX Benchmark: Simulated Online Brokerage Scenario 3 Integration of Altova Tools with DB2 9 pureXML 3.1 XMLSpy 3.2 MapForce 3.3 StyleVision 3.4 DatabaseSpy
3 3 4 4 4 5 6 7 7 8 8
4 Business problems solved through the integration of Altova Tools with DB2 9 9 5 Solutions to the Identified Business Problems 5.1 Migrating the customer data (CLOB to XML) 5.2 Selecting (SQL) and updating a customer document 5.3 Obtaining a partial customer profile 5.3.1 XML output (XQuery in XMLSpy) 5.3.2 CSV output (MapForce) 5.3.3 HTML table output (StyleVision) 5.4 Placing a new order (validation with FIXML) 5.5 Producing a list of securities (SQL/XML) 5.6 Issuing a change in the security schema 6 Summary About IBM and Altova References 10 10 12 15 15 17 19 22 25 26 28 28 29
?? Copyright Altova GmbH and IBM Corporation, 2008. All Rights Reserved.
2
Integration of Altova Tools with IBM DB2 9 pureXML
Altova?? and IBM?? WhitePaper
Abstract
This paper demonstrates how the deep integration of the graphical Altova tools with DB2 pureXML software can help XML developers, DBAs and end users solve real-life business problems easily and quickly. The examples from the financial industry (the online brokerage scenario) are chosen to explain and to highlight the benefits of this integration.

下一页