Видавець: Packt Publishing
PORUS HOMI HAVEWALA
Data centers around the world are experiencing an unprecedented era of growth due to expanding data volumes. There is also a corresponding increase in the number of databases and applications. In such rapid-growth centers, it is inevitable that fighting fires daily becomes a common occurrence. There is often no controlled method of performance management, neither is rapidly changing configuration information collected. With the lack of automation and control, Data Centers do not often realize their intended cost-effectiveness and regress into a chaotic and uncontrolled day-to-day type of existence. This was the case until Oracle Enterprise Manager started being used as an Enterprise-wide central management solution, changing the whole game in the process.In this brand new book by Porus Homi Havewala, one of the leading experts in the Oracle space, you will be introduced to the all-encompassing world of Oracle Enterprise Manager Cloud Control 12c, Oracle's premier product for managing and monitoring the Enterprise space. Drawing from the author's many years of experience in the real world, the book brings together the major capabilities of the latest Enterprise Manager software and demonstrates how to ease the growing pains of Data Centers.The book takes you on a descriptive journey of what issues are normally experienced in the Data Center, and how Oracle Enterprise Manager Cloud Control 12c manages to address and resolve many of the issues.The book introduces the reader to the typical chaos in Data Centers and discusses the way these common issues are normally resolved, by manual labor or manual scripting using extensive human resources. Then it will show you how Cloud Control 12c aids in Database Performance Management, Configuration Management, Security Compliance, Automated Provisioning, Automated Patching and Database Change Management.You will learn how Cloud Control 12c allows Exadata Database Machine Monitoring and Management, Test Data Management for data subsetting of large databases, as well as Sensitive Data De-identification using Data Masking.The book includes various real life examples and case studies of actual Oracle customers to show how they have benefited from using Oracle Enterprise Manager. It explores the strong standing of Oracle in the Enterprise Management game, now also strengthened by the new Enterprise Manager Cloud Control 12c.
Ashwin Kumar Karkala, Govinda Raj Sambamurthy, Govinda...
Jose R Ruiz, Jose R. Ruiz
Oracle Essbase is a Multi-Dimensional Online Analytical Processing (OLAP) server, providing a rich environment for effectively developing custom analytic and enterprise performance management applications. Oracle Essbase enables business users to quickly model complex business scenarios.This practical cookbook shows you the advanced development techniques when building Essbase Applications and how to take these applications further.Packed with over 90 task-based and immediately reusable recipes, this book starts by showing you how to use a relational data model to build and load an Essbase cube and how to create a data source, prepare the mini schema, and work with the data elements in Essbase Studio. The book then dives into topics such as building the BSO cube, building the ASO cube, using EAS for development, creating Calculation Scripts and using MaxL to automate processes.
Joseph Gomez, Joseph Sydney Gomez, Sarma Anantapantula
The hot new data analysis trends involve business intelligence and analytics. The technology that supports business intelligence and analytics better than anything else is today's multidimensional OLAP technology ñ and there is none better than Oracle Essbase! Although storing data in a cube and developing analytical applications leaves many people grasping for understanding, especially if their experience is with relational databases, embracing OLAP technology will pay big dividends in the long run.It's easy to develop multidimensional analytic OLAP solutions when you have got this Oracle Essbase book to hand. It is a step-by-step guide to timeless Essbase fundamentals, which takes you from a basic software installation through to launching a fully functioning Essbase database cube.This book will guide you through every stage of installing Oracle's Essbase software on your analytic server, the Essbase Administration Services client, and the client software itself. You will learn, in easy-to-understand language, the concepts of multidimensional database technology as you are taken step by step through building an actual Essbase application complete with database, database calculation scripts, and database report scripts.Once you have your system built and functional, the next course of instruction covers the available automation features included in your Essbase software package and how to use them. These chapters alone are worth the price of admission!As an IT professional you quite rightly have a desire to understand multidimensional OLAP ñ this book gives you that understanding. Should you wish to embark on an exciting career as an Essbase developer/administrator, this book provides a fantastic foundation from which to grow.Best of all, this book is filled with the tips and tricks that you can only get from many years and countless hours spent playing with Essbase. You get them all in just the time it takes you to complete this book.
Ankur Gupta
Oracle Goldengate 11g Complete Cookbook is your complete guide to all aspects of Goldengate administration. The recipes in this book will teach you how to setup Goldengate configurations for simple and complex environments requiring various filtering and transformations. It also covers various aspects of tuning and troubleshooting the replication setups using exception handling, custom fields, and logdump utility.The book begins by explaining some basic tasks like Installation and Process groups setup. You will then be introduced to some further topics including DDL replication and various options to perform Initial Loads. You will then learn some advanced administration tasks such as Multi Master replication setup and conflict resolution. Further recipes, contain the cross platform replication and high availability options for Goldengate.
John P Jeffries
Data replication is an important part of any database system that is growing due to today's demand for real-time reporting and regulatory requirements. GoldenGate has recently become Oracle's strategic real-time data replication solution. Until now, very little has been written about how to implement GoldenGate in a production enterprise environment where performance, scalability, and data integrity are paramount.Your days of dismay over the lack of documentation over Oracle GoldenGate are over.Welcome to Oracle GoldenGate 11g Implementer's guide – a comprehensive practical book, which will deliver answers to your questions in a clear, concise style, allowing you to progress effectively in a timeline-driven environment. Based on the author's own experience, this long awaited GoldenGate administration book has all that is required to install, design, configure, and tune data replication solutions suited to every environment. Be the first to master GoldenGate's power and flexibility by reading this unique hands-on implementation companion.Systems need to send data from one system to another in a timely manner to satisfy the ever-increasing need for speed. Regardless of whether you are a novice or an expert – or someone in between – this book will guide you through all the steps necessary to build a high-performance GoldenGate solution on Oracle11gR1. Expert users can dive into key topic areas such as performance tuning or troubleshooting, while novice users can step through the early installation and configuration chapters, later progressing to the advanced chapters.This book is more than an implementation guide. It offers detailed real-life examples, encouraging additional thought and discussion by going beyond the manual.With Oracle GoldenGate 11g Implementer's guide in hand, you'll be designing, installing, and configuring high-performance solutions using GoldenGate in less time than you can say replicate
Edward J. Cody, Emily M. Vose, Emily...
Oracle Hyperion Interactive Reporting is one of many products in the Oracle Business Intelligence Enterprise Edition Plus software suite, an industry-leading business intelligence platform. The primary focus of the Interactive Reporting product is to provide strong relational querying and data analysis capabilities, where the software provides significant flexibility for creating custom dashboards, interfaces, and data analysis routines through the use of JavaScript programming and built-in software functionality. While Interactive Reporting is extremely flexible, performing advanced operations in the software is complicated and requires basic programming knowledge and an advanced understanding of the software. This book continues from where The Business Analyst’s Guide to Oracle Hyperion Interactive Reporting 11 completed and provides the reader with the information to successfully execute the advanced features of the product along with examples and specific techniques applicable to everyday use.The Oracle Hyperion Interactive Reporting 11 Expert Guide provides software users and developers with many examples of the techniques used by software experts. The book begins with an introduction to leveraging advanced features of the project and an introduction to JavaScript. Dashboards are a major focus of the book with four chapters focused on building a simple to complex dashboard including functions, global objects, and syncing selections across dashboards. The book places an emphasis on learning methods for data analysis by using advanced programming and built-in functions, and a unique approach to using code to generate batch reports and exports is provided. The Dashboard Studio Optimize Utility and the Dashboard Studio Merge utility are explained in detail, and the approach to building and using a central code repository for use in dashboards and computations across multiple documents in an enterprise is demonstrated. This book will help the reader become an expert user of the software, providing the skills necessary to understand, communicate, and perform advanced level tasks. The authors’ experience in developing and supporting Interactive Reporting users is very apparent throughout each chapter of the book. While the book displays content and examples from version 11 of the software, the book is also applicable to previous versions of the software dating back to version 8, so readers not currently using Interactive Reporting 11 will find the book applicable to daily use with the product.