This is the first book to provide in-depth coverage of star schema aggregates used in dimensional modeling-from selection and design, to loading and usage, to specific tasks and deliverables for implementation projects Covers the principles of aggregate schema design and the pros and cons of various types of commercial solutions for navigating and building aggregates Discusses how to include aggregates in data warehouse development projects that focus on incremental development, iterative builds, and early data loads

This IBM Redbooks publication is one in a series of IBM publications written specifically for the IBM System Blue Gene supercomputer, Blue Gene/L, which was developed by IBM in collaboration with Lawrence Livermore National Laboratory (LLNL). This book provides an overview of the application development performance analysis environment for Blue Gene/L. This book explains some of the tools that are available to do application-level performance analysis. It devotes the majority of its content to Chapter 3, "External Performance Instrumentation Facility" and Chapter 4, "Performance Application Programming Interface."

Get the scoop on designing databases for Mac and Windows Use FileMaker Pro design and scripting to quickly, easily build databases that solve real problems FileMaker Pro has grown up, and it's better than ever! This easy-to-use guide shows you how to design a great FileMaker application, build a database that works, add the functionality you need, populate your database, and venture into programming with ScriptMaker. You'll find out how to share and protect your database, too. Discover how to Build a layout that works Create custom triggers and calculated fields Generate reports automatically Manage security Publish your database on the Web Embed pictures, sound, and video

Altiris Deployment Solution is an industry leading management product which helps reduce the cost of deploying servers from bare metal and managing them all from a centralized location. Its user interface makes it easy to deploy operating systems and applications, apply custom configurations, and distribute software updates. Deployment Solution runs in either a virtual or physical server environment and supports deploying Linux, Windows, and ESX Server, as well as virtual machines to an ESX Server system. Deployment Solution also integrates with the IBM ServerGuide Scripting Toolkit to offer custom scripts for IBM hardware to further optimize the automation and standardization of complex server deployments on IBM hardware. Deployment Solution is a ServerProven application and is available directly from IBM. This IBM Redbooks publication describes the features of Altiris Deployment Solution and explains in detail how to implement features such as managing and deploying firmware updates and hardware configuration changes, image-based and script-based deployments, and integration with the IBM management tools. This book addresses the common issues and recommends best practices to overcome many of the challenges that arise during initial deployment setup. Update September 2006: Added 4.1.4, "Additional updates" on page 109 describing how to deploy updates such as server diagnostics using Altiris Deployment Solution and the ServerGuide Scripting Toolkit.

This IBM Redbooks publication shows in detail IBM Branch Transformation Toolkit for WebSphere Studio Version 5.1 and explains how to migrate from Branch Transformation Toolkit Version 4.3 to Branch Transformation Toolkit 5.1. We provide guidelines for the architecture of the target solution, the correct use of migration tools, and migration-sizing. This book also describes how to build new applications in Branch Transformation Toolkit V5.1. We explain both top-down and bottom-up development, and discuss how to use WebSphere Studio and Branch Transformation Toolkit development plug-ins. We also describe rich Java client development using the Branch Transformation Toolkit. This book is intended for the following audiences: - Solution architects who require a description of IBM Branch Transformation Toolkit for WebSphere Studio and how to build a solution - IT professionals and executives who require a broad understanding of the architecture of the Branch Transformation Toolkit and its implementation - Readers who are familiar with object-oriented software and related development techniques, and have a general knowledge of Java 2 Platform, Enterprise Edition (J2EE) and related technologies Please note that the additional material referenced in the text is not available from IBM.

Grid architecture is Oracle’s strategy for high-end computing and RAC is the stepping stone into this arena. This book focuses on current technology including all valid RAC features up through Oracle Database 10g Release 2, with a primary focus on deploying it in a high-end grid environment. The book discusses this technology at length which users will find beneficial when researching, implementing or monitoring a RAC environment. The author covers workshop implementation of services and the distribution of workload across instances, with threshold definitions and the new load balancing algorithms. In addition it includes detailed discussions on ASM that complements the implementation of RAC in Oracle Grid strategy. The book also includes discussions on new Oracle Clusterware, its components and its integration with RAC. Oracle 10g RAC focuses on RAC-specific topics including ASM, operating system configuration, installation and configuration of RAC and much more. Coverage includes network configuration for high availability, FAN, TAF, ONS, implementation of maximum availability architecture (MAA), EM Grid Control, AWR, ADDM and other performance-related tools. The author includes several scripts for performance tuning and implementation that the reader can use to configure a RAC environment either on a 2, 4, 8, 60 or 99 node configuration. * Focuses on implementing, testing and tuning features of Real Application Clusters (RAC) database version 10g Release 2 * Provides extensive coverage of usage, day-to-day functions and operations * Includes tips and techniques such as script samples to illustrate various features of RAC * A jumpstart into all the key features of 10g R2 RAC

A new edition of this title is available, ISBN-10: 067232976X ISBN-13: 9780672329760 You own your own business. You have also created a website for your business that details the products or services that you offer, but it doesn't allow potential customers to purchase anything online. Don't risk losing business-learn to create a dynamic online environment using only three programs. PHP, MySQL and Apache are three popular open-source tools that can work together to help you create a dynamic website, such as an online shopping experience. Sams Teach Yourself PHP, MySQL and Apache All in One is a complete reference manual for all three development tools. You will learn how to install, configure and set up the PHP scripting language, use the MySQL database system, and work with the Apache Web server. Then you'll take it a step further and discover how they work together to create a dynamic website. Use the book and the included CD to create a simple website, as well as a mailing list, online address book, shopping cart and storefront. Updated to reflect the most recent developments in PHP and MySQL, including the final stable release of MySQL 5.0, you will open your website to limitless possibilities with Sams Teach Yourself PHP, MySQL and Apache All in One.

SQL Server 2005 is Microsoft’s next-generation data management and analysis solution that delivers increased security, scalability, and availability to enterprise data and analytical applications while making them easier to create, deploy, and manage. This book shows readers with fundamental SQL Server skills, as well as new-to-topic but experienced database developers, techniques to design, build, test, deploy, and maintain better SQL Server databases. The format is a hands-on, sequential, developer’s companion, providing beyond-the-basics guidance. This book is not a feature-driven reference manual, but a highly practical learning experience demonstrating how to build database solutions to solve business problems.

Written with clarity and a down-to-earth approach, Sams Teach Yourself SQL Server 2005 Express in 24 Hours covers the basics of Microsoft's latest version of SQL Server. Expert author Alison Balter takes you from basic concepts to an intermediate level in 24 one-hour lessons. You will learn all of the basic tasks necessary for the administration of SQL Server 2005. You will also learn how to write and fully utilize: SQL Server stored procedures Functions Triggers using T-SQL, VB.NET, and C# You will also learn how to output SQL Server data to reports and the Internet. Sams Teach Yourself SQL Server 2005 Express in 24 Hours is a well-organized, authoritative introduction that will quickly have you up and running with SQL Server 2005.

Need to learn FileMaker Pro fast? Try a Visual QuickStart Guide! If you've recently upgraded to FileMaker Pro 8, teach yourself this powerful database software the quick and easy way! Using pictures rather than lengthy explanations, this Visual QuickStart Guide takes you from working with records and files to creating and designing databases, printing and networking with FileMaker, and Web publishing with FileMaker in no time. Step-by-step tasks show you how to use new features like PDF and Excel makers; fast match, fast send, layout alignment, email merge, and table import tools; and popular features like digital image management to organize digital photos with minimal effort and XML support to easily share and integrate data with other applications--even those not running FileMaker. This affordably priced, reference style book also includes a companion Web site with excerpts, tips, related links, and more. You'll be up and running in no time!

Find tips for creating efficient PL/SQL code If you know a bit about SQL, this book will make PL/SQL programming painless! The Oracle has spoken—you need to get up to speed on PL/SQL programming, right? We predict it'll be a breeze with this book! You'll find out about code structures, best practices, and code naming standards, how to use conditions and loops, where to place PL/SQL code in system projects, ways to manipulate data, and more. Discover how to Write efficient, easy-to-maintain code Test and debug PL/SQL routines Integrate SQL and PL/SQL Apply PL/SQL best practices Use new features introduced in Oracle 9i and 10g

“Buck Woody’s new book will help new and experienced users alike in getting productive with SQL Server 2005 quickly. His special attention to security and performance make this an exceptional reference that is sure to remain relevant for some time.” —Chip Andrews, CISSP, MCDBA, Director of Research and Development Special Ops Security, Inc. “SQL 2005 is the most exciting upgrade to come out of Redmond in years; this book will help you get up and running quickly to take full advantage of it! If you are looking for a book about upgrading to SQL 2005, look no further, this one is all you need. It gives you all you need to take advantage of everything SQL 2005 has to offer, and that is a lot!” —Doug Ellis, Area Technical Manager, Cognos “Buck Woody provides insight into administering SQL Server 2005 that all developers and database administrators will find useful; the book assumes very little knowledge by providing ‘DBA 101’ sections which will not alienate the experienced reader while providing the necessary introduction to topics for those less experienced.” —Doug Holland, Visual C# MVP, Precision Objects “SQL Server 2005 is a landmark release and this title does an awesome job of hitting everything new in SQL 2005. It covers new and improved administration tools, and contains an overview of Notification Services, SQL Server Service Broker, Reporting Services, Integration Services, and Analysis Services. As a result, you’ll be able to work on your own SQL Server 2005 solutions quickly and painlessly. Ultimately, this book provides you with a starting point, a roadmap, and then the tools and knowledge to exploit this powerful new database server to its fullest power. So, start your computer and get ready to learn SQL Server 2005!” —Alexzander N. Nepomnjashiy, SQL Server DBA, NeoSystems NorthWest “A solid introduction to administering SQL 2005. The ‘DBA 101’ sections provide useful tips for the new DBA, good review for the experienced DBA, and the 101 label enables the seasoned DBA to skip basic material and jump ahead to where the REAL action is…. Buck’s conversational writing style makes this an enjoyable and refreshing contrast to the majority of tech books written these days.” —Brad Russell, MCDBA, Visionary Integration Professionals The Complete, Practical, 100% Useful Guide for Every SQL Server 2005 DBA! This book has one goal: to help database administrators and their managers run SQL Server 2005 with maximum efficiency, reliability, and performance. Renowned SQL Server expert Buck Woody covers every facet of database administration, from installation and configuration through maintaining enterprise-class business intelligence environments. If you’re a new SQL Server administrator, Buck will help you master core tasks rapidly—and avoid costly mistakes that only show up when it’s too late. If you’re familiar with previous versions of SQL Server, he’ll get you up-to-speed fast on everything new that matters, from high availability improvements and Integration Services to the SQL Server Management Studio. Whatever your background, you’ll find best practices, real-world scenarios, and easy-to-use automation scripts—all grounded in Buck’s unsurpassed SQL Server knowledge. • Timesaving tips, practical applications, and start-to-finish examples throughout • Understand the key “decision points” at every stage of your SQL Server deployment • Perform day-to-day maintenance more efficiently, from hotfixes to backup/recovery • Automate maintenance tasks with the SQL Server Agent • Establish and audit security on SQL Server 2005 and the underlying Windows Server platform • Monitor and optimize SQL Server: baselining, profiling, index strategies, query refactoring, and more • Maximize availability using replication, clustering, mirroring, and SQL Server’s new online indexing • Leverage important new improvements in Integration Services and Reporting Services • Use Analysis Services to support enterprise-class Business Intelligence deployments • Even set up a simple configuration of SQL Server 2005 for free—legally! Foreword xviii Chapter 1: Installation and Configuration 1 Chapter 2: Architecture and Tools 35 Chapter 3: Maintenance and Automation 99 Chapter 4: Security 173 Chapter 5: Monitoring and Optimization 237 Chapter 6: High Availability 295 Chapter 7: Notification Services and the Service Broker 365 Chapter 8: Integration Services 399 Chapter 9: Reporting Services 451 Chapter 10: Analysis Services 515 Appendix A: Upgrading to SQL Server 2005 581 Index 605

IBM Tivoli Monitoring Express Version 6.1 is a powerful, affordable, and easy-to-use availability management solution designed to help small to mid-sized companies manage IT infrastructures. It offers the ability to manage bottlenecks, performance impacts, and outages across heterogeneous environments from a single, centralized portal. IBM Tivoli Monitoring Express V6.1 is easy to install, easy to deploy, and easy to use, providing rapid time to value. It provides real-time and historical data that enables you to quickly diagnose and solve issues with the new GUI through the IBM Tivoli Enterprise Portal component. This IBM Redbooks publication presents a deployment guide for IBM Tivoli Monitoring Express V6.1. We describe planning, installing, and troubleshooting IBM Tivoli Monitoring Express V6.1. In addition, we provide some case studies that you can use as part of a proof of concept or a customer demonstration. The target audience for this book is IT specialists working on new IBM Tivoli Monitoring Express V6.1 installations. Please note that the additional material referenced in the text is not available from IBM.

Written by the lead developers of Analysis Services at Microsoft, this book begins with an overview showing how Analysis Services and MDX can be used to build data warehouses and multidimensional databases The authors then describe the development processes for building dimensions and cubes from various data sources Demonstrating a variety of techniques in real-world scenarios, the book shows how MDX can be used to query databases to provide sophisticated analysis of business problems Finally, the book explains how Analysis Services can be used with other components of SQL Server, including DTS, data mining, and Report Services, to provide comprehensive, end-to-end solutions

IBM Tivoli Provisioning Manager Express Version 4.1 for Software Distribution is an easy-to-use, comprehensive solution for software distribution, patch, inventory, and asset management. This Web-based solution is designed for ease of use and implementation so that you can quickly begin to manage the PCs in your enterprise. IBM Tivoli Provisioning Manager Express V4.1 for Software Distribution is implemented with both a client agent on the managed PCs and a centralized data repository. The product is specifically targeted for the small-to-medium business (SMB) market. This IBM Redbooks publication presents a deployment guide for IBM Tivoli Provisioning Manager Express V4.1 for Software Distribution. We discuss the planning, installation, configuration, usage and troubleshooting of the operation. In addition, we provide a case study using a fictitious company, called XYZ Corporation. The target audience for this book is IT specialists working on IBM Tivoli Provisioning Manager Express V4.1 Software Distribution installations and proof of concepts.

Don’t be fooled by the name; IBM Tivoli Directory Integrator integrates anything, and it is not in any way limited to directories. It is a truly generic data integration tool that is suitable for a wide range of problems that usually require custom coding and significantly more resources to address with traditional integration tools. This IBM Redbooks publication shows you how Directory Integrator can be used for a wide range of applications utilizing its unique architecture and unparalleled flexibility. We discuss the business context for this evolutionary data integration and tell you how to architect and design an enterprise data synchronization approach. By telling you everything about Directory Integrator’s component structure and then applying all the techniques in two comprehensive business scenarios, we build a formidable base for your own data integration and synchronization projects. This book is a valuable resource for security administrators and architects who want to understand and implement a directory synchronization project. Please note that the additional material referenced in the text is not available from IBM.

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 Redbooks publication helps you to understand the basics of identifying and tuning the performance of Structured Query Language (SQL) statements using IBM DB2 Universal Database for iSeries. DB2 Universal Database for iSeries 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. This book also presents tips and techniques based on the SQL Performance Monitors and other tools, such as Visual Explain. You'll find this guidance helpful in gaining the most out of both DB2 Universal Database for iSeries and query optimizer when using SQL.

“Terry’s style is always direct, approachable, and pragmatic. Abstraction is hard, and visualizing abstractions is as well, but here she’ll guide you in doing both using Rational Software Architect.” —From the Foreword by Grady Booch, IBM Fellow Master UML 2.0 Visual Modeling with IBM Rational Software Architect Using IBM Rational Software Architect, you can unify all aspects of software design and development. It allows you to exploit new modeling language technology to architect systems more effectively and develop them more productively. Now, two of IBM’s leading experts have written the definitive, start-to-finish guide to UML 2-based visual modeling with Rational Software Architect. You’ll learn hands-on, using a simplified case study that’s already helped thousands of professionals master analysis, design, and implementation with IBM Rational technologies. Renowned UML expert Terry Quatrani and J2EE/SOA evangelist Jim Palistrant walk you through visualizing all facets of system architecture at every stage of the project lifecycle. Whether you’re an architect, developer, or project manager, you’ll discover how to leverage IBM Rational’s latest innovations to optimize any project. Coverage includes Making the most of model-driven development with Rational Software Architect’s integrated design and development tools Understanding visual modeling: goals, techniques, language, and processes Beginning any visual modeling project: sound principles and best practices Capturing and documenting functional requirements with use case models Creating analysis models that begin to reveal your optimal system implementation Building design models that abstract your implementation model and source code Using implementation models to represent your system’s physical composition, from subsystems to executables and data Transforming these models to actual running code The IBM Press developerWorks® Series is a unique undertaking in which print books and the Web are mutually supportive. The publications in this series are complemented by resources on the developerWorks Web site on ibm.com. Icons throughout the book alert the reader to these valuable resources.

Traditional relational databases and embedded databases both have shortcomings that can leave a developer perplexed. So for many people, the solution resides in an open source embeddable database with an amazingly small footprint (less than 250 kilobytes). SQLite packs a powerful array of features and can handle databases as large as 2 terabytes. It offers a flexible set of datatypes and the ability to perform transactions, and it is supported by languages like C, PHP, Perl, and Python. And because SQLite's databases are completely file based, privileges are granted at the operating system level, allowing for easy and fast user management. The Definitive Guide to SQLite is the first book to devote complete coverage to this powerful database. It offers you a thorough overview of SQLite capabilities and APIs, while remaining cognizant of newcomers who may be making their first foray into a database environment with SQLite. This book serves as both a first-time tutorial and future reference guide.

IBM Workplace Services Express is software that makes it simple 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 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 is written for administrators who want to install, configure, and administer Workplace Services Express on an IBM eServer iSeries server. It introduces you to Workplace Services Express. It shows you how to deploy and customize it on the iSeries server, as well as how to integrate with an existing IBM Lotus Domino infrastructure. In addition, this book shows you how to integrate Domino mail and applications with a Workplace Services Express environment. It explains how to enable the iSeries Web Access portlets so you can work with your iSeries server from a Workplace Services Express environment. And this book provides information about performance tuning for Workplace Services Express on the iSeries server. Please note that the additional material referenced in the text is not available from IBM.

Tivoli Continuous Data Protection for Files is specifically targeted at end user computers, such as mobile computers and workstations, as well as file servers. It provides continuous data protection of files, providing the highest level of protection possible, yet is simple to use and administer. When files change, Tivoli Continuous Data Protection for Files will make up to three copies of the file (or queue copies to be made later). This IBM Redbooks publication presents a deployment guide for Tivoli Continuous Data Protection for Files. We cover planning, installing, and troubleshooting of Tivoli Continuous Data Protection for Files for several use case scenarios. In addition, we provide some case studies, including integration with IBM Tivoli Storage Manager, that can be used as a proof of concept or demonstration of the product at a client environment. The target audience for this book is IT Specialists who will be working on Tivoli Continuous Data Protection for Files installations and proof of concepts.

A comprehensive, hands-on reference for database developers and administrators, this book focuses on advanced language features of Transact-SQL (T-SQL), the database programming language built into SQL Server. Includes code and table examples.

The primary objective of this IBM Redbooks publication is to provide best practices for the implementation of a License Management solution based on IBM Tivoli License Manager V2.2. This book is divided into two main parts: In Part 1, "Business aspects and project engagement considerations" on page 1, we discuss the reasons why you should deploy a License Management solution. We also position License Management in the overall picture of the IT Service Management and describe the IBM solution in this area. We also provide best practices on how to approach and engage such a project. The high level tasks of such a project are also introduced. We emphasize the fact that you must not only realize what the key elements are that need to be managed to make your project a success, but also how you should organize your IT operations to get the highest benefit from your solution. In Part 2, "Solution design considerations" on page 57, we provide detailed information for the architecture and design of a IBM Tivoli License Manager V2.2 solution implementation. Both IT Architects and IT Specialist benefit from the information provided in this part, as it covers a great deal, from an introduction to IBM Tivoli License Manager V2.2, its components, and architecture, and solution design fundamental tasks, to detailed physical and logical design and configuration of all components of an IBM Tivoli License Manager V2.2 solution.

IBM DB2 Document Manager Version 8.3 is one of the newest members of the IBM Enterprise Content Management portfolio. Document Manager provides a secure and robust platform to manage the complete life cycle of business documents. It helps ensure accurate and up-to-date documents are available on demand. When configured with IBM DB2 Records Manager Version 4.1.2, the Document Manager solution also provide records management capability. Please note that the additional material referenced in the text is not available from IBM.

If you’re looking for the inside scoop on the latest version of FileMaker, you’ve come to the right place. Authors Scott Love and Steve Lane are FileMaker experts who were involved in the development of FileMaker 8, and they bring that knowledge to you in Special Edition Using FileMaker 8. Frequent tips, case studies, and thorough examples show you how to avoid mistakes and save time in developing databases with FileMaker 8. This is the comprehensive reference that every database developer needs on their shelf.