With the XQuery 1.0 standard, you finally have a tool that will make it much easier to search, extract and manipulate information from XML content stored in databases. This in-depth tutorial not only walks you through the XQuery specification, but also teaches you how to program with this widely anticipated query language. XQuery is for query writers who have some knowledge of XML basics, but not necessarily advanced knowledge of XML-related technologies. It can be used both as a tutorial, by reading cover to cover, and as a reference, by using the comprehensive index and appendixes. Either way, you will find the background knowledge in namespaces, schemas, built-in types and regular expressions that is relevant to writing XML queries. This book provides: A high-level overview and quick tour of XQuery Information to write sophisticated queries, without being bogged down by the details of types, namespaces, and schemas Advanced concepts for users who want to take advantage of modularity, namespaces, typing and schemas Guidelines for working with specific types of data, such as numbers, strings, dates, URIs and processing instructions A complete alphabetical reference to the built-in functions and types You will also learn about XQuery's support for filtering, sorting, and grouping data, as well as how to use FLWOR expressions, XPath, and XQuery tools for extracting and combining information. With this book, you will discover how to apply all of these tools to a wide variety of data sources, and how to recombine information from multiple sources into a single final output result. Whether you're coming from SQL, XSLT, or starting from scratch, this carefully paced tutorial takes you through the final 1.0 standard in detail.

SQL Server 2005 Integration Services (SSIS) lets you build high-performance data integration solutions. SSIS solutions wrap sophisticated workflows around tasks that extract, transform, and load (ETL) data from and to a wide variety of data sources. This Short Cut begins with an overview of key SSIS concepts, capabilities, standard workflow and ETL elements, the development environment, execution, deployment, and migration from Data Transformation Services (DTS). Next, you'll see how to apply the concepts you've learned through hands-on examples of common integration scenarios. Once you've finished this Short Cut, you'll have the background and understanding you need to start building your own SSIS integration solutions.

Pro Access 2007M covers the features of Microsoft Access 2007, including working with SharePoint Office Server and customizing Ribbons. The book is aimed at professional developers and power users who are new to Access 2007. Among other topics, youll learn about the new Access menu structure, including customization, as well as new SharePoint features. This book provides good, short, solid information with as little waffle as possible. And the book includes solid examples that thoroughly explain new features. Author Martin Reid is also a working Access developer who is respected by his peers and knows what working developers face, especially at the time of a new release. What you'll learn Creating custom menus using RibbonX Get up and running building Visual Basic for Applications Classes Learn about Microsoft Office SharePoint Server and how it fits into Access Working with SQL Server and using the new Microsoft Access 2007 to SQL Server 2005 tools Code examples provided to highlight real-world issues Use Access and .NET to present information via the Internet

Schematron is a rule-based XML schema language, offering flexibility and power that W3C XML schema, RELAX NG, and DTDs simply can't match. You need Schematron and can't settle for other languages if you have to check rules that go beyond checking the document structures (i.e., checking that an element bar is included in element foo) and their datatypes. Schematron is the right tool for checking conditions such as "startDate is earlier than or equal to endDate." Schematron is also the right tool to use if you have to raise user-friendly error messages rather than depend on error messages that are generated by a schema processor and that are often obscure. Schematron builds on XPath. You will need to understand XPath to to get the most from Schematron.

This Short Cut introduces you to how SQL injection vulnerabilities work, what makes applications vulnerable, and how to protect them. It helps you find your vulnerabilities with analysis and testing tools and describes simple approaches for fixing them in the most popular web-programming languages. This Short Cut also helps you protect your live applications by describing how to monitor for and block attacks before your data is stolen. Hacking is an increasingly criminal enterprise, and web applications are an attractive path to identity theft. If the applications you build, manage, or guard are a path to sensitive data, you must protect your applications and their users from this growing threat.

Real Application Clusters (RAC) and the Grid architecture are Oracle's strategy for scaling out enterprise systems to cope with bigger workloads and more users. Many books limit themselves by conceptualizing and theorizing about RAC technology, but this book is the first to portray implementing and administering an Oracle 10 g RAC system in a Linux environment. This book features basic concepts underlying Linux and Oracle RAC, design strategies, hardware procurement and configuration, and many other topics. The RAC-specific technologies described include configuration of the interconnect, OCFS, ASM, Cluster Ready Services, and Grid Control. The Oracle features RMAN and Data Guard are also discussed, along with available hardware options. The authors include practical examples and configuration information, so that upon reading this book, you'll be armed with the information you need to build an Oracle RAC database on Linux, whether it is on a single laptop or a 64-node Itanium cluster.

This IBM Redbooks publication provides best practices for deploying IBM System Storage N series storage systems, in support of mySAP Business Suite solutions that run in UNIX and NFS environments that use a DB2 database. We address common storage infrastructure design, operation, and management challenges that are faced by businesses and IT personnel, deploying the latest generation of SAP solutions.

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.