Harnessing Hibernate is an ideal introduction to the popular framework that lets Java developers work with information from a relational database easily and efficiently. Databases are a very different world than Java objects, and they often involve people with different skills and specializations. With Hibernate, bridging these two worlds is significantly easier, and with this book, you can get up to speed with Hibernate quickly. Rather than present you with another reference, Harnessing Hibernate lets you explore the system, from download and configuration through a series of projects that demonstrate how to accomplish a variety of practical goals. The new edition of this concise guide walks you through Hibernate's primary features, which include mapping from Java classes to database tables, and from Java data types to SQL data types. You will also learn about Hibernate's data query and retrieval facilities, and much more. By reading and following along with the examples, you can get your own Hibernate environment set up quickly and start using it for real-world tasks right away. Harnessing Hibernate teaches you how to: Perform Object/Relational mapping Work with persistent data from Java code Work with groups and relationships between objects Extend Hibernate's rich type support for your own needs Simplify query creation using criteria and examples Use the Hibernate Query Language (HQL) and understand how it differs from SQL Use Hibernate in conjunction with Spring Use Hibernate in conjunction with other packages, such as the Stripes web framework and the Eclipse IDE Once you're past the first few chapters, you can jump to topics that you find particularly interesting or relevant. All background material and explanations of how Hibernate works and why is in the service of a focused task. Source code can be downloaded from the book's website. If using SQL is an uncomfortable chore, Harnessing Hibernate offers you an effective and trouble-free method for working with the information you store in your applications.

Discussing new and existing features, SQL Server designer and administrator Michael Coles takes you on an expert guided tour of Transact-SQL functionality in SQL Server 2008 in his book, Pro T-SQL 2008 Programmer's Guide. Fully functioning examples and downloadable source code bring Coles' technically accurate and engaging treatment of Transact-SQL into your own hands. Step-by-step explanations ensure clarity, and an advocacy of best-practices will steer you down the road to success. Pro T-SQL 2008 Programmer's Guide is every developer's key to making full use of SQL Server 2008's powerful, built-in Transact-SQL language. Transact-SQL is the language developers and DBAs use to interact with SQL Server. It's used for everything from querying data, to writing stored procedures, to managing the database. New features in SQL Server 2008 include a spatial data type, SQLCLR integration, the MERGE statement, a dramatically improved and market-leading XML feature set, and support for encryption—all of which are covered in this book

Design Feature-Rich PL/SQL Applications Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance. Create, debug, and manage Oracle-driven PL/SQL programs Use PL/SQL structures, delimiters, operators, variables, and statements Identify and eliminate errors using PLSQL_WARNINGS and exception handlers Work with functions, procedures, packages, collections, and triggers Define and deploy varray, nested table, and associative array data types Handle external routines, object types, large objects, and secure files Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE Call external procedures through Oracle Net Services and PL/SQL wrappers Integrate internal and server-side Java class libraries using Oracle JVM Develop robust Web applications using PL/SQL Gateway and Web Toolkit

When you need to find the right SQL keyword or MySQL client command-line option right away, turn to this convenient reference, known for the same speed and flexibility as the system it covers so thoroughly. MySQL is packed with so many capabilities that the odds of remembering a particular function or statement at the right moment are pretty slim. With MySQL in a Nutshell, you get the details you need, day in and day out, in one concise and extremely well organized book. The new edition contains all the commands and programming information for version 5.1, including new features and language interfaces. It's ideal for anyone using MySQL, from novices who need to get up to speed to advanced users who want a handy reference. Like all O'Reilly Nutshell references, it's easy to use and highly authoritative, written by the editor of the MySQL Knowledge Base at MySQL AB, the creator and owner of MySQL. Inside, you'll find: A thorough reference to MySQL statements, functions, and administrative utilities Several tutorial chapters to help newcomers get started Programming language APIs for PHP, Perl, and C Brief tutorials at the beginning of each API chapter to help anyone, regardless of experience level, understand and master unfamiliar territory New chapters on replication, triggers, and stored procedures Plenty of new examples of how MySQL is used in practice Useful tips to help you get through the most difficult subjectsWhether you employ MySQL in a mission-critical, heavy-use environment or for applications that are more modest, this book puts a wealth of easy-to-find information at your fingertips, saving you hundreds of hours of trial and error and tedious online searching. If you're ready to take advantage of everything MySQL has to offer, MySQL in a Nutshell has precisely what it takes.

All-in-One is All You Need Get complete coverage of all three Microsoft Certified IT Professional database developer exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference. Get full details on all exam topics including how to: Install and configure SQL Server 2005 Manage database design Use Transact-SQL and XML Work with functions, triggers, and CLR integration Optimize, monitor, and secure databases Create stored procedures Handle disaster recovery Work with Service Broker, Web Services, and MARS Use SQL Server Reporting Services and Notification Services Manage locks, deadlocks, and cursors Transfer data using Replication and SQL Server Integration Services The CD-ROM features: Six full practice exams-two for each exam: 70-431, 70-441, & 70-442 Scripts from the step-by-step exercises in the book Video training clips from the author Complete electronic book

Combining theory with everyday practicality, this definitive volume is packed with the up-to-date information, new features, and explanations you need to get the very most out of SQL and its latest standard. The book is unique in that every chapter highlights how the new SQL standard applies to the three major databases, Oracle 11g, IBM DB2 9.5, and Microsoft SQL Server 2008. The result is a comprehensive, useful, and real-world reference for all SQL users, from beginners to experienced developers.

Have a Google Maps mashup that you'd like to expose to millions of users on maps.google.com? New to the mapping craze, but have an idea for a killer map–based application? Want to learn how to create GeoRSS and KML feeds with your geotagged content, exposing your customer to new ways of exploring and navigating your content? Google Maps Mashups with Google Mapplets Is the first book to cover Google's Mapplet technology Shows you how to create Google Maps–based applications and publish to maps.google.com Provides a single–source resource and practical guide to Mapplets and mashups Teaches you how to mash up Mapplets using location–specific data Includes examples of real–world applications

Refocused and completely rewritten with the needs of business users and FileMaker Pro developers in mind, FileMaker Pro 9 Bible shows you how to design an industrial-strength database, make it intuitive, and automate it with scripts and programming. From the fundamentals to data modeling to writing no-fail code, you'll find the clear, step-by-step procedures, solid techniques, and detailed explanations you need to master this powerful software and build the right solutions for your needs.

With the introduction of Ferret, Ruby users now have one of the fastest and most flexible search libraries available. And it's surprisingly easy to use. This book will show you how to quickly get up and running with Ferret. You'll learn how to index different document types such as PDF, Microsoft Word, and HTML, as well as how to deal with foreign languages and different character encodings. Ferret describes the Ferret Query Language in detail along with the object-oriented approach to building queries. You will also be introduced to sorting, filtering, and highlighting your search results, with an explanation of exactly how you need to set up your index to perform these tasks. You will also learn how to optimize a Ferret index for lightning fast indexing and split-second query results.

This up-to-date “quick reference guide” is an easy, fast, and convenient way of learning SAP FI CO (including SAP R/3 4.70 Enterprise and SAP ERP(ECC)6.0); it also covers ABAP and Basis on the technical side, and MM, SD, and PP on the functional side to provide a thorough understanding of the SAP system. Separate sections on SAP Tables and SAP Transaction Codes guide you through the intricacies of the SAP modules and the 100-page section of SAP Terminology provides an excellent reference for mastering acronyms, codes, and definitions of the multiple components of this popular software.

This IBM® Redbook captures some of the best practices based on field experience and details the performance gains that can be achieved by implementing the IBM System Storage™ SAN Volume Controller. This book is intended for very experienced storage, SAN, and SVC administrators and technicians. Readers are expected to have an advanced knowledge of the SVC and SAN environment, and we recommend these books as background reading: IBM System Storage SAN Volume Controller, SG24-6423 Introduction to Storage Area Networks, SG24-5470 Using the SVC for Business Continuity, SG24-7371

This Wrox Blox explores Service Orientated Architecture and the Enterprise Service Bus, focusing on how it can be implemented using Microsoft BizTalk Server. It explains the need for SOA Architecture in an enterprise business and looks at the key Business and IT Drivers in business, how they can interact, and where there are conflicts that SOA can help resolve. Specifically, the author discusses Microsoft ESB Guidance and how, by using BizTalk 2006, ESB implementation can provide a solid platform for SOA development; management across the IT and Business Space with the Governance and tools provided in the ESB Toolkit; pointers to online resources, including guides on installing and deploying ESB; and how to avoid common SOA pitfalls. The target audience for this Wrox Blox is IT Managers, Business Managers, Architects, Developers, and Business Analysts who want to find architectural guidance information on Service Oriented Architecture, BizTalk, and Enterprise Service Bus.

Pro BizTalk 2006 is a high-end resource that is based on real feedback from BizTalk developers. Authors George Dunphy and Ahmed Metwally are well known within the BizTalk community, and here they cover topics not discussed in other books, like performance tuning, scalability, and administration. This book also features examples of specific, real-world implementations.

The purpose of this book is to remove the veil of secrecy surrounding SAP upgrade techniques and concepts, and to provide the user with a detailed description of the steps needed for a successful implementation. Today more than 12 million people in 120 countries who are working for 36,200 companies are using SAP on a regular basis. This popular, but very complex software system must be constantly reconfigured and upgraded to accommodate its latest releases. Upgrading SAP provides a complete overview of the process to upgrade from one SAP release to the next one and explains with detailed descriptions, the use of all relevant SAP upgrade tools. Along with a technical description of the SAP NetWeaver Application Server (AS), it also discusses personnel issues and the economic ramifications of such an upgrade project. Examples in this book are based on various different SAP products and releases, such as SAP NetWeaver 2004, 2004S (also known as NetWeaver 7.0 and 7.1), and SAP Business Suite 2005 with SAP ERP 6.0, BI, CRM, SCM, and SRM. Conceived as both a teaching book and as a reference manual, it covers all the techniques, background information, notes, tips, and tricks needed for any SAP upgrade project. A CD-ROM accompanies the book with templates and outlines for the upgrading process, as well as third-party SAP-related material.

In order to comply with government and industry regulations, such as Sarbanes-Oxley, Gramm-Leach-Bliley, and COBIT, enterprises have to constantly detect, validate, and report unauthorized change and out-of-compliance actions on their IT infrastructure. The Tivoli Compliance Insight Manager solution allows organizations to improve the security of their information systems by capturing comprehensive log data, correlating this data through sophisticated log interpretation and normalization, and communicating results through a dashboard and a full set of audit and compliance reporting. We discuss the business context of security audit and compliance software for organizations, and we show a typical deployment within a business scenario. This IBM Redbooks publication is a valuable resource for security officers, administrators, and architects who wish to understand and deploy a centralized security audit and compliance solution.

This book is part of the Deployment Guide series. It provides a step-by-step guide for deploying Tivoli Usage and Accounting Manager V7.1. It is intended to help an IBM or business partner service person to plan and perform the deployment of the product. Please note that the additional material referenced in the text is not available from IBM.

This IBM® Redbooks® publication follows The IBM System Storage Tape Libraries Guide for Open Systems, SG24-5946, and can help you plan, install, and configure IBM Ultrium LTO tape drives, as well as the TS1120 Tape Drive and libraries in i5/OS® environments. The book focuses on the setup and customization of these drives and libraries. The first part of the book gives an overview of the System i™ family of servers and describes how to attach and configure the drives and libraries. It also covers basic installation and administration. We describe the sharing and partitioning of libraries and explain the concept and usage of the Advanced Library Management System (ALMS). In the second part of the book, we document how to use these products with Backup Recovery and Media Services (BRMS), how to implement Tape Encryption, and how to use the IBM TS7520 Virtualization Engine™ with i5/OS. This book can help IBM personnel, Business Partners, and customers to better understand and implement the IBM Ultrium LTO product line, and also the TS1120 Tape Drive attached to System i servers. We assume that the reader is familiar with tape drives and libraries and has a basic understanding of System i servers and i5/OS.

Your Hands-On Guide to SAP Business Information Warehouse Give your company the competitive edge by delivering up-to-date, pertinent business reports to users inside and outside your enterprise. SAP Business Information Warehouse Reporting shows you how to construct Enterprise Data Warehouses, create workbooks and queries, analyze and format results, and supply meaningful reports. Learn how to use the BEx and Web Analyzers, Web Application Designer, Visual Composer, and Information Broadcaster. You will also find out how to forecast future business trends, build enterprise portals and websites, and tune performance. Group data into InfoCubes and DataStore Objects and generate reports using queries and workbooks Work with the BEx Analyzer, Web Analyzer, and Query Designer Build queries and reports using the Business Administration Workbench Add attachments and drill-through using Document Integration and RRI Format and distribute results using Report Designer and Information Broadcaster Extend functionality with Enterprise Portal, Data Modeling, and Visual Composer Deploy charts, maps, diagrams, and unit of measure conversions Predict trends and possible outcomes using SBC and Integrated Planning Generate HTML pages using Enterprise Reporting and Web Application Designer Create BI-based corporate Web and intranet sites using SAP Enterprise Portal

IBM Tivoli Monitoring Version 6.2 is a powerful monitoring product from IBM, that is easily customizable and provides real-time and historical data that enables you to quickly diagnose and solve issues through the IBM Tivoli Enterprise Portal component. This common, flexible, and easy-to-use browser interface helps users to quickly isolate and resolve potential performance problems. This IBM Redbooks publication presents a deployment guide for IBM Tivoli Monitoring V6.2. We cover planning, installing, and configuration of IBM Tivoli Monitoring V6.2 for small, medium, and large environments. In addition, we provide some case studies, such as IBM Tivoli Monitoring V5.x migration, event management integration, and Agent Builder. Agent Builder is a very powerful tool that you can use to develop your own monitoring agents. In order to show you how this tool can be used in a real life scenario, we have created a 30 minute video that you can launch from the ITSO Web site. We have also added an appendix that discusses IBM Tivoli Monitoring sales engagement planning for Business Partners and Solution Developers. The target audience for this documentation is IT Specialists and Business Partners who will be working on IBM Tivoli Monitoring V6.2 implementations and proof of concepts. Please note that the additional material referenced in the text is not available from IBM.

In this IBM® Redbooks® publication, we describe the capabilities and ways to use the IBM Tivoli® Application Dependency Discovery Manager (TADDM). It is becoming critical for enterprises to track the IT resources in their environment and, more importantly, the dependencies of their business applications on various components. TADDM provides rich capabilities that discover the components of a complex infrastructure and their interdependencies. In this book, we provide insight into the TADDM capabilities and architecture. We include recommended procedures for installing and configuring TADDM, tips and techniques for populating the TADDM database and customizing its use, performance considerations, and information about how TADDM integrates with operational management programs.

The IBM Tivoli Monitoring solution is the next generation of the IBM Tivoli family of products that help monitor and manage critical hardware and software in distributed environments. This IBM Redbooks publication provides a practical guide to implementing, using and optimizing IBM Tivoli Monitoring, including best practices for performance tuning, sizing, high availability, scalability, reporting, IBM Change and Configuration Management Database integration and firewall considerations.

In order to improve the performance and operational efficiency of businesses worldwide, a customer using SAP® wanted to establish a global business program to define and implement a standardized, group-wide business process architecture and associated master data for the parameterization of the group of software tools. The expected growth of the number of users and the size of the database would be at a level never reached by other customers, however, so IBM® was asked to undertake the following tasks: * Test the application to be sure that it can sustain such growth. This project illustrates the new near real time business intelligence (BI) context approached by customers who want the ability to rapidly analyze their business data to gain market shares. Data today comes from many diverse global sources and needs to be merged into an intelligent data warehouse. This IBM Redbooks® publication describes the testing that was done in terms of performance and manageability in an SAP NetWeaver® BI and DB2® environment on IBM System p™ when scaling a client's solution to a data warehouse of 60 terabytes (TB). This book resulted from a joint cooperative effort that included the PSSC, the IBM/SAP International Competency Center, the DB2-SAP Center of Excellence, SAP AG, and a customer. The customer involved in this project is a worldwide company employing more than 250,000 employees with factories and logistics operations in almost every country in the world. This project involved multiple technical skills and multiple products, as described here: * Chapter 1, "Project overview: business objectives, architecture, infrastructure, and results" on page 1, summarizes the entire project, starting from the business needs through the description of the environment and options used, to the results achieved. This chapter can be viewed as an executive summary from an IT specialist perspective. * Chapter 2, "The SAP NetWeaver BI perspective" on page 47; Chapter 3, "The DB2 perspective" on page 127; and Chapter 4, "The IBM System p perspective" on page 287, provide detailed views of the project from the perspectives of SAP specialists, DB2 specialists, and System p and AIX® specialists, respectively. * Chapter 5, "The system storage perspective" on page 319, and Chapter 6, "The Tivoli Storage Manager perspective" on page 349, describe the storage environment and the manageability issues in such a large environment. * Finally Appendix A, "The scripts used" on page 395, provides the scripts that we needed to develop for this project.

If you want to build dynamic Web sites that encourage users to interact with them, PHP and MySQL are among the best tools you’ll find. PHP is a scripting language designed specifically for use on the Web, while MySQL is a database management system that works with it perfectly. Best of all, they’re free. It’s hard to beat that combination! PHP & MySQL Web Development All-in-One Desk Reference For Dummies is kind of one-stop shopping for the information you need to get up and running with these tools and put them to good use. It’s divided into six handy minibooks that cover setting up your environment, PHP programming, using MySQL, security, PHP extensions, and PHP Web applications. They make it easy to create a Web site where visitors can sign on, use shopping carts, complete forms, and do business with your business. It’s easy to find what you need in this handy guide. You’ll discover how to: Find and acquire all the tools you need and set up your development environment Build PHP scripts to make your Web site work Create a MySQL database that visitors can access Summarize and sort data results Design and implement user access control Build a shopping cart application Create extensions that make your site more useful With PHP & MySQL Web Development All-in-One Desk Reference For Dummies by your side, you’ll be a Web site guru before you know it!

Written by a team of expert SQL users, this comprehensive resource approaches performance tuning from a new perspective by showing you a methodical scientific approach to diagnose performance problems. The book first walks you through how to discover bottlenecks when something is wrong and you'll then learn how to identify and remove the problems that are causing poor performance. You'll discover preventive measures you can take to try to avoid a performance problem entirely and you'll learn how to achieve better performance.

This IBM® Redbooks® publication describes the IBM Tivoli® Composite Application Manager (ITCAM) family of products. The Composite Application Manager family currently consists of: - IBM Tivoli Composite Application Manager for WebSphere® The aim of IBM Tivoli Composite Application Manager is to simplify and enhance distributed application management. Application components can reside on multiple servers, across different platforms and J2EE environments, even through mainframes. The complexity of understanding and solving application-related problems, typically around performance issues, requires a cohesive set of tools to provide an end-to-end view of the application. The discussion that we provide in this book mainly consists of the basic installation and configuration of the products. The discussion is aimed at augmenting the information provided in the product manuals. Consult the appropriate product manual before starting to implement these products. We provide usage scenarios in this book as a demonstration of using these products in our sample environment. We use a single application environment that can be managed by all of the products.