A concise introduction to the fundamentals of working with MySQL. MySQL is an open-source relational database management system that is rapidly growing in popularity. Known for its speed, reliability, and ease of use, MySQL has proven itself to be particularly well suited both for beginners and for experienced developers to create sophisticated database-backed Web sites and applications. MySQL Tutorial is a clear, concise introduction to the fundamental concepts and techniques of working with MySQL. It teaches the beginning MySQL user how to create and administer powerful databases that can be used at home, at work, and on the Web. Whether you are a novice to databases or a technical professional looking to find out more about how MySQL works, MySQL Tutorial efficiently guides you through the information you need in order to get started with MySQL and quickly become proficient.

If you're seeking ways to build network-based applications or XML-based web services, Microsoft provides most of the tools you'll need. XML is integrated into the .NET Framework and Visual Studio .NET, but if you want to get a grasp on how .NET and XML actually work together, that's a different story. With .NET & XML, you can get under the hood to see how the .NET Framework implements XML, giving you the skills to write understandable XML-based code that interoperates with code written with other tools, and even other languages. .NET & XML starts by introducing XML and the .NET Framework, and then teaches you how to read and write XML before moving on to complex methods for manipulating, navigating, transforming, and constraining it. To demonstrate the power of XML in .NET, author Niel Bornstein builds a simple hardware store inventory system throughout the book. As you move from chapter to chapter, you'll absorb increasingly complex information until you have enough knowledge to successfully program your own XML-based applications. This tutorial also contains a quick reference to the API, plus appendices present additional .NET assemblies that you can use to work with XML, and how to work with the .NET XML configuration file format.One study puts the potential market for new software based on XML at or near $100 billion over the next five years. The .NET Framework gives you a way to become a part of it. But to use XML and .NET effectively, you need to understand how these two technologies work together. This book gives you the insight to take full advantage of the power the two provide.

This IBM Redbooks publication provides the foundation for establishing an automatic provisioning environment of Web server solutions. The material discussed in this book provides detailed information on using the IBM BladeCenter platform as a building block for hosting a highly available, multi-tier application. The book also shows how the IBM Director and Remote Deployment Manager software products can be used to automate the deployment of WebSphere software, and demonstrates how these products can be scripted to provide hot-standby and hot-addition of blade servers to running WebSphere clusters.. The additional software components of IBM Web Infrastructure Orchestration are designed to respond dynamically to Web capacity needs and utilization issues. This product bundle, based on the IBM eServer BladeCenter, consists of pre-integrated versions of WebSphere Application Server, DB2, Tivoli Storage Manager, Tivoli Monitoring, and TotalStorage hardware, coordinated by defined business policies and managed by IBM Tivoli Intelligent ThinkDynamic Orchestrator. This book is intended for an audience of experienced developers, designers, planners, network specialists, and testers of the software and hardware components listed above.

This IBM Redbooks publication builds upon two existing Redbooks: Working with Sametime Client Toolkits, SG24-6666 and Working with the Sametime Community Server Toolkit, SG24-6667. Focusing on the latest toolkits available for IBM Lotus Instant Messaging and Lotus Web Conferencing (Sametime) 3, it explores Sametime as a development platform, illustrating how to extend the functionality of Sametime beyond its more commonly known instant messaging and e-meeting hosting features. It provides a detailed technical discussion and examples for building and integrating Sametime real-time collaborative capabilities, presence awareness, and Web conferencing capabilities into both new and existing applications. In-depth discussions and code examples are provided for topics such as building custom bots, leveraging Sametime functionality through Web Services, and integrating Sametime into workflow applications. Additionally, this book reveals how you can customize (brand) your organization’s Sametime Meeting Center to more closely match the company’s identity. Finally, thorough analysis is given to the topics of Sametime Links and the Sametime Places architecture. Several samples of Sametime applications, with source code, are included. Ultimately, we hope this book will help you better appreciate how your organization may benefit by more effectively leveraging Sametime. Please note that the additional material referenced in the text is not available from IBM.

XSLT is a powerful language for transforming XML documents into something else. That something else can be an HTML document, another XML document, a Portable Document Format (PDF) file, a Scalable Vector Graphics (SVG) file, a Virtual Reality Modeling Language (VRML) file, Java code, or a number of other things. You write an XSLT stylesheet to define the rules for transforming an XML document, and the XSLT processor does the work.As useful as XSLT is, its peculiar characteristics make it a difficult language in which to get started. In fact, newcomers are often a little dazed on first contact. Learning XSLT offers a hands-on introduction to help them get up to speed with XSLT quickly. The book will help web developers and designers understand this powerful but often mystifying template-driven and functional-styled language, getting them over the many differences between XSLT and the more conventional programming languages. Learning XSLT moves smoothly from the simple to complex, illustrating all aspects of XSLT 1.0 through step-by-step examples that you'll practice as you work through the book. Thorough in its coverage of the language, the book makes few assumptions about what you may already know. You'll learn about XSLT's template-based syntax, how XSLT templates work with each other, and gain an understanding of XSLT variables. Learning XSLT also explains how the XML Path Language (XPath) is used by XSLT and provides a glimpse of what the future holds for XSLT 2.0 and XPath 2.0.The ability to transform one XML vocabulary to another is fundamental to exploiting the power of XML. Learning XSLT is a carefully paced, example-rich introduction to XSLT that will have you understanding and using XSLT on your own in no time.

UNIX Network Programming, Volume 1: The Sockets Networking API, Third Edition "Everyone will want this book because it provides a great mix of practical experience, historical perspective, and a depth of understanding that only comes from being intimately involved in the field. I've already enjoyed and learned from reading this book, and surely you will too." --Sam Leffler The classic guide to UNIX networking APIs... now completely updated! To build today's highly distributed, networked applications and services, you need deep mastery of sockets and other key networking APIs. One book delivers comprehensive, start-to-finish guidance for building robust, high-performance networked systems in any environment: UNIX Network Programming, Volume 1, Third Edition. Building on the legendary work of W. Richard Stevens, this edition has been fully updated by two leading network programming experts to address today's most crucial standards, implementations, and techniques. New topics include: POSIX Single UNIX Specification Version 3 IPv6 APIs (including updated guidance on IPv6/IPv4 interoperability) The new SCTP transport protocol IPsec-based Key Management Sockets FreeBSD 4.8/5.1, Red Hat Linux 9.x, Solaris 9, AIX 5.x, HP-UX, and Mac OS X implementations New network program debugging techniques Source Specific Multicast API, the key enabler for widespread IP multicast deployment The authors also update and extend Stevens' definitive coverage of these crucial UNIX networking standards and techniques: TCP and UDP transport Sockets: elementary, advanced, routed, and raw I/O: multiplexing, advanced functions, nonblocking, and signal-driven Daemons and inetd UNIX domain protocols ioctl operations Broadcasting and multicasting Threads Streams Design: TCP iterative, concurrent, preforked, and prethreaded servers Since 1990, network programmers have turned to one source for the insights and techniques they need: W. Richard Stevens' UNIX Network Programming. Now, there's an edition specifically designed for today's challenges--and tomorrow's.

This is the SQL reference you'll reach for first, every time! If you're an SQL programmer, you can easily picture how useful a comprehensive, single-volume Transact-SQL command reference manual would be in streamlining your work. And if that book was rich in examples, was written with users of all levels of expertise in mind, and was even designed to fit comfortably on your desktop, you'd probably buy it right away, wouldn't you? Well, look no further— Transact-SQL Desk Reference, by noted programming instructor Deac Lancaster, is exactly the book you need. As it turns out, Transact-SQL Desk Reference is just the book Deac himself was looking for. The problem was, no such book existed, so he saved programmers everywhere a lot of trouble and he wrote it himself! The book answers the question, "How exactly do I write a statement to do a particular job?" by providing the full syntax of each command along with examples showing each command in action. Then, to assist you in making your code more portable, Transact-SQL Desk Reference shows where Transact-SQL diverges from the ANSI SQL standard. The commands are arranged by functional area and are well indexed and cross-referenced, making it as easy as possible to find what you're looking for-even if you don't know the command's name. Inside, you'll find: SQL commands grouped logically by purpose and function, plus an index so you can jump right to the command Definitions that give the full syntax of each command, along with examples of each command in use plus tips on maximizing portability Additional chapters covering RDBMS concepts, details of Transact-SQL, and advanced SELECT queries! This book is intended for programmers of all levels working with Microsoft SQL Server.

This IBM Redbooks publication discusses how to install, tailor, and configure the IBM 2109 M12 FICON Director, in conjunction with the FICON topologies supported by IBM eServer zSeries (800, 900, and 990) and 9672 Generation 5 and Generation 6 servers. We focus on the hardware installation, as well as the software definitions needed to provide connectivity for the supported FICON environments. This book provides planning information and FICON Director setup information. We also include helpful utilities for monitoring and managing the IBM 2109 M12 FICON Director. This document is intended for system engineers, SAN administrators, and system programmers who will plan and install IBM 2109 M12 FICON Directors. A good background in systems planning, hardware and cabling infrastructure planning, and zSeries I/O definitions (HCD or IOCP), as well as Fibre Channel or FICON Directors, is assumed.

Take your database expertise to the next level! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and handy workarounds for Microsoft Office Access 2003 in concise, fast-answer format.

This IBM Redbooks publication introduces the reader to the world of EDI. In addition to general terms about EDI, it also introduces a number of products in this area. WebSphere Data Interchange is discussed as the translation engine to map EDI documents to and from documents in other formats. This book also introduces two communication products that use Internet technologies: iSoft’s P2PAgent and Trading Partner Interchange. In addition to product introductions, the book describes several implementation scenarios in a multi-partner and multi-product environment. Besides a network where trading partners only use iSoft’s P2PAgent, we also look at a setup where trading partners use a combination of the two products. For each communication product, we investigate several integration options with internal applications and other middleware. We discuss the integration options with the translation product WebSphere Data Interchange and with the process integration product WebSphere BI Interchange Server. The integration technique can be file-based or messaging-based. Finally, we take a look at options to combine the flexibility of the Internet with the reliability of value-added networks. When Internet connectivity is temporarily not available, a trading partner has the ability to use Expedite to dial into IBM’s network and send or receive EDI documents. By exploiting the recycle mechanics in iSoft's P2PAgent, we can implement a solution that provides a highly available connection between trading partners. For more up-to-date information about WebSphere B2B, please refer to the following books: Please note that the additional material referenced in the text is not available from IBM.

The IBM eServer Cluster 1600 server, which was introduced to meet the rigorous demands of mission-critical enterprise applications, continues to offer outstanding performance, scalability, reliability, availability, serviceability, and management capabilities. In this IBM Redbooks publication, we highlight the benefits of using a Cluster 1600, and describe which hardware components can be managed by either Parallel System Support Programs (PSSP) Version 3, Release 5, or Cluster Systems Management (CSM) Version 1, Release 3, Modification 2.

"I can pretty much guarantee that anyone who uses SQL Server on a regular basis (even those located in Redmond working on SQL Server) can learn something new from reading this book." --David Campbell, Product Unit Manager, Relational Server Team, Microsoft Corporation The latest book from the highly regarded and best-selling author Ken Henderson, is the consummate reference to Microsoft SQL Server. Picking up where documentation and white papers leave off, this book takes an all-inclusive approach to provide the most depth and breadth of coverage of any book on SQL Server architecture, internals, and tuning. The Guru's Guide to SQL Server Architecture and Internals Blending in-depth discussion with practical application, the guide begins with several chapters on the fundamental Windows technologies behind SQL Server, including processes and threads, memory management, Windows I/O, and networking. The focus then moves on to the architectural details of SQL Server and how to practically apply them. The entire SQL Server product is covered--not just the functionality that resides within the core executable or product features that have been in place for years. SQL Server has matured and broadened substantially with each release, and the author explores the "fringe" technologies that have yet to be covered elsewhere, including Notification Services, Full Text Search, SQLXML, replication, DTS, and a host of others. Throughout the book, the author uses WinDbg, Microsoft's free downloadable symbolic debugger, to look under the hood of SQL Server. Armed with new debugging and coding skills, readers will be ready to master SQL Server on their own. The accompanying CD-ROM is packed with additional material, including full source code for the book's 900+ examples, as well as three invaluable tools: DTSDIAG, the VBODSOLE Library, and DTS Package Guru. DTSDIAG allows developers and administrators to simultaneously collect Profiler traces, perform logs, blocking script output, system event logs, and SQLDIAG reports from a specified SQL Server. The VBODSOLE Library features more than twenty new COM-based functions for Transact-SQL, including T-SQL enhancements such as array-manipulation routines, financial functions, string-manipulation functions, and system functions. DTS Package Guru is a .NET-based package editor for SQL Server's Data Transformation Services that allows editing of any modifiable package and supports the automation of mass package changes. is the essential guide for database developers and admin- istrators alike, regardless of skill level. The Guru's Guide to SQL Server Architecture and Internals 0201700476B10012003

This IBM Redbooks publication implements a solution that integrates IBM Tivoli Workload Scheduler and IBM DB2 Content Manager OnDemand products to provide centralized output processing for job logs (job outputs, message files, and audit files) from IBM Tivoli Workload Scheduler and IBM Tivoli Workload Scheduler for z/OS. The solution provides immediate benefit by integrating the job logs into an online, electronic information archive and retrieval system, which is used for quick search and problem resolution purposes. We include all scripts that make up this solution so that you will be able customize the solution according to your needs. We anticipate that the solution covered in this book will provide great value for IBM Tivoli Workload Scheduler and IBM Tivoli Workload Scheduler for z/OS customers who are planning to deploy a centralized job logging and browsing system. Please note that the additional material referenced in the text is not available from IBM.

Enterprise Integration Patterns provides an invaluable catalog of sixty-five patterns, with real-world solutions that demonstrate the formidable of messaging and help you to design effective messaging solutions for your enterprise. The authors also include examples covering a variety of different integration technologies, such as JMS, MSMQ, TIBCO ActiveEnterprise, Microsoft BizTalk, SOAP, and XSL. A case study describing a bond trading system illustrates the patterns in practice, and the book offers a look at emerging standards, as well as insights into what the future of enterprise integration might hold. This book provides a consistent vocabulary and visual notation framework to describe large-scale integration solutions across many technologies. It also explores in detail the advantages and limitations of asynchronous messaging architectures. The authors present practical advice on designing code that connects an application to a messaging system, and provide extensive information to help you determine when to send a message, how to route it to the proper destination, and how to monitor the health of a messaging system. If you want to know how to manage, monitor, and maintain a messaging system once it is in use, get this book.

Sams Teach Yourself XML in 21 Days, written by expert author Steve Holzner, offers hundreds of real-world examples demonstrating the uses of XML and the newest tools developers need to make the most of it. In Week One, he starts from basic syntax, and discusses XML document structure, document types, and the benefits of XML Schema. Week Two covers formatting using either CSS or the Extensible Sytlesheet Language, and working with XHTML and other tools for presenting XML data on the Web, or in multimedia applications. The final chapter of week two discusses XForms, the newest way to process forms in XML applications. Week Three applies XML to programming with Java, .NET or JavaScript, and building XML into database or Web Service applications with SOAP. Along the way, Steve shows readers the results of every lesson and provides both the "how" and "why" of the inner working of XML technologies.

This IBM Redbooks publication helps you to implement Lotus Enterprise Integrator (LEI) 6 on the IBM eServer iSeries server. It is targeted for system administrators who plan to implement or upgrade to LEI 6 in their organization. The book provides tips and techniques to help you successfully deploy and administer LEI 6 on an iSeries server. Please note that the additional material referenced in the text is not available from IBM.

Praise for XForms: XML Powered Web Forms “XForms is an exciting new technology for designing Web forms in an elegant and accessible way. Raman’s book provides strong motivations for flexibility in the design of human-machine interactions, and explains how to use XForms to this end in crystal-clear prose.” — Eve Maler XML Standards Architect, Sun Microsystems “Interactive forms technology is the logical evolution of Web user interface design. XForms represents a significant leap forward in that evolution.” — Sean McGrath CTO, Propylon “The greatest strength of this book is the skill with which T. V. Raman links the XForms technology with the larger context of the Web. The limitations of HTML forms, the ways in which XForms provides a better foundation for Web and Web service user interfaces, and the opportunities for an XForms-powered Web that is accessible to all users and devices are outlined and brought together in a compelling way.” — Michael Champion Advisory Research and Development Specialist, Software AG “Raman’s book gives the reader an excellent explanation of the emerging W3C XForms recommendation. It’s a well-organized and well-written book that begins with a gentle introduction to the concepts that motivated the development of XForms and then provides a reasonable overview of the relevant XML technology related to XForms. Most of the book covers XForms components: user interface controls, model properties, functions, actions, and events. It concludes with XForms as a Web service, offering multi-modal access and accessibility. In light of the October 2003 deadline for U.S. federal agencies to comply with the mandate of the Government Paperwork Elimination Act (GPEA) to give citizens the opportunity to provide information online, this important technical work comes none too soon. As T. V. masterfully elucidates, XForms provides the ‘last mile’ in ‘connecting users to their data.’ Insightfully, he also observes ‘the document is the human interface’ to data—an understanding without which the challenge to make eGov services ‘citizen-centered’ simply cannot and will not be met.” — Owen Ambur Cofounder and Cochair, XML Working Group, U.S. CIO Council “I found the author’s straightforward style quite comfortable and informative. I heartily recommend this book, especially for government XML developers interested in the broader area of E-Forms. Understanding XForms is key to developing robust and flexible E-Forms solutions that separate content, logic, validation, and presentation. You’ll never look at (X)HTML forms the same way after reading Raman’s book.” — Kenneth Sall GSA eGov Technical Architect/XML Specialist, SiloSmashers “Reusable components such as E-Forms are at the heart of the U.S. Federal Enterprise Architecture and E-Government, and XML standards-based solutions are starting to appear for use across the government. T. V. Raman’s book meticulously explains how XForms leverage the power of using XML for E-Forms and have been designed to abstract much of XML’s functionality into a set of components referred to as MVC (Model, View, Controller), which separates the model from its final presentation. This XForms component architecture serves as an excellent roadmap for the reader. T. V. eloquently shows how XForms make the original promise of ‘the document is the interface’ a reality so the collected data can be directly submitted to a Web service—thus putting a human face on Web services!” —Brand Niemann, Ph.D., Chair, XML Web Services Working Group, U.S. CIO Council XForms—XML-powered Web forms—are set to replace HTML forms as the backbone of electronic commerce. XForms enable the creation and editing of structured XML content within a familiar Web browser environment, which is likely to play a key role in enabling simple browser-based access to Web services. XForms leverage the power of XML in modeling, collecting, and serializing user input. In this book, World Wide Web Consortium (W3C) XForms specification editor T. V. Raman explains how programmers can create durable and dependable feature-rich forms accessible from multiple platforms and devices and available in multiple languages and modes. XForms play a key role in connecting humans to information technologies, deployed as Web services. This book begins by providing an overview of the XForms technology and the set of XML standards on which it is built, including XML Path Language (XPath), Dom2 events, XML events, XML namespaces, and XML Schema. Part II profiles the XForms architecture and its components. An introduction to the available user interface controls leads into a guide to creating complex user interfaces. The following chapters describe XForms model properties, functions, actions, and events. Each chapter’s increasingly complex examples illustrate the concepts discussed. The final part of the book details how XForms will be used to create a new generation of human-centric, multimodal, accessible Web transactions. Readers will learn: Why XForms can deliver better user interaction at less cost How the XForms technology works What comprises the XForms architecture How to use XForms to connect users to Web services How XForms can accommodate spoken and visual interaction How to ensure universal accessibility to Web content with XForms XForms will transform the way companies and consumers handle Web transactions. provides Web developers, IT professionals, and Web server administrators with a firm grasp of this standard, how it will shape emerging solutions, and how it will change the nature of their day-to-day work. XForms: XML Powered Web Forms

XQuery Kick Start delivers a concise introduction to the XQuery standard, and useful implementation advice for developers needing to put it into practice. The book starts by explaining the role of XQuery in the XML family of specifications, and its relationship with XPath. The authors then explain the specification in detail, describing the semantics and data model, before moving to examples using XQuery to manipulate XML databases and document storage systems. Later chapters discuss Java implementations of XQuery and development tools that facilitate the development of Web sites with XQuery. This book is up to date with the latest XQuery specifications, and includes coverage of new features for extending the XQuery language.

Praise for Effective XML “This is an excellent collection of XML best practices: essential reading for any developer using XML. This book will help you avoid common pitfalls and ensure your XML applications remain practical and interoperable for as long as possible.” — Edd Dumbill, Managing Editor, XML.com and Program Chair, XML Europe “A collection of useful advice about XML and related technologies. Well worth reading both before, during, and after XML application development.” — Sean McGrath, CTO, Propylon “A book on many best practices for XML that we have been eagerly waiting for.” — Akmal B. Chaudhri, Editor, IBM developerWorks “The fifty easy-to-read items cover many aspects of XML, ranging from how to use markup effectively to what schema language is best for what task. Sometimes controversial, but always relevant, Elliotte Rusty Harold’s book provides best practices for working with XML that every user and implementer of XML should be aware of.” — Michael Rys, Ph.D., Program Manager, SQL Server XML Technologies, Microsoft Corporation “ Effective XML is an excellent book with perfect timing. Finally, an XML book everyone needs to read! Effective XML is a fount of XML best practices and solid advice. Whether you read Effective XML cover to cover or randomly one section at a time, its clear writing and insightful recommendations enlighten, entertain, educate, and ultimately improve the effectiveness of even the most expert XML developer. I’ll tell you what I tell all my coworkers and customers: You need this book.” — Michael Brundage, Technical Lead, XML Query Processing, Microsoft WebData XML Team “This book provides great insight for all developers who write XML software, regardless of whether the software is a trivial application-specific XML processor or a fullblown W3C XML Schema Language validator. Mr. Harold covers everything from a very important high-level terminology discussion to details about parsed XML nodes. The well-researched comparisons of currently available XML-related software products, as well as the key criteria for selecting between XML technologies, exemplify the thoroughness of this book.” — Cliff Binstock, Author, The XML Schema Complete Reference If you want to become a more effective XML developer, you need this book. You will learn which tools to use when in order to write legible, extensible, maintainable and robust XML code. Page 36: How do you write DTDs that are independent of namespace prefixes? Page 82: What do parsers reliably report and what don't they? Page 130: Which schema language is the right one for your job? Page 178: Which API should you choose for maximum speed and minimum size? Page 257: What can you do to ensure fast, reliable access to DTDs and schemas without making your document less portable? Page 283: Is XML too verbose for your application? Elliotte Rusty Harold provides you with 50 practical rules of thumb based on real-world examples and best practices. His engaging writing style is easy to understand and illustrates how you can save development time while improving your XML code. Learn to write XML that is easy to edit, simple to process, and is fully interoperable with other applications and code. Understand how to design and document XML vocabularies so they are both descriptive and extensible. After reading this book, you'll be ready to choose the best tools and APIs for both large-scale and small-scale processing jobs. Elliotte provides you with essential information on building services such as verification, compression, authentication, caching, and content management. If you want to design, deploy, or build better systems that utilize XML—then buy this book and get going!

This second edition of the bestselling Learning XML provides web developers with a concise but grounded understanding of XML (the Extensible Markup Language) and its potential-- not just a whirlwind tour of XML.The author explains the important and relevant XML technologies and their capabilities clearly and succinctly with plenty of real-life projects and useful examples. He outlines the elements of markup--demystifying concepts such as attributes, entities, and namespaces--and provides enough depth and examples to get started. Learning XML is a reliable source for anyone who needs to know XML, but doesn't want to waste time wading through hundreds of web sites or 800 pages of bloated text.For writers producing XML documents, this book clarifies files and the process of creating them with the appropriate structure and format. Designers will learn what parts of XML are most helpful to their team and will get started on creating Document Type Definitions. For programmers, the book makes syntax and structures clear. Learning XML also discusses the stylesheets needed for viewing documents in the next generation of browsers, databases, and other devices. Learning XML illustrates the core XML concepts and language syntax, in addition to important related tools such as the CSS and XSL styling languages and the XLink and XPointer specifications for creating rich link structures. It includes information about three schema languages for validation: W3C Schema, Schematron, and RELAX-NG, which are gaining widespread support from people who need to validate documents but aren't satisfied with DTDs. Also new in this edition is a chapter on XSL-FO, a powerful formatting language for XML. If you need to wade through the acronym soup of XML and start to really use this powerful tool, Learning XML, will give you the roadmap you need.

How profitable (or successful) is your e-business investment? How effective is your e-business at attracting new customers and retaining existing ones? What is the availability of your e-business Web server infrastructure and performance of your Web transactions? These questions, which are critical in measuring e-business success, are both behavioral and operational in nature. It is necessary to measure both e-business and IT metrics, which are closely linked, and have a direct effect on each other. For example, a spike in web traffic (or a single hit for that matter) has a direct effect on server load and the systems that process the transaction. Therefore, it is critical to analyze each of these metrics and draw correlations between them.

IBM DB2 Universal Database v8.1.2 will help you access any information, from any application, from anywhere in your organization, anytime—and do it all more easily and cost-effectively than you ever thought possible. Now, in DB2 Version 8: The Official Guide, a team of IBM DB2 experts shows experienced DB2 professionals exactly how to make the most of DB2 Version 8 in any environment—Linux®, UNIX®, or Windows®. The authors draw on extensive personal experience helping customers implement state-of-the-art DB2 solutions, and unparalleled access to the IBM DB2 development team. They offer detailed, never-before-published technical guidance for the key challenges you'll face in delivering high-performance DB2 databases, e-business infrastructure, and enterprise integration solutions. Coverage includes: Simplifying management with the Configuration Advisor, HealthCenter(, and Memory Visualizer Integrating the enterprise via Federated Web Services and the DB2 enhanced XML productivity tools Maximizing database scalability, availability, and robustness Using multidimensional data clustering and other integrated business intelligence tools Integrating with IBM WebSphere and Microsoft software development tools Leveraging key improvements in DB2 SQL functionality The accompanying CD-ROM contains a complete trial version of IBM® DB2® Universal Database Personal Edition Version 8.1, for Windows® Operating Environments, Evaluation Copy, plus the DB2 demonstration program for trying out the various SQL commands on your own machine. If you're an experienced DB2 professional who's ready to take DB2 Version 8 to the max, DB2 Version 8: The Official Guide is the book you've been searching for.

Oracle system performance inefficiencies often go undetected for months or even years--even under intense scrutiny--because traditional Oracle performance analysis methods and tools are fundamentally flawed. They're unreliable and inefficient.Oracle DBAs and developers are all too familiar with the outlay of time and resources, blown budgets, missed deadlines, and marginally effective performance fiddling that is commonplace with traditional methods of Oracle performance tuning. In this crucial book, Cary Millsap, former VP of Oracle's System Performance Group, clearly and concisely explains how to use Oracle's response time statistics to diagnose and repair performance problems. Cary also shows how "queueing theory" can be applied to response time statistics to predict the impact of upgrades and other system changes. Optimizing Oracle Performance eliminates the time-consuming, trial-and-error guesswork inherent in most conventional approaches to tuning. You can determine exactly where a system's performance problem is, and with equal importance, where it is not, in just a few minutes--even if the problem is several years old. Optimizing Oracle Performance cuts a path through the complexity of current tuning methods, and streamlines an approach that focuses on optimization techniques that any DBA can use quickly and successfully to make noticeable--even dramatic--improvements.For example, the one thing database users care most about is response time. Naturally, DBAs focus much of their time and effort towards improving response time. But it is entirely too easy to spend hundreds of hours to improve important system metrics such as hit ratios, average latencies, and wait times, only to find users are unable to perceive the difference. And an expensive hardware upgrade may not help either.It doesn't have to be that way. Technological advances have added impact, efficiency, measurability, predictive capacity, reliability, speed, and practicality to the science of Oracle performance optimization. Optimizing Oracle Performance shows you how to slash the frustration and expense associated with unraveling the true root cause of any type of performance problem, and reliably predict future performance.The price of this essential book will be paid back in hours saved the first time its methods are used.

Easy Microsoft Office Access 2003 takes the work out of learning this powerful database by using short, easy-to-follow lessons that show you how to accomplish basic tasks quickly and efficiently! It is the perfect book for beginners who want to learn Microsoft's database application through a visual, full-color approach. More than 100 hands-on lessons are designed to teach the easiest, fastest, or most direct way to accomplish common Access tasks. The book is suited for new Access users, as well as those upgrading from an earlier version.

Microsoft Access 11 is a powerful, relational database software package that makes it easier for you to create and manage complex databases. With Access, you can create a database quickly from scratch or by using and Access database Wizard. Once you¿ve created your database, Access provides all the tools you need to enter and manipulate data. Using Access, you can do the following: Quickly start a new database by using the Database Wizard. Create tables from scratch or by using a Wizard. Add and edit database information by using both tables and forms. Manipulate data in a number of tables by using queries and reports.