XML and SQL: Developing Web Applications / Edition 1

XML and SQL: Developing Web Applications / Edition 1

by Daniel K. Appelquist, Daniel K. Applequist
     
 

ISBN-10: 0201657961

ISBN-13: 9780201657968

Pub. Date: 12/28/2001

Publisher: Addison-Wesley

"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

Overview

"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

Product Details

ISBN-13:
9780201657968
Publisher:
Addison-Wesley
Publication date:
12/28/2001
Edition description:
1 ED
Pages:
256
Product dimensions:
7.40(w) x 9.20(h) x 0.60(d)

Table of Contents

Introduction.

Who Should Read This Book?

Why Would You Read This Book?

The Structure of This Book.

My Day Job in the Multimodal World.

Acknowledgments.

About the Author.

1. Why XML?

The Lesson of SGML.

What About XML?

Why HTML Is Not the Answer.

The Basics of XML.

Why You Don't Need to Throw Away Your RDBMS.

A Brief Example.

Great! How Do I Get Started?

Summary.

2. Introducing XML and SQL: A History Lesson of Sorts.

Extensible Markup Language (XML).

Evaluating XML's Design Goals.

Structured Query Language (SQL).

What Is “Relational”?

Fitting It All Together.

Summary.

3. Project Definition and Management.

An Illustrative Anecdote.

How to Capture Requirements.

CyberCinema: The Adventure Begins.

Requirements Gathering.

User Scenarios.

Functional Requirements Document.

Quality Assurance.

Unit Testing.

Integration Testing.

Project Management.

Dynamic Systems Development Method (DSDM).

Extreme Programming!

The Technical Specification Document.

Summary.

4 Data Modeling.

Getting Data-Centric.

Show Me the Data!

What Do You Hope to Accomplish?

Making It Visual: Entity Relationship Diagrams.

Roll Film: Back to CyberCinema.

Normalization Equals Power: Defining Relationships.

Keep It Simple: No Really, I Mean It.

Getting Complex: Many-to-One and Many-to-Many Relationships.

Another Layer of Complexity: Adding Media.

Summary.

5. XML Design.

Carving Your Rosetta Stone.

When to Use XML and When Not to Use It.

Think Like an Archeologist.

Building a DTD.

CyberCinema: The Rosetta Stone Meets the Web.

The Head.

The Body.

Building XML DTDs: Let the Experts Do Hard Stuff.

Summary.

6. Getting Relational: Database Schema Design.

Knowing When to Let Go.

First Steps.

SQL and XML: The Joys of Partial Decomposition.

Decomposing CyberCinema.

XML Nitro Injection: Adding Reviews.

Link Management.

Selecting What You Need.

Using Link Management to Help Power Suggestions.

Summary.

7. Related Standards: XSLT, XML Schema, and Other Flora and Fauna.

XSLT: XML Transformers!

So How Does XSLT Work Exactly?

XML Schema: An Alternative to DTDs.

Querying XML Documents.

XML Query.

SQLX: The Truth Is Out There.

Summary.

8. XML and SQL Server 2000.

Contributed by JJ Kuslich.

Retrieving Data in XML Format.

FOR XML.

FOR XML AUTO.

FOR XML EXPLICIT.

Communicating with SQL Server over the Web.

Under the Hood.

Retrieving Data in XML Format-Continued.

SQL Queries in URLs.

Template Files.

XPath Queries.

HTTP Post Queries.

XML Views.

Defining XML Views.

Let SQL Server Do the Work.

Working with XML Documents.

OPENXML.

Summary.

9. Java Programming with XML and SQL.

Dealing with XML in Java.

Building Java Objects for XML Instances with DOM.

Using SAX Events to Drive XML Partial Decomposition.

Invoking XSLT Transformations.

Designing an Entity Bean for Movie Reviews.

To Transform or Not to Transform.

JDBC, JNDI, and EJBs.

JNDI.

Bean Persistence.

JDBC Advanced Data Types.

On the Near Horizon: XML Data Binding.

J2EE Application Servers.

Summary.

10. More Examples: Beyond Silly Web Sites.

Building a Web Service.

Corporate Phone Directory.

Stock Quotes.

E-Commerce.

Taxonomical Structure.

Document Management and Content Locking.

Versioning and Change Management.

Summary.

Appendix.

Bibliography.

Index. 0201657961T11282001

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >