Oracle Magazine - May/June 2012

Beginning Database Design,
Second Edition

By Clare Churcher
Apress
apress.com

Beginning Database Design,
Second Edition, provides
short, easy-to-read expla-
nations of how to get data-
base design right the first time. It is aimed
at novice designers, especially those who are
doing ad hoc design as a result of employing
end-user tools such as Oracle Application
Express, Microsoft Access, and Microsoft
Excel. The author offers numerous examples
to help readers avoid the many pitfalls faced
by new and not-so-new database designers.

The book helps designers ask and answer important questions about their data so they can understand the problems they are trying to solve and create a pragmatic design capturing the essential—while leaving the door open for refinements and extension at a later stage.

Oracle Database 11g Release 2
Performance Tuning Tips and
Techniques

By Richard Niemiec
Oracle Press
oraclepressbooks.com

Oracle Certified Master
Richard Niemiec sho ws
you how to systematically
identify and eliminate data-
base performance problems in this updated
Oracle Press book. Filled with real-world case
studies and best practices, the book details
the latest monitoring, troubleshooting, and
optimization methods. Learn how to find and
fix bottlenecks, configure storage devices,
execute effective queries, and develop
bug-free SQL and PL/SQL code. Testing,
reporting, and security enhancements are
also covered. In addition, Niemiec discusses
how to properly index and partition Oracle
Database 11g Release 2; work with Oracle
Exadata and Oracle Exalogic Elastic Cloud;
and efficiently manage disk drives, RAID
arrays, and memory.

Agile Oracle Application Express

By Patrick Cimolini and Karen Cannell

Apress
apress.com

Agile Oracle Application
Express shows how skilled,
motivated, and self-
organizing developers can realize the com-
mercial benefits of Oracle Application
Express by coupling it with an agile software
development approach to iteratively design,
create, and deliver quality applications on
time and within budget. You will learn why
Oracle Application Express is well suited
to agile processes, with its support for
rapid prototyping and team development.
The authors also discuss how support for
enabling technologies such as SQL, HTML,
CSS, and JavaScript in Oracle Application
Express allows you to deliver any type of Web
application to meet your development needs.

Oracle BAM 11g R1 Handbook

By Pete Wang Packt packtpub.com

Oracle BAM 11g R1 Handbook is a practical best-practices tutorial focused entirely on Oracle Business Activity

Monitoring, which enables business service and process monitoring through real-time data streaming and operational reports. Packed with best practices, the book covers business activity monitoring migration, high-availability configuration, and more. Wang dives straight into the architecture of Oracle Business Activity Monitoring

11g before moving on to managing business activity, monitoring server securities, populating data objects, and performing load testing, as well as building an Oracle Application Development Framework–based report. This intermediate-to-advanced guide includes step-by-step instructions and an accompanying demo project that will guide SOA report developers through application development and producing dashboards and reports.

PeopleSoft for the Oracle DBA,
Second Edition

By David Kurtz
Apress
apress.com

PeopleSoft for the Oracle
DBA, Second Edition, is
written for DBAs charged
with supporting an Oracle’s
PeopleSoft system, and especially those
responsible for troubleshooting and resolving
PeopleSoft performance issues. In this revised
edition, readers will learn about the internet
architecture in PeopleSoft applications and
its use of Oracle Tuxedo. The book includes
full coverage of key database issues such as
indexing, connectivity, and tablespace usage
as they apply to PeopleSoft applications. The
author also provides advice on managing
and troubleshooting performance issues in
a PeopleSoft environment, including how to
pinpoint problems within the code.

Look for other Oracle books at oracle.com/ technetwork/community/bookstore

Oracle PartnerNetwork Adds
MySQL Specialization

Reflecting its commitment to MySQL innovation, Oracle has launched a MySQL specialization as part of the Oracle PartnerNetwork Specialized program. More than 3,000 independent software vendors, original equipment manufacturers, and value-added resellers already use MySQL in their solutions; those that earn MySQL specialization can spotlight their strengths and expertise, differentiate their offerings, and gain a competitive edge.

Under MySQL specialization, Oracle partners reselling MySQL solutions receive special branding, advanced educational and enablement resources, and easier and faster ordering and reselling. Partners that embed or bundle MySQL with software, hardware, or appliances can access the development license of the MySQL Enterprise Monitor and Query Analyzer features as well as other tools to improve their products’ quality, stability, and performance.

bit.ly/zHzE3D

Accenture Garners Oracle Life
Sciences Data Hub Specialization

Accenture is the first Oracle Diamond Partner to achieve Specialized status for Oracle Life

Sciences Data Hub. The specialization underscores Accenture’s ability to help life sciences companies increase traceability and visualization of clinical data, conduct cross-trial analyses, and improve data analysis. Accenture and Oracle have worked together on successful Oracle Life Sciences Data Hub implementations for five years.

Oracle Life Sciences Data Hub integrates clinical and nonclinical data from multiple sources into a single environment for analysis, visualization, and reporting, providing better insights for more-informed decision-making, improved regulatory compliance, and greater productivity. To achieve Specialized status, Accenture met requirements based on the needs and priorities of the customer and partner communities, including completing online sales, presales, and support assessments and passing an implementation exam.