Oracle Embedded Programming and Application Development / Edition 1

Oracle Embedded Programming and Application Development / Edition 1

by Lakshman Bulusu
     
 

ISBN-10: 1439816441

ISBN-13: 9781439816448

Pub. Date: 09/08/2010

Publisher: Taylor & Francis

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

Overview

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

Product Details

ISBN-13:
9781439816448
Publisher:
Taylor & Francis
Publication date:
09/08/2010
Pages:
372

Table of Contents

INTRODUCTORY CONCEPTS

Embedded Programming—An Oracle-Centric Approach
Embedded Programming from the Oracle Perspective: The Primary Indicators and the Solution Life Cycle
What’s In and What’s Not: Programming Languages, Platforms, and Solution Options Available for an Oracle-Based Solution
The Foundations: Architecture, Technologies, and Methodologies for Integration and Interaction with Oracle
Oracle Database-Specific Code Versus Non-Oracle 3GL and 4GL code in Conjunction with SQL and PL/SQL: Key Differentiators

Feature-Set and Solution-Set Enhancements
New feature and solution options in Oracle11g
New feature and solution options in Oracle10g

BEST PRACTICES BY WAY OF DESIGN AND DEVELOPMENT

Programming Languages, Platforms, and Solutions: Best Practices in Terms of Choice and Suitability—How Best Is the "Best"?
Why and when architecture takes precedence over feature set
Best practices in terms of Oracle database interaction
Best practices for using SQL and PL/SQL only (with HTML, XML via PSP, or Web Toolkit)
Best practices for using .NET based languages (C++, C#)
Best practices for using Java-based languages (Java Libraries, Java via JDBC, Java via SQLJ, Java via Java Stored Procedures)
Best practices for using PHP-based languages (PHP-only, PHP and AJAX, PHP Web pages)
Perl in the picture—best practices for the perfect fit and use of Perl in an embedded scenario
For better or worse: Application-centric and business-centric key performance indicators

Best Practices for Data Structure Management
Data representation: database versus programming language perspectives
Best practices for using heterogeneous data structures: arrays, array lists, lists, maps, enumerations
Best practices for using LINQ to objects (in Oracle11g)
Best practices for using objects as data structures
Best Practices for meta-programming: use or eliminate

Best Practices for Robust Error Detection and Handling
Best design practices to reduce the probability of errors and enable quick resolution
Techniques to obtain complete error information
Techniques to customize the error information returned
Techniques for halting further processing on error occurrence

Best Practices for Data Management
Database management using embedded programming languages – Design Practices for best degree of fit
Best practices in terms of Connectivity and Interactivity to the Oracle database
Techniques to connect to multiple databases simultaneously using same meta-data
Best fit for Oracle in the ADO.NET Framework – ODP.NET, ODE.NET
Best Practices for Data Retrieval
Best Practices for Data Manipulation
Best Practices for using LINQ to SQL
Best Practices for Data validation
Best Practices for using XML
Best Practices for Handling Unstructured Data
Best Practices to protect data integrity and special cases involved

Best Practices for Application Management
Code Accelerators for Rapid Application Development & Management: Design, and coding aspects
Best Practices for Application Integrity
Best Practices for Application Consistency
Best Practices for Application Web Interaction: Receiving, Routing, Responding, Redirecting, Rendering, Linking
Best practices for Security beyond User Authentication – End-to-End Application Security
Best fit for Oracle in the ASP.NET Framework
Best Practices for Templates: use or eliminate
Best Practices beyond HTML – Auto-generate dynamic visual content, Web Services, and Mobile Applications
Best Practices for Creative Reporting

APPLYING EMBEDED PROGRAMMING IN THE REAL WORLD

Application Development Frameworks
Application Development Framework – A Pragmatic "best possible" solution
Next Generation Web Framework for Interaction and Intercommunication with Internet, Web Services and E-mail
Master Error Management Framework
Master Audit Management Framework
Performance Tuning Framework
Debugging Framework

Miscellaneous Best Practices
Simulating Oracle-based datasets – Best practices for design and coding
Building a highly visible website

Best Practices in Terms of Coding Standards and Troubleshooting
Coding Standards from an Oracle11g embedded programming perspective
Tuning SQL & PL/SQL Code for optimality
Tuning embedded language code for optimality-Data Structures and Procedural Code
Fine Tuning Solution methodology for optimality

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >