Xml and SQL

The author offers an understanding of the many advantages of both XML and SQL and provides practical information and techniques for utilizing the best of both systems. The book explores the stages of application development step by step, featuring a real-world perspective and many examples of when and how each technology is most effective.

Specific topics covered include:

• Project definition for a data-oriented application
• Creating a bullet-proof data model
• DTDs (document type definitions) and the design of XML documents
• When to use XML, and what parts of your data should remain purely relational
• Related standards, such as XSLT and XML Schema
• How to use the XML support incorporated into Microsoft's SQL Server™ 2000
• The XML-specific features of J2EE™ (Java™ 2 Enterprise Edition)

Throughout this book, numerous concrete examples illustrate how to use each of these powerful technologies to circumvent the other's limitations. If you want to use the best part of XML and SQLcreate robust, data-centric systems then there is no better resource than this book.

• Introduction
• Acknowledgments
• About the Author
• Ch. 1 Why XML? 1
• Ch. 2 Introducing XML and SQL: A History Lesson of Sorts 11
• Ch. 3 Project Definition and Management 25
• Ch. 4 Data Modeling 49
• Ch. 5 XML Design 63
• Ch. 6 Getting Relational: Database Schema Design 89
• Ch. 7 Related Standards: XSLT, XML Schema, and Other Flora and Fauna 115
• Ch. 8 XML and SQL Server 2000 129
• Ch. 9 Java Programming with XML and SQL 157
• Ch. 10 More Examples: Beyond Silly Web Sites 179
• Appendix 201
• Bibliography 209
• Index