Posts

Working with XML in Databases


More and more users are storing XML documents in database columns, especially when XML data is sent or received from other entities. Storing data in XML helps enterprises more easily accommodate revisions to industry-standard data formats as XML Schemas evolve over time. One challenge in migrating from a relational database to an XML-oriented database application is developing queries that replace traditional SQL queries of relational data to parse XML documents stored in the database. We recently had an opportunity to address XQuery for XML in databases in a presentation titled Altova Tools for DB2® in a teleconference sponsored by IBM® for the pureXML™ Devotees user group. After an introduction and brief background on Altova, we focused on the special functionality included in XMLSpy to manage XML Schemas in DB2 and to edit XML data stored in DB2. The XMLSpy Database Query Window makes it easy to edit XML database content directly in XMLSpy. XMLSpy_editDB2_blog Altova has built specialized capabilities for deep integration of Altova tools with the DB2 pureXML data server to help customers working with XML, XML Schema, XQuery, and other XML-related technologies. We demonstrated the XMLSpy XQuery editor, XQuery debugger and XQuery profiler, with support for executing XQuery scripts directly against the DB2 database and for the special DB2 xmlcolumn and sqlquery operators. We closed the presentation with a walk-through of the steps a user can take to migrate legacy relational data to an XML-based application, including inferring an XML Schema from relational data in a table in DB2, then importing data from the table and automatically tagging it in XML according to the new XML Schema. We have uploaded a PDF file the slides from the presentation on SlideShare. You can also get a copy at the IBM pureXML Devotees page, where you can listen to the recorded audio as well. The best way to experience for yourself how well the features of XMLSpy, MapForce, StyleVision, and DatabaseSpy work with DB2 and other databases with XML is to click here to download a free trial of the Altova MissionKit.

Tags: , , , , , , ,

New DatabaseSpy Video: Exploring Databases


We’ve just launched the third video in the DatabaseSpy series. Exploring Databases is a tour of the DatabaseSpy Online Browser, a powerful tool for viewing, searching, and analyzing one or more connected databases. Exploring Databases demo Exploring Databases builds on the preceding video, Database Connections, which demonstrated how easy it is to use DatabaseSpy to connect to one or more databases. You can even simultaneously connect to databases of different types. And DatabaseSpy supports the most popular databases in production today, including Microsoft SQL Server, IBM DB2, Oracle, Sybase, MySQL, and more. Once you’re connected, the DatabaseSpy Online Browser shows you an expandable hierarchy of the database structure. It’s a great place to start exploring an unfamiliar database or quickly navigate to any specific element you need to work with in a familiar one. The Altova Flash videos are proving to be a popular feature on our Web site, with close to 350,000 views in all. If you haven’t seen an Altova product video yet, you’re missing a great opportunity to get a flavor for components of the award-winning Altova MissionKit by seeing them in action. If you’re already a fan, check back again soon — we’re in the studio working on more videos right now.

Tags: , , , , , , ,

White Paper: Reaping the Benefits of pureXML with Altova Tools


The IBM® DB2® data server offers a scalable and reliable information infrastructure that provides seamless integration of XML and relational services. Now with the deep integration of Altova tools and DB2 9, users can query, exchange, transform, and edit their XML artifacts more quickly, easily, and accurately.
Demonstrated using an online brokerage scenario, this white paper shows how the integration of Altova tools with DB2 allows users to:

  • Design and perfect XQuery statements faster, with real-time validation for a faster and more robust design time experience.
  • Preview, edit, and validate XML data stored in the database with just a few clicks
  • Easily manage XML Schemas in the DB2 9 Schema Repository
  • Map XML data from the database to a CSV file or convert it to an HTML table or other format

The solutions to the business problems presented in the white paper show how DBAs and developers working with real-world XML applications can benefit from the integration of Altova tools with IBM DB2 9.
Access the white paper here to read more about these solutions and view screenshots: https://www.altova.com/resources_wp.html#ibm_whitepaper

Get more information about using Altova tools when working with IBM DB2 9 pureXML here: https://www.altova.com/IBM_DB2_9_pureXML.html

Download a free 30-day trial of the Altova MissionKit here: https://www.altova.com/download.html, and see how working with XML-related technologies in DB2 9 is enabled by Altova tools.

Tags: , , ,

Altova XMLSpy Earns IBM CTO Innovation Award Certificate of Excellence


Altova, (www.altova.com) creator of the industry-leading XMLSpy XML Editor and other leading XML, data management, UML, and Web services tools, today announced that Altova XMLSpy received a 2007 IBM CTO Innovation Award Certificate of Excellence for its deep integration with the IBM DB2 9 data server. Altova XMLSpy provides users with exclusive functionality for querying, editing, transforming, and exchanging XML data stored in DB2 9 databases. The CTO Innovation Award Certificate was presented in conjunction with the second annual Information Management Business Partner Awards at the IBM Information on Demand conference held October 14-19 in Las Vegas, NV.

Tags: , ,

Altova Releases German Language Version of DatabaseSpy 2008


VIENNA, Austria, 6 November 2007 – Altova, (www.altova.com) creator of the industry-leading XMLSpy XML Editor and other leading XML, data management, UML, and Web services tools, today announced that Altova DatabaseSpy 2008 is now available in a German language version. Like its English counterpart, the German edition of DatabaseSpy connects to all major databases, easing SQL editing and database structure design, for a fraction of the cost of single-database solutions. DatabaseSpy supports IBM DB2 (including IBM pureXML), Microsoft SQL Server, Microsoft Access, Oracle, MySQL, and Sybase, as well as other ADO or ODBC databases.

Tags: , , , , , ,