XML and SQL: Developing Web Applications [Paperback]

Daniel K. Appelquist (Author)

Book Description

ISBN-10: 0201657961 | ISBN-13: 978-0201657968 | Publication Date: December 16, 2001 | Edition: 1

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.

Editorial Reviews

From the Back Cover

"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

About the Author

Daniel K. Appelquist is an independent technology consultant specializing in content management and e-business strategy. While at TheStreet.com, he built a content management solution using XML and SQL and then went on to be CTO for TheStreet.co.uk. At E-Doc, he built SGML-based solutions for publishers such as John Wiley & Sons and Macmillan Press to put journals such as Cancer and Nature online. He has spoken at Seybold, Xtech, and other events, and has been active on the Advisory Committee of the W3C and in the Open Group's Mobile Management Forum. In addition, he has served as an advisory member of the ICE protocol group and is on the Advisory Board of Kinecta Corporation.

0201657961AB10152001

See all Editorial Reviews

Product Details

• Paperback: 256 pages
• Publisher: Addison-Wesley Professional; 1 edition (December 16, 2001)
• Language: English
• ISBN-10: 0201657961
• ISBN-13: 978-0201657968
• Product Dimensions: 9.1 x 7.3 x 0.7 inches
• Shipping Weight: 1.1 pounds (View shipping rates and policies)
• Average Customer Review: 3.0 out of 5 stars  See all reviews (1 customer review)
• Amazon Best Sellers Rank: #1,333,579 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

14 of 15 people found the following review helpful:

3.0 out of 5 stars Good on XML, short on SQL, June 9, 2002

By 

David Williams "I.T. consultant" (Newcastle, NSW, Australia) - See all my reviews
(REAL NAME)   

This review is from: XML and SQL: Developing Web Applications (Paperback)

I have mixed feelings about this book.

On the one hand, it is easy to read, with a strong sense of humour throughout and a crisp layout.

Yet, on the other, it falls short, I believe, of its presumed goal of being a practical and invaluable reference for Web developers wanting to enhance sites with back-end databases.

The book kicks off with a detailed overview and explanation of XML, moving on through discussions of project management, data modelling, XML design, XML stylesheets, and developing database schemas. These chapters are easily accessible, largely due to the author's humour.

Yet, two concluding chapters are where, I feel, the book falls down - integrating XML with SQL Server 2000, and integrating XML with Java.

The depth of these chapters is visibly lacking, especially when contrasted to the earlier coverage of just what XML is. Indeed, these chapters weigh in at 29 and 19 pages respectively - rather puny when one considers that the title of the book is "XML and SQL".

I wouldn't want to make any unfair assumptions, but it seems to me the author is far more of an "XML guy" than, say, a "database guy" or a "programming guy". Indeed, the back cover credits say he is active on the Advisory Committee of the W3C, and it is clear from the text that he is knowledgeable about XML down to the fine detail of its mandated implementation.

However, there is nothing to give confidence that he is equally a master of SQL and the book is definitely unbalanced in its coverage.

Ultimately, I believe "XML and SQL" holds value as a good-humoured guide to XML and its implementation. It would even serve well as an academic textbook, if supplemented with practical exercises.

Unfortunately, though, I do not believe it serves professional programmers well.