The goal of database performance tuning is to minimize the response time of your queries. It is also to optimize your server’s resources by minimizing network traffic, disk I/O, and CPU time. This IBM IBM Redbooks publication helps you to understand the basics of identifying and tuning the performance of Structured Query Language (SQL) statements using IBM DB2 for i5/OS . DB2 for i5/OS provides a comprehensive set of tools that help technical analysts tune SQL queries. The SQL Performance Monitors are part of the set of tools that IBM i5/OS provides for assisting in SQL performance analysis since Version 3 Release 6. These monitors help to analyze database performance problems after SQL requests are run. In V5R4 of i5/OS iSeries Navigator provides a series of new tools to do SQL Performance analysis that we cover in this book. Among the new tools that we will covering are:

This IBM Redbooks publication provides a getting started level of information about supporting the IBM Virtualization Engine TS7510 under i5/OS, primarily using the Backup Recovery and Media Services (BRMS), 5722-BR1, management product. BRMS is the primary backup and recovery management product for i5/OS. This book cannot make you an expert in i5/OS backup and recovery or in the use of BRMS. It also cannot make you an expert in full usage and management of the IBM Virtualization Engine TS7510 capabilities. More complete coverage of the TS7510 is included in the book IBM Virtualization Engine TS7510: Tape Virtualization for Open Systems Servers, SG24-7189. However, this book does provide sufficient information and examples to get you up and running with the IBM Virtualization Engine TS7510 attached to an i5/OS partition or system using BRMS. This book also helps you to understand where the IBM Virtualization Engine TS7510 can fit into your complete set of backup and recovery processes where multiple systems or servers, or logical partitions have to save data to a common repository. The TS7510 helps you to minimize your backup window, facilitates data sharing among the multiple systems, and helps you to minimize your total cost of ownership (TCO) in the backup and recovery area.

The Google Maps API remains one of the showcase examples of the Web 2.0 development paradigm. Beginning Google Maps Applications with Rails and Ajax: From Novice to Professional is the first book to comprehensively introduce the service from a developer perspective, showing you how you can integrate mapping features into your Rails-driven web applications. Proceeding far beyond simplistic map display, youll learn how to draw from a variety of data sources such as the U.S. Census Bureau's TIGER/Line data and Google's own geocoding feature to build comprehensive geocoding services for mapping many locations around the world. The book also steers you through various examples that show how to encourage user interaction such as through pinpointing map locations, adding comments, and building community-driven maps. Youll want to pick up a copy of this book because This is the first book to comprehensively introduce the Google Maps application development using the Rails development framework. Youll be introduced to the very latest changes to the Google Maps API, embodied in the version 2 release. It is written by four developers actively involved in the creation of location-based mapping services. For additional info, please visit the author's reference site for this book.

Have you ever wondered how to get started writing your own schema? As you prepare to create your schema, you must consider a number of factors. This guide explains each of those factors in detail and recommends an approach for documenting your schema development plan in an information model. Your information model can not only be used as a planning mechanism to develop your schema but can also be used as a training resource and as a reference guide for those using the schema after it is developed. By putting a well-thought-out information model in place, you are bound to produce a schema that you can use indefinitely and build upon easily.

Systems Solution for Branch Banking is targeted to the financial institutions that have chosen to keep a decentralized infrastructure. This is approximately 50% of the customer base. This solution is a technology sell, and will therefore be most attractive to banks that are due for a technology refresh (that is, those that have not done a major upgrade of their branch infrastructure for the past 5 to 10 years). This IBM Redbooks publication discusses how to install and configure the components of the Systems Solution for Branch Banking, a hardware and software solution that enables banks to provide a common, easy-to-support IT infrastructure in their branch locations. The solution takes into consideration that the skills required to upgrade or maintain the infrastructure in the branch do not exist, so we provide a remote management function. Although a common solution has been defined, each implementation may have its own unique variations, depending on the network, software, and hardware environments.

Maximize the Capabilities of Oracle Collaboration Suite Facilitate enterprisewide communication, data sharing, and team work using Oracle Collaboration Suite 10g and the in-depth information contained in this Oracle Press guide.Oracle Collaboration Suite Handbook explains how to install, implement, manage, and optimize the suite in an enterprise environment.

This IBM Redbooks publication presents an overview and descriptions of IBM System Storage Business Continuity Solutions for Backup / Restore, Rapid Data Recovery, and Continuous Availability. IT Business Continuity concepts are discussed; advice, tips, and a roadmap for selecting the optimum IT Business Continuity solution for your organization is provided. IBM System Storage products are described that can fulfill your IT Business Continuity solution design. This book is a summary of the detailed information contained in IBM TotalStorage Business Continuity Solutions Guide, SG24-6547 and IBM System Storage Business Continuity: Part 2 Solutions Guide, SG24-6548.

The IBM acquisition of Micromuse Inc. in 2006 marked a major milestone for IBM Tivoli software because it significantly strengthened the end-to-end IBM Service Management software portfolio. As new technologies emerge, the ability to manage networks and provide very high network availability has become increasingly important for most organizations. Please note that the additional material referenced in the text is not available from IBM.

"Microsoft Office InfoPath represents a revolutionary leap in XML technologies and a new paradigm for gathering business-critical information. I am delighted that Scott Roberts and Hagen Green, two distinguished members of the InfoPath product team, decided to share their experience in this book." --From the Foreword by Jean Paoli, cocreator of XML 1.0 and Microsoft Office InfoPath Microsoft Office InfoPath 2007 offers breakthrough tools for gathering, managing, and integrating business-critical information, and creating efficient forms-driven processes. Two longtime members of Microsoft's InfoPath product team have written the first comprehensive, hands-on guide to building successful XML-based solutions with InfoPath 2007. The book opens with a practical primer on the fundamentals of InfoPath form template design for information workers and application developers at all levels of experience. It then moves into advanced techniques for customizing, integrating, and extending form templates--with all the code examples and detail needed by professional developers. Learn how to: Design form templates: create blank form templates, insert and customize controls, use advanced formatting, and construct and lay out views Work with data: start with XML data or schema, manually edit data sources, and understand design-time visuals Add custom business logic to forms, and integrate them with other applications Retrieve and query data from external data sources, including XML files, databases, SharePoint lists, Web services, and ADO.NET DataSets Submit and receive form data using ADO.NET Save, preview, and publish to e-mail, SharePoint, and more Build reusable components with template parts Create workflows with SharePoint and InfoPath E-Mail Forms Administer Forms Services and Web-enabled form templates Build advanced form templates using C# form code, custom controls, add-ins, and the new InfoPath 2007 managed object model Design form templates using Visual Studio Tools for Office (VSTO) Update, secure, and optimize your form templates List of Figures PART I: Designing Forms

The convergence of Internet Protocol (IP) networks is enabling seamless communications that combine data, voice, video and other information streams. The true value of converged IP network however is realized through the converged applications that leverage the network. The key enabler to developing converged applications is the platform for designing, developing, testing, and deploying applications that integrate and compose services. This IBM Redbooks publication introduces IBM tools for creating converged Session Initiation Protocol (SIP) and IP Multimedia Subsystem (IMS) applications. It provides programming guidelines and working examples that demonstrate how to use the different development tools. It also provides hints and tips that enable you to quickly get up to speed developing converged applications. The portfolio of products include the IBM WebSphere Application Server Network Deployment, IBM WebSphere IP Multimedia Subsystem Connector, IBM WebSphere Presence Server, IBM WebSphere Telecom Web Services Server, and IBM WebSphere Integration Developer. This book is aimed at the diverse set of professionals that design and develop SIP and IMS applications. Please note that the additional material referenced in the text is not available from IBM.

SAP SCM: Applications and Modeling for Supply Chain Management empowers you to capitalize on the sophistication of SAP APO. This book provides clear advice on the inevitable, critical decisions that can lead to project success or failure and shows you, wherever you are on the supply chain management staff—buyer, planner, ground controller or analyst—to fully exploit the agility SAP APO offers.

A plethora of patterns and palettes! This hardworking reference book is the second volume in Rockport’s Pattern and Palette series.

Since Microsofts release of BizTalk Server 2006, there is a serious need for more documentation on this product. Foundations of BizTalk Server 2006 fills that void. The book will take you from novice to professional, equipping you with the tools you'll need to get started in the world of BizTalk server integration. From installation to deployment, you will grow increasingly more comfortable with the product as you work through a multitude of hands-on examples and demo applications. This book will demystify the product and emphasize the new 2006 BizTalk Server features. So even if you're a reluctant reader at first, youll gain full confidence in the product by books end.

David Litchfield has devoted years to relentlessly searching out the flaws in the Oracle database system and creating defenses against them. Now he offers you his complete arsenal to assess and defend your own Oracle systems. This in-depth guide explores every technique and tool used by black hat hackers to invade and compromise Oracle and then it shows you how to find the weak spots and defend them. Without that knowledge, you have little chance of keeping your databases truly secure.

IBM Tivoli Provisioning Manager, built on a Service Oriented Architecture, enhances usability for executing changes while keeping server and desktop software compliant. It helps organizations with provisioning, configuration and maintenance of servers and virtual servers, operating systems, middleware, applications, storage and network devices acting as routers, switches, firewalls, and load balancers. This IBM Redbooks publication is a study guide for IBM Tivoli Provisioning Manager V5.1 for people who want to get an IBM Professional Certification for this product. The IBM Tivoli Provisioning Manager V5.1 Certification, offered through the Professional Certification Program from IBM, is designed to validate the skills required of technical professionals who work in the implementation of the IBM Tivoli Provisioning Manager V5.1 product.This book provides a combination of theory and practical experience needed for a general understanding of the subject matter and sample questions that will help in the evaluation of personal progress and provide familiarity with the types of questions in the exam. The chapters are based on the sections of the Tivoli Provisioning Manager V5.1 Implementation Certification test. Studying each chapter will help you prepare for one section of the exam.

Since the enormous number of features made available with MySQL release 5.0, MySQL has been gaining steam as a viable alternative to database behemoths like Oracle and IBM DB2. MySQL users now have the ability to extend MySQL with new SQL commands, optimize query execution, and embed MySQL within low-resource environments like embedded devices and kiosks. Expert MySQL, by Dr. Charles A. Bell, is the first book to examine these opportunities in detail, showing you how to wield maximum control over this powerful open source database. You'll learn how to create your own custom storage handlers, ensuring maximum flexibility and speed within your specialized applications. You'll also gain valuable insight into MySQLs architecture and learn how to tweak its behavior through custom changes to the source code.

Arm yourself with the knowledge and tools to help you sell IBM® solutions and enable IBM clients to become innovative businesses enabled by on demand. This IBM Redbooks publication serves as a practical reference for those who desire to understand the IBM innovation enabled by on demand and how to sell the IBM innovative technology. It provides the perfect starting point for those who want to integrate on demand business concepts into their selling practice. It also serves as a guide for anyone preparing to take the IBM Certified for On Demand Business Solutions Advisor V2 Exam via Test 818. After reading this publication, your knowledge will expand in the following capacities:

This fast-paced book teaches you the basics of Access 2007 so you can start using this popular database program right away. You'll learn how to work with Access' most useful features to design databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. The new Access is radically different from previous versions, but with this book, you'll breeze through the new interface and its timesaving features in no time with: Clear explanations Step-by-step instructions Lots of illustrations Larger type Plenty of friendly advice Ideal for small businesses and households, Access runs on PCs and manages large stores information, including numbers, pages of text, and pictures -- everything from a list of family phone numbers to an enormous product catalog. Unfortunately, each new version of the program crammed in yet another set of features -- so many that even the pros don't know where to find them all. Access 2007 breaks the mold: Microsoft changed the user interface by designing a tabbed toolbar that makes features easy to locate. One thing that hasn't improved is Microsoft's documentation. Even if you find the features you need, you still may not know what to do with them. Access 2007 for Starters: The Missing Manual is the perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.

Beginning Database Design: From Novice to Professional provides short, easy-to-read explanations of how to get database design right the first time. This book offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. Through the help of use cases and class diagrams modeled in the UML, youll learn how to discover and represent the details and scope of the problem in question. Database design is not an exact science, and solid database design principles and examples help demonstrate the consequences of simplifications and pragmatic decisions. The rationale is to try to keep it simple, but allow room for development as situations change or resources permit. The book also features an introduction for implementing the final design in a relational database.

This IBM Redbooks publication is a study guide for IBM TotalStorage Productivity Center for Data Version 3.1, and it is targeted for professionals who want to get an IBM Certification in this specific product. This Certification, offered through the Professional Certification Program from IBM, is designed to validate the skills required of technical professionals who work in the implementation of the IBM TotalStorage Productivity Center for Data Version 3.1 product. This book provides a combination of theory and practical experiences necessary for a general understanding of the subject matter. It also provides sample questions that will help in the evaluation of personal progress and provide familiarity with the types of questions that will be encountered in the exam. This book does not replace practical experience, nor is it designed to be a stand-alone guide for any subject. Instead, it is an effective tool that, when combined with education activities and experience, can be a useful preparation guide for the exam.