This text serves as a complete guide to designing databases for optimal performance. A proper data model is the single most important aspect of database performance, and this book is a complete guide to designing databases to utilize database structures, using examples from the popular Oracle database. Not just a theory book, it combines data modeling theory with Oracle data structures. Physical Database Design Using Oracle shows how to model a structure for use by Oracle to achieve the highest performance.

Focusing on tried and true best practice techniques in cross-technology based Oracle embedded programming, this book provides authoritative guidance for improving your code compilation and execution. Geared towards IT professionals developing Oracle-based Web-enabled applications in PL/SQL, Java, C, C++, .NET, Perl, and PHP, it covers application development from concepts to customization, following a pragmatic approach to design, coding, testing, deployment, and customization explaining how to maximize embedded programming practices.

Oracle Embedded Programming and Application Development explains application development frameworks using 3GL and 4GL high-level language code as embedded code segments across .NET, Java, and Open Source technologies, in conjunction with SQL and/or PL/SQL and the Oracle RDBMS through version 11gR2. It also:

• Features pluggable code using parameterized constructs to promote code reuse
• Explains when to use a particular embedded language as a best fit for specific applications
• Highlights design considerations that reduce the probability of errors, enable quick resolution, and boost performance in terms of enabling a Fast-Actionable-Synchronized-Tested (FAST) solution implementation
• Provides best practice techniques that can enhance any application development code-design methodology for a better, easier, faster, cheaper, and pervasive solution that in turn helps achieve a Better Business Benefit (B-B-B)

This practical guide details techniques for constructing architecture and code design methodologies for live application development projects that can be generalized and standardized as application development and code design frameworks. Cover to cover, the text provides an understanding of how the designed, developed, and deployed solutions conform to emerging and next-generation trends. It also discusses the conformance and usage of Web 2.0-based RIA functionality and regulatory compliance practices involving auditing and security.

Praise for:

"Taking an Oracle-centric approach, Lakshman skillfully guides you through the maze of various popular programming languages and environments including .NET, C/C++, Perl, PHP, Java, and even SQL and PL/SQL not only showing you how they interact with Oracle but also which language is the best fit for a given situation."
John Kanagaraj, Executive Editor, IOUG SELECT Journal