XML and SQL Server 2000 will enable SQL developers to understand and work with XML, the preferred technology for integrating eBusiness systems. This book will provide a comprehensive discussion of SQL Server 2000's XML capabilities. There is a brief discussion in the first two chapters on XSL/XSLT and DTD's targeted to database developers since most developers are new to this technology. From there numerous examples are discussed in the areas of IIS Directories, http, xml views and xml schemas, openxml, and much more.
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Maße
Höhe: 228 mm
Breite: 177 mm
Dicke: 20 mm
Gewicht
ISBN-13
978-0-7357-1112-9 (9780735711129)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
John Griffin is currently Senior Applications Developer for Iomega Corp. in Roy, UT. He has worked in the computer industry in one form or another since 1969. Previous experience includes contract work for Sprint-Paranet of Houston, TX, systems administration for the Department of Defense, and serving in the U.S. Navy for nine years. He holds the MCNE, MCSE, MCP+I and A+ certifications. John lives in Layton, Utah with his wife, Judith, and Australian Shepherd, Maggie.
1. XML.
The Origin of XML. The XML Document. Document Type Definition (DTD). XML Schemas. Advanced Topics. Answers to the Two Exercises in the Chapter. Recap of What Was Discussed in This Chapter.
2. XSLT Stylesheets.
Extensible Stylesheet Language Transformations (XSLT). What Are Stylesheets? Nodes and Trees, Not Documents. Stylesheet Structure. Templates. Formatting Numbers for Output. Conditional Processing. Modes. Example-An Enterprise Quarterly Fiscal Report. Recap of What Was Discussed in This Chapter.
3. IIS and Virtual Directories.
Virtual Directories. The Virtual Directory Management Utility. Creating a Virtual Directory Using the Virtual Directory Management Utility. The Virtual Directory Management Object Model. Creating a Virtual Directory Using the Object Model. Recap of What Was Discussed in This Chapter.
4. Accessing SQL 2000 via HTTP.
Two-, Three-, and N-Tiered Architectures. What Are Our Capabilities When Utilizing HTTP? Entities. Executing SQL via HTTP. Executing Template Files via HTTP. Executing Stored Procedures. Accessing Database Objects via HTTP. Posting Templates via HTML Forms. Recap of What Was Discussed in This Chapter.
5. Creating XML Views with XDR Schemas.
Overview. XDR Schemas. BizTalk. Annotations to the XDR Schema. Default Values for Schema Attributes. Using Annotated XDR Schemas in Queries. Schema Caching and Performance. Recap of What Was Discussed in This Chapter.
6. Using XPath Queries
Implementation Limitations. Differences from W3C Specification. XPath Data Types. Location Paths. Accessing Database Objects via HTTP. Recap of What Was Discussed in This Chapter.
7. FOR XML.
Syntax. FOR XML Limitations. RAW Mode. AUTO Mode. EXPLICIT Mode. Recap of What Was Discussed in This Chapter.
8. OPENXML.
Using OPENXML. Metaproperties. Recap of What Was Discussed in This Chapter.
Appendix A. Northwind Database Schema.
Table Categories. Table CustomerCustomerDemo. Table CustomerDemographics. Table Customers. Table dtproperties. Table Employees. Table EmployeeTerritories. Table Order Details. Table Orders. Table Products. Table Region. Table Shippers. Table Suppliers.
Appendix B. XSLT Instructions with Reference to Text Usage.
Appendix C. XPath Functions and Examples.
Appendix D. Microsoft XML Data Types.
Appendix E. Resources.
XML. XSLT. Namespaces. XML Schema. SQL Server 2000. Miscellaneous Resources.
Appendix F. IBM's XSL Editor.
Appendix G. Microsoft's SQL Server XML View Mapper.
Overview of XML View Mapper. How XML View Mapper Works.
Glossary.
Index.
