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 lifecycle–from 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, you’ll 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 development–including code samples for Java, .NET, C, COBOL,PL/1, PHP, and Perl
Understanding DB2 9 Security is the only comprehensive guide to securing DB2 and leveraging the powerful new security features of DB2 9. Direct from a DB2 Security deployment expert and the IBM® DB2 development team, this book gives DBAs and their managers a wealth of security information that is available nowhere else. It presents real-world implementation scenarios, step-by-step examples, and expert guidance on both the technical and human sides of DB2 security.
This book’s material is organized to support you through every step of securing DB2 in Windows®, Linux®, or UNIX® environments. You’ll start by exploring the regulatory and business issues driving your security efforts, and then master the technological and managerial knowledge crucial to effective implementation. Next, the authors offer practical guidance on post-implementation auditing, and show how to systematically maintain security on an ongoing basis.
Coverage includes
Establishing effective security processes, teams, plans, and policies
Implementing identification and authentication controls, your first lines of defense
DB2 in Windows environments: managing the unique risks, leveraging the unique opportunities
Using the new Label Based Access Control (LBAC) of DB2 9 to gain finer-grained control over data protection
Encrypting DB2 connections, data “in flight,” and data on disk: step-by-step guidance
Auditing and intrusion detection: crucial technical implementation details
Using SSH to secure machine-to-machine communication in DB2 9 multi-partitioned environments
Staying current with the latest DB2 security patches and fixes
This is the only IBM insider's reference and guidebook for making the most of DB2 in Solaris enterprise environments. Coverage includes: integrating Solaris and DB2 to build more secure database applications; working with DB2's management utilities in a Solaris environment; client/server communications under Solaris; special issues and opportunities associated with running DB2 Universal Database Enterprise Edition under Solaris, and much more! The authors explain configuring Solaris and DB2 failover support and provide expert tips and techniques for DB2/Solaris performance monitoring, optimization, and troubleshooting. If you manage or develop for DB2 on Solaris, this book is critical to your success -- and you can't find it anywhere else!
Marketshare for DB2 has been growing steadily over the past 5 years and with the announcement of DB2 Universal Database V8 (T-Rex), the product has never had more momentum. DB2 owns about 30 percent of the database market--the same as Oracle. Not only is the product used in many Fortune 500 companies, but it is becoming very popular in small to medium sized businesses as well. This book provides the reader with a comprehensive reference and research tool for DB2 for the mainframe. Official material is awkwardly written, spans over a dozen manuals in PDF format, and lacks real-world guidance. Author, Craig Mullins, consistently hears from readers of past editions that they rely on this book as their primary reference for DB2. Craig Mullins is constantly being asked when it will support a new release. "This is an excellent book . . . It is chock full of DB2 technical information, design and tuning approaches and database administration guidelines . . .Mullins seems to have dumped his entire DB2 life experience into DB2 Developer's Guide."- Jonathon Sayles in Relational Database Journal.
