XML and SQL : developing Web applications

"Dan's book provides something that the formal standards and development manuals sorely lack: a context that helps developers understand how to use XML in their own projects." --Tim Kientzle, Independent Software Consultant XML and SQL: Developing Web Applications is a guide for Web developers and database programmers interested in building robust XML applications backed by SQL databases. It makes it easier than ever for Web developers to create and manage scalable database applications optimized for the Internet. 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 SQL to create robust, data-centric systems then there is no better resource than this book. 0201657961B10152001 Integrating XML and SQL: how to get the best of both worlds!
· Demystifies the relationship between XML and SQL, and shows how to integrate them to solve problems neither can solve alone.
· Architecting robust systems that leverage both XML and SQL.
· Using SQL to overcome XML's key limitations.

As XML has rapidly gained in popularity, many database developers have become confused about its relationship with SQL and traditional RDBMS technologies. In this book, Dan Appelquist demystifies the relationship between XML and SQL, and shows exactly how to integrate these technologies for maximum advantage. XML and SQL covers every leading approach to integrating XML and SQL, helping you clearly understand each technology's strengths and weaknesses, and choose the right solution for each task or application. Drawing upon his extensive real-world experience, Appelquist offers expert guidance on: architecting robust systems that incorporate both XML and SQL technologies; using SQL to overcome XML's limitations; bringing XML's formatting capabilities to bear on SQL data, and much more. For all database developers, system architects, Web developers, content managers, and others interested in the use of XML to build robust, data-centric software systems.

Daniel K. Appelquist is an independent consultant based in London. He was formerly Director of Global R&D for Digital Channel Partners, and before that Director of Content Management for The Street.com, where he managed the process of converting all information to an XML-based system. Appelquist is also a member of the advisory council for the ICE XML-based content protocol specification. "Dan's book provides something that the formal standards and development manuals sorely lack: a context that helps developers understand how to use XML in their own projects." --Tim Kientzle, Independent Software Consultant XML and SQL: Developing Web Applications is a guide for Web developers and database programmers interested in building robust XML applications backed by SQL databases. It makes it easier than ever for Web developers to create and manage scalable database applications optimized for the Internet. 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 ServerTM 2000 The XML-specific features of J2EETM (JavaTM 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 SQL to create robust, data-centric systems then there is no better resource than this book. 0201657961B10152001 This guide for Web developers and database programmers shows how to build robust XML applications backed by SQL databases. After an overview of advantages of XML and SQL, stages of application development are detailed step-by-step, illustrated with examples of when and how each technology is most effective. Coverage includes project definition, data modeling, database schema design, and Java programming with XML and SQL. The book is intended for software developers managing small- to medium-scale projects. Appelquist is a technology consultant in content management and e-business strategy. Annotation copyrighted by Book News, Inc., Portland, OR Provides something that the formal standards and development manuals sorely a context that helps developers understand how to use XML in their own projects. Throughout, numerous concrete examples illustrate how to use each of these powerful technologies to circumvent the other's limitations. Softcover.