For the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL. The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10 g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers. The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization. Co-authored by the world's foremost PL/SQL authority, Steven Feuerstein, this classic reference provides language syntax, best practices, and extensive code, ranging from simple examples to complete applications--making it a must-have on your road to PL/SQL mastery. A companion web site contains many more examples and additional technical content for enhanced learning.

This IBM Redbooks publication is part of a series of documents related to grid computing that IBM is presenting to the IT community to enrich it and all its players: clients, industry leaders, emerging enterprises, universities, and producers of technology. It is mainly oriented to IT architects or those who have the responsibility of analyzing the capabilities of the product used to build a grid solution. We describe the functions of grid computing and the categorizations of the components within it. IBM, ISVs, and open source products will be explained. Some of these products are not specific for grid, but they can be used in a grid computing environment. We hope that this book helps you select functions and products and shows you how grid can fit into your IT picture as new products and services for grid are introduced. Part 1 introduces the concept of grid computing and provides the terminology the readers will use in this book. Part 2 explores the functionality associated with certain products and product families. It also presents some examples of the utilization of these products in the grid computing environment. Part 3 presents grid computing product families that can be used to build a complete grid solution. These bundles, or suites, often implement most of the core grid disciplines. Part 4 gives an overview of the grid computing offerings and services that IBM provides.

XSLT is an essential tool for converting XML into other kinds of documents: HTML, PDF file, and many others. It's a critical technology for XML-based platforms such as Microsoft .NET, Sun Microsystems' Sun One, as well as for most web browsers and authoring tools. As useful as XSLT is, however, most people have a difficult time getting used to its peculiar characteristics. The ability to use advanced techniques depends on a clear and exact understanding of how XSLT templates work and interact. The XSLT 1.0 Pocket Reference from O'Reilly wants to make sure you achieve that level of understanding. With its concise approach, this handy pocket guide quickly gets you up to speed on XSLT 1.0 so you can covert XML like a seasoned pro. In addition to covering the basics of stylesheet structure, it also explains how to: use template rules create a result tree apply conditional processing transform multiple source documents employ number formatting Thanks to their convenient, quick-reference format, O'Reilly's Pocket References spare you from having to hunt through larger books for answers. They deliver just what you need to get the job done in a timely fashion. And the XSLT 1.0 Pocket Reference is no different--it's the ideal companion to have at your desk when you need an answer fast.

The Oracle database is one of the most popular in the world, and for good reason. It's compatible, scalable, portable, and capable of performing incredibly fast. The advantages Oracle holds over its competition come with a price, however--it's a highly complex database that's becoming more complex with every release. And this level of detail, of course, can begin to weigh on database administrators (DBAs). Fortunately, the Oracle DBA Pocket Guide from O'Reilly is on the case. This handy reference is designed to help administrators make more effective use of their time by presenting a compact summary of DBA tasks in an easy-to-use form. With this book by your side, you'll have instant access to the most important concepts, best practices, tips, and checklists. Key topics include architecture, installation, configuration, tuning, and backup/recovery. Everything that you absolutely must know to do your job well is right there at your fingertips. Moreover, the Oracle DBA Pocket Guide covers Oracle Database 9i, as well as its latest release, Oracle Database 10g. The first database designed for enterprising grid computing, Oracle Database 10g significantly reduces the cost of managing the IT environment with a simplified install, reduced configuration and management requirements, and automatic performance diagnosis and SQL tuning. The latest in O'Reilly's line of bestselling Oracle titles, this book is an invaluable companion for any database administrator--new or experienced--interested in reviewing core Oracle concepts at a glance.

XML, the Extensible Markup Language, is everywhere: the syntax of choice for newly designed document formats across almost all computer applications. Now used daily by developers, XML is living up to its reputation as one of the most important developments in document interchange in the history of computing. A perennial bestseller, the handy XML Pocket Reference from O'Reilly has been revised once again to give you quick access to the latest goods. In addition to its comprehensive look at XML, this third edition has been updated with new material on Namespaces and XML Schema--considered among the most important elements in current XML use--along with RELAX NG and Schematron, additional powerful tools for describing XML document structures. Like other titles in O'Reilly's Pocket Reference series, the XML Pocket Reference, 3rd Edition features a well-organized format that gets right to the point. As a result, it's already won over the allegiance of developers everywhere. If you need XML answers quick and on the fly, this compact book is most definitely the book for you.

This IBM Redbooks publication presents an overview of IBM Tivoli Storage Manager Version 5.3. It is designed as a workshop presentation guide, and therefore uses presentation slides to provide descriptions about the changes made in the new release. This format enables you to easily gain a comprehensive overview and to quickly understand the new features of Tivoli Storage Manager. This book is intended for IBM Clients, Business Partners, consultants, and IBM and Tivoli staff who are familiar with earlier releases of Tivoli Storage Manager and who want to understand what is new in Version 5.3.0, 5.3.1, and 5.3.2. We recommend that you use this book in conjunction with the ITSO workshop, the book "IBM Tivoli Storage Manager Version 5.3 Technical Guide", SG24-6638, manuals and readme files that are provided with the products. This book is not intended to replace any information contained therein.

IBM Workplace Services Express is software that makes it easy for you, your colleagues, your teams, and your entire organization to quickly collaborate and effectively work together. Designed specifically for small and medium-sized organizations with less than a thousand employees, or departmental needs in larger organizations, Workplace Services Express enables you to easily create, edit, and share documents from your own customized Workplace environment. This IBM Redbooks publication will introduce you to Workplace Services Express and its features and tell you how to deploy and customize it. Whether you are a line-of-business manager who wants to understand the business value of Workplace Services Express, an administrator who wants to install it, or an application developer who wants to customize it, this book is for you. Please note that the additional material referenced in the text is not available from IBM.

From the moment you're born, you enter the data stream-from birth certificates to medical records to what you bought on Amazon last week. As your dossier grows, so do the threats, from identity thieves to government snoops to companies who want to sell you something. Computer Privacy Annoyances shows you how to regain control of your life. You'll learn how to keep private information private, stop nosy bosses, get off that incredibly annoying mailing list, and more. Unless you know what data is available about you and how to protect it, you're a sitting duck. Computer Privacy Annoyances is your guide to a safer, saner, and more private life. Written by privacy pro Dan Tynan, and based on interviews with privacy experts from all over the globe, Computer Privacy Annoyances serves up real-world advice in bite-sized portions that will help you stop the snoops in their tracks. The book even addresses non-computing threats, from telemarketer-cum-stalkers, thieves at your mailbox, nosy folks in your HR department, cell phone eavesdroppers, and more. The key areas covered include: Privacy at Home Privacy on the Net Privacy at Work Privacy in Public Privacy and Uncle Sam Privacy in the Future Daniel Tynan has written about Internet privacy and security for nearly a decade. His work has appeared in more than 40 national publications. As executive editor at PC World, Tynan edited a special issue on Internet Privacy that won a Grand Neal Award and was a finalist for a National Magazine Award. He has won more than a dozen other honors, including nine Neals, four Maggies, and two Computer Press Association Awards.

The acquisition of Informix by IBM has provided the opportunity for Informix customers to consider new alternatives to further enrich their data management systems infrastructure. They can now more easily take advantage of available products, services, and capabilities as they grow and change. This IBM Redbooks publication focuses on strategies, techniques, capabilities, and considerations for using Informix Extended Parallel Server (XPS) and DB2 Universal Database (UDB). It provides detailed discussions and data to give a good understanding of the two products, their capabilities, and their similarities. XPS customers can choose to adopt a database strategy of coexistence or consider transitioning to DB2 UDB. The features and functionality of each DBMS are briefly described for a better understanding, in areas such as architecture, partitioning techniques, SQL considerations, configuration, indexing, data types, DML, and DDL. It also discusses products and tools to complement these database management systems. With this information, you can better decide which products satisfy your particular requirements, and better plan on how to achieve your objectives as you develop your database management system strategy. You will be better positioned to make informed decisions that can give you the best return on your DBMS investment.

This IBM Redbook introduces the IBM System z9 109 (z9-109), which offers a continuation of the IBM scalable mainframe servers. The z9-109 server is based on z/Architecture and provides extensions to the architecture. In addition to increased performance and expansion options, particular emphasis has been placed on the integration of the z9-109 into a complete system and software environment.

MS/VCR provides a fast, reliable facility with high integrity for the renaming and recataloging of data sets on target volumes after a FlashCopy or Snapshot volume copy, solving the cloned data access dilemma. This facility enables the immediate use of the data from the same system as the original copy. MS/VCR resolves catalog conflicts of like-named datasets that are created by "cloning" a volume. It also solves internal conflicts that are created when copying a volume to a different VOLSER. MS/VCR is designed to rename and catalog target volume datasets in record time. The window of time required to copy and rename a target dataset is a critical factor for many customers. This IBM Redbooks publication provides a broad understanding of the MS/VCR product and how to use it in real situations.

The second edition of the best-selling PostgreSQL has been updated to completely cover new features and capabilities of the 8.0 version of PostgreSQL. You will be lead through the internals of the powerful PostgreSQL open source database chapter, offering an easy-to-read, code-based approach that makes it easy to understand how each feature is implemented, how to best use each feature, and how to get more performance from database applications. This definitive guide to building, programming and administering the powerful PostgreSQL open-source database system will help you harness one of the most widely used open source, enterprise-level database systems.

This IBM Redbooks publication provides advice for Business Partners or other technical people about how to plan, implement, and demonstrate IBM Tivoli Storage Manager Version 5.3 in a proof-of-concept simulated environment. This environment can be used to demonstrate the capabilities of the IBM Tivoli Storage Manager solutions using customer data, in order to gain customer acceptance for the next phase of the sell cycle to engage the Business Partner in a real proof-of-concept of IBM Tivoli Storage Manager. Please note that the additional material referenced in the text is not available from IBM.

Deploying and managing distributed systems in hundreds or thousands of branch banks and retail stores, called outlets, requires careful planning of the automation to cope with the sheer numbers of systems involved. This IBM Redbooks publication demonstrates how to architect, establish, and configure a Tivoli systems management environment that supports the central management of thousands of outlet systems based on the open United Linux platform. The main focus of this book is to provide step-by-step instructions, sample scripts, and code to install and deploy the core Tivoli products that enable the organization to: - Deploy and maintain distributed application solutions This book is intended for IT professionals with a basic understanding of the core Tivoli product set and who are responsible for deploying a Tivoli management infrastructure. Please note that the additional material referenced in the text is not available from IBM.

In development scenarios where things can't be run in a debugger, or when you run the risk of masking the problem, logs are the greatest source of information about running a program. Pro Apache Log4j, Second Edition provides best practices guidelines and comprehensive coverage of the most recent release. Step by step, the book explains core concepts, from basic to advanced. Code samples are in Java and include guidelines for different application-specific needs. You’ll also learn how to extend the API to write custom components and best practices for using the feature-rich log4j API. This book concludes with enterprise Java applications using log4j with JSP and J2EE.

This IBM Redbooks publication is an easy-to-follow guide that describes how to implement IBM Tivoli Storage Manager Version 5.3 products in highly available clustered environments. The book is intended for those who want to plan, install, test, and manage the IBM Tivoli Storage Manager Version 5.3 in various environments by providing best practices and showing how to develop scripts for clustered environments. The book covers the following environments: IBM AIX HACMP, IBM Tivoli System Automation for Multiplatforms on Linux and AIX, MicrosoftCluster Server on Windows 2000 and Windows 2003, VERITAS Storage Foundation HA on AIX, and Windows Server 2003 Enterprise Edition. Please note that the additional material referenced in the text is not available from IBM.

With the help of the Internet and accompanying tools, creating and publishing online maps has become easier and rich with options. A city guide web site can use maps to show the location of restaurants, museums, and art venues. A business can post a map for reaching its offices. The state government can present a map showing average income by area.Developers who want to publish maps on the web often discover that commercial tools cost too much and hunting down the free tools scattered across Internet can use up too much of your time and resources. Web Mapping Illustrated shows you how to create maps, even interactive maps, with free tools, including MapServer, OpenEV, GDAL/OGR, and PostGIS. It also explains how to find, collect, understand, use, and share mapping data, both over the traditional Web and using OGC-standard services like WFS and WMS.Mapping is a growing field that goes beyond collecting and analyzing GIS data. Web Mapping Illustrated shows how to combine free geographic data, GPS, and data management tools into one resource for your mapping information needs so you don't have to lose your way while searching for it.Remember the fun you had exploring the world with maps? Experience the fun again with Web Mapping Illustrated. This book will take you on a direct route to creating valuable maps.

The authoritative, hands-on guide to advanced MySQL programming and administration techniques for high performance is here. MySQL Database Design and Tuning is the only guide with coverage of both the basics and advanced topics, including reliability, performance, optimization and tuning for MySQL. This clear, concise and unique source for the most reliable MySQL performance information will show you how to: Deploy the right MySQL product for your performance needs. Set up a performance management and monitoring environment using tools from MySQL. Implement the right indexing strategy Apply good performance strategy when developing software to work with the MySQL database. Configure dozens of variable to correctly tune the MySQL engine. If you deal with the intricacies and challenges of advanced MySQL functionality on a daily basis, you will be able to build on your knowledge with author Robert Schneider's real-world experiences in MySQL Database Design and Tuning.

Since the dawn of creation, man has designed maps to help identify the space that we occupy. From Lewis and Clark's pencil-sketched maps of mountain trails to Jacques Cousteau's sophisticated charts of the ocean floor, creating maps of the utmost precision has been a constant pursuit. So why should things change now? Well, they shouldn't. The reality is that map creation, or "cartography," has only improved in its ease-of-use over time. In fact, with the recent explosion of inexpensive computing and the growing availability of public mapping data, mapmaking today extends all the way to the ordinary PC user. Mapping Hacks, the latest page-turner from O'Reilly Press, tackles this notion head on. It's a collection of one hundred simple--and mostly free--techniques available to developers and power users who want draw digital maps or otherwise visualize geographic data. Authors Schuyler Erle, Rich Gibson, and Jo Walsh do more than just illuminate the basic concepts of location and cartography, they walk you through the process one step at a time. Mapping Hacks shows you where to find the best sources of geographic data, and then how to integrate that data into your own map. But that's just an appetizer. This comprehensive resource also shows you how to interpret and manipulate unwieldy cartography data, as well as how to incorporate personal photo galleries into your maps. It even provides practical uses for GPS (Global Positioning System) devices--those touch-of-a-button street maps integrated into cars and mobile phones. Just imagine: If Captain Kidd had this technology, we'd all know where to find his buried treasure! With all of these industrial-strength tips and tools, Mapping Hacks effectively takes the sting out of the digital mapmaking and navigational process. Now you can create your own maps for business, pleasure, or entertainment--without ever having to sharpen a single pencil.

This IBM Redbooks publication provides practical information related to problem determination using IBM Self-Managing Autonomic Technology, with an emphasis on the components provided by the IBM Autonomic Computing Toolkit. The primary objective of this book is to empower software developers to provide facilities to enable applications or other system components to participate in an autonomic environment and focuses on the problem determination capabilities provided by the IBM Autonomic Computing Toolkit and other Self-Managing Autonomic Technology. The tools, components, and techniques used and demonstrated in this book provide the base for automating problem determination and self-healing of applications and components using Self-Managing Autonomic Technology. As with the technologies themselves, components of the IBM Autonomic Computing Toolkit will evolve as new capabilities and tools become available. Software developers are encouraged to check the latest releases of both IBM Autonomic Computing Toolkit and other tools provided by IBM at http://www.ibm.com/developerworks/autonomic. Please note that the additional material referenced in the text is not available from IBM.