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"

Full Product Details

Author:   Daniel K. Appelquist
Publisher:   Pearson Education (US)
Imprint:   Addison Wesley
Dimensions:   Width: 23.30cm , Height: 1.60cm , Length: 18.60cm
Weight:   0.408kg
ISBN:  

9780201657968

ISBN 10:   0201657961
Pages:   256
Publication Date:   19 December 2001
Audience:   College/higher education ,  Tertiary & Higher Education
Format:   Paperback
Publisher's Status:   Out of Print
Availability:   Out of stock  

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

Reviews

Author Information

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

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions