Atjaunināt sīkdatņu piekrišanu

SQL Server 2000 XML Distilled 1st ed. [Mīkstie vāki]

3.00/5 (2 ratings by Goodreads)
, , , , , , , ,
  • Formāts: Paperback / softback, 633 pages, height x width: 229x152 mm, weight: 956 g, XIV, 633 p., 1 Paperback / softback
  • Izdošanas datums: 10-Oct-2003
  • Izdevniecība: APress
  • ISBN-10: 1590591917
  • ISBN-13: 9781590591918
Citas grāmatas par šo tēmu:
  • Mīkstie vāki
  • Cena: 46,87 €*
  • * ši ir gala cena, t.i., netiek piemērotas nekādas papildus atlaides
  • Standarta cena: 55,15 €
  • Ietaupiet 15%
  • Grāmatu piegādes laiks ir 3-4 nedēļas, ja grāmata ir uz vietas izdevniecības noliktavā. Ja izdevējam nepieciešams publicēt jaunu tirāžu, grāmatas piegāde var aizkavēties.
  • Daudzums:
  • Ielikt grozā
  • Piegādes laiks - 4-6 nedēļas
  • Pievienot vēlmju sarakstam
SQL Server 2000 XML Distilled 1st ed.Palielināt
  • Formāts: Paperback / softback, 633 pages, height x width: 229x152 mm, weight: 956 g, XIV, 633 p., 1 Paperback / softback
  • Izdošanas datums: 10-Oct-2003
  • Izdevniecība: APress
  • ISBN-10: 1590591917
  • ISBN-13: 9781590591918
Citas grāmatas par šo tēmu:
Permanent link: https://www.kriso.lv/db/9781590591918.html
Keywords:
"SQL Server 2000 XML Distilled" shows where XML as a data model makes sense, when and how best to get both relational databases and XML to work together, and how to set up and configure the SQL Server XML environment.
Introduction 1(8)
What Does This Book Cover?
1(3)
What You Need to Use This Book
4(1)
Source Code
5(1)
Conventions
5(1)
Customer Support
5(4)
Errata
6(1)
E-mail Support
6(3)
Chapter 1: SQL Server, XML, and the DBA 9(22)
Data Based Computing
10(3)
The Success of Relational Databases
10(1)
The Success of the Web
11(1)
XML - The Next Step
12(5)
System Interoperability and Data Interchange in an n-tier Environment
13(1)
Web Services
13(1)
What Aspects of XML are Relevant to Databases?
13(4)
XML and Relational Structures
17(1)
Relational Structures
17(1)
XML Structures
17(2)
Storing XML in Relational Structures
18(1)
Storing Relational Data Using XML
18(1)
Mapping XML and Relational Data
18(1)
The Main Uses of XML Structures
19(1)
XML for Messaging - The Other Application Wants XML
19(1)
XML as Document - Markup Based Document Objects
20(1)
XML for Presentation - The Browser Wants Markup
20(1)
An Architectural View
20(8)
Different Approaches to the Problem
21(6)
XML End-to-End
21(2)
Relational End-to (near the)-end
23(1)
Ad Hoc
24(1)
Take a Step Back
25(2)
Which Approach?
27(1)
Summary
28(3)
Chapter 2: Architecture and Setup 31(28)
Architecture Overview
31(11)
Architecture of SQL Server 2000 XML
32(2)
FOR XML Queries
32(1)
OPENXML
33(1)
Architecture of SQLXML
34(7)
HTTP Access
34(1)
XDR Schemas
35(1)
XML Templates
36(1)
XML Bulk Load
37(1)
Updategrams
38(1)
Client-side XML
38(1)
NET Managed Classes
39(1)
DiffGrams
40(1)
XML Schemas
40(1)
Web Services
41(1)
Putting it All Together
41(1)
Where SQLXML Fits With NET/DNA
42(1)
Installation of SQLXML
42(2)
Requirements
42(1)
Installing SQLXML 3.0
43(1)
Creating SQLXML Virtual Directories
44(12)
General Tab
45(1)
Security Tab
46(1)
Data Source Tab
47(1)
Settings Tab
48(2)
Virtual Names Tab
50(1)
Advanced Tab
51(1)
Upgrade to Version 3 Tab
52(1)
Test Your Setup
52(1)
Registry Settings
53(1)
Security Considerations
53(1)
URL Queries
54(1)
Types of Authentication
54(1)
Other Security Issues
54(1)
Troubleshooting
54(2)
Debugging Tools
56(1)
SQL Profiler
56(1)
IIS Logging
56(1)
Query Analyzer
56(1)
Summary
57(2)
Chapter 3: Mapping SQL Server to XML 59(32)
Considerations When Mapping Data
59(5)
Standards Support
59(2)
Transmission
61(1)
Presentation
62(1)
Archival
63(1)
XML Schemas vs. XML-Data Reduced Schemas
64(1)
Equivalent XML Datatypes
65(9)
Design Approach
74(7)
Identification of Relevant Information
74(1)
Design of XML Document Overall Structure
75(3)
Sequence, Choice, or All?
75(1)
Understanding Foreign Key Relationships
76(1)
Proper Usage of ID-IDREF Relationships
77(1)
Handling "Dangling" Elements
78(1)
Mapping Column Values
78(3)
Converting Data Types
79(1)
Handling Constraints
79(1)
Include or Exclude Identifiers
80(1)
Handling NULL Values
81(1)
Implementation
81(1)
Using an XML View to Create the XML Document
82(1)
Using FOR XML EXPLICIT to Create the XML Document
82(1)
Inventory Example
82(7)
Design Goals
82(1)
Identifying the Relevant Information
83(1)
Designing the Document Structure
83(2)
Mapping the Column Values
85(1)
A FOR XML EXPLICIT Query Mapping the Data to XML
86(3)
Summary
89(2)
Chapter 4: FOR XML 91(30)
Comparison of Server-Side and Client-Side XML Processing
92(1)
FOR XML Query Results
93(1)
Server-Side XML Processing
94(23)
SQL Limitations
95(1)
Security Considerations
95(1)
Performance Implications
96(1)
FOR XML RAW
96(3)
XMLDATA
98(1)
BINARY BASE64
98(1)
FOR XML AUTO
99(5)
ELEMENTS
103(1)
FOR XML EXPLICIT
104(13)
Directives
110(7)
Client-Side XML Processing
117(2)
RAW
118(1)
NESTED
118(1)
EXPLICIT
119(1)
Ways of Using Client-Side FOR XML
119(1)
Summary
119(2)
Chapter 5: URL Queries and Template Queries 121(24)
URL Queries
121(11)
Security Considerations
122(1)
Setting up the Environment
123(1)
Usage
123(9)
Data Modification
125(1)
Executing Stored Procedures
125(2)
Using Stylesheets
127(3)
Content Types
130(2)
Template Queries
132(11)
Usage Guidelines
132(1)
Security Considerations
133(1)
Setting up the Environment
133(2)
Template and XSL Stylesheet Caching
134(1)
Usage
135(12)
Stored Procedures
136(1)
Parameterizing Queries
136(2)
Using Multiple Queries
138(2)
Using Output Parameters
140(1)
Using Stylesheets
140(1)
XPath Queries
141(1)
Other Options
141(1)
Posting Templates
142(1)
Summary
143(2)
Chapter 6: Annotating XML Schemas 145(28)
Why Annotate XML Schemas?
145(1)
XML Schemas vs. XDR Schemas
146(1)
The XML Schema Annotation Namespace
146(1)
Annotation Mechanisms
147(21)
Mapping Complex Elements to SQL Server Tables
147(1)
Mapping Attributes to SQL Server Columns
148(1)
Mapping Text-only Elements to SQL Server Columns
149(1)
Defining Unmapped XML Elements
150(1)
Excluding XML Elements From the Mapping
151(1)
Specifying Relationships Between Two SQL Tables
152(3)
Filtering the Data in an XML Document
155(2)
Specifying Unique Keys in an XML Document
157(2)
Creating ID-IDREF Relationships in XML Schemas
159(2)
Escaping Invalid XML Characters in XML Schemas
161(1)
Mapping Binary Large Objects (BLOBS)
162(3)
Specifying Identity Columns in an XML Schema
165(1)
Specifying a GUID in an XML Schema
166(1)
Limiting Recursion Depths in XML Schemas
167(1)
Summary
168(5)
Chapter 7: XML Views 173(14)
The What and Why of XML Views
173(1)
Creating an XML View
174(6)
Annotating an Existing XDR or XML Schema
175(1)
Modeling Tables and Columns in XML Views
175(2)
Modeling Joins in XML Views
177(3)
Accessing Data Through an XML View
180(1)
Accessing Data Using URLs
180(1)
Accessing Data Using Templates
180(1)
Examples
181(4)
Simple Example
181(2)
Layering an XML View Over a SQL Server View
183(2)
Summary
185(2)
Chapter 8: XPath Queries 187(26)
Overview of XPath
187(1)
Setting up the Sample
188(2)
Set up a Schema Mapping
188(1)
Create the Sample Schema
189(1)
From T-SQL to XPath
190(9)
SELECT
190(1)
FROM
190(3)
Namespaces
191(2)
WHERE
193(6)
XPath Data Types
195(3)
XPath Operators
198(1)
XPath Functions
198(1)
Using XPath Queries
199(3)
XPath Queries in a URL
199(1)
XPath Queries in Templates
199(3)
Using Parameters
201(1)
XPath Queries in ADO
202(1)
XPath Queries in the Managed Classes
202(1)
Performance Considerations
202(5)
Tuning XPath Using SQL Profiler
202(1)
Recursive Queries
203(4)
Security Issues
207(1)
Who Has Access to the Data?
207(1)
Can the Data be Changed?
207(1)
Other Methods
208(1)
Limitations
208(2)
Summary
210(3)
Chapter 9: Mapping XML to SQL Server 213(34)
Things to Consider
213(6)
Loading Persistent Data
213(2)
Loading Temporary Data for Manipulation
215(2)
Inserts or Updates?
217(2)
Equivalent SQL Data Types
219(5)
Types to Avoid in XML Data Destined for SQL Server
223(1)
Design Approach
224(15)
Mixed-mode Documents
224(1)
Identification of Relevant Information
225(1)
Design of the Overall Relational Structure
226(9)
Handling Child Elements
226(5)
Handling ID-IDREF Relationships
231(2)
Handling ID-IDREFS Relationships
233(2)
Mapping Data Points
235(4)
Converting Data Types
237(1)
Creating Constraints Based on XML Schema Constraints
237(1)
Modeling Enumeration Constraints
238(1)
Creating Record Identifiers
239(1)
Example
239(5)
Design Goals
241(1)
Identifying the Relevant Information
241(1)
Designing the Tables
241(1)
Mapping the Column Values
242(2)
Summary
244(3)
Chapter 10: OPENXML 247(44)
Introduction
247(1)
Parsing an XML document with OPENXML
248(5)
Parsing Example
250(2)
Namespaces
252(1)
OPENXML Function Syntax
253(14)
TableName
253(2)
SchemaDeclaration
255(3)
XML Document Example
256(2)
rowpattern
258(4)
Restricting Results
258(2)
Set Operations in the rowpattern
260(2)
OPENXML Flags
262(3)
Consumed Data
264(1)
Column Patterns
265(14)
Specifying metaproperties
266(1)
Combining with Other Tables
267(4)
Using XML Data to Modify Tables
271(8)
Using XML Meta Data
279(4)
Simple Edge Table
280(2)
Edge Table with DTD or Inline Schema
282(1)
Performance
283(3)
Memory
283(1)
Timing
284(1)
IO
285(1)
Limitations
286(1)
Updating Documents
286(1)
Caching and Statistics
286(1)
Whitespace and Escaped Characters
286(1)
Multi-Valued Attributes
287(1)
Summary
287(4)
Chapter 11: Updategrams 291(36)
What are Updategrams?
292(3)
Driving Updategrams with an Annotated Schema
295(2)
Default Mapping in Updategrams
297(1)
Inserting Data with an Updategram
298(4)
Inserting Multiple Rows
301(1)
Deleting Data with an Updategram
302(2)
Deleting Multiple Rows
303(1)
Updating Data with an Updategram
304(3)
Explicitly Relating Records
306(1)
Explicitly Relating Before and After
307(1)
Multiple Actions Within One Updategram
307(4)
Capturing Identity Values for Inserted Records
311(4)
Inverse Relationships in an Updategram
315(2)
Creating GUIDs as Part of an Updategram
317(1)
Generating Updategrams "on-the-fly"
318(1)
Applying Updategrams to a Database
319(5)
Applying an Updategram Using HTTP
319(1)
Applying an Updategram from a URL
320(1)
Applying Updategrams from Templates
320(2)
Applying an Updategram Directly Using HTTP Post
322(1)
Applying an Updategram Using ADO
323(1)
Summary
324(3)
Chapter 12: SQLXML Bulk Load 327(36)
Overview
328(2)
Creating the Schema
330(5)
Sample Script
335(1)
Properties of the SQLXMLBulkLoad Object
336(8)
Providing Connection information
336(2)
Table Creation and Deletion
338(1)
Error Handling
339(1)
Optimization
340(1)
Transaction Management
341(1)
Control over Data Loading
342(2)
CheckConstraints
342(1)
IgnoreDuplicateKeys
343(1)
KeepIdentity
343(1)
KeepNulls
343(1)
XMLFragment
344(1)
Completing the Script and Running it in DTS
344(12)
Loading Multiple Tables
348(6)
Loading From a Stream Instead of a File
354(2)
Differences from Other Bulk Load Interfaces
356(3)
Comparison to Updategrams
358(1)
Comparison to OPENXML
358(1)
Summary
359(4)
Chapter 13: Programmatic Access with SQLXML 363(52)
Programming XML with ADO
365(24)
Extended Properties of the ADO Command Object
368(7)
XML Root
369(1)
NameSpaces
369(1)
Output Encoding
370(1)
Base Path
370(1)
Mapping Schema
371(1)
XSL
371(3)
SS STREAM FLAGS
374(1)
Output Stream
375(1)
Querying with Templates
375(2)
Querying Using XPath and a Mapping Schema
377(4)
SQLXMLOLEDB Provider and Client-Side Processing
381(7)
FOR XML NESTED
383(1)
Coding for Client-Side XML
383(1)
Querying Stored Procedures to Get XML
384(1)
Letting ADO Create the XML
385(3)
Using ADO and a Stored Procedure with OPENXML
388(1)
Programming XML with ADO.NET
389(4)
Executing a FOR XML Query With SqlCommand
390(2)
Saving ADO.NET Datasets as XML
392(1)
SQLXML Managed Classes
393(11)
SqlXmlCommand
394(7)
Properties of SqlXmlCommand
395(5)
Methods of SqlXmlCommand
400(1)
SqlXmlParameter
401(1)
SqlXmlAdapter
402(2)
DiffGrams
404(8)
Summary
412(3)
Chapter 14: Web Services in SQL Server 2000 415(18)
What is a Web Service?
415(1)
Setting up a SQL Server 2000 Web Service With SQLXML 3.0
416(8)
The Sample Database
416(2)
Creating the SOAP Virtual Name
418(1)
Exposing Stored Procedure Functionality as a Web Service
419(1)
Output Options
420(3)
XML Objects
421(1)
Dataset Objects
422(1)
Error Mechanisms
423(1)
Stored Procedure Return Codes
423(1)
SOAP Faults
423(1)
Exposing UDF Functionality as a Web Service
423(1)
Consuming Services Through Visual Studio.NET
424(2)
Further SQL Server 2000 Web Service Topics
426(4)
UDDI Registries
426(1)
Web Service Security/Authentication
427(1)
Shortcomings of SQL Server Web Services
427(1)
Microsoft Specific
427(1)
No Control Over Return Values
428(1)
Wrapping Services with .NET Services
428(2)
Summary
430(3)
Chapter 15: Case Study: Detecting Web Site Clients 433(24)
Benefits and Drawbacks of the Methods
434(1)
Basic Detection
434(1)
Client Detection Using SQLXML
435(9)
Client-Side Scripting
435(1)
Server-Side Scripting
435(1)
The Solution to SQLXML Client Detection
435(8)
The SQLXML Virtual Directory
436(1)
Creating the XML Templates
436(3)
Creating Client Detection Code
439(4)
Drawbacks to Client Detection in SQLXML
443(1)
Client Detection Using the SQLXML Managed Classes
444(7)
Visual Studio.NET and the NET Framework
444(1)
Creating the Project
444(1)
ASP.NET Browser Detection
445(1)
SQLXML Managed Classes
446(1)
Plugging in our SQLXML Templates
447(3)
Advantages to Using ASP.NET Client Detection
450(1)
Client Detection Using SQLXML and ADO
451(3)
Using Classic ADO
451(2)
ASP Browser Detection
453(1)
Advantages to Using ASP Client Detection
454(1)
Summary
454(3)
Chapter 16: Case Study: BizTalk Integration 457(38)
Software You Will Need
458(1)
HR and Departmental Databases
459(3)
HR Database
459(2)
Department Database
461(1)
SQLXML Configuration
461(1)
Ideal Business Process
462(2)
Advantages
463(1)
Security Ramifications
463(1)
BizTalk Primer
464(1)
First Problem
464(1)
Revised Business Process
465(1)
BizTalk Messages
465(8)
New Employee
465(4)
Updategrams
469(4)
HR Orchestration Schedule
473(12)
HR Business Process
474(1)
Updategram Component
474(2)
HR Messaging Implementations
476(4)
HR Data Flow
480(1)
BizTalk Messaging Configuration
481(4)
Department Phone List Schedule
485(4)
Department Business Process
485(1)
Department Messaging Implementations
486(1)
Department Data Flow
487(1)
BizTalk Messaging Configuration
488(1)
Testing the System
489(1)
Assessing the System
490(2)
Performance
490(1)
Security
491(1)
Summary
492(3)
Chapter 17: The Future - Emergent Technologies 495(18)
ISO SQL/XML Working Draft (or SQLX)
496(1)
Oracle 9i Release 2 (9.0.2)
496(4)
Oracle and XML Support
497(3)
What's so Good About the Native xmltype?
497(1)
And What's So Good About the Integrated Support for XML Schema?
498(1)
What About These Integrated Functions?
499(1)
Oracle and XQuery
500(1)
Oracle Summary
500(1)
W3C XQuery
500(9)
XQuery Working Draft
500(1)
XQuery and XPath 2.0, XSLT and XPath 1.0 and 2.0
501(1)
XQuery Overview
501(13)
Basic Syntax
502(1)
FLoWeR - or FOR LET WHERE RETURN
503(2)
FLoWeR and SQL 505 Joins
505(2)
If. .. Then. .. Else
507(1)
Core Functions
507(1)
Data Types and Validation
508(1)
XQuery Future - In the Pipeline
508(1)
XQuery Summary
508(1)
Microsoft Next Steps - Yukon
509(1)
So What Does all This Mean?
510(3)
Appendix A: XPath Reference 513(46)
XPath Data Model
514(7)
Node Types
516(1)
Node Properties
516(2)
Data Types
518(3)
Location Paths
521(8)
Absolute and Relative Location Paths
521(1)
Steps
522(1)
Axes
522(3)
Node Tests
525(2)
Abbreviations
527(1)
Predicates
527(2)
Variables
529(1)
Operators
530(4)
Arithmetic Operators
530(1)
Comparisons
531(2)
Logical Operators
533(1)
Node-Set Operators
533(1)
Functions
534(18)
XPath 2.0 and XQuery
552(7)
XPath 2.0
552(3)
XQuery 1.0
555(4)
Appendix B: XML Schema Reference 559(42)
Namespaces for XML Schema
559(1)
XML Schema Elements
560(10)
Global Attributes
560(10)
xsd:schema> 561
xsd:element> 562
xsd:group> 566
xsd:attribute> 568
xsd:attributeGroup> 569
Defining and Constraining Types
570(15)
xsd:simpleType> 572
xsd:complexType> 573
Simple Type Restrictions
575(7)
Complex Type Restrictions
582(3)
Relationships and Null Fields
585(6)
xsd:unique> 586
xsd:key> 589
xsd:keyref> 590
Namespaces
591(2)
form Attribute
591(2)
Importing Schemas
593(1)
xsd:include> 593
xsd:redefine> 593
xsd:import> 594
Documentation
594(1)
xsd:documentation> 594
xsd:appinfo> 595
Varying XML Content
595(2)
xsd:any> 596
xsd:anyAttribute> 597
The XML Schema Instance Namespace
597(2)
References
599(2)
Appendix C: A Tool for XML Queries 601(8)
Why is a Query Tool Useful?
601(2)
The Query Tool
603(6)
Index 609