Muutke küpsiste eelistusi

DB2 9 for Developers [Pehme köide]

4.33/5 (6 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 550 pages, kõrgus x laius x paksus: 229x178x28 mm, kaal: 744 g
  • Ilmumisaeg: 01-Mar-2008
  • Kirjastus: MC Press, LLC
  • ISBN-10: 1583470719
  • ISBN-13: 9781583470718
Teised raamatud teemal:
DB2 9 for DevelopersSuurem pilt
  • Formaat: Paperback / softback, 550 pages, kõrgus x laius x paksus: 229x178x28 mm, kaal: 744 g
  • Ilmumisaeg: 01-Mar-2008
  • Kirjastus: MC Press, LLC
  • ISBN-10: 1583470719
  • ISBN-13: 9781583470718
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781583470718.html
Written by an "in-the-trenches" consultant, this guide hails the newest version of DB2 as a major release, highlighting the large number of totally new features, most notably the addition of XML capabilities. Packed with the information DB2 developers and administrators need to know when implementing version 9, the discussion covers upgrading from prior releases of DB2, converting relational data to XML data, and how DB2 supports industry standard schemas. With detailed examples and useful scripts, users learn how to develop DB2 XML applications, design an XML database, and tune the DB2 XML hybrid database. Extensive information on DB2 optimization of SQL and XML is a particularly useful feature of the book and includes a rundown on import and export utilities that database managers can use in their own installations. Going far beyond the standard manuals and certification guides, this is a truly comprehensive resource that teaches the "why" and "how" of a well-designed and well-implemented DB2 database.
Foreword xi
DB2 9 Product Overview
1(10)
DB2 Workgroup Server Edition
3(2)
DB2 Enterprise Server Edition
5(2)
DB2 Developer Workbench
7(2)
Summary
9(2)
DB2 9 Enhancements
11(12)
Native XML Data Store Support
13(1)
Application Development Enhancements
14(3)
Performance and Scalability Enhancements
17(2)
Installation and Fix Pack Enhancements
19(2)
Summary
21(2)
XML Evolution and Revolution
23(14)
Components of XML
26(3)
XML-Only Databases
29(2)
Initial XML Relational Database Implementations
31(1)
DB2 9: The Revolutions
32(3)
Summary
35(2)
The Path to DB2 9 XML Capabilities
37(22)
XPath Data Model
41(4)
DB2 9 Hybrid Architecture
45(5)
DB2 9 Native XML Storage Architecture
50(4)
Querying DB2 9 XML Data
54(3)
Summary
57(2)
Developer Workbench: Developing Applications
59(64)
Getting Started with DWB
60(14)
Creating an SQL Procedure
74(21)
Topology View
95(1)
Working with XML and DWB
96(18)
Building an Xquery
114(8)
Summary
122(1)
DB2 9 and Service Oriented Architecture
123(16)
Service Oriented Architecture
124(2)
Web Service Functions and Protocols
126(7)
SOA and DB2 9
133(4)
DB2 Example
137(1)
Summary
138(1)
Logical and Physical Design
139(26)
Logical Design
140(19)
Physical Design
159(5)
Summary
164(1)
Tuning Buffer Pools
165(24)
Creating Buffer Pools
166(3)
Dropping Buffer Pools
169(12)
Monitoring and Tuning Tables, Buffer Pools, and Table Spaces
181(6)
Summary
187(2)
The Way to DB2: The Optimizer
189(36)
DFT_QUERYOPT Parameter
194(5)
SQL/XML Predicate Coding Best Practices
199(2)
Partition Eliminatio
201(3)
Creating Indexes over XML Data
204(3)
SQL and XML Explain Facilities
207(14)
DB2 Design Advisor
221(3)
Summary
224(1)
Utilities
225(64)
The XML Data Type and the Import Command
226(4)
The XML Data Type and the Export Command
230(3)
Reorganizing Indexes and Tables
233(9)
Backup Database Utility
242(5)
Recover Database Command
247(3)
Restore Database Utility
250(11)
DB2 9 Data Compression and the Inspect Utility
261(4)
Migrate Database Utility
265(2)
Load Utility
267(21)
Summary
288(1)
Monitoring
289(96)
Snapshot Monitoring
291(44)
Health Center and Health Monitor
335(16)
Activity Monitor
351(7)
db2pd Utility
358(13)
Memory Tracker
371(2)
Event Monitoring
373(9)
Summary
382(3)
Performance
385(64)
DB2 Memory Model
386(6)
DB2 Self-Tuning Memory Manager
392(17)
Instance-Level Tuning Considerations
409(4)
Database-Level Tuning Considerations
413(35)
Summary
448(1)
OS Monitoring: Tips and Techniques
449(22)
Monitoring Methodology
450(14)
Scenario #3: Monitoring DB2 on AIX and Linux
464(6)
Summary
470(1)
Problem Determination
471(36)
Connectivity Problems
473(2)
DB2 Code (Defect) Problem
475(2)
DB2 Problem-Determination Aids
477(23)
Sending Information to DB2 Support
500(5)
Summary
505(2)
Appendix A DB2 Information Sources on the Web 507(2)
Appendix B SQL and XQuery Limits 509(12)
Appendix C New Environment Variables in DB2 9 521(4)
Index 525


Philip K. Gunning is the principal of Gunning Technology Solutions, which provides DB2 consulting to firms throughout North America and Europe, and is active in the International DB2 User Group where he serves on the Solutions Journal editorial board. He is the author of DB2 Universal Database Handbook for Windows, UNIX, and Linux. He lives in Sinking Springs, Pennsylvania.