On CBS MoneyWatch: Dumbest Things You Do With Money
BNET Business Network:
BNET
TechRepublic
ZDNet

FREE Registration is required

Overview:

This paper focuses on ways to "Shred" XML data in DB2. Shredding is the process of mapping XML elements and attributes into relational tables and columns. One way to shred in DB2 is through the use of an annotated XML schema. If the XML data contains an XML schema, it is the easiest and fastest way to perform decomposition. If the mapping is significantly complex and involves multiple tables, existing tools automate both the mapping and decomposition steps. Another, perhaps less-known, method for shredding is through the use of the SQL/XML function XMLTABLE. It is useful when an XML schema does not exist. Using the XMLTABLE function can be more complex since the decomposition steps must be manually coded.

(Is this item miscategorized? Does it need more tags? Let us know.)

Format:HTML
Date:Jan 2008
Pages:17

People who downloaded this item also downloaded

Download TechRepublic's 2009 IT skills and salary report
White Paper Introduction to Annotated XML Schema Decomposition Using the DB2 Visual Studio 2005 Add-In: Use DB2 XML Shredding Technology
White Paper A Performance Comparison of DB2 9 pureXML and CLOB or Shredded XML Storage
White Paper 15 Best Practices for pureXML Performance in DB2
White Paper Programming With XML for DB2, Part 4: Integrate Data From Different Data Sources in Your Web-Based DB2 Application

Top results from Programming Languages

White Paper Surviving and Thriving in the Customer-Driven Age
White Paper Designing High Availability for Internet Information Services
White Paper Citizants: Bringing IT In-House
White Paper Supporting Employees Anytime, Anywhere
White Paper The Pursuit of a Standardized Solution for Secure Enterprise RBAC

» View all Programming Languages listings

advertisement

White Papers, Webcasts, and Resources

Featured Training Courses

advertisement
Click Here

SmartPlanet

Click Here

Returning users: Log In Here!

Already registered on BNET, TechRepublic, or ZDNet? Simply log in.

Free Membership: Sign Up Now!

Sign up for a free membership today and get instant and unlimited access to one of the largest databases of white papers, webcasts, and casestudies anywhere. Your FREE membership allows you to:

  • Download an unlimited amount of content, including classic and current white papers, case studies, webcasts and more
  • Track content on your chosen topics of interest
  • Receive targeted email alerts when your favorite content is added
  • Save content for future reading
  • Receive our member newsletter

When you register to access this library, you allow us to share your information with companies that produce products or services featured in the library--so that such companies may contact you with information and offers regarding their products and services. This enables us to keep the library a free service. As a library registrant, you will receive a complimentary subscription to the ZDNet white paper newsletter and e-mail Must-Read News Alerts. You can unsubscribe from these at any time. By clicking the Sign up button, you indicate that you agree to our Terms and Conditions and have read and understand our Privacy Policy (updated).