Muutke küpsiste eelistusi

DB2 pureXML Cookbook: Master the Power of the IBM Hybrid Data Server [Kõva köide]

5.00/5 (2 hinnangut Goodreads-ist)
,
  • Formaat: Hardback, 792 pages, kõrgus x laius x paksus: 240x185x45 mm, kaal: 137 g
  • Ilmumisaeg: 27-Aug-2009
  • Kirjastus: IBM Press
  • ISBN-10: 0138150478
  • ISBN-13: 9780138150471
Teised raamatud teemal:
  • Kõva köide
  • Hind: 64,66 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
DB2 pureXML Cookbook: Master the Power of the IBM Hybrid Data ServerSuurem pilt
  • Formaat: Hardback, 792 pages, kõrgus x laius x paksus: 240x185x45 mm, kaal: 137 g
  • Ilmumisaeg: 27-Aug-2009
  • Kirjastus: IBM Press
  • ISBN-10: 0138150478
  • ISBN-13: 9780138150471
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780138150471.html
Märksõnad:
DB2 pureXML Cookbook

Master the Power of the IBM Hybrid Data Server

 

Hands-On Solutions and Best Practices for Developing and Managing XML Database Applications with DB2

 

More and more database developers and DBAs are being asked to develop applications and manage databases that involve XML data. Many are utilizing the highly praised DB2 pureXML technology from IBM. In the DB2 pureXML Cookbook, two leading experts from IBM offer the practical solutions and proven code samples that database professionals need to build better XML solutions faster. Organized by task, this book is packed with more than 700 easy-to-adapt recipe-style examples covering the entire application lifecyclefrom planning and design through coding, optimization, and troubleshooting. This extraordinary library of recipes includes more than 250 XQuery and SQL/XML queries. With the authors hands-on guidance, youll learn how to combine pureXML ingredients to efficiently perform virtually any XML data management task, from the simplest to the most advanced.

 

Coverage includes

 





pureXML in DB2 9 for z/OS and DB2 9.1, 9.5, and 9.7 for Linux, UNIX, and Windows Best practices for designing XML data, applications, and storage objects Importing, exporting, loading, replicating, and federating XML data Querying XML data, from start to finish: XPath and XQuery data model and languages, SQL/XML, stored procedures, UDFs, and much more Avoiding common errors and inefficient XML queries Converting relational data to XML and vice versa Updating and transforming XML documents Defining and working with XML indexes Monitoring and optimizing the performance of XML queries and other operations

Using XML Schemas to constrain and validate XML documents XML application developmentincluding code samples for Java, .NET, C, COBOL,PL/1, PHP, and Perl

 
Introduction
1(14)
Anatomy of an XML Document
2(2)
Differences Between XML and Relational Data
4(3)
Overview of DB2 pure XML
7(3)
Bnefits of DB2 pureXML over Alternative Storage Options for XML data
10(1)
XML Solutions to Relational Data Model Problems
11(2)
When the Schema Is Volatile
12(1)
When Data Is Inherently Hierarchical in Nature
12(1)
When Data Represents Business Objects
12(1)
When Objects Have Sparse Attributes
13(1)
When Data Needs to be Exchanged
13(1)
Summary
13(2)
Designing XML Data and Applications
15(12)
Chossing Between XML Elements and XML Attributes
15(4)
XML Tags versus Values
19(3)
Choosing the Right Document Granularity
22(2)
Using a Hybrid XML/Relational Approach
24(1)
Summary
25(2)
Designing and Managing XML Storage Objects
27(48)
Understanding XML Document Trees
28(2)
Understanding pureXML Storage
30(3)
XML Storage in DB2 for Linux, Unix, and Windows
33(8)
Storage Objects for XML Data
33(3)
Defining Columns, Tables, and Table Spaces for XML Data
36(4)
Dropping XML Columns
40(1)
Improved XML Storage Format in DB2 9.7
40(1)
Using XML Base Table Row Storage (Inlining)
41(7)
Monitoring and Configuring XML Inlining
43(4)
Potential Benefits and Drawbacks of XML Inlining
47(1)
Compressing XML Data
48(3)
Examining XML Storage Space Consumption
51(2)
Reorganizing XML Data and Indexes
53(1)
Understanding XML Space Management: A Comprehensive Example
54(3)
XML in Range Partitioned Tables and MDC Tables
57(2)
XML and Range Partitioning
57(1)
XML and Multidimensional Clustering
58(1)
XML in a Partitioned Database (DPF)
59(1)
XML Storage in DB2 for z/OS
60(5)
Storage Objects for XML Data
61(2)
Characteristics of XML Table Spaces
63(1)
Tables with Multiple XML Columns
64(1)
Naming and Storage Conventions
64(1)
Utilities for XML Objects in DB2 for z/OS
65(6)
Report Tablespaceset for XML
67(1)
Reorganizing XML Data in DB2 for z/OS
68(1)
Check Data for XML
69(2)
XML Parsing and Memory Consumption in DB2 for z/OS
71(2)
Controlling the Memory Consumption of XML Operations
71(1)
Redirecting XML Parsing to ziiP and zAAP
72(1)
Summary
73(2)
Inserting and Retrieving XML Data
75(22)
Inserting XML Documents
76(6)
Simple Insert Statements
76(3)
Reading XML Documents from Files or URLs
79(3)
Deleting XML Documents
82(1)
Retrieving XML Documents
83(2)
Handling Documents with XML Declarations
85(1)
Copying Full XML Documents
86(1)
Dealing with XML Special Characters
87(2)
Understanding XML Whitespace and Document Storage
89(6)
Preserving XML Whitespace
91(2)
Changing the Whitespace Default from ``Strip'' to 11Preserve''
93(1)
Storing XML Documents for Compliance
94(1)
Summary
95(2)
Moving XML Data
97(28)
Exporting XML Data in DB2 for Linux, UNIX, and Windows
98(8)
Exporting XML Documents to a Single File
98(2)
Exporting XML Documents as Individual Files
100(2)
Exporting XML Documents as Individual Files with Non-Default Names
102(1)
Exporting XML Documents to One or Multiple Dedicated Directories
102(2)
Exporting Fragements of XML Documents
104(1)
Exporting XML Data With XML Schema Information
105(1)
Importing XML Data in DB2 for Linux, Unix, and Windows
106(3)
Import Command and Input Files
107(1)
Import/Insert Performance Tips
108(1)
Loading XML Data in DB2 for Linux, Unix, and Windows
109(2)
Unloading XML Data in DB2 for z/OS
111(3)
Loading XML Data in DB2 for z/OS
114(2)
Validating XML Documents during Load and Insert Operations
116(1)
Splitting Large XML Documents into Smaller Documents
116(2)
Replicating and Publishing XML Data
118(2)
Federating XML Data
120(1)
Managing XML Data with HADR
121(1)
Handling XML Data in db2look and db2move
122(1)
Summary
123(2)
Querying XML Data: Introduction and XPath
125(34)
An Overview of Querying XML Data
126(2)
Understanding the XQuery and XPath Data Model
128(3)
Sequences
128(2)
Sequence in, Sequence out
130(1)
Sample Data for XPath, SQL/XML, and XQuery
131(1)
Introduction to XPath
132(5)
Analogy Between XPath and Navigating a File System
133(1)
Simple XPath Queries
133(4)
How to Execute XPath in DB2
137(3)
Wildcards and Double Slashes
140(2)
XPath Predicates
142(5)
Existential Semantics
147(1)
Logical Expressions with and, or, not()
148(3)
The Current Context and the Parent Step
151(2)
Positional Predicates
153(1)
Union and Construction of Sequences
154(1)
XPath Functions
155(1)
General and Value Comparisons
156(1)
XPath Axes and unabbreviated Syntax
157(1)
Summary
157(2)
Querying XML Data with SQL/XML
159(30)
Overview of SQL/XML
160(1)
Retrieving XML Documents or Document Fragments with XMLQUERY
161(4)
Referencing XML Columns in SQL/XML Functions
162(1)
Retrieving Element Values Without XML Tags
163(1)
Retrieving Repeating Elements with XMLQUERY
164(1)
Retrieving XML Values in Relational Format with XMLTABLE
165(12)
Generating Rows and Columns from XML Data
165(2)
Dealing with Missing Elements
167(1)
Avoiding Type Errors
168(1)
Retrieving Repeating Elements with XMLTABLE
169(4)
Numbering XMLTABLE Rows Based on Repeating Elements
173(1)
Retrieving Multiple Repeating Elements at Different Levels
174(3)
Using XPath Predicates in SQL/XML with XMLEXISTS
177(4)
Common Mistakes with SQL/XML Predicates
181(2)
Using Parameter Markers or Host Variables
183(2)
XML Queries with Dynamically Computed XPath Expressions
185(1)
Ordering a Query Result Set Based on XML Values
186(1)
Converting XML Values to Binary SQL Types
187(1)
Summary
188(1)
Querying XML Data with XQuery
189(44)
XQuery Overview
190(1)
Processing XML Data with FLWOR Expressions
191(6)
Anatomy of a Flowor Expression
191(2)
Understanding the for and let Clauses
193(1)
Understanding the Where and Order by Clauses
194(1)
Flwor Expressions with Multiple for and let Clauses
195(2)
Comparing Flwor Expressions, XPath Expressions, and SQL/XML
197(5)
Traversing XML Documents
197(1)
Using XML Predicates
198(2)
Result Set Cardinalities in XQuery and SQL/XML
200(1)
Using Flwor Expressions in SQL/XML
201(1)
Constructing XML Data
202(6)
Constructing Elements with Computed Values
202(2)
Constructing XML Data with Predicates and Conditions
204(2)
Constructing Documents with Multiple Levels of Nesting
206(1)
Constructing Documents with XML Aggregation in SQL/XML Queries
207(1)
Data Types, Cast Expressions, and Type Errors
208(4)
Arithmetic Expressions
212(2)
XQuery Functions
214(13)
String Functions
215(3)
Number and Aggregation Functions
218(2)
Sequence Functions
220(2)
Namespace and Node Functions
222(2)
Date and Time Functions
224(2)
Boolean Functions
226(1)
Embedding SQL in XQuery
227(2)
Using SQL Functions and User-Defined Functions in XQuery
229(1)
Summary
230(3)
Querying XML Data: Advanced Queries & Troubleshooting
233(34)
Aggregation and Grouping of XML Data
233(6)
Aggregation and Grouping Queries with XMLTABLE
234(2)
Aggregation of Values within and acros XML Documents
236(1)
Grouping Queries in SQL/XML versus XQuery
237(2)
Join Queries with XML Data
239(13)
XQuery Joins between XML Columns
240(2)
SQL/XML Joins between XML Columns
242(6)
Joins between XML and Relational Columns
248(2)
Outer Joins between XML Columns
250(2)
Case-Insensitive XML Queries
252(1)
How to Avoid ``Bad'' Queries
253(5)
Construction of Excessively Large Documents
253(1)
``Between'' Predicates on XML Data
254(2)
Large Global Sequences
256(1)
Multilevel Nesting SQL and XQuery
257(1)
Common Errors and How to Avoid Them
258(6)
SQL 16001N
259(1)
SQL 16002N
259(1)
SQL 16003N
260(1)
SQL 16005N
261(1)
SQL 16015N
262(1)
SQL 16011N
263(1)
SQL 16611N
264(1)
SQL 16075N
264(1)
Summary
264(3)
Producing XML from Relational Data
267(30)
SQL/XML Publishing Functions
268(22)
Constructing XML Elements from Relational Data
269(5)
Null Values Missing Elements, and Empty Elements
274(1)
Constructing XML Attributes from Relational Data
275(2)
Constructing XML Documents from Multiple Relational Rows
277(4)
Constructing XML Documents from Multiple Relational Tables
281(3)
Comparing XMLAGG, XMLCONCAT, and XMLFOREST
284(1)
Conditional Element Construction
284(1)
Leading Zeros in Constructed Elements and Attributes
285(1)
Default Tagging of Relational Data with XMLROW and XMLGROUP
286(3)
GUI-Based Definition of SQL/XML Publishing Queries
289(1)
Constructing Comments, Processing Instructions, and Text Nodes
290(1)
Legacy Functions
290(1)
Using XQuery Constructors with Relational Input
290(2)
XML Declarations for Constructed XML Data
292(2)
Inserting Constructed XML Data into XML Columns
294(1)
Summary
295(2)
Converting XML to Relational Data
297(24)
Advantages and Disadvantages of Shredding
297(4)
Shredding with the XMLTABLE Function
301(5)
Hybrid XML Storage
303(2)
Relational Views over XML Data
305(1)
Shredding with Annotated XML Schemas
306(12)
Annotating an XML Schema
306(5)
Defining Schema Annotations Visually in IBM Data Studio
311(1)
Registering an Annotated Schema
311(1)
Decomposing One XML Document at a Time
312(3)
Decomposing XML Documents in Bulk
315(3)
Summary
318(3)
Updating and Transforming XML Documents
321(40)
Replacing a Full XML Document
322(2)
Modifying Documents with XQuery Updates
324(2)
Updating the Value of an XML Node in a Document
326(5)
Replacing an Element Value
326(1)
Replacing an Attribute Value
327(1)
Replacing a Value Using a Parameter Marker
328(1)
Replacing Multiple Values in a Document
328(1)
Replacing an Existing Value with a Computed Value
329(2)
Replacing XML Nodes in a Document
331(2)
Deleting XML Nodes from a Document
333(1)
Reanming Elements or Attributes in a Document
334(1)
Inserting XML Nodes into a Document
335(5)
Defining the Position of Inserted Elements
335(1)
Defining the Position of Inserted Attributes
336(1)
Insert Examples
337(3)
Handling Repeating and Missing Nodes
340(3)
Modifying Multiple XML Nodes in the Same Document
343(3)
Snapshot Semantics and Conflict Situations
343(2)
Converting Elements to Attributes and Vice Versa
345(1)
Modifying XML Documents in Queries
346(3)
Modifying XML Documents in Insert Operations
349(1)
Modifying XML Documents in Update Cursors
350(1)
XML Updates in DB2 for z/OS
351(1)
Transforming XML Documents with XSLT
352(6)
The XSLTRANSFORM Function
353(3)
XML to HTML Transformation
356(2)
Summary
358(3)
Defining and Using XML Indexes
361(34)
Defining XML Indexes
362(5)
Unique XML Indexes
364(1)
Lean XML Indexes
365(1)
Using the DB2 Control Center to Create XML Indexes
366(1)
XML Indexe Data Types
367(6)
Varchar(n)
367(1)
Varchar Hashed
368(1)
Double and Decfloat
369(1)
Date and Timestamp
369(1)
Choosing a Suitable Index Data Type
369(2)
Rejecting Invalid Values
371(2)
Using XML Indexes to Evaluate Query Predicates
373(6)
Understanding Index Eligiblity
373(1)
Data Types in XML Indexes and Query Predicates
374(1)
Text Nodes in XML Indexes and Query Predicates
375(1)
Wildcards in XML Indexes and Query Predicates
376(1)
Using Indexes for Structrual Predicates
377(2)
XML Indexes and Join Predicates
379(4)
XML Indexes on Non-Leaf Elements
383(2)
Special Cases Where XML Indexes Cannot be Used
385(2)
Speical Cases with XMLQUERY
385(1)
Parent Steps
385(1)
The let and return Clauses
386(1)
XML Index Internals
387(3)
XML Index Keys
387(2)
Logical and Physical XML Indexes
389(1)
XML Index Statistics
390(3)
Summary
393(2)
XML Performance and Monitoring
395(42)
Explaning XML Queries in DB2 for Linux, Unix, and Windows
396(13)
The Explain Tables in DB2 for Linux, Unix, and Windows
396(1)
Using db2exfmt to Obtain Access Plans
397(3)
Using Visual Explain to Display Access Plans
400(1)
Access Plan Operators
401(2)
Understanding and Analyzing XML Query Execution Plans
403(6)
Explaining XML Queries in DB2 for z/OS
409(8)
The Explain Tables in DB2 for z/OS
409(1)
Obtaining Access Plan Information in SPUFI
410(1)
Using Visual Explain to Display Access Plans
411(2)
Access Plan Operators
413(1)
Understanding and Analyzing XML Query Execution Plans
414(3)
Statistics Collection for XML Data
417(7)
Statistics Collection for XML Data in DB2 for z/OS
417(1)
Statistics Collection for XML Data in DB2 for Linux, Unix, and Windows
418(1)
Examining XML Statistics with db2cat
419(5)
Monitoring XML Activity
424(4)
Using the Snapshot Monitor in DB2 for Linux, Unix, and Windows
424(3)
Monitoring Database Utilities
427(1)
Best Practices for XML Performance
428(7)
XML Document Design
428(1)
XML Storage
429(1)
XML Queries
430(2)
XML Indexes
432(2)
XML Updates
434(1)
XML Schemas
434(1)
XML Applications
434(1)
Summary
435(2)
Managing XML Data with Namespaces
437(34)
Introduction to XML Namespaces
437(7)
Namespace Declarations in XML Documents
439(3)
Default Namespaces
442(2)
Exploring Namespaces in XML Documents
444(3)
Querying XML Data with Namespaces
447(9)
Declaring Namespaces in XML Queries
448(3)
Using Namespace Declarations in SQL/XML Queries
451(1)
Using Namespace in the XMLTABLE Function
452(2)
Dealing with Multiple Namespaces per Document
454(2)
Creating Indexes for XML Data with Namespaces
456(4)
Constructing XML Data with Namespaces
460(3)
SQL/XML Publishing Functions and Namespaces
460(2)
XQuery Constructors and Namespaces
462(1)
Updating XML Data with Namespaces
463(6)
Updating Values in Documents with Namespaces
464(1)
Renaming Nodes in Documents with Namespace Prefixes
465(2)
Renaming Nodes in Documents with Default Namespaces
467(1)
Inserting and Replacing Nodes in Documents with Namespaces
468(1)
Summary
469(2)
Managing XML Schemas
471(42)
Introduction to XML Schemas and Their Usage
472(4)
Valid Versus Well-Formed XML Documents
473(1)
To Validate or Not to Validate, That Is the Question!
474(1)
Custom Versus Industry Standard XML Schemas
474(2)
Anatomy of an XML Schema
476(3)
An XML Schema with Include and Import
479(4)
Registering XML Schemas
483(9)
Registering XML Schemas in the DB2 Command Line Processor
484(2)
Registering XML Schemas from Applications via Stored Procedures
486(2)
Registering XML Schemas from Java Applications via JDBC
488(1)
Two XML Schemas Sharing a Common Schema Document
489(1)
Error Situations and How to Resolve Them
490(2)
Removing XML Schemas from the Schema Repository
492(1)
XML Schema Evolution
493(6)
Schema Evolution Without Document Validation
494(1)
Generic Schema Evolution with Document Validation
494(1)
Compatible Schema Evolution with the Update XMLSCHEMA Command
495(4)
Granting and Revoking XML Schema Usage Privileges
499(2)
Document Type Definitions (DTDs) and External Entities
501(1)
Browsing the XML Schema Repository (XSR)
502(8)
Tables and Views of the XML Schema Repository
503(5)
Queries against the XML Schema Repository
508(2)
XML Schema Considerations in DB2 for z/OS
510(2)
Summary
512(1)
Validating XML Documents against XML Schemas
513(34)
Document Validation Upon Insert
514(4)
Document Validation Upon Update
518(1)
Validation without Rejecting Invalid Documents
519(1)
Enforcing Validation with Check Constraints
520(3)
Automatic Validation with Triggers
523(2)
Diagnosing Validation and Parsing Errors
525(5)
Validation during Load and Import Operations
530(4)
Validation against a Single XML Schema
530(1)
Validation against Multiple XML Schemas
531(1)
Using a Default XML Schema
532(1)
Overriding XML Schema References
532(2)
Validation Based on SchemaLocation Attributes
534(1)
Checking Whether an Existing Document Has Been Validated
534(1)
Validating Existing Documents in a Table
535(3)
Finding the XML Schema for a Validated Document
538(2)
How to Undo Document Validation
540(1)
Considerations for Validation in DB2 for z/OS
540(4)
Document Validation Upon Insert
541(1)
Document Validation Upon Update
542(1)
Validating Existing Documents in a Table
543(1)
Summary of Platform Similarities and Differences
543(1)
Summary
544(3)
Using XML in Stored Procedures, UDFs, and Triggers
547(20)
Manipulating XML in SQL Stored Procedures
548(8)
Basic XML Manipulation in Stored Procedures
548(2)
A Stored Procedure to Store XML in a Hybrid Manner
550(3)
Loops and Cursors
553(1)
A Stored Procedure to Update a Selected XML Element or Attribute
554(1)
Three Tips for Testing Stored Procedures
555(1)
Manipulating XML in User-Defined Functions
556(5)
A UDF to Extract an Element or Attribute Value
557(1)
A UDF to Extract the Values of a Repeating Element
557(1)
A UDF to Shred XML Data to a Relational Table
558(1)
A UDF to Modify an XML Document
559(2)
Manipulating XML Data with Triggers
561(3)
Insert Triggers on Tables with XML Columns
562(1)
Delete Triggers on Tables with XML Columns
563(1)
Update Triggers on XML Columns
564(1)
Summary
564(3)
Performing Full-Text Search
567(30)
Overview of Text Search in DB2
568(2)
Sample Table and Data
570(1)
Enabling a Database for the DB2 Net Search Extender
571(1)
Managing Full-Text Indexes with the DB2 Net Search Extender
572(9)
Creating Basic Text Indexes
572(1)
Creating Text Indexes with Specific Storage Paths
573(1)
Creating Text Indexes with a Periodic Update Schedule
574(2)
Creating Text Indexes for Specific Parts of Each Document
576(2)
Creating Text Indexes with Advanced Options
578(1)
Updating and Reorganizing Text Indexes
579(1)
Altering Text Indexes
580(1)
Performing XML Full-Text Search with the DB2 Net Search Extender
581(9)
Full-Text Search in SQL and XQuery
581(2)
Full-Text Search with Boolean Operators
583(2)
Full-Text Search with Custom Document Models
585(1)
Advanced Search with Proximity, Fuzzy, and Stemming Options
586(1)
Finding the Correct Match within an XML Document
587(1)
Search Conditions on Sibling Branches of an XML Document
588(1)
Text Search in the Presence of Namespaces
588(2)
DB2 Text Search
590(4)
Enabling a Database for DB2 Text Search
590(1)
Creating and Maintaining Full-Text Indexes for DB2 Text Search
591(1)
Writing DB2 Text Search Queries for XML Data
592(1)
Full-Text Search with XPath Expressions
593(1)
Full-Text Search with Wildcards
594(1)
Summary of Text Search Administration Commands
594(2)
XML Full-Text Search in DB2 for z/OS
596(1)
Summary
596(1)
Understanding XML Data Encoding
597(12)
Understanding Internal and External XML Encoding
599(2)
Internally Encoded XML Data
599(1)
Externally Encoded XML Data
600(1)
Avoiding Code Page Conversions
601(1)
Using Non-Unicode Databases for XML
601(1)
Examples of Code Page Issues
602(4)
Chinese Characters in a Non-Unicode Code Page ISO-8859-1
602(1)
Fetching Data from a Non-Unicode Code Database into a Character Type Application Variable
603(1)
Encoding Issues with XMLTABLE and XMLCAST
604(1)
Japanese Literal Values in a Non-Unicode Database
605(1)
Data Expansion and Shrinkage Due to Code Page Conversion
605(1)
Avoiding Data Loss and Encoding Errors in Non-Unicode Databases
606(1)
Summary
606(3)
Developing XML Applications with DB2
609(52)
The Value of DB2 pureXML for Application Development
610(3)
Avoid XML Parsing in the Application Layer
610(2)
Storing Business Objects in an Intuitive Format
612(1)
Rapid Prototyping
612(1)
Responding Quickly to Changing Business Needs
613(1)
Using Parameter Markers or Host Variables
613(2)
Java Applications
615(16)
XMl Support in JDBC 3.0
615(4)
XML Support in JDBC 4.0
619(2)
Comprehensive Example of Manipulating XML Data with JDBC 4.0
621(6)
Creating XML Documents from Application Data
627(2)
Binding XML Data to Java Objects
629(1)
IBM pureQuery
629(2)
.Net Applications
631(5)
Querying XML Data in .Net Applications
632(1)
Manipulating XML Data in .Net Applications
633(2)
Inserting XML Data from .Net Applications
635(1)
XML Schema and DTD Handling in .Net Applications
636(1)
CLI Applications
636(3)
Embedded SQL Applications
639(8)
Cobol Applications with Embedded SQL
640(3)
PL/I Applications with Embedded SQL
643(2)
C Applications with Embedded SQL
645(2)
PHP Applications
647(3)
Perl Applications
650(1)
XML Application Development Tools
651(8)
IBM Data Studio Developer
652(4)
IBM Database Add-ins for Visual Studio
656(1)
Altova XML Tools
656(2)
Oxygen
658(1)
Stylus Studio
659(1)
Summary
659(2)
Exploring XML Information in the DB2 Catalog
661(14)
XML-Related Catalog Information in DB2 for Linux, Unix, and Windows
661(6)
Catalog Information for XML Columns
661(1)
The XML Strings and Paths Tables
662(1)
The Internal XML Regions and Path Indexes
663(1)
Catalog Information for User-Defined XML Indexes
664(3)
Catalog Information for XML Schemas
667(1)
XML-Related Catalog Information in DB2 for z/OS
667(6)
Catalog Information for XML Storage Objects
667(4)
Catalog Information for XML Indexes
671(1)
Catalog Information for XML Schemas
672(1)
Summary
673(2)
Test Your Knowledge---The DB2 pureXML Quiz
675(28)
Designing XML Data and Applications
675(2)
Designing and Managing Storage Objects for XML
677(3)
Inserting and Retrieving XMl Data
680(1)
Moving xML Data
681(1)
Querying XML
682(4)
Producing XML from Relational Data
686(1)
Converting XML to Relational Data
687(1)
Updating and Transforming XML Documents
688(1)
Defining and Using XML Indexes
689(3)
XML Performance and Monitoring
692(1)
Managing XML Data with Namespaces
693(1)
XML Schemas and Validation
694(2)
Performing Full-Text Search
696(1)
XML Application Development
697(3)
Answers
700(3)
Appendix A Getting Started with DB2 pureXML
703(6)
Exploring the Structure of XMl Documents
703(3)
Exploring XMl Documents in the DB2 Control Center
703(1)
Exploring XMl Documents in the CLP
704(1)
Exploring XMl Documents in SPUFI
705(1)
Tips for Running XML Operations in the CLP
706(3)
Appendix B The XML Sample Database
709(8)
XML Sample Database on DB2 for Linux, Unix, and Windows
709(1)
XMl Sample Tables on DB2 for z/OS
710(1)
Table customer---Column info
710(2)
Table product---Column description
712(1)
Table purchaseorder---Column proder
713(4)
Appendix C Further Reading
717(10)
General Resources for All
Chapters
717(1)
Chapter-Specific Resources
718(8)
Resources on the Integration of DB2 pureXML with Other Products
726(1)
Index 727
Matthias Nicola is a Senior Software Engineer for DB2 pureXML at IBMs Silicon Valley Lab. His work focuses on all aspects of XML in DB2, including XQuery, SQL/XML, XML storage, indexing, and performance. Matthias also works closely with customers and business partners, assisting them in the design, implementation, and optimization of XML solutions. Matthias has published more than a dozen articles on various XML topics (see www.matthiasnicola.de) and is a frequent speaker at DB2 conferences. Prior to joining IBM, Matthias worked on data warehousing performance for Informix Software. He received his doctorate in computer science from the Technical University of Aachen, Germany.

 

Pav Kumar-Chatterjee has worked with DB2 since 1991 on DB2 for z/OS and since 2000 on DB2 for Linux, UNIX, and Windows. He is currently employed by IBM as a technical sales specialist for Information Management in the United Kingdom. He has helped customers implement the XML Extender product with DB2 V8 and has presented on DB2 and XML in the United Kingdom and around Europe.