Book Description

The book covers data migration, data consolidation, and data integration, the three scenarios that are typically part of the information integration life cycle. Organizations typically find themselves migrating data to Oracle and either later, or at the same time, consolidating multiple database instances into a single global instance for a department, or even an entire company. The business savings and technical benefits of data consolidation cannot be overlooked, and this book will help you to use Oracle’s technology to achieve these goals.

This highly practical and business-applicable book will teach you to be successful with the latest Oracle data and application integration, migration, information life-cycle management, and consolidation products and technologies.

In this book, you will gain hands-on advice about data consolidation, integration, and migration using tools and best practices. Along the way you will leverage products like Oracle Data Integrator, Oracle GoldenGate, and SQL Developer, as well as Data Hubs and 11gR2 Database.

The book covers everything from the early background of information integration and the impact of SOA, to products like Oracle GoldenGate and Oracle Data Integrator. By the end you’ll have a clear idea of where information and application integration is headed and how to plan your own projects.

Use Oracle technologies and best practices to manage, maintain, migrate, and mobilize data

Download Now »

Book Description

Whether you’re a DBA, data warehousing or business intelligence professional, reporting specialist, or developer, this book has the answers you need. Through hands-on examples, you’ll systematically master Crystal Reports and Xcelsius 2008’s most powerful features for creating, distributing, and delivering content. One step at a time, long-time Crystal Reports insiders take you from the basics through advanced content creation and delivery using Xcelsius, Crystal Reports Server, crystalreports.com, and the offline Crystal Reports Viewer.

Every significant enhancement introduced in Crystal Reports 2008 is covered, including its new visualization options and more robust Web services capabilities. The book concludes by showing how to use Crystal Reports’ powerful .NET and Java SDKs to customize and extend enterprise reporting in virtually unlimited ways.

• Learn hands-on, through step-by-step examples and exercises–and discover tips and tricks proven in real-world enterprise environments
• Master new Crystal Reports 2008 features, including interactive report viewing, Xcelsius dashboarding, Flex, and Flash integration, Report Designer improvements, report bursting, and more
• Publish professional-quality reports against virtually any data source, including relational and OLAP databases, Universes, SAP, PeopleSoft, JavaBeans, .NET/COM objects, XML, and more
• Discover advanced visualization techniques using Xcelsius, charts, and maps
• Learn methods for distributing reports and integrating content into other applications Download Now »

Book Description

Microsoft SQL Server is an enterprise database platform that contains a multitude of technologies, Analysis Services being one of them. SQL Server Analysis Services (SSAS) provides OLAP and data mining capabilities and allows users to analyze multidimensional data stored in cubes using the MDX query language.

This cookbook contains over 80 practical, task-based recipes that show how Microsoft SQL Server 2008 R2 Analysis Services solutions can be taken further by enriching them with high-performance MDX calculations and flexible MDX queries.

Packed with immediately usable, real-world recipes, the book starts with elementary techniques that lay the foundation for designing further MDX calculations and queries. Here you will find topics such as iterations on a set, Boolean logic, and dissecting and optimizing MDX calculations.

In the first half of the book you will learn how to efficiently work with time, strings, metadata, calculated members and sets in general, and how to implement MDX solutions that are appropriate in a particular context: a time-aware calculation, a concise report, a calculation relative to another. You will also learn how to implement various types of conditional formatting, how to perform typical MDX calculations like ranks, percentages and averages, and year-to-date calculations.

The book then deep dives into topics such as enhancing cube design with utility dimensions, context-aware calculations, and other advanced topics. In this part you will learn how a utility dimension can be of great help Download Now »

Book Description

A competent system administrator knows that a Linux server is a high performance system for routing large amounts of information through a network connection. Setting up and maintaining a Linux server requires understanding not only the hardware, but the ins and outs of the Linux operating system along with its supporting cast of utilities as well as layers of applications software. There’s basic documentation online but there’s a lot beyond the basics you have to know, and this only comes from people with hands-on, real-world experience. This kind of “know how” is what we sought to capture in Linux Server Hacks.

Linux Server Hacks is a collection of 100 industrial-strength hacks, providing tips and tools that solve practical problems for Linux system administrators. Every hack can be read in just a few minutes but will save hours of searching for the right answer. Some of the hacks are subtle, many of them are non-obvious, and all of them demonstrate the power and flexibility of a Linux system. You’ll find hacks devoted to tuning the Linux kernel to make your system run more efficiently, as well as using CVS or RCS to track the revision to system files. You’ll learn alternative ways to do backups, how to use system monitoring tools to track system performance and a variety of secure networking solutions. Linux Server Hacks also helps you manage large-scale Web installations running Apache, MySQL, and other open source tools that are typically part of a Linux system.

O’Reilly’s new Hacks Series proudly reclaims the term “hacking” for the good guys. Hackers use their ingenuity to solve interesting problems. Rob Flickenger is an experienced system administrator, having managed the systems for O’Reilly Network for several years. Download Now »

Book Description

Performance problems are rarely “problems” per se. They are more often “crises” during which you’re pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won’t have the time for a leisurely perusal of the manuals, nor to lean back and read a book on theory. What you need in that situation is a book of solutions, and solutions are precisely what Oracle Database 11g Performance Tuning Recipes delivers.

Oracle Database 11g Performance Tuning Recipes is a ready reference for database administrators in need of immediate help with performance issues relating to Oracle Database. The book takes an example-based approach, wherein each chapter covers a specific problem domain. Within each chapter are “recipes,” showing by example how to perform common tasks in that chapter’s domain. Solutions in the recipes are backed by clear explanations of background and theory from the author team. Whatever the task, if it’s performance-related, you’ll probably find a recipe and a solution in this book.

• Provides proven solutions to real-life Oracle performance problems
• Offers relevant background and theory to support each solution
• Written by a team of experienced database administrators successful in their careers

What you’ll learn

• Optimize the use of memory and storage
• Monitor performance and troubleshoot problems Download Now »

Book Description

Expert Oracle GoldenGate is a hands-on guide to creating and managing complex data replication environments using the latest in database replication technology from Oracle. GoldenGate is the future in replication technology from Oracle, and aims to be best-of-breed. GoldenGate supports homogeneous replication between Oracle databases. It supports heterogeneous replication involving other brands such as Microsoft SQL Server and IBM DB2 Universal Server. GoldenGate is high-speed, bidirectional, highly-parallelized, and makes only a light impact on the performance of databases involved in replication.

The authors share their experience in the form of tutorials on designing and implementing all types of Oracle GoldenGate environments. You’ll learn methods for tuning Oracle GoldenGate performance. You’ll discover GoldenGate’s utility as a migration and extract, transform, load (ETL) tool. You’ll learn to configure highly-available environments involving GoldenGate, Real Application Clusters, and Data Guard. From installation to design to implementation and troubleshooting, Expert Oracle GoldenGate helps you master all aspects of using and applying Oracle GoldenGate as the replication tool of choice in your environment.

• Explains all aspects of using GoldenGate for replication
• Covers homogeneous, heterogeneous, and bidirectional replication
• Shows the use of GoldenGate for data migration and extract, transform, load (ETL)

Download Now »