Oracle Database 11g and MySQL 5. 6
Developer Handbook
By Michael McLaughlin
Oracle Press
oraclepressbooks.com
Oracle Database 11g and
MySQL 5. 6 Developer
Handbook is a compara-
tive reference to support
developers moving from MySQL to Oracle
Database or vice versa. The book compares
and demonstrates development environ-
ments, architecture, security, transac-
tions, and referential integrity concepts. It
compares and contrasts SQL dialects and
approaches across the spectrum of SQL
commands and discusses their portability.
The book also compares and contrasts
stored programs in both databases and dis-
cusses their design portability. The author
provides clear examples, instructions, and
explanations for porting dialects between
Oracle Database and MySQL and offers best
practices throughout the chapters.
Oracle Information Integration,
Migration, and Consolidation
By Tom Laszewski,
Jason Williamson, and
Prakash Nauduri
Packt
packpub.com
This book covers data
migration, consolidation,
and integration, the three components
that are usually part of the information
integration lifecycle. Organizations typically
find themselves migrating data to Oracle
Database and at the same time or later, con-
solidating multiple database instances into
a single global instance for a department or
even an entire company. This book discusses
the business and technical benefits of data
consolidation and shows you how to use
Oracle technologies to achieve them. The
authors offer readers hands-on advice using
tools and best practices.
Expert PL/SQL Practices
By Michael Rosenblum and
14 others
Apress
apress.com
Expert PL/SQL Practices is
a book of collected wisdom
on PL/SQL programming.
Each chapter is a deep dive into a specific
problem, technology, or feature set. The
path to PL/SQL mastery begins with syntax
and the mechanics of writing statements
to make things happen. If you’ve reached
that point with PL/SQL, this book will show
you how to combine syntax and mechanics
with features and techniques to really make
the language sing. You’ll learn to do more
with less effort, to write code that scales and
performs well, and to eliminate and avoid
defects. The 15 authors cover when to use
PL/SQL, employment in large projects, unit
testing, debugging, contract-oriented pro-
gramming, performance, bulk operations,
and much more.
Oracle Database 11g Performance
Tuning Recipes
By Sam Alapati, Darl Kuhn,
and Bill Padfield
Apress
apress.com
Oracle Database 11g
Performance Tuning
Recipes is a ready refer-
ence for DBAs in need of immediate help
with performance issues relating to Oracle
Database. The book takes an example-based
approach in providing proven solutions
to real-life Oracle performance problems.
Relevant background and theory are pro-
vided to support each solution. Whatever
the task, if it’s performance-related, you’ll
probably find a recipe and a solution in this
book. However, performance problems are
rarely “problems” per se. They are more
often “crises” during which you’re pressured
for quick results. That’s when you need a
book of solutions, such as those included in
this book.
Effective MySQL: Optimizing
SQL Statements
By Ronald Bradford
Oracle Press
oraclepressbooks.com
The first book in the new
Oracle Press Effective
MySQL series, Effective
MySQL: Optimizing SQL
Statements takes readers through critical
and exacting elements of MySQL optimiza-
tion, offering educational insights, tips,
and revelations. Oracle ACE Director and
MySQL expert Ronald Bradford drills down
into the real-world problems and solutions
that DBAs, developers, and architects face
daily using MySQL. He prescribes succinct,
proven formulas for succeeding faster and
with greater overall understanding of the
systems—no matter what level of experience
the reader possesses. Readers will learn to
identify the essential analysis commands
for gathering and diagnosing issues, how
different index theories are applied and
represented in MySQL, and how to plan and
execute informed SQL optimizations.
Look for other Oracle books at oracle.com/
technetwork/community/bookstore.
Accenture Expands AFPO
Oracle Diamond Partner Accenture has rolled
out version two of its Accenture Foundation
Platform for Oracle (AFPO), a software tool
for integrating and developing solutions on
Oracle Fusion Middleware. AFPO now supports Oracle SOA Suite 11g, Oracle Business
Intelligence Suite 11g, and Oracle Identity
Management 11g products, and also integrates and supports Oracle Database 11g
Release 2, Oracle Enterprise Manager 11g,
and Oracle Data Integrator 11g.
AFPO provides a reference application
architecture, implementation accelerator, and
common services framework for Oracle Fusion
Middleware. It was developed in collaboration
with Oracle, using experience and knowledge
Accenture has gained through hundreds of
implementations of Oracle products.
AFPO can be delivered as a fully integrated architecture, or in sections—such as
SOA or security—depending on an organization’s client’s needs. It is available either on
premises or through the cloud. AFPO is the
cornerstone of Accenture’s Fusion Readiness
Program, which helps organizations anticipate the architectural and business needs of
Oracle Fusion Applications. Currently, nine
Accenture clients are using the first version
of AFPO through a pilot program launched in
December 2010.
accenture.com
Mythics Opens Center for Public
Sector Cloud Computing
Mythics, an Oracle Platinum Partner and
Oracle GSA Schedule Holder, has opened the
Mythics Public Sector Technology Briefing
Center in the Oracle Cloud Computing Center
of Excellence in Reston, Virginia. There,
Mythics and Oracle customers and partners
can access hands-on demos, training, and
specialized proofs-of-concept for Oracle
public sector technologies and solutions.
Since 2000, Mythics has provided Oracle
licensing, training, and consulting services
across the entire Oracle product portfolio.
Mythics provides technology solutions within
the U. S. Department of Defense, federal
civilian agencies, intelligence agencies, and
state and local governments, as well as the
commercial and healthcare sectors.
mythics.com