Sams Teach Yourself XML in 21 Days

By Steven Holzner

• Table of Contents
  • About the Author
  • Acknowledgments
  • We Want to Hear from You!
  • Introduction
  • Part I: At a Glance
  • Day 1. Welcome to XML
  • Day 2. Creating XML Documents
  • Day 3. Creating Well-Formed XML Documents
  • Day 4. Creating Valid XML Documents: DTDs
  • Declaring Attributes in DTDs
  • Day 6. Creating Valid XML Documents: XML Schemas
  • Day 7. Creating Types in XML Schemas
  • Part I. In Review
  • Day 8. Formatting XML by Using Cascading Style Sheets
  • Day 9. Formatting XML by Using XSLT
  • Day 10. Working with XSL Formatting Objects
  • Part II. In Review
  • Part III: At a Glance
  • Day 11. Extending HTML with XHTML
  • Day 12. Putting XHTML to Work
  • Day 13. Creating Graphics and Multimedia: SVG and SMIL
  • Day 14. Handling XLinks, XPointers, and XForms
  • Part III. In Review
  • Part IV: At a Glance
  • Day 15. Using JavaScript and XML
  • Day 16. Using Java and .NET: DOM
  • Day 17. Using Java and .NET: SAX
  • Day 18. Working with SOAP and RDF
  • Part IV. In Review
  • Part V: At a Glance
  • Day 19. Handling XML Data Binding
  • Day 20. Working with XML and Databases
    • XML, Databases, and ASP
    • Storing Databases as XML
    • Using XPath with a Database
    • Introducing XQuery
    • Summary
    • Q&A
    • Workshop
  • Day 21. Handling XML in .NET
  • Part V. In Review
  • Appendix A. Quiz Answers

Day 20. Working with XML and Databases

The connection between XML and databases is a natural one, and we're going to take a look at this field today. We'll also take a look at the XQuery language that is now being developed as a W3C recommendation and that is designed to work with XML and databases. In fact, today you'll use one of the few XQuery software implementations available to get all the details. Here's an overview of today's topics:

• Handling XML databases
• Using XML for database storage with Visual Basic .NET 2003
• Using XPath in Visual Basic .NET 2003 databases
• Working with XQuery
• Using XQuery to query an XML document

The way XML is implemented by database providers varies widely, which means the coverage today will be in many different areas. First, we're going to take a look at a brute-force method of working with XML and databases, and then we'll examine some integrated XML support in a database provider, and finally we'll talk about W3C's XQuery, which provides a query language (much like SQL for database applications) to work with databases from XML's point of view.

Share This