About the Book: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.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