Java Persistence with Hibernate explores Hibernate by developing an application that ties together hundreds of individual examples. You'll immediately dig into the rich programming model of Hibernate 3.2 and Java Persistence, working through queries, fetching strategies, caching, transactions, conversations, and more. You'll also appreciate the well-illustrated discussion of best practices in database design, object/relational mapping, and optimization techniques. In this revised edition of Manning's bestselling Hibernate in Action, authors Christian Bauer and Gavin King—the founder of the Hibernate project—cover Hibernate 3.2 in detail along with the EJB 3.0 and Java Persistence 1.0 standards. The book ends with detailed coverage of JBoss Seam, a revolutionary web application framework for Java EE that builds on EJB 3.0, JavaServer Faces, and Hibernate concepts. About the Technology Persistence—the ability of data to outlive an instance of a program—is central to modern applications. Hibernate, the most popular Java persistence tool, provides automatic and transparent object/relational mapping so it's a snap to work with SQL databases in Java applications. Hibernate conforms to the new EJB 3.0 and Java Persistence 1.0 standards. About the Book What's Inside O/R mapping concepts Get started with Hibernate and Java Persistence Efficient database application design Comprehensive Hibernate and Java Persistence reference Unmatched breadth and depth About the Reader About the Authors Christian Bauer is a member of the Hibernate developer team and a trainer, consultant, and product manager for Hibernate, EJB 3.0, and JBoss Seam at JBoss. Gavin King, a lead developer at JBoss, is the founder of the Hibernate project, and a member of the EJB 3.0 (JSR 220) expert group. He also leads the Web Beans JSR 299, a standardization effort involving Hibernate concepts, JSF, and EJB 3.0. Quotes ...this book is the ultimate solution. If you are going to use Hibernate in your application, you have no other choice, go rush to the store and get this book. - Meera Subbarao, JavaLobby "Java Persistence with Hibernate" is the most comprehensive, authoritative and definitive guide, tutorial, and reference to OR-mapped Java persistence. - Will Wagers, C#online.net A definitive source on Hibernate. Great for any developer. - Patrick Peak, CTO, BrowserMedia, Author of Hibernate Quickly I wholeheartedly recommend this book! - Stuart Caborn, Thoughtworks Great topic, great content, and there is a great need for this book! - Ryan Daigle, RTP Region, ALTERthought ...very thorough, very complete. I highly recommend it. - Patrick Dennis, Java Developer Management Dynamics Inc. A must-read for developers using Hibernate. - Dan Dobrin, BEA Systems It's the best book out there about Hibernate (and there are quite a few on the market right now), maybe even the best book about ORM in Java, in general. - Adrian Spinei, Real Life, beta version

IBM Tivoli Workload Scheduler is an IBM strategic scheduling product that runs on different platforms including the mainframe. The new version of the product, IBM Tivoli Workload Scheduler V8.3, comes with some important enhancements, such as relational database management system (RDBMS) support, new advanced planning system, which allows the definition of plans that span more that 24 hours, removal of framework requirements, new application programming interface (API), Job Scheduling Console enhancements, and so on. This IBM Redbooks publication documents the architecture, deployment, best practices, and migration scenarios for IBM Tivoli Workload Scheduler V8.3 on distributed environment. In addition, we cover IBM Tivoli Workload Scheduler V8.3 security, IBM DB2 and IBM WebSphere considerations, troubleshooting, tuning for performance, application programming interface, and JnextPlan, which has replaced the JnextDay process in this release. Clients and Tivoli professionals who are responsible for installing, administering, maintaining, or using IBM Tivoli Workload Scheduler V8.3 will find this book a major reference.

• SAP is investing billions to redesign its flagship R/3 product line based on its ESA, and that ESA will become the standard framework for developing all new SAP ERP applications with NetWeaver * This book provides an overview of the core building blocks of SAP's new ESA, and shows how ESA works with the NetWeaver platform as well as mySAP ERP * A step-by-step action plan proposes ideas for designing ESA-based SAP applications * The companion Web site contains in-depth case examples that show how to build various SAP services and applications using the NetWeaver development tools, plus third-party tools * Some of the SAP tools covered include NetWeaver Developer Studio, WebDynPro and NetWeaver Portal, NetWeaver BI, and the SAP Composite Application Framework

Direct from Microsoft Insiders: the Complete Hands-On Guide to SQL Server 2005’s Powerful Tools! Microsoft SQL Server 2005’s high-powered management tools can dramatically improve DBA productivity and effectiveness. Now there’s a comprehensive guide to SQL Server 2005’s toolset, straight from the Microsoft team that created it. This book covers the entire toolset in unprecedented depth, guides database professionals in choosing the right tools, and shows them how to use various tools collectively to solve real-world problems. The authors present “how-to” solutions and never-before-published tips for SQL Server 2005 installation, upgrades, configuration, authoring, schema design, development, deployment, optimization, troubleshooting, and more. Coverage includes  Understanding how SQL Server 2005 tools differ from their predecessors  Leveraging the new Business Intelligence Development Studio and Management Studio to accomplish dozens of common tasks  Improving security by reducing the “surface area” you expose  Executing queries with the new Query Editor and SQLCMD query tools  Optimizing with the revamped SQL Server Profiler and Database Engine Tuning Advisor  Scheduling maintenance tasks with the SQL Server Agent  Monitoring with the Activity Monitor, SQL Server Agent, and other tools  Moving data efficiently and reliably with Integration Services  Using SQL Server’s new e-mail tool, Database Mail  Managing replication in complex distributed environments  Mastering SQL Server’s Analysis Services’ OLAP and Data Mining tools  Using Notification Services 2.0, Reporting Services, and more  Extending functionality using underlying APIs and the included CD-ROM’s sample code. MICHAEL RAHEEM is the senior product manager of the Microsoft SQL Server team and led the design and implementation of several SQL Server tools, such as SQL Server Management Studio, Database Mail, Upgrade Advisors, and Surface Area Configuration. He currently leads the SQL Server enterprise marketing efforts including high availability, scalability, and performance. DIMA SONKIN is development lead in the SQL Server Tools group responsible for SQL Server Agent, SMO, DMO, SQL Profiler, Database Engine Tuning Advisor, Database Mail, SQLMail, SqlCmd, and OSQL. THIERRY D’HERS is the lead program manager on Microsoft’s SQL BI Analysis Services team and has spent five years designing and specifying Analysis Services tools. KAMI LEMONDS is the documentation manager for Microsoft’s SQL Server User Education team and contributed to the SQL Server 2000 Resource Kit. CD-ROM contains all sample code from the book and corresponding Visual Studio project files. Contents Foreword . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xix Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . xxvi About the Authors . . . . . . . . . . . . . . . . . . . . . . . xxvii Chapter 1 Inside the Fundamentals. . . . . . . . . . . . . . . . . . . . . 1 Chapter 2 Inside the Installation and Upgrade Tools. . . . . . . 23 Chapter 3 Inside the Configuration Tools . . . . . . . . . . . . . . . 73 Chapter 4 Inside Management and Administration Tools . . 129 Chapter 5 Inside Data Authoring Tools . . . . . . . . . . . . . . . . 181 Chapter 6 Inside SQLCMD Query Tools . . . . . . . . . . . . . . . . 199 Chapter 7 Inside Tuning and Optimization Tools . . . . . . . . . 237 Chapter 8 Inside Scheduling Tools . . . . . . . . . . . . . . . . . . . 273 Chapter 9 Inside Monitoring Tools. . . . . . . . . . . . . . . . . . . . 305 Chapter 10 Inside Email Tools . . . . . . . . . . . . . . . . . . . . . . . . 337 Chapter 11 Inside Programming Object Models . . . . . . . . . . 357 Chapter 12 Inside Replication Tools . . . . . . . . . . . . . . . . . . . 385 Chapter 13 Inside Analysis Services OLAP Tools . . . . . . . . . 429 Chapter 14 Inside Analysis Services Data Mining Tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . 519 Chapter 15 Inside Notification Services Tools . . . . . . . . . . . 543 Chapter 16 Inside Integration Services Tools . . . . . . . . . . . . 601 Chapter 17 Inside the Reporting Services Tools . . . . . . . . . . 679 Appendix A Sample KPI Client Code— Retrieving and Exposing Your First KPI. . . . . . . . . . . . . . . . . . . . 711 Appendix B KPI Utilities—Code for Parsing Display Folders and Getting Image Indexes . . . . . . . . . . 713 Appendix C KPI Viewer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 721 Appendix D Complete List of Data Mining Stored Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 723 Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 733

XML represents a fundamental change in computing. It allows applications to move away from proprietary file and data formats to a world of open data interchange. XML has become ubiquitous not only because of its range of applications, but also because of its ease of use. Although XML solves many problems by providing a standard format for data interchange, some challenges remain. In the real world, applications need reliable services to store, retrieve, and manipulate data. These services have traditionally been offered by DB2 for i5/OS. In this IBM Redbooks publication, we discuss the challenges of representing XML hierarchies in the relational database model. We provide an in-depth explanation of the three most popular approaches to bridge the hierarchy, the relational model dichotomy: Programmatically process the XML documents and map their hierarchy into a relational database. Use database middleware to handle the XML parsing and XML-to-relational database mapping. Use Extensible Stylesheet Language (XSL) Transformation to transform inbound XML documents directly to SQL scripts. We also share best practices and techniques aimed at streamlining the XML and DB2 for i5/OS integration. Please note that the additional material referenced in the text is not available from IBM.

Plug Yourself In with the Ultimate Guide to the Internet! EXHAUSTIVE INDEX: An exhaustive index with thorough cross-references helps you find exactly what you want, quickly and easily. INTERNATIONAL COVERAGE: International coverage makes your discoveries on the Web virtually limitless. SEARCH SECRETS: Michael Miller, along with Mikal Belicove and Joe Kraynak, have written the foreward that gets you up to speed on searching the Internet, blocking pop-up ads, protecting children online, accessing the wireless Web, plugging in to podcasts and webcasts, and reading fascinating weblogs (blogs). Use This Complete Guide to Web Surfing at Its Best: • Find new job opportunities • Find information and resources on all aspects of adoption • Download music from your favorite artists • Get tips, strategies, and information on improving your poker game • Get free technical support for your PC or Mac • Learn the ancient Chinese art of Feng Shui • Find sites devoted to men’s and women’s health and related issues Category Internet–Directories Covers The Internet and the World Wide Web User Level All In this Edition Icons identify unique information about each listed website BEST OF THE BEST This icon identifies THE best website in any given category. If you have time to visit only one site in a category, look for the Best of the Best! KID ICON The child-rating icon is designed to help you weed out sites that are inappropriate for children. BLOG ICON The blog icon identifies those sites that allow visitors to post comments and are interactive. PODCAST The Podcast icon identifies sites that provide audio-on-the-go content. WEBCAST The webcast icon identifies those sites that feature dynamic audio-visual content RSS FEED ICON The RSS Feed icon indicates, quickly and easily, those sites that offer live feeds in any given category. DIRECTORY ICON The Directory icon indicates websites that may not provide a lot of quality information on their own but instead point you to the best sites that deal with a particular topic. QUALITY INDICATOR The quality indicator icon rates sites on a scale of 1 to 5 based on content, appearance, and ease of use. Look for a ranking of 5 and you’ve found the most user-friendly sites. 789736292 100307

This practical, hands-on book offers deep, thorough coverage of the internals of architecture and resource management in SQL Server 2005, focusing on the Storage Engine. The book features extensive code samples and table examples.

Joe Celko's SQL Puzzles and Answers, Second Edition, challenges you with his trickiest puzzles and then helps solve them with a variety of solutions and explanations. Author Joe Celko demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but also help develop the mindset needed to solve the many difficult SQL puzzles you face every day. This updated edition features many new puzzles; dozens of new solutions to puzzles; and new chapters on temporal query puzzles and common misconceptions about SQL and RDBMS that leads to problems. This book is recommended for database programmers with a good knowledge of SQL. A great collection of tricky SQL puzzles with a variety of solutions and explanations Uses the proven format of puzzles and solutions to provide a user-friendly, practical look into SQL programming problems - many of which will help users solve their own problems New edition features: Many new puzzles added!, Dozens of new solutions to puzzles, and using features in SQL-99, Code is edited to conform to SQL STYLE rules, New chapter on temporal query puzzles, New chapter on common misconceptions about SQL and RDBMS that leads to problems

This IBM Redbooks publication is a study guide for Tivoli Provisioning Manager Express for Software Distribution V4.1 and is aimed at the people who want to get an IBM Professional Certification for this product.

The IBM System i family, which encompasses the IBM AS/400, eServer iSeries, eServer i5, and System i5, has a successful 24-year history of satisfying hundreds of customers' requirements, thanks to its developers. DB2 for i5/OS, also known as DB2 Universal Database for iSeries, is deeply rooted in the architecture and heritage of the AS/400 and its predecessor System/38. The database has undergone significant changes over the years to maintain its competitive advantage including fundamental changes to the structure of the database to compete successfully in the industry. In doing so, IBM Rochester launched a project to re-engineer and redesign important components of the database. The redesigned components were architected using object-oriented design concepts and then implemented using object-oriented implementation techniques. The query optimizer was one of the key components that was redesigned. This IBM Redbooks publication gives a broad understanding of the architectural changes of the database concerning the query optimizer. It explains the following concepts: The architecture of the query optimizer The data access methods used by the query optimizer The Statistics Manager included in V5R2 The feedback message changes of the query optimizer Some performance measurements Changes and enhancements made in V5R4 The objective of this book is to help you minimize any SQL or database performance issues when upgrading to OS/400 V5R2 or V5R3 or to IBM i5/OS V5R4. Prior to reading this book, you should have some knowledge of database performance and query optimization.

This IBM Redbooks publication provides an introduction to the Enterprise Workload Manager (EWLM) Version 2 Release 1. In addition to describing the overall product concept and functionality, it presents a detailed discussion of the elements that comprise an EWLM solution. Step-by-step instructions take you through the installation of EWLM code on multiple platforms, for both the domain manager and managed servers, and also show how to enable the instrumentation of the middleware for a 3-tier Web application. The features for administering EWLM are described, along with the monitoring, managing, and reporting capabilities. Sample scenarios implemented in the ITSO environment are used to guide you through the process of classifying workload and defining and deploying your own EWLM policy. These scenarios are then used to demonstrate the business goal based partition management capabilities of EWLM. Techniques for securing your EWLM domain as well as the load balancing capabilities of EWLM are described. Troubleshooting hints and tips are provided, along with some basic performance considerations to help you design the optimum EWLM solution. Please note that the additional material referenced in the text is not available from IBM.

The Classic SQL Tutorial: Fully Updated for Today’s Standards and Today’s Top Databases For twenty years, van der Lans’ Introduction to SQL has been the definitive SQL tutorial for database professionals everywhere, regardless of experience or platform. Now van der Lans has systematically updated this classic guide to reflect the latest SQL standards and the newest versions of today’s leading RDBMSs: Oracle, Microsoft SQL Server, DB2, and MySQL. Using case study examples and hands-on exercises, van der Lans illuminates every key SQL concept, technique, and statement. Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why SQL works as it does–and how to get the most out of it. You’ll gain powerful insight into everything from basic queries to stored procedures, transactions to data security. Whether you’re a programmer or DBA, a student or veteran, this book will take you from “apprentice” to true SQL master. Writing queries and updating data: all you need to know about SELECT Working with joins, functions, and subqueries Creating database objects: tables, indexes, views, and more Specifying keys and other integrity constraints Using indexes to improve efficiency Enforcing security via passwords and privileges Building stored procedures and triggers Developing with embedded SQL and ODBC Working with transactions, including rollbacks, savepoints, isolation levels, and more Optimizing performance by reformulating SQL statements Using object-relational features: subtables, references, sets, and user-defined data types Reference section: SQL statement definitions and SQL function lists

This IBM Redbooks publication introduces the IBM Problem Determination and Deployment Tools for z/OS and OS/390. The tools covered are: -> IBM Application Performance Analyzer for z/OS Version 1 Release 1 This comprehensive suite of powerful yet easy-to-use tools helps developers to efficiently build, test, and service applications while minimizing errors and increasing cost-effectiveness. The tools allow users to quickly identify and resolve problems that occur in batch, IMS, DB2, CICS, and UNIX System Services applications. For each tool, this book provides step-by-step instructions for installation and customization, a detailed discussion of the features and capabilities, and guidance for using the tool in your environment.

This comprehensive book guides readers through Microsoft's brand-new SQL 2005 administrator exam: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 (Exam 70443) Addresses the database tasks that the MCITP exam focuses on such as design, development, deployment, optimization, maintenance, and support Reviews key topics, including defining high availability solutions, automating administrative tasks, defining security solutions, monitoring and troubleshooting the database server, and much more The CD-ROM features leading-edge exam prep software with test engine plus hundreds of practice questions and electronic flashcards Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

In-depth coverage of Microsoft’s powerful new data integration tool Learn to maximize the features of SQL Server 2005 Integration Services from this essential guide. Hands-On Microsoft SQL Server 2005 Integration Services makes learning SSIS easy through the use of extensive real-world exercises structured around every component within the tool. You will learn to collect corporate data from various sources and transform that data for analysis, mining, and reporting.

IBM TotalStorage Productivity Center is a suite of infrastructure management software that can centralize, automate, and simplify the management of complex and heterogeneous storage environments. It can help reduce the effort of managing complex storage infrastructures, improve storage capacity utilization, and improve administration efficiency. IBM TotalStorage Productivity Center allows you to respond to on demand storage needs and brings together, in a single point, the management of storage devices, fabric, and data. TotalStorage Productivity Center V3.1 is a rewrite of previous versions. This IBM Redbooks publication shows you how to access the functions as compared to the previous releases. This book is intended for administrators and users who are installing and using IBM TotalStorage Productivity Center. It provides an overview of the product components and functions. It describes the hardware and software environment required and provides a step- by-step installation procedure. Customization and usage hints and tips are also provided.

First Published in 2006. Routledge is an imprint of Taylor & Francis, an informa company.

"The expertise, thought, and effort that go into each book are obvious, and I sincerely appreciate your efforts. Keep up the wonderful work!" --Tracey Moore (Memphis, TN) Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you will discover step-by-step screen shots that demonstrate over 140 key techniques using PHP amd MySQL, including: Configuring Apache to process PHP code Working with character strings Creating, sorting, and comparing arrays Defining and using functions Finding and replacing substrings Querying databases and retrieving data Stopping and starting the MySQL server Adding dynamic check boxes Sending new Web pages to a browser Extra / Apply It High-resolution screen shots demonstrate each task Succinct explanations walk you through step-by-step Two-page lessons break big topics into bite-sized modules "Apply It" and "Extra" sidebars highlight useful tips

SQL Server 2005 is Microsoft’s next-generation data management and analysis solution that delivers enhanced scalability, availability, and security features to enterprise data and analytical applications while making them easier to create, deploy, and manage. Now you can teach yourself how to design, build, test, deploy, and maintain SQL Server databases—one step at a time. With STEP BY STEP, you work at your own pace through hands-on, learn-by-doing exercises. Instead of merely focusing on describing new features, this book shows new database programmers and administrators how to use specific features within typical business scenarios. Each chapter puts you to work, providing a highly practical learning experience that demonstrates how to build database solutions to solve common business problems.

Identity and user lifecycle management projects are being deployed more and more frequently - and demand is growing. By demonstrating how IBM Tivoli Identity Manager can be made resilient and adapted to special functional requirements, this IBM Redbooks publication creates or enhances confidence in the IBM Tivoli Identity Manager-based solution for senior management, architects, and security administrators. Advanced design topics can start with infrastructure availability for all involved components, Web application, and database server clustering as well as LDAP multi-master setups, continuing with compliance challenges addressing enhanced auditing and reporting, and designing and creating your own self-care/self-registration application environment that embraces external users and business partners offering fine-tuned workflow options and lifecycle management capabilities. The powerful features and extensions of IBM Tivoli Identity Manager are opening doors into a world of advanced design and customization for every identity management challenge you might encounter. Please note that the additional material referenced in the text is not available from IBM.