This is a defining book on the Oracle database for any developer or database administrator who works with Oracle-driven database applications. Tom Kyte has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you will find that there are few information management problems that you cannot solve quickly and elegantly. Expert Oracle Database Architecture is the first of a three-book series that completely explores and defines the Oracle database. It covers all of the most important Oracle architecture features, including: Files, memory structures and processes Locking and latching Transactions, concurrency and multi-versioning Tables and Indexes Datatypes Partitioning and parallelism Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it. This fully revised edition covers both the 9 i and 10 g versions. It also comes with a CD containing a searchable PDF of the 8 i version of the book.M Tom has fully revised and expanded the architecture-related sections from Expert One-on-One Oracle (a searchable PDF of which is included on the CD accompanying this book), and added substantial new material. He focuses solely on 9 i and 10 g architecture in this book and refers to the CD for 8 i-specific details. The number of changes will surprise you. In summary, this book provides a one-stop resource containing deep wisdom on the design, development and administration of Oracle applications, written by one of the world's foremost Oracle experts, Thomas Kyte.

IBM Tivoli Configuration Manager controls software distribution and asset management inventory in a multiplatform environment. It is designed for configuration, distribution, change, version, and asset management in a distributed computing environment. Working on top of IBM Tivoli Management Framework, IBM Tivoli Configuration Manager provides an integrated solution for managing complex, distributed enterprise environments. This IBM Redbooks publication introduces the IBM Tivoli Configuration Manager logical and physical components and covers detailed planning and implementation steps to deploy IBM Tivoli Configuration Manager in small-to-medium and large-sized environments, including IBM AIX 5L, Microsoft Windows, Linux, and IBM OS/400 systems. In addition, we talk about best practices, advanced customization, and tuning topics for IBM Tivoli Configuration Manager. This book will be useful for IT specialists responsible for implementing IBM Tivoli Configuration Manager V4.2.x in customer environments. Please note that the additional material referenced in the text is not available from IBM.

Experienced PL/SQL programmers and Oracle developers will learn to master Oracle's procedural extension to industry-standard SQL. Using this authoritative resource, readers will become experts at developing robust, high-performance enterprise applications with PL/SQL. Detailed examples describe the practical aspect of each feature, and provide ideas to the reader of how they can best exploit the functionality.

Linux on zSeries offers many advantages to customers who rely upon IBM mainframe systems to run their businesses. Linux on zSeries takes advantage of the qualities of service in the zSeries hardware—making it a robust industrial strength Linux. This provides an excellent platform for consolidating Oracle databases that exist in your enterprise. This IBM Redbooks publication describes experiences gained while installing and testing Oracle10g for Linux on zSeries, such as: -Installing a single instance database of Oracle10g instances for Linux on zSeries Interested readers include database consultants, installers, administrators, and system programmers.

Moving Objects Databases is the first uniform treatment of moving objects databases, the technology that supports GPS and RFID. It focuses on the modeling and design of data from moving objects — such as people, animals, vehicles, hurricanes, forest fires, oil spills, armies, or other objects — as well as the storage, retrieval, and querying of that very voluminous data. It includes homework assignments at the end of each chapter, exercises throughout the text that students can complete as they read, and a solutions manual in the back of the book. This book is intended for graduate or advanced undergraduate students. It is also recommended for computer scientists and database systems engineers and programmers in government, industry and academia; professionals from other disciplines, e.g., geography, geology, soil science, hydrology, urban and regional planning, mobile computing, bioterrorism and homeland security, etc. Focuses on the modeling and design of data from moving objects--such as people, animals, vehicles, hurricanes, forest fires, oil spills, armies, or other objects--as well as the storage, retrieval, and querying of that very voluminous data. Demonstrates through many practical examples and illustrations how new concepts and techniques are used to integrate time and space in database applications. Provides exercises and solutions in each chapter to enable the reader to explore recent research results in practice.

Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition) will prepare database administrators for upcoming changes in SQL Server 2005. Obtain the skills necessary to run SQL Server 2005 from the experts at Microsoft Gold Partner. Get a head-start to understanding the new concepts and features of SQL Server 2005 from the database administrator's perspective, including: SQL Server 2005 Architecture Tool Sets Scalability, Reliability and High Availability Chapter Performance Tuning Replication .NET CLR Integration DTS and Business Intelligence Minimize the surprises in SQL Server 2005 with the help of Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition).

This IBM Redbook is a study guide for IBM Tivoli Storage Manager Version 5.3 and is meant for those who want to achieve IBM Certifications for this specific product.

Praise for Hands-On Microsoft Access “Bob has distilled the essence of database design and Access development into a highly valuable and easily understandable resource that I wish was available when I first started out.” —Graham R. Seach, Microsoft Access MVP “If you’ve been using Access with that typical uncertainty, asking yourself 'Just how could I do that?' or 'Why isn’t this working?', if you’d like to know what you’re doing before you hit the wall, this book is probably perfect for you.” —Olaf Rabbachin, CEO, IntuiDev IT-solutions “Life at the cutting edge of Access development is exciting and very challenging. The knowledge and experience gained over many years of research and trial-and-error has been hard won. But Bob's new book encapsulates the knowledge we now take for granted, and for the first time the beginner is afforded the opportunity to bypass all that hard work. In this his latest work, Bob has distilled the essence of database design and Access development into a highly valuable and easily understandable resource that I wish was available when I first started out.” —Graham R Seach, MCP, MCAD, MCSD, Microsoft Access MVP, author “This is an excellent book for beginners, with an easy reading style. It is now on my recommended list of books that I hand out in every Access class that I teach.” —M.L. “Sco” Scofield, Microsoft Access MVP, MCSD, Senior Instructor, Scofield Business Services “If you've been using Access with that typical uncertainty, asking yourself 'Just how could I do that?' or 'Why isn't this working?', or if you'd like to know what you're doing before you hit the wall, this book is perfect for you. Access is a tremendous product and a database is created using a few clicks; but without at least some theoretical background you're bound to encounter problems soon. I wish a book like this one would've been available when I started getting deeper into working with Access some ten years ago.” —Olaf Rabbachin, CEO, IntuiDev IT-solutions “This book is for any level DB developer/user. It is packed full of real-world examples and solutions that are not the normal Northwind database that most Access books use. The examples and the technical content surrounding them are the real strength of the book. Schneider uses real-world scenarios that make for excellent reading. It made me want to go and redo a lot of my older Access DBs that were not written as well as they could have been. This book taught me different approaches to doing some routine tasks.” —Ron Crumbaker, Microsoft MVP – SMS “While a very powerful application (or perhaps because of its power), Microsoft Access does have a steep learning curve and can be intimidating to new users. Bob Schneider has managed to write a book that's both understandable and enjoyable to read. His examples should be understandable to all readers, and he extends them in a logical manner. This book should leave the reader well equipped to make use of what many consider to be the best desktop database product available.” —Doug Steele, Microsoft Access MVP “The author takes what is potentially a very dry subject and adds fantastic color through entertaining analogies and metaphors. For instance, his examples using the NBA, the Beatles, and Donald Rumsfeld help us 'get it' without realizing we have just traversed what could be very stale database theory. Brilliant!” —Kel Good, MCT, MCSD for Microsoft.NET, Custom Software Development Inc. (www.customsoftware.ca) Go from Access “beginner” to Access “master”! Millions of people use Microsoft Access, but only a small fraction of them are really comfortable with it. If you're ready to go “beyond the wizards”—and become a confident, highly effective Access user— Hands-On Microsoft Access was written for you. In plain English, Bob Schneider helps you master crucial principles for building flexible, powerful databases. Discover how to enter data more easily, retrieve it more freely, manipulate it more successfully, analyze it with greater sophistication, and share it more effectively. Schneider's dozens of hands-on examples thoroughly demystify Access, and his friendly, conversational style makes it more approachable than ever before. Hands-On Microsoft Access presents solutions for the challenges you're most likely to encounter, including How do Access objects and interfaces fit together, and when should I use each one? What's the best way for me to organize my fields into tables? How can I modify the tables, forms, and reports an Access wizard created for me? How can I design forms and reports for people to use more effectively? How do primary keys and relationships work, and why are they so important? How do I make sure my data stays consistent and accurate? How do I build queries that give me the right information—quickly, efficiently, and reliably? How do I use data from other sources, or deliver Access data to other people or programs? What are PivotTables and PivotCharts, what can I do with them, and how do I use them? Written for Access 2003, this book also contains special instructions for Access 2002 users and extensive coverage of issues relevant to Access 95, 97, and 2000.

Oracle Database 10g Insider Solutions is a must-have reference guide for all Oracle professionals. It provides much-needed information on best practices, tips, and techniques in debugging, installation, deployment, and tuning of the Oracle 10g database. You can draw upon the experience and knowledge of these authors to find creative ways to put your Oracle database to work. The authors will also address common and not-so-common installation concerns, database administration, development, and tuning. Oracle Database 10g Insider Solutions will bring you the insider information that you can't get anywhere else.

SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. If you're working with a relational database--whether you're writing applications, performing administrative tasks, or generating reports--you need to know how to interact with your data. Even if you are using a tool that generates SQL for you, such as a reporting tool, there may still be cases where you need to bypass the automatic generation feature and write your own SQL statements. To help you attain this fundamental SQL knowledge, look to Learning SQL, an introductory guide to SQL, designed primarily for developers just cutting their teeth on the language. Learning SQL moves you quickly through the basics and then on to some of the more commonly used advanced features. Among the topics discussed: The history of the computerized database SQL Data Statements--those used to create, manipulate, and retrieve data stored in your database; example statements include select, update, insert, and delete SQL Schema Statements--those used to create database objects, such as tables, indexes, and constraints How data sets can interact with queries The importance of subqueries Data conversion and manipulation via SQL's built-in functions How conditional logic can be used in Data StatementsBest of all, Learning SQL talks to you in a real-world manner, discussing various platform differences that you're likely to encounter and offering a series of chapter exercises that walk you through the learning process. Whenever possible, the book sticks to the features included in the ANSI SQL standards. This means you'll be able to apply what you learn to any of several different databases; the book covers MySQL, Microsoft SQL Server, and Oracle Database, but the features and syntax should apply just as well (perhaps with some tweaking) to IBM DB2, Sybase Adaptive Server, and PostgreSQL. Put the power and flexibility of SQL to work. With Learning SQL you can master this important skill and know that the SQL statements you write are indeed correct.

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.