Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
PeopleSoft for the Oracle DBA

Buy
PeopleSoft for the Oracle DBA, 9781430237075 (1430237074), Apress, 2012

This book is aimed at helping Oracle DBAs understand and use PeopleSoft technology. For the typical DBA, the introduction to PeopleSoft is likely to include some surprises, not all of them agreeable. Many—if not most—DBAs have to deal with many different databases, usually supporting different applications. Often they will want to be able to administer all databases in a standard fashion. However, this is not always possible with a PeopleSoft system.

Most surprising to Oracle DBAs may be what is missing. In a vanilla PeopleSoft database, there is only minimal use of Oracle-specific features and Oracle-specific SQL constructions. There are no referential constraints. Very few optimizer hints are used, and only where there is no alternative. All PeopleSoft processes connect to the one database schema that contains all the database objects, so security is maintained by the application, not the database. Oracle sequences are never used; instead, sequence numbers are generated using ordinary tables.

In order to avoid the use of platform-specific SQL constructions, most of the delivered SQL conforms to a lowest common denominator subset of SQL accepted by the supported RDBMS platforms (Oracle, Microsoft SQL Server, DB2, Sybase, and Informix). The data model is kept uniform across all platforms, although there are variations in the column data types between platforms. There can be some differences in the indexing between platforms. There is some capability for different code on different platforms in PeopleSoft, but its use in the delivered product is kept to an absolute minimum.

Hence, PeopleSoft is sometimes described as a platform-agnostic product. It is my experience that this approach generally does not produce optimal performance. It may have assisted PeopleSoft to manufacture and maintain a single product on many platforms, but it does not help PeopleSoft customers to achieve optimal performance from their systems on their chosen database platform.

In PeopleTools 8, there has been some expansion of the areas in which it is possible to introduce database-specific features and code. From PeopleTools 8.1, database triggers were used to write audit records, although these have to be enabled by customization. Database instrumentation was added to PeopleTools 8.50. Active Data Guard is supported from PeopleTools 8.51.

The other area of confusion for typical Oracle DBAs, particularly those familiar with Oracle’s management tools, is that unless certain DBA tasks are incorporated into the application with PeopleSoft’s Application Designer, they may be lost. Consequently, this can restrict the effectiveness of generic Oracle administration and monitoring tools.

In short, to be effective, DBAs must become PeopleSoft aware. They must work with the PeopleSoft development tools and the application, rather than continually fighting against it—otherwise it will bite back! One of the goals of this book is to outline these areas for DBAs, providing workaround techniques where possible.

(HTML tags aren't allowed.)

Transformation of Knowledge, Information and Data: Theory and Applications
Transformation of Knowledge, Information and Data: Theory and Applications
Transformation of Knowledge, Information and Data: Theory and Applications considers transformations within the context of computing science and information science, as they are essential in changing organizations.

Data today is in motion, going from one location to another. It is more and more moving between systems, system components,
...
Spacetime, Geometry and Gravitation (Progress in Mathematical Physics)
Spacetime, Geometry and Gravitation (Progress in Mathematical Physics)

Teaching Einstein’s general relativity at introductory level poses problems because students cannot begin to appreciate the basics of the theory unless they learn a sufficient amount of Riemannian geometry. Most elementary books take the easy course of telling the students a few working rules stripping the mathematical details to a minimum...

Professional Android 2 Application Development (Wrox Programmer to Programmer)
Professional Android 2 Application Development (Wrox Programmer to Programmer)

Build unique mobile applications with the latest Android SDK

Written by an Android authority, this up-to-date resource shows you how to leverage the features of Android 2 to enhance existing products or create innovative new ones. Serving as a hands-on guide to building mobile apps using Android, the book walks you through a series...


Radioactive Waste Disposal at Sea: Public Ideas, Transnational Policy Entrepreneurs, and Environmental Regimes
Radioactive Waste Disposal at Sea: Public Ideas, Transnational Policy Entrepreneurs, and Environmental Regimes
"This book makes a significant contribution by showing that, under certain circumstances, regimes can be created and changed by a combination of powerful but highly oversimplified ‘public ideas’ and transnational political entrepreneurs. The work is original and the scholarship is sound beyond any question."
...
Deploying Microsoft Forefront Threat Management Gateway 2010
Deploying Microsoft Forefront Threat Management Gateway 2010

When we began this project, our intent was to create a real world scenario that would guide IT professionals in using Microsoft best practices to deploy Microsoft Forefront Threat Management Gateway (TMG) 2010. We hope you find that we have achieved that goal. We’ve also included the main deployment scenarios for Forefront TMG,...

The Essential Guide to Flex 2 with ActionScript 3.0
The Essential Guide to Flex 2 with ActionScript 3.0
Flex 2 represents something of a revolution in web applications. It is the next evolutionary step of Flash, which has grown from a web animation tool to a powerful enterprise web design and development tool. with nearly 98% of all web browsers and cellular phones running the Flash player needed to use Flash and Flex applications, knowledge of Flex...
©2021 LearnIT (support@pdfchm.net) - Privacy Policy