Querying XML XQuery, XPath and SQLXML in Context

Description

XML has become the lingua franca for representing business data, for exchanging information between business partners and applications, and for adding structure- and sometimes meaning-to text-based documents. XML offers some special challenges and opportunities in the area of search: querying XML can produce very precise, fine-grained results, if you know how to express and execute those queries. For software developers and systems architects: this book teaches the most useful approaches to querying XML documents and repositories. This book will also help managers and project leaders grasp how "querying XML" fits into the larger context of querying and XML. Querying XML provides a comprehensive background from fundamental concepts (What is XML?) to data models (the Infoset, PSVI, XQuery Data Model), to APIs (querying XML from SQL or Java) and more. * Presents the concepts clearly, and demonstrates them with illustrations and examples; offers a thorough mastery of the subject area in a single book. * Provides comprehensive coverage of XML query languages, and the concepts needed to understand them completely (such as the XQuery Data Model). * Shows how to query XML documents and data using: XPath (the XML Path Language); XQuery, soon to be the new W3C Recommendation for querying XML; XQuery's companion XQueryX; and SQL, featuring the SQL/XML * Includes an extensive set of XQuery, XPath, SQL, Java, and other examples, with links to downloadable code and data samples. Querying XML: XQuery, XPath, and SQL/XML in Context......Page 1 1558607110......Page 5 Content......Page 8 Foreword......Page 18 Preface......Page 20 Part I: XML: Documents and Data......Page 30 1.2 Adding Markup to Data......Page 32 1.3 XML-Based Markup Languages......Page 43 1.4 XML Data......Page 48 1.5 Some Other Ways to Represent Data......Page 50 1.6 Chapter Summary......Page 57 2.1 Introduction......Page 60 2.2 Querying Traditional Data......Page 61 2.3 Querying Nontraditional Data......Page 68 2.4 Chapter Summary......Page 72 3. I Introduction......Page 74 3.2 Navigating an XML Document......Page 75 3.3 What Do You Know about Your Data?......Page 90 3.4 Some Ways to Query XMLToday......Page 92 3.5 Chapter Summary......Page 93 Part II: Metadata and XML......Page 94 4.1 Introduction......Page 96 4.2 Structural Metadata......Page 98 4.3 Semantic Metadata......Page 104 4.4 Catalog Metadata......Page 107 4.5 Integration Metadata......Page 111 4.6 Chapter Summary......Page 113 5.1 Introduction......Page 114 5.2 DTDs......Page 115 5.3 XML Schema......Page 129 5.4 Other Schema Languages for XML......Page 144 5.5 Deriving an Implied Schema from a DTD......Page 148 5.6 Chapter Summary......Page 149 6.1 Introduction......Page 152 6.2 What Is the Infoset?......Page 153 6.3 The Infoset Information Items and Their Properties......Page 154 6.4 The Infoset vs.the Document......Page 162 6.5 The XPath 1.0 Data Model......Page 165 6.6 The Post-Schema-Validation Infoset (PSVI)......Page 167 6.7 The Document Object Model (DOM) — An API......Page 171 6.8 Introducing the XQuery Data Model......Page 175 6.9 A Note Regarding Data Model Terminology......Page 176 6.10 Chapter Summary and Further Reading......Page 178 Part III: Managing and Storing XML for Querying......Page 180 7.1 Introduction......Page 182 7.2 Transforming, Formatting, and Displaying XML......Page 183 7.3 The Relationships between XML Documents......Page 192 7.4 Relationship Constraints: Enforcing Consistency......Page 214 7.5 Chapter Summary......Page 220 8.1 Introduction......Page 222 8.2 The Need for Persistence......Page 223 8.3 SQL/XML's XMLType......Page 235 8.4 Accessing Persistent XML Data......Page 236 8.5 XML on the Fly: Nonpersistent XML Data......Page 238 8.6 Chapter Summary......Page 240 Part IV: Querying XML......Page 242 9.1 Introduction......Page 244 9.2 XPath 1.0......Page 246 9.3 XPath 2.0 Components......Page 281 9.4 XPath 2.0 and XQuery......Page 287 9.5 Chapter Summary......Page 288 10.1 Introduction......Page 290 10.2 A Brief History......Page 291 10.3 Requirements......Page 293 10.4 Use Cases......Page 298 10.5 The XQuery 1.0 Suite of Specifications......Page 304 10.6 The Data Model......Page 309 10.7 The XQueryType System......Page 326 10.8 XQuery 1.0 Formal Semantics and Static Typing......Page 335 10.9 Functions and Operators......Page 342 10.10 XQuery 1.0 and XSLT 2.0 Serialization......Page 348 10.11 Chapter Summary......Page 356 11.1 Introduction......Page 358 11.2 Overview of XQuery......Page 359 11.3 The XQuery Processing Model......Page 362 11.4 The XQuery Grammar......Page 367 11.5 XQuery Expressions......Page 368 11.6 FLWOR Expressions......Page 409 11.7 Error Handling......Page 422 11.8 Modules and Query Prologs......Page 423 11.10 XQuery for SQL Programmers......Page 431 11.11 Chapter Summary......Page 432 12.1 Introduction......Page 436 12.2 How Far to Go?......Page 437 12.3 The XQueryX Specification......Page 445 12.4 XQueryX By Example......Page 446 12.5 Querying XQueryX......Page 462 12.6 Chapter Summary......Page 466 13.1 Introduction......Page 468 13.2 Full-Text......Page 469 13.3 Update......Page 507 13.4 Chapter Summary......Page 524 14.1 Introduction......Page 526 14.2 Alphabet-Soup Review......Page 527 14.3 XQJ — XQuery for Java......Page 532 14.4 SQL/XML......Page 549 14.5 Looking Ahead......Page 550 15.1 Introduction......Page 552 15.2 SQL/XML Publishing Functions......Page 555 15.3 XML DataType......Page 566 15.4 XQuery Functions......Page 569 15.5 Managing XML in the Database......Page 601 15.6 Talking the Same Language — Mappings......Page 602 15.7 Chapter Summary......Page 609 Part V: Querying and The World Wide Web......Page 612 16.1 Introduction......Page 614 16.2 Markup Languages......Page 615 16.3 Discovery on the World Wide Web......Page 626 16.4 Customized Query Languages......Page 631 16.5 Chapter Summary......Page 633 17.1 Introduction......Page 634 17.2 What Is Internationalization?......Page 635 17.3 Internationalization and the World Wide Web......Page 636 17.4 Internationalization Implications: XPath, XQuery, and SQL/XML......Page 647 17.5 Chapter Summary......Page 650 18.1 Introduction......Page 652 18.2 Finding Structured Data — Databases......Page 653 18.3 Finding Stuff on the Web — Web Search......Page 654 18.4 Finding Stuff at Work — Enterprise Search......Page 667 18.5 Finding Other People's Stuff — Federated Search......Page 669 18.6 Finding Services — WSDL, UDDI,WSIL, RDDL......Page 670 18.7 Finding Stuff in a More NaturaI Way......Page 673 18.8 Putting It All Together — The Semantic Web+......Page 674 A.1 Introduction......Page 676 A.2 Example Data......Page 677 A.3 Some Examples from the Book......Page 727 A.4 A Simple Web Application......Page 758 A.5 Summary......Page 778 B.1 Introduction......Page 780 B.2 World Wide Web Consortium (W3C)......Page 782 B.3 Java Community Process (JCP)......Page 786 B.4 De Jure Standards: ANSI and ISO......Page 790 B.5 Summary......Page 798 C.2 XQuery Grammar......Page 800 C.3 SQL/XML Grammar......Page 808 C.4 Chapter Summary......Page 817 Index......Page 818 About the Authors......Page 844